Open Sourse
Proprietary
In [9]:
import sqlite3
#import the driver
##psycopg2 for protsgeSQL
# pymysql for MySQL
In [4]:
conn = sqlite3.connect('example.sqlite3')
#connecting to sqlite 3 and makes a new database file if file not already present
In [5]:
cur = conn.cursor()
#makes a file cursor we can make multiple cursors as well
In [6]:
cur.execute('CREATE TABLE countries (id integer, name text, iso3 text)')
#creating a new table
Out[6]:
In [7]:
cur.execute('SELECT * FROM countries')
#
Out[7]:
In [8]:
cur.fetchall()
#fetching the whole
Out[8]:
In [10]:
cur.execute('INSERT INTO countries (id,name,iso3) VALUES (1, "Nepal", "NEP")')
Out[10]:
In [11]:
cur.execute('SELECT * FROM countries')
Out[11]:
In [12]:
cur.fetchall()
Out[12]:
In [15]:
sql = '''INSERT INTO countries (id,name,iso3) VALUES (?,?,?)'''
cur.executemany(sql , [(2, 'India','INA'),
(3, 'Bhutan','BHU'),
(4, 'Afghanistan','AFG')])
Out[15]:
In [18]:
cur.execute('SELECT * FROM countries')
Out[18]:
In [19]:
cur.fetchall()
Out[19]:
In [23]:
sql = 'INSERT INTO countries (id,name,iso3) VALUES (4, "PAKISTAN", "PAK")'
cur.execute(sql)
Out[23]:
In [24]:
cur.execute('SELECT * FROM countries')
cur.fetchall()
Out[24]:
In [40]:
sql = 'UPDATE countries SET id = 5 WHERE iso3 = "4"'
cur.execute(sql)
Out[40]:
In [41]:
cur.execute('SELECT * FROM countries')
cur.fetchall()
Out[41]:
In [42]:
sql = 'UPDATE countries '
In [43]:
conn.commit()
In [44]:
cur.execute('SELECT * FROM countries WHERE id > 2 ')
cur.fetchall()
Out[44]:
In [46]:
cur.execute('SELECT *FROM countries WHERE name LIKE "%an"')
cur.fetchall()
Out[46]:
In [47]:
cur.execute('SELECT *FROM countries WHERE name LIKE "%an%"')
cur.fetchall()
Out[47]:
In [49]:
cur.execute('SELECT *FROM countries WHERE name LIKE "Pa%"')
cur.fetchall()
Out[49]:
In [51]:
cur.execute('DELETE FROM countries')
Out[51]:
In [52]:
cur.execute('SELECT *FROM countries')
cur.fetchall()
Out[52]:
In [53]:
conn.commit()
In [54]:
import csv
In [63]:
sql = 'INSERT INTO countries (id,name,iso3) VALUES(?,?,?)'
_id = 1
with open('countries.txt','r') as datafile:
csvfile = csv.DictReader(datafile)
for row in csvfile:
if row ['Common Name'] and row['ISO 3166-1 3 Letter Code']:
cur.execute(sql, (_id, row['Common Name'], row['ISO 3166-1 3 Letter Code']))
_id +=1
conn.commit()
In [78]:
cur.execute('DELETE FROM country_list')
Out[78]:
In [ ]:
In [79]:
cur.execute('SELECT *FROM country_list')
cur.fetchall()
Out[79]:
In [67]:
sql = '''CREATE TABLE
country_list(id integer primary key autoincrement,
country_name text not null,
iso3 text not null unique)'''
cur.execute(sql)
Out[67]:
In [81]:
sql = 'INSERT INTO country_list (country_name,iso3) VALUES(?,?)'
with open('countries.txt','r') as datafile:
csvfile = csv.DictReader(datafile)
for row in csvfile:
if row ['Formal Name'] and row['Formal Name']:
cur.execute(sql, (row['Formal Name'], row['Formal Name']))
conn.commit()
In [82]:
cur.execute('SELECT *FROM country_list')
cur.fetchall()
Out[82]:
In [84]:
connn = sqlite3.connect("Library Management System.txt")
In [85]:
curs = connn.cursor()
In [91]:
sql = '''CREATE TABLE
books(book_id text,
isbn integer not null unique,
book_name text)'''
curs.execute(sql)
In [ ]:
In [92]:
sql2 = '''CREATE TABLE
Student( roll number integer not null unique,
name text not null,
faculty text)'''
curs.execute(sql2)
Out[92]:
In [94]:
sql3 = '''CREATE TABLE
Teacher(name text not null,
faculty text)
'''
curs.execute(sql3)
Out[94]:
class Temperature:
temp = 10
def __intit__(self,temp):
self.temp = temp
def get_temperature(self):
return self.temp
@classmethod
def get_class_temperature(cls):
return cls.temp
@staticmethod
def get_added_method(inst):
return inst.temp +10
t = Temperature (20)
#t = Temperature() --> Temperature.__init__(t,20)
t.get_temperature() #20
#Temperature.get_temperature(t)
Temperature.get_class_temperature() #10
#Temperature.get_class_temperature(Temperature)
Temperature.get_added_temperature(t) #30
#Temperature.get_added_temperature(t)
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]: