#Filename: DBcon.py

import sqlite3

import time

conn=sqlite3.connect(r'D:\Exercise\Python\DB\example.db')

c=conn.cursor()

c.execute("Create table if not exists stocks (date text, trans text, symbol text, qty real, price real)")

flag=raw_input("Do you wanna clean the table?(y/n):")

if flag=='y':

c.execute("delete from stocks")

c.execute("Insert into stocks values('"+time.strftime('%Y-%m-%d %H:%m:%S')+"', 'Buy','Rhatd',1000,23.14)")

conn.commit()

c.execute('select * from stocks')

res=c.fetchall()

count=0

print res

print '-'*60

for line in res:

for f in line:

count=count+1

print count,f,

print

print '-'*60

print '-'*60

print 'There are %d records!' %count

c.close()

conn.close()