import sqlite3

#Python 3.2.3 (default, Apr 11 2012, 07:15:24) [MSC v.1500 32 bit (Intel)] on win32
# python 3.3 on windows 7 (64) identical result with window XP (32)

##conn = sqlite3.connect('d:/dumpdata.sql')
##c = conn.cursor()

##c.execute( 'drop table tblS;')
##conn.commit()
##c.execute('''create table tblS ( \
##  ID integer primary key autoincrement, \
##  naambegin character, \
##  naamfamily character, \
##  naamia character , \
##  soort character, \
##  datum real);''')
##  conn.commit()

for loop in range(0,20):
    conn = sqlite3.connect('d:/dumpdata.sql')
    c = conn.cursor()

    sw = int(input('7=add valued records   8= add default values   <>7,8 only show records in file'))
    if sw==0 :
        break

    if sw == 7:
        c.execute('delete from tblS;')
        for i in range(1,3):
            t = ('a{0}'.format(i),'newfamily', 'abcd{0}b.com'.format(i) , 'test', 409.)
            c.execute('insert into tblS \
                       (naambegin,naamfamily,naamia,soort,datum) \
                      values (?,?,?,?,?);',t)
        conn.commit
        print('VALUE records added?')

    if sw == 8:
        for i in range(1,3):
            c.execute('insert into tblS default values;')
        conn.commit()
        print('default records added?')

    c.close()
    d = conn.cursor()
    d.execute('select rowid,* from tblS;')
    conn.commit
    for row in d:
        print(row)

    conn.close()
    print( 'ready')