def run_test_212(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")
if (server.DBMS_NAME[0:3] == 'Inf'):
i = "sales_person"
else:
i = "SALES_PERSON"
print "%s size %d" % (i, ifx_db.field_display_size(result, i))
i = 2
print "%d size %d" % (i, ifx_db.field_display_size(result, i))
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_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_213(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
result = ifx_db.exec_immediate(conn, "select * from sales")
i = "sales_person"
print "%s size %d\n" % (i, (ifx_db.field_display_size(result, i) or 0))
i = "REGION"
print "%s size %d\n" % (i, (ifx_db.field_display_size(result, i) or 0))
i = "REgion"
print "%s size %d\n" % (i, (ifx_db.field_display_size(result, i) or 0))
i = "HELMUT"
print "%s size %d\n" % (i, (ifx_db.field_display_size(result, i) or 0))
t = ifx_db.field_display_size(result, "")
print t
t = ifx_db.field_display_size(result, "HELMUT")
print t
t = ifx_db.field_display_size(result, "Region")
print t
t = ifx_db.field_display_size(result, "SALES_DATE")
print t