make_db.py

from flask import Flask
from flask import render_template
import sqlite3

app = Flask(__name__)

@app.route('/books')
def books():
    
    con = sqlite3.connect('database.db')
    
    try:
        con.execute('CREATE TABLE books (isbn PRIMARY KEY INT,name TEXT, price INT, date TEXT, trade_price REAL, image TEXT )')
        print ('Table created successfully');
    except: 
        pass
    
    con.close()
    
    con = sqlite3.connect("database.db")
    con.row_factory = sqlite3.Row
    cur = con.cursor()
    cur.execute("SELECT * from books")
    rows = cur.fetchall();
    
    return render_template("books.html", rows = rows)