SQLite Script

sqliteDemo.py

import sqlite3

def Main():
	
	try:
        con = sqlite3.connect('sqlite.db')
        cur = con.cursor() 
        cur.executescript("""DROP TABLE IF EXISTS Animal;
                            CREATE TABLE Animal(Id INT, Name TEXT, Price INT);""")

        cur.execute("INSERT INTO Animal VALUES(1, 'Cat', 400)")
        cur.execute("INSERT INTO Animal VALUES(2, 'Dog', 600)")
        cur.execute("INSERT INTO Animal VALUES(3, 'Rabbit', 200)")
        cur.execute("INSERT INTO Animal VALUES(4, 'Bird', 60)")
        
        pets = ((3, 'Rabbit', 200),
                (4, 'Bird', 60),
                (5, 'Goat', 500))
        cur.executemany("INSERT INTO Animal VALUES(?, ?, ?)", pets)
        con.commit()
        cur.execute("SELECT * FROM Animal")
        data = cur.fetchall()
        
        for row in data:
            print(row)

	except sqlite3.Error:
		if con:
			con.rollback()
	finally:
		if con:
			con.close()

if __name__ == '__main__':
	Main()