#!/usr/bin/python

import sqlite3

import sys

con = None

try:

con = sqlite3.connect('ydb.db')

cur = con.cursor()

cur.execute("DROP TABLE IF EXISTS friends")

cur.execute("CREATE TABLE friends(id INTEGER PRIMARY KEY, name TEXT)")

cur.execute("INSERT INTO friends(name) VALUES ('Tom')")

cur.execute("INSERT INTO friends(name) VALUES ('Rebecca')")

cur.execute("INSERT INTO friends(name) VALUES ('Jim')")

cur.execute("INSERT INTO friends(name) VALUES ('Robert')")

#con.commit()

except sqlite3.Error as e:

if con:

con.rollback()

print(e)

sys.exit(1)

finally:

if con:

con.close()