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