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."
