Posts

Showing posts with the label Sqlite

Flask and Sqlite Basic Crud Python Tutorial

Image
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")   ...
Post a Comment
Read more

Flask Sqlite3 python Web App Tutorial

Image
 1) Creating Database import  sqlite3 conn = sqlite3.connect('bookapp.db') conn.execute("create table Books (id INTEGER PRIMARY KEY AUTOINCREMENT,                name TEXT NOT NULL,                quantity INT  NOT NULL,                edition INT NOT NULL,               year INT NOT NULL,                price INT NOT NULL)") conn.close() 2) need to create template folder and add html files to it 2.1)Html Form  (Template folder) <html> <head>     <title>form</title> </head> <body>  <form action="/input" method="post"> <p>Bookname</p>  <input name="name" type="text" /><br /><br /> <p>Bookquantity</p>  <input name="quantity" type="text" /><br /><br /> ...
Post a Comment
Read more

Tkinter SQlite Data Entry Python

Image
step 1: Creating Database import sqlite3 conn = sqlite3.connect('product.db') conn.execute('''CREATE TABLE PRODUCTS          (ID INT PRIMARY KEY     NOT NULL,          NAME           TEXT    NOT NULL,          PRICE            INT     NOT NULL );''') conn.close() Step 2: Inserting Values import sqlite3 conn = sqlite3.connect('product.db') conn.execute("INSERT INTO PRODUCTS (ID,NAME,PRICE) \       VALUES (1, 'SAMSUNG', 20000.00 )"); conn.commit() conn.close() Step 3: TKinter Code from tkinter import * from tkinter import ttk import sqlite3 conn = sqlite3.connect('product.db') root = Tk() root.geometry('600x500') tree = ttk.Treeview(root,column=("c1","c2","c3"),show='headings',height=8) tree.column("#1",anchor=CENTER) tree.heading("#1",text ="ID") tree.column("#2",anchor=CENTER) tree.heading("#2",text ...
Post a Comment
Read more

Insert And Retrieve Images From SQlite Database using Tkinter and Python

Image
Insert And Retrieve Images From SQlite Database using Tkinter and Python Firstly need to create database  import sqlite3 conn = sqlite3.connect('test8.db')  conn.execute('''CREATE TABLE PHOTO          (ID INT PRIMARY KEY     NOT NULL,          IMAGE           BLOB   NOT NULL,                     );''')    conn.close() Secondly Inserting Method import sqlite3 conn = sqlite3.connect('test8.db') image = open("Home.png","rb")  ////IMAGE FILE TO UPLOAD conn.execute('INSERT INTO PHOTO (ID,IMAGE) VALUES(1,?)',[sqlite3.Binary(image.read())]) conn.commit() conn.close() Retrieve Images From Database Using Tkinter import sqlite3 from tkinter import * root = Tk() root.geometry('300x400') conn = sqlite3.connect('test8.db') cursor = conn.cursor() cursor = conn.execute("""SELECT * FROM PHOTO WHERE ID = 3 """...
Post a Comment
Read more