Question

You will be creating a python module that emulates the behavior of the built-in module, "sqlite3". Your module will be able to execute SQL statements corresponding to: creating tables, inserting rows, and selecting rows.

Need help starting out on this

Answer 1

Please find the description given about the sqlite3 module existed in PYTHON PROGRAMMING LANGUAGE.

We can connect to the database using sqlite3 module by creating a connection object and we can execute the SQL statements by creating a cursor object .

Here is the sample program which i have attached below , which consists of creating connection object , creating Table , Inserting rows and finally Selecting rows..

PROGRAM:

#imported sqlite3 module

import sqlite3

conn = sqlite3.connect('test.db') #To open the database

conn.execute('''CREATE TABLE PERSON (ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50));''') # To create the table

conn.execute("INSERT INTO PERSON (ID,NAME,AGE,ADDRESS) \
      VALUES (1, 'Kumar', 32, 'Karnataka' )"); #To Insert the rows into the table

conn.execute("INSERT INTO PERSON (ID,NAME,AGE,ADDRESS) \ VALUES (2, 'Ganesh', 25, 'Telangana' )"); #To Insert the rows into the table

conn.commit() #Once we do the commit rows will get fetched to the table.

#Created Cursor to point to the row , we can move the cursor so that we can fetch all the records

#which we got as result of specific query

cursor = conn.execute("SELECT id, name, address from PERSON")
#To get the each record from the cursor and to move the cursor as well
for row in cursor:
   print "ID = ", row[0]
   print "NAME = ", row[1]
   print "ADDRESS = ", row[2] "\n"

conn.close() #Finally closing the database.

Thanks..