Flask Sqlite3 python Web App Tutorial

 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 />

<p>edition</p>

 <input name="edition" type="text" /><br /><br />

<p>Bookyear</p>

 <input name="year" type="text" /><br /><br />

<p>Bookprice</p>

 <input name="price" type="text" /><br /><br />

     <tr><td><input type="submit" value="Submit" /></td></tr>


</form>


    <a href="/view">View Data</a><br /><br />


</body>

</html>





2.2)Data view (Template Folder)



<html>

<head>

   

</head>

<body>



<table border="5">

    <thead>

        <td>ID</td>

        <td>name</td>

        <td>quantity</td>

        <td>edition</td>

        <td>year</td>

       <td>price</td>


    </thead>


    {% for row in rows %}


        <tr>

            <td>{{row["id"]}}</td>

            <td>{{row["name"]}}</td>

            <td>{{row["quantity"]}}</td>

            <td>{{row["edition"]}}</td>

            <td>{{row["year"]}}</td>

            <td>{{row["price"]}}</td>


        </tr>


    {% endfor %}

</table>

<br /><br />

 <a href="/">Home Page</a><br /><br />




</body>

</html>






3)main.py


import sqlite3


from flask import Flask, render_template, request, redirect, url_for


app = Flask(__name__)  # creating the Flask class object


@app.route("/")

def home():

    return render_template("index.html")

@app.route("/input",methods = ["POST","GET"])

def input():

    if request.method == "POST":

        name = request.form["name"]

        quantity= request.form["quantity"]

        edition =request.form["edition"]

        year =request.form["year"]

        price = request.form["price"]

        with sqlite3.connect("bookapp.db") as con:

            cur = con.cursor()

            cur.execute("INSERT into Books (name, quantity, edition,year, price) values (?,?,?,?,?)", (name, quantity,edition,year,price))

            con.commit()

            return redirect(url_for('view'))





@app.route("/view")

def view():

    con = sqlite3.connect("bookapp.db")

    con.row_factory = sqlite3.Row

    cur = con.cursor()

    cur.execute("select * from books")

    rows = cur.fetchall()

    return render_template("view.html",rows = rows)





if __name__ == '__main__':

    app.run(debug=True)





Comments

Post a Comment

Popular posts from this blog

Django Class Based Views Blog App

 Models class Blog(models.Model):     title = models.CharField(max_length =200)     description = models.TextField()     def __str__(self):         return self.title Python manage.py makemigrations Python manage.py migrate views from .models import Blog from django.views.generic.edit import CreateView from django.views.generic.list import ListView from django.views.generic.edit import DeleteView from django.views.generic.edit import UpdateView class BlogCreate(CreateView):     model =  Blog     fields = '__all__'     success_url = '/blog' class BlogList(ListView):     model = Blog class BlogDelete(DeleteView):     model = Blog     success_url = '/list' class BlogUpdate(UpdateView):     model = Blog     fields = '__all__'     template_name = 'dapp/blog_form.html'     success_url = '/list' urls from .views import BlogCreate from .v...
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 """...
Read more

Currency Converter Code Python Tkinter Gui

Image
  Window Creation from tkinter import * root = Tk() root.geometry("320x300") root.title("currency converter") i= PhotoImage(file='') root.iconphoto(False,i) root['bg'] ='#f09942' Widgets Using Entry Button & Label lab = Label(root,text="Currency Converter",relief="raised",borderwidth=2,font= ('Garamond',25),bg='#f09942',padx=20,pady=10) lab.pack(padx=10,pady=10) lab_1 =Label(root,text="USD",font= ('Garamond',25),bg='#f09942') lab_1.pack(padx=2,pady=2) en = Entry(root,highlightthickness=1, width=30) en.pack(padx=2,pady=2) bt = Button(root,text="TO",command=convert,width=10) bt.pack(padx=2,pady=2) lab_2=Label(root,text="INR",font= ('Garamond',25),bg='#f09942') lab_2.pack(padx=2,pady=2) en_1=Entry(root,highlightthickness=1, width=30) en_1.pack(padx=2,pady=2) Button Code (Conversion Method)  [Button,command= convert] def convert():     en_1.delet...
Read more