"""
To create the testdb:
# mysqladmin create pydbi
# mysql mysql
grant all privileges on pydbi.* to test@localhost identified by 'test';
flush privileges;
# mysql pydbi
create table flopp(id integer primary key, test varchar(255));
insert into flopp(1, 'testing');
insert into flopp values (1, 'testing');
insert into flopp values (2, 'testing 2');
insert into flopp values (3, 'testing 3');
insert into flopp values (4, 'testing 4');
insert into flopp values (5, 'testing 5');
insert into flopp values (6, 'testing 6');
"""
# $Id: dbtest.py,v 1.1 2000/06/21 19:13:57 sverrest Exp $	

import sys
import timing

def main(driver, conn):
	print driver
	print driver.apilevel
	print driver.threadlevel
	print driver.paramstyle
	print conn
	
	cursor = conn.cursor()	
	print cursor
	print cursor.rowcount
	print cursor.description

	cursor.execute('select * from flopp')
	print cursor.rowcount
	print cursor.description
	print cursor.fetchone()
	print cursor.fetchmany(2)
	print cursor.fetchall()

	cursor.execute('select * from flopp where id = ?', (1,))	
	print cursor.fetchall()

	cursor.close()
	conn.close()

if __name__ == '__main__':
	timing.start()
	print sys.version
	if sys.version == '1.1':
		import jdbi
		driver = jdbi
		conn = driver.Connect("org.gjt.mm.mysql.Driver","jdbc:mysql://127.0.0.1/pydbi?user=test&password=test")
		main(driver, conn)		
	else:
		import ODBC.MySQL
		driver = ODBC.MySQL
		conn = driver.Connect('pydbi','test','test')
		main(driver, conn)
	timing.finish()

	print "Time used: %i millis" % timing.milli()