SQLite Database Database Connectivity in Python


A PROGRAM THAT ILLUSTRATES SQLITE DATABASE CONNECTION


AIM:

To write a python program using Database Connection.

ALGORITHM:

STEP 1:To create the database in sqlite3 Browser.

STEP 2: To assign the database name.

STEP 3: To create the table name, field name and data type.

STEP 4: To assign the table feed the value in the table.

STEP 5: To establish the database connection with sqlite3.

STEP 6: :Establish users.db table name.

STEP 7: To write the sql query.

STEP 8: Create a function for Select data in db.

STEP 9: Create a function for Insert data in db.

STEP 10 Create a function for Delete data in db.

STEP 11: Create a function for Update data in db.


Source Code

import sqlite3
con=sqlite3.connect('users.db')

def insertData(name,age,city):
    qry="insert into users (NAME,AGE,CITY) values (?,?,?);"
    con.execute(qry,(name,age,city))
    con.commit()
    print("User Details Added")
    
def updateData(name,age,city,id):
    qry="update users set NAME=?,AGE=?,CITY=? where id=?;"
    con.execute(qry,(name,age,city,id))
    con.commit()
    print("User Details Updated")
    
def deleteData(id):
    qry="delete from users where id=?;"
    con.execute(qry,(id))
    con.commit()
    print("User Details Deleted")

def selectData():
    qry="select * from users"
    result=con.execute(qry)
    for row in result:
        print(row)
    
print("""
1.Insert
2.Update
3.Delete
4.Select
""")

ch=1
while ch==1:
    c=int(input("Select Your Choice : "))
    if(c==1):
        print("Add New Record")
        name=input("Enter Name : ")
        age=input("Enter Age : ")
        city=input("Enter City : ")
        insertData(name,age,city)
    elif (c==2):
        print("Edit A Record")
        id=input("Enter ID : ")
        name=input("Enter Name : ")
        age=input("Enter Age : ")
        city=input("Enter City : ")
        updateData(name,age,city,id)
    elif (c==3):
        print("Delete A Record")
        id=input("Enter ID : ")
        deleteData(id)
    elif (c==4):
        print("Print All Record")
        selectData()
    else:
        print("Invalid Selectio")
    ch=int(input("Enter 1 To Continue : "))
print("Thank You")
To download raw file Click Here

Output


1.Insert
2.Update
3.Delete
4.Select

Select Your Choice : 1
Add New Record
Enter Name : Ram
Enter Age : 23
Enter City : NAMAKKAL
User Details Added
Enter 1 To Continue : 1
Select Your Choice : 2
Edit A Record
Enter ID : 1
Enter Name : Siva
Enter Age : 21
Enter City : CHENNAI
User Details Updated
Enter 1 To Continue : 1
Select Your Choice : 4
Print All Record
(1, 'Siva', 21, 'CHENNAI')
(2, 'Ram', 23, 'NAMAKKAL')
Enter 1 To Continue : 4
Thank You