import gvib

db = 'server:/usr/local/db'

def create_table():
	cn = gvib.connect(db, 'sysdba', 'masterkey')
	c=cn.cursor()
	try:
		c.execute('create generator gen_gvib')
		c.execute('create table test_gvib (id double precision)')
	except:
		pass
	cn.commit()
	
	



def mostra():
	cn = gvib.connect(db, 'sysdba', 'masterkey')
	c=cn.cursor()
	c.execute('select count(id) from test_gvib')
	print c.fetchall()
	cn.commit()



def inc(numero):
	cn = gvib.connect(db, 'sysdba', 'masterkey')
	c=cn.cursor()
	for i in range(numero):	
		c.execute('insert into test_gvib (id) values (GEN_ID(gen_gvib,1))');
	cn.commit()
	



create_table()
mostra()
inc(1000)
mostra()

print 'Done.'
k=raw_input()