def run_test_120(self): conn = ifx_db.connect(config.ConnStr, config.user, config.password) server = ifx_db.server_info( conn ) if conn: stmt = ifx_db.exec_immediate(conn, "SELECT * FROM animals") name1 = ifx_db.field_name(stmt, 1) name2 = ifx_db.field_name(stmt, 2) name3 = ifx_db.field_name(stmt, 3) name4 = ifx_db.field_name(stmt, 4) name6 = ifx_db.field_name(stmt, 8) name7 = ifx_db.field_name(stmt, 0) if (server.DBMS_NAME[0:3] == 'IDS'): name5 = ifx_db.field_name(stmt, "id") name8 = ifx_db.field_name(stmt, "WEIGHT") else: name5 = ifx_db.field_name(stmt, "ID") name8 = ifx_db.field_name(stmt, "weight") print "string(%d) \"%s\"" % (len(name1), name1) print "string(%d) \"%s\"" % (len(name2), name2) print "string(%d) \"%s\"" % (len(name3), name3) print "%s" % name4 print "string(%d) \"%s\"" % (len(name5), name5) print "%s" % name6 print "string(%d) \"%s\"" % (len(name7), name7) print "%s" % name8 else: print "Connection failed."
def run_test_124(self): conn = ifx_db.connect(config.ConnStr, config.user, config.password) if conn: result = ifx_db.exec_immediate( conn, "select * from staff, employee, org where employee.lastname in ('HAAS','THOMPSON', 'KWAN', 'GEYER', 'STERN', 'PULASKI', 'HENDERSON', 'SPENSER', 'LUCCHESSI', 'OCONNELL', 'QUINTANA', 'NICHOLLS', 'ADAMSON', 'PIANKA', 'YOSHIMURA', 'SCOUTTEN', 'WALKER', 'BROWN', 'JONES', 'LUTZ', 'JEFFERSON', 'MARINO', 'SMITH', 'JOHNSON', 'PEREZ', 'SCHNEIDER', 'PARKER', 'SMITH', 'SETRIGHT', 'MEHTA', 'LEE', 'GOUNOT') order by org.location,employee.lastname,staff.id" ) cols = ifx_db.num_fields(result) j = 0 row = ifx_db.fetch_both(result) while (row): for i in range(0, cols): field = ifx_db.field_name(result, i) value = row[ifx_db.field_name(result, i)] if (value == None): value = '' print "%s:%s" % (field, value) print "---------" j += 1 if (j == 10): break row = ifx_db.fetch_both(result) ifx_db.close(conn) print "done" else: print ifx_db.conn_errormsg()
def run_test_231(self): conn = ifx_db.connect(config.ConnStr, config.user, config.password) result = ifx_db.exec_immediate(conn, "select * from sales") result2 = ifx_db.exec_immediate(conn, "select * from staff") result3 = ifx_db.exec_immediate(conn, "select * from emp_photo") for i in range(0, ifx_db.num_fields(result) + 1): print str(i) + ":" + str( ifx_db.field_type(result, ifx_db.field_name(result, i))) print "\n-----" for i in range(0, ifx_db.num_fields(result2)): print str(i) + ":" + ifx_db.field_type( result2, ifx_db.field_name(result2, i)) print "\n-----" for i in range(0, 3): print str(i) + ":" + ifx_db.field_type( result3, ifx_db.field_name(result3, i)) print "\n-----" print "region:%s" % ifx_db.field_type(result, 'region') print "5:%s" % ifx_db.field_type(result2, 5)
def run_test_064(self): conn = ifx_db.connect(config.ConnStr, config.user, config.password) server = ifx_db.server_info(conn) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ifx_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 integer, c2 varchar(40))' try: result = ifx_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 integer, c2 varchar(40))' try: result = ifx_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 integer, c2 varchar(40))' try: result = ifx_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 integer, c2 varchar(40))' try: result = ifx_db.exec_immediate(conn, create) except: pass if (server.DBMS_NAME[0:3] == 'IDS'): result = ifx_db.tables(conn, None, 't') else: result = ifx_db.tables(conn, None, 'T') for i in range(0, ifx_db.num_fields(result)): print "%s, " % ifx_db.field_name(result, i) print print i = 0 row = ifx_db.fetch_tuple(result) while (row): ifx_db.num_fields(result) if (i < 4): print ", " + row[1] + ", " + row[2] + ", " + row[3] + ", , \n" i = i + 1 row = ifx_db.fetch_tuple(result) ifx_db.free_result(result) ifx_db.exec_immediate(conn, 'DROP TABLE t.t1') ifx_db.exec_immediate(conn, 'DROP TABLE t.t2') ifx_db.exec_immediate(conn, 'DROP TABLE t.t3') ifx_db.exec_immediate(conn, 'DROP TABLE t.t4')
def run_test_232(self): conn = ifx_db.connect(config.ConnStr, config.user, config.password) result = ifx_db.exec_immediate(conn, "select * from sales") for i in range(0, ifx_db.num_fields(result) + 1): field_name = ifx_db.field_name(result, i) field_type = ifx_db.field_type(result, ifx_db.field_name(result, i)) print str(ifx_db.field_name(result, i)) + ":" + str( ifx_db.field_type(result, ifx_db.field_name(result, i))) print "-----" t = ifx_db.field_type(result, 99) print t t1 = ifx_db.field_type(result, "HELMUT") print t1
def run_test_065(self): conn = ifx_db.connect(config.ConnStr, config.user, config.password) server = ifx_db.server_info(conn) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ifx_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 integer, c2 varchar(40))' try: result = ifx_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 integer, c2 varchar(40))' try: result = ifx_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 integer, c2 varchar(40))' try: result = ifx_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 integer, c2 varchar(40))' try: result = ifx_db.exec_immediate(conn, create) except: pass result = ifx_db.tables(conn, None, '%', "t3") columns = ifx_db.num_fields(result) for i in range(0, columns): print "%s, " % ifx_db.field_name(result, i) print "\n\n" row = ifx_db.fetch_tuple(result) while (row): final = ", " + row[1] + ", " + row[2] + ", " + row[3] + ", , " row = ifx_db.fetch_tuple(result) print final ifx_db.free_result(result) ifx_db.exec_immediate(conn, 'DROP TABLE t.t1') ifx_db.exec_immediate(conn, 'DROP TABLE t.t2') ifx_db.exec_immediate(conn, 'DROP TABLE t.t3') ifx_db.exec_immediate(conn, 'DROP TABLE t.t4')
def run_test_125(self): conn = ifx_db.connect(config.ConnStr, config.user, config.password) server = ifx_db.server_info( conn ) result = ifx_db.exec_immediate(conn, "SELECT * FROM sales") result2 = ifx_db.exec_immediate(conn, "SELECT * FROM staff") for i in range(0, ifx_db.num_fields(result)): print "%d:%s" % (i, ifx_db.field_name(result,i)) print "-----" for i in range(0, ifx_db.num_fields(result2)): print "%d:%s" % (i, ifx_db.field_name(result2,i)) print "-----" if (server.DBMS_NAME[0:3] == 'IDS'): print "Region:%s" % ifx_db.field_name(result, 'region') else: print "Region:%s" % ifx_db.field_name(result, 'REGION') print "5:%s" % ifx_db.field_name(result2, 5)
def run_test_241(self): conn = ifx_db.connect(config.ConnStr, config.user, config.password) result = ifx_db.exec_immediate(conn, "select * from sales") result2 = ifx_db.exec_immediate(conn, "select * from staff") result3 = ifx_db.exec_immediate(conn, "select * from emp_photo") for i in range(0, ifx_db.num_fields(result)): print str(ifx_db.field_width(result,i)) print "\n-----" for i in range(0, ifx_db.num_fields(result2)): print str(ifx_db.field_width(result2,ifx_db.field_name(result2,i)))
def run_test_122(self): conn = ifx_db.connect(config.ConnStr, config.user, config.password) if conn: drop = "drop table ftest" try: ifx_db.exec_immediate(conn, drop) except: pass create = "create table ftest ( \"TEST\" integer, \"test\" integer, \"Test\" integer )" ifx_db.exec_immediate(conn, create) insert = "INSERT INTO ftest values (1,2,3)" ifx_db.exec_immediate(conn, insert) stmt = ifx_db.exec_immediate(conn, "SELECT * FROM ftest") num1 = ifx_db.field_name(stmt, 0) num2 = ifx_db.field_name(stmt, 1) num3 = ifx_db.field_name(stmt, 2) num4 = ifx_db.field_name(stmt, "TEST") num5 = ifx_db.field_name(stmt, 'test') num6 = ifx_db.field_name(stmt, 'Test') print "string(%d) \"%s\"" % (len(num1), num1) print "string(%d) \"%s\"" % (len(num2), num2) print "string(%d) \"%s\"" % (len(num3), num3) print "string(%d) \"%s\"" % (len(num4), num4) print "string(%d) \"%s\"" % (len(num5), num5) print "string(%d) \"%s\"" % (len(num6), num6) else: print "Connection failed."
def run_test_121(self): conn = ifx_db.connect(config.ConnStr, config.user, config.password) server = ifx_db.server_info(conn) if conn: ifx_db.autocommit(conn, ifx_db.SQL_AUTOCOMMIT_OFF) insert = "INSERT INTO animals values (7, 'cat', 'Benji', 5.1)" ifx_db.exec_immediate(conn, insert) stmt = ifx_db.exec_immediate( conn, "SELECT breed, COUNT(breed) AS number FROM animals GROUP BY breed ORDER BY breed" ) name1 = ifx_db.field_name(stmt, 0) name2 = ifx_db.field_name(stmt, 1) name3 = ifx_db.field_name(stmt, 2) name4 = ifx_db.field_name(stmt, 3) if (server.DBMS_NAME[0:3] == 'Inf'): name5 = ifx_db.field_name(stmt, "breed") name6 = ifx_db.field_name(stmt, 7) name7 = ifx_db.field_name(stmt, '"nUMBER"') name8 = ifx_db.field_name(stmt, "number") else: name5 = ifx_db.field_name(stmt, "BREED") name6 = ifx_db.field_name(stmt, 7) name7 = ifx_db.field_name(stmt, '"Number"') name8 = ifx_db.field_name(stmt, "NUMBER") print "string(%d) \"%s\"" % (len(name1), name1) print "string(%d) \"%s\"" % (len(name2), name2) print "%s" % name3 print "%s" % name4 print "string(%d) \"%s\"" % (len(name5), name5) print "%s" % name6 print "%s" % name7 print "string(%d) \"%s\"" % (len(name8), name8) ifx_db.rollback(conn) else: print "Connection failed."