def run_test_240(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(i) + ":" + str(ifx_db.field_width(result, i))
print "\n-----"
for i in range(0, ifx_db.num_fields(result2)):
print str(i) + ":" + str(
ifx_db.field_width(result2, ifx_db.field_name(result2, i)))
print "\n-----"
for i in range(0, 3):
print str(i) + ":" + str(ifx_db.field_width(
result3, i)) + "," + str(ifx_db.field_display_size(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_180(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
if conn:
result = ''
result2 = ''
try:
result = ifx_db.exec_immediate(
conn,
"insert int0 t_string values(123,1.222333,'one to one')")
except:
pass
if result:
cols = ifx_db.num_fields(result)
print "col:", cols, ", "
rows = ifx_db.num_rows(result)
print "affected row:", rows
else:
print ifx_db.stmt_errormsg()
try:
result = ifx_db.exec_immediate(
conn, "delete from t_string where a=123")
except:
pass
if result:
cols = ifx_db.num_fields(result)
print "col:", cols, ", "
rows = ifx_db.num_rows(result)
print "affected row:", rows
else:
print ifx_db.stmt_errormsg()
else:
print "no connection"
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_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_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_102(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
if (not conn):
print ifx_db.conn_errormsg()
server = ifx_db.server_info(conn)
if ((server.DBMS_NAME[0:2] != "AS") and (server.DBMS_NAME != "DB2")
and (server.DBMS_NAME[0:3] != "Inf")):
result = ifx_db.exec_immediate(conn, "VALUES(1)")
#throw :unsupported unless result
if (not result):
raise Exception('Unsupported')
print ifx_db.num_fields(result)
else:
print '1'
ifx_db.close(conn)
def run_test_101(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
if conn:
result = ifx_db.exec_immediate(
conn, "insert into t_string values(123,1.222333,'one to one')")
if result:
cols = ifx_db.num_fields(result)
print "col: %d" % cols
rows = ifx_db.num_rows(result)
print "affected row: %d" % rows
result = ifx_db.exec_immediate(conn,
"delete from t_string where a=123")
if result:
cols = ifx_db.num_fields(result)
print "col: %d" % cols
rows = ifx_db.num_rows(result)
print "affected row: %d" % rows
else:
print "no connection"
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_100(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
if conn:
ifx_db.autocommit(conn, ifx_db.SQL_AUTOCOMMIT_OFF)
stmt = ifx_db.exec_immediate(
conn, "SELECT * FROM animals ORDER BY breed")
fields1 = ifx_db.num_fields(stmt)
print "int(%d)" % fields1
stmt = ifx_db.exec_immediate(
conn, "SELECT name, breed FROM animals ORDER BY breed")
fields2 = ifx_db.num_fields(stmt)
print "int(%d)" % fields2
stmt = ifx_db.exec_immediate(conn, "DELETE FROM animals")
fields3 = ifx_db.num_fields(stmt)
print "int(%d)" % fields3
stmt = ifx_db.exec_immediate(
conn, "INSERT INTO animals values (0, 'cat', 'Pook', 3.2)")
fields4 = ifx_db.num_fields(stmt)
print "int(%d)" % fields4
stmt = ifx_db.exec_immediate(
conn, "SELECT name, breed, 'TEST' FROM animals")
fields5 = ifx_db.num_fields(stmt)
print "int(%d)" % fields5
ifx_db.rollback(conn)
else:
print "Connection failed."
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_211(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
result = ifx_db.exec_immediate(conn, "select * from sales")
i = 1
while (i <= ifx_db.num_fields(result)):
#printf("%d size %d\n",i, ifx_db.field_display_size(result,i) || 0)
print "%d size %d" % (i, ifx_db.field_display_size(result, i) or 0)
i += 1
ifx_db.close(conn)
def run_test_015(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
if conn:
result = ifx_db.exec_immediate(conn,"insert into t_string values(123,1.222333,'one to one')")
if result:
cols = ifx_db.num_fields(result)
# NOTE: Removed '\n' from the following and a few more prints here (refer to ruby test_015.rb)
print "col:", cols
rows = ifx_db.num_rows(result)
print "affected row:", rows
else:
print ifx_db.stmt_errormsg()
result = ifx_db.exec_immediate(conn,"delete from t_string where a=123")
if result:
cols = ifx_db.num_fields(result)
print "col:", cols
rows = ifx_db.num_rows(result)
print "affected row:", rows
else:
print ifx_db.stmt_errormsg()
ifx_db.close(conn)
else:
print "no connection:", ifx_db.conn_errormsg()
def run_test_InsertRetrieveDateTimeTypeColumn(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
if conn:
drop = 'DROP TABLE tab_datetime'
result = ''
try:
result = ifx_db.exec_immediate(conn, drop)
except:
pass
t_val = datetime.time(10, 42, 34)
d_val = datetime.date(1981, 7, 8)
#ts_val = datetime.datetime.today()
ts_val = datetime.datetime(1981, 7, 8, 10, 42, 34, 10)
server = ifx_db.server_info(conn)
if (server.DBMS_NAME[0:3] == 'IDS'):
statement = "CREATE TABLE tab_datetime (col1 DATETIME HOUR TO SECOND, col2 DATE, col3 DATETIME YEAR TO FRACTION(5))"
result = ifx_db.exec_immediate(conn, statement)
statement = "INSERT INTO tab_datetime (col1, col2, col3) values (?, ?, ?)"
stmt = ifx_db.prepare(conn, statement)
result = ifx_db.execute(stmt, (t_val, d_val, ts_val))
else:
statement = "CREATE TABLE tab_datetime (col1 TIME, col2 DATE, col3 TIMESTAMP)"
result = ifx_db.exec_immediate(conn, statement)
statement = "INSERT INTO tab_datetime (col1, col2, col3) values (?, ?, ?)"
stmt = ifx_db.prepare(conn, statement)
result = ifx_db.execute(stmt, (t_val, d_val, ts_val))
statement = "SELECT * FROM tab_datetime"
result = ifx_db.exec_immediate(conn, statement)
for i in range(0, ifx_db.num_fields(result)):
print str(i) + ":" + ifx_db.field_type(result, i)
statement = "SELECT * FROM tab_datetime"
stmt = ifx_db.prepare(conn, statement)
rc = ifx_db.execute(stmt)
result = ifx_db.fetch_row(stmt)
while (result):
row0 = ifx_db.result(stmt, 0)
row1 = ifx_db.result(stmt, 1)
row2 = ifx_db.result(stmt, 2)
print type(row0), row0
print type(row1), row1
print type(row2), row2
result = ifx_db.fetch_row(stmt)
ifx_db.close(conn)
else:
print "Connection failed."
def run_test_016(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
if conn:
result = ifx_db.exec_immediate(
conn, "insert into t_string values(123,1.222333,'one to one')")
if result:
cols = ifx_db.num_fields(result)
print "col:", cols
rows = ifx_db.num_rows(result)
print "affected row:", rows
else:
print ifx_db.stmt_errormsg()
result = ifx_db.exec_immediate(conn,
"delete from t_string where a=123")
if result:
cols = ifx_db.num_fields(result)
print "col:", cols
rows = ifx_db.num_rows(result)
print "affected row:", rows
else:
print ifx_db.stmt_errormsg()
ifx_db.close(conn)
else:
print "no connection:", ifx_db.conn_errormsg()
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_103(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
if conn:
result = ifx_db.exec_immediate(
conn, "select * from org, project order by project.projname")
cols = ifx_db.num_fields(result)
j = 1
row = ifx_db.fetch_tuple(result)
while (row):
print "%d) " % j
for i in range(0, cols):
print "%s " % row[i]
j += 1
if (j > 10):
break
row = ifx_db.fetch_tuple(result)
ifx_db.close(conn)
else:
print ifx_db.conn_errormsg()
def run_test_103(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
if conn:
result = ifx_db.exec_immediate(
conn,
"select * from org, project order by project.projname,org.deptnumb"
)
cols = ifx_db.num_fields(result)
j = 1
row = ifx_db.fetch_tuple(result)
while (row):
print "%d) " % j
for i in range(0, cols):
print "%s " % row[i]
j += 1
if (j > 10):
break
row = ifx_db.fetch_tuple(result)
ifx_db.close(conn)
else:
print ifx_db.conn_errormsg()
#__END__
#__IDS_EXPECTED__
#1) 10 Head Office 160 Corporate New York AD3113 ACCOUNT PROGRAMMING D21 000270 2.00 1982-01-01 1983-02-01 AD3110
#2) 15 New England 50 Eastern Boston AD3113 ACCOUNT PROGRAMMING D21 000270 2.00 1982-01-01 1983-02-01 AD3110
#3) 20 Mid Atlantic 10 Eastern Washington AD3113 ACCOUNT PROGRAMMING D21 000270 2.00 1982-01-01 1983-02-01 AD3110
#4) 38 South Atlantic 30 Eastern Atlanta AD3113 ACCOUNT PROGRAMMING D21 000270 2.00 1982-01-01 1983-02-01 AD3110
#5) 42 Great Lakes 100 Midwest Chicago AD3113 ACCOUNT PROGRAMMING D21 000270 2.00 1982-01-01 1983-02-01 AD3110
#6) 51 Plains 140 Midwest Dallas AD3113 ACCOUNT PROGRAMMING D21 000270 2.00 1982-01-01 1983-02-01 AD3110
#7) 66 Pacific 270 Western San Francisco AD3113 ACCOUNT PROGRAMMING D21 000270 2.00 1982-01-01 1983-02-01 AD3110
#8) 84 Mountain 290 Western Denver AD3113 ACCOUNT PROGRAMMING D21 000270 2.00 1982-01-01 1983-02-01 AD3110
#9) 10 Head Office 160 Corporate New York AD3100 ADMIN SERVICES D01 000010 6.50 1982-01-01 1983-02-01
#10) 15 New England 50 Eastern Boston AD3100 ADMIN SERVICES D01 000010 6.50 1982-01-01 1983-02-01
def run_test_6792(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
if conn:
drop = 'DROP TABLE table_6792'
result = ''
try:
result = ifx_db.exec_immediate(conn, drop)
except:
pass
t_val = '10:42:34'
d_val = '1981-07-08'
ts_val = '1981-07-08 10:42:34'
ts_withT_val = '2013-06-06T15:30:39'
server = ifx_db.server_info(conn)
if (server.DBMS_NAME[0:3] == 'IDS'):
statement = "CREATE TABLE table_6792 (col1 DATETIME HOUR TO SECOND, col2 DATE, col3 DATETIME YEAR TO SECOND, col4 DATETIME YEAR TO SECOND)"
result = ifx_db.exec_immediate(conn, statement)
statement = "INSERT INTO table_6792 (col1, col2, col3) values (?, ?, ?)"
stmt = ifx_db.prepare(conn, statement)
result = ifx_db.execute(stmt, (t_val, d_val, ts_val))
else:
statement = "CREATE TABLE table_6792 (col1 TIME, col2 DATE, col3 TIMESTAMP, col4 TIMESTAMP)"
result = ifx_db.exec_immediate(conn, statement)
statement = "INSERT INTO table_6792 (col1, col2, col3, col4) values (?, ?, ?, ?)"
stmt = ifx_db.prepare(conn, statement)
result = ifx_db.execute(stmt,
(t_val, d_val, ts_val, ts_withT_val))
statement = "SELECT * FROM table_6792"
result = ifx_db.exec_immediate(conn, statement)
for i in range(0, ifx_db.num_fields(result)):
print str(i) + ":" + ifx_db.field_type(result, i)
statement = "SELECT * FROM table_6792"
stmt = ifx_db.prepare(conn, statement)
rc = ifx_db.execute(stmt)
result = ifx_db.fetch_row(stmt)
while (result):
row0 = ifx_db.result(stmt, 0)
row1 = ifx_db.result(stmt, 1)
row2 = ifx_db.result(stmt, 2)
row3 = ifx_db.result(stmt, 3)
print row0
print row1
print row2
print row3
result = ifx_db.fetch_row(stmt)
ifx_db.close(conn)
else:
print "Connection failed."
#__END__
#__LUW_EXPECTED__
#0:time
#1:date
#2:timestamp
#3:timestamp
#10:42:34
#1981-07-08
#1981-07-08 10:42:34
#2013-06-06 15:30:39
#__ZOS_EXPECTED__
#0:time
#1:date
#2:timestamp
#3:timestamp
#10:42:34
#1981-07-08
#1981-07-08 10:42:34
#2013-06-06 15:30:39
#__SYSTEMI_EXPECTED__
#0:time
#1:date
#2:timestamp
#3:timestamp
#10:42:34
#1981-07-08
#1981-07-08 10:42:34
#2013-06-06 15:30:39
#__IDS_EXPECTED__
#0:time
#1:date
#2:timestamp
#3:timestamp
#10:42:34
#1981-07-08
#1981-07-08 10:42:34
#2013-06-06 15:30:39
