# code for update operationimportsqlite3# database name to be passed as parameterconn=sqlite3.connect('mydatabase.db')# update the student recordconn.execute("UPDATE Student SET name = 'Sam' where unix='B113059'")conn.commit()print"Total number of rows updated :",conn.total_changescursor=conn.execute("SELECT * FROM Student")forrowincursor:printrow,conn.close()

# code for delete operationimportsqlite3# database name to be passed as parameterconn=sqlite3.connect('mydatabase.db')# delete student record from databaseconn.execute("DELETE from Student where unix='B113058'")conn.commit()print"Total number of rows deleted :",conn.total_changescursor=conn.execute("SELECT * FROM Student")forrowincursor:printrow,conn.close()

# code for executing query using input dataimportsqlite3# creates a database in RAMcon=sqlite3.connect(":memory:")cur=con.cursor()cur.execute("create table person (name, age, id)")print("Enter 5 students names:")who=[raw_input()foriinrange(5)]print("Enter their ages respectively:")age=[int(raw_input())foriinrange(5)]print("Enter their ids respectively:")p_id=[int(raw_input())foriinrange(5)]n=len(who)foriinrange(n):# This is the q-mark style:cur.execute("insert into person values (?, ?, ?)",(who[i],age[i],p_id[i]))# And this is the named style:cur.execute("select * from person")# Fetches all entries from tableprintcur.fetchall()

# graph visualization using matplotlib libraryimportmatplotlib.pyplotaspltdefgraph_data(p_id,age):# plotting the pointsplt.plot(p_id,age,color='yellow',linestyle='dashed',linewidth=3,marker='*',markerfacecolor='blue',markersize=12)# naming the x axisplt.xlabel('Persons Id')# naming the y axisplt.ylabel('Ages')# plt.plot(p_id,age)plt.show()print("Enter 5 students names:")who=[raw_input()foriinrange(5)]print("Enter their ages respectively:")age=[int(raw_input())foriinrange(5)]print("Enter their ids respectively:")p_id=[int(raw_input())foriinrange(5)]# calling graph functiongraph_data(p_id,age)