Flask and Sqlite Basic Crud Python Tutorial
Flask app.py from flask import Flask, render_template, request, redirect import sqlite3 app = Flask(__name__) @app.route('/') def view(): con = sqlite3.connect("product.db") con.row_factory =sqlite3.Row cur = con.cursor() cur.execute("SELECT * FROM PRODUCTS") rows = cur.fetchall() return render_template("viewdata.html",rows=rows) @app.route('/add<int:id>') def add(id): con= sqlite3.connect("product.db") con.row_factory =sqlite3.Row cur = con.cursor() cur.execute("INSERT INTO KART2 (id,name,price) SELECT id,name,price FROM PRODUCTS WHERE id = ?",[id]) con.commit() cur = con.cursor() cur.execute("SELECT * FROM kart2") rows = cur.fetchall() return render_template("kart.html",rows=rows) @app.route('/kart') def kart(): con = sqlite3.connect("product.db") ...