Using DB-API Notes.ipynb

Kernel: Unknown Kernel

Writing code using DB-API

The following format of code should be used when using the DB-API:

#Necessary import
from dbmodule import connect

#Create connection object
connection = connect('databasename', 'username', 'password')

#Create a cursor object
cursor = connection.cursor()

#Run queries
cursor.execute('select * from mytable')
results = cursor.fetchall()

#Free resources up
Cursor.close()
connection.close()