Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- def connect_db():
- db = sqlite3.connect("studentdb.db")
- print("Database connected")
- return db
- def create_table(db):
- cursor = db.cursor()
- cursor.execute("create table if not exists student(name text,usn text primary key,sem integer,marks integer)")
- print("Table created")
- db.commit()
- def insert_data(db,name,usn,sem,marks):
- cursor = db.cursor()
- cursor.execute("insert into student(name,usn,sem,marks) values(?,?,?,?)",(name,usn,sem,marks))
- db.commit()
- def fetch_data(db):
- cursor = db.cursor()
- # cursor.execute("select * from users")
- # rows = cursor.fetchall()
- print("Fetching Data...")
- for i in cursor.execute("select * from student"):
- print(i)
- db.commit()
- def update_data(db,usn,marks):
- cursor = db.cursor()
- cursor.execute("update student set marks=? where usn=?",(marks,usn))
- print("\nTable updated")
- db.commit()
- def delete_data(db,usn):
- cursor = db.cursor()
- cursor.execute("delete from student where usn=?",(usn,))
- print("\n1 Data deleted")
- db.commit()
- def drop_table(db):
- cursor = db.cursor()
- cursor.execute("drop table student")
- print("\nTable dropped")
- db.commit()
- def marks_display(db,marks):
- cursor = db.cursor()
- print("\nFetching custom data...")
- for i in cursor.execute("select * from student where marks>?",(marks,)):
- print(i)
- db.commit()
- if __name__=="__main__":
- db = connect_db()
- create_table(db)
- insert_data(db,"Talha","1NH23AI006",4,45)
- insert_data(db,"Aneesh","1NH23AI017",4,40)
- insert_data(db,"Rohith","1NH23AI001",4,20)
- insert_data(db,"Anil","1NH23AI019",4,30)
- print("\nAll Data inserted")
- fetch_data(db)
- update_data(db,"1NH23AI001",23)
- fetch_data(db)
- delete_data(db,"1NH23AI019")
- fetch_data(db)
- marks_display(db,25)
- drop_table(db)
- db.close()
- print("Database disconnected")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
