print client.list_databases(con=con) # delete if database named 'test' already exists try: print client.execute_sql(con=con, query=''' drop database test ''') print client.list_databases(con=con) except Exception, e: print e.message # create a database named 'test' print client.execute_sql(con=con, query=''' create database test ''') print client.list_databases(con=con) # connect to the database 'test' and open the database database = DHDatabase(name='test') con = client.open_database(con=con, database=database) # create a table named 'person' print client.list_tables(con=con) print client.execute_sql( con=con, query=''' create table person (id integer, name varchar(20)) ''') print client.list_tables(con=con) # insert/delete/update records print client.execute_sql(con=con, query=''' insert into person values (1, 'anant') ''') print client.execute_sql(con=con, query=''' insert into person values (2, 'david') ''') print client.execute_sql(con=con, query=''' insert into person values (3, 'sam') ''') print client.execute_sql(con=con, query=''' select * from person ''')
print client.list_databases(con=con) # delete if database named 'test' already exists try: print client.execute_sql(con=con, query=''' drop database test ''') print client.list_databases(con=con) except Exception, e: print e.message # create a database named 'test' print client.execute_sql(con=con, query=''' create database test ''') print client.list_databases(con=con) # connect to the database 'test' and open the database database = DHDatabase(name='test') con = client.open_database(con=con, database=database) # create a table named 'person' print client.list_tables(con=con) print client.execute_sql(con=con, query=''' create table person (id integer, name varchar(20)) ''') print client.list_tables(con=con) # insert/delete/update records print client.execute_sql(con=con, query=''' insert into person values (1, 'anant') ''') print client.execute_sql(con=con, query=''' insert into person values (2, 'david') ''') print client.execute_sql(con=con, query=''' insert into person values (3, 'sam') ''') print client.execute_sql(con=con, query=''' select * from person ''')