def run_test_191(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
server = ifx_db.server_info( conn )
if conn:
if (server.DBMS_NAME[0:3] == 'IDS'):
result = ifx_db.columns(conn,None,config.user,"emp_photo");
else:
result = ifx_db.columns(conn,None,None,"EMP_PHOTO");
i = 0
row = ifx_db.fetch_both(result)
while ( row ):
if (server.DBMS_NAME[0:3] == 'IDS'):
if ( (row['column_name'] != 'emp_rowid') and (i < 3) ):
print "%s,%s,%s,%s\n" % (row['table_schem'],
row['table_name'], row['column_name'], row['is_nullable'])
else :
if ( (row['COLUMN_NAME'] != 'EMP_ROWID') and (i < 3) ):
print"%s,%s,%s,%s\n" % (row['TABLE_SCHEM'],
row['TABLE_NAME'], row['COLUMN_NAME'], row['IS_NULLABLE'])
i = i + 1
row = ifx_db.fetch_both(result)
print "done!"
else:
print "no connection: ", ifx_db.conn_errormsg()
def run_test_190(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
server = ifx_db.server_info(conn)
if conn:
if (server.DBMS_NAME[0:3] == 'Inf'):
result = ifx_db.columns(conn, None, config.user, "employee")
else:
result = ifx_db.columns(conn, None, None, "EMPLOYEE")
row = ifx_db.fetch_tuple(result)
while (row):
str = row[1] + "/" + row[3]
print str
row = ifx_db.fetch_tuple(result)
print "done!"
else:
print "no connection:", ifx_db.conn_errormsg()
def run_test_191(self):
conn = ifx_db.connect(config.ConnStr, config.user, config.password)
server = ifx_db.server_info(conn)
if conn:
result = ifx_db.columns(conn, None, config.user, "emp_photo")
i = 0
row = ifx_db.fetch_both(result)
while (row):
if ((row['COLUMN_NAME'] != 'emp_rowid') and (i < 3)):
print "%s,%s,%s,%s\n" % (
row['TABLE_SCHEM'], row['TABLE_NAME'],
row['COLUMN_NAME'], row['IS_NULLABLE'])
i = i + 1
row = ifx_db.fetch_both(result)
print "done!"
else:
print "no connection: ", ifx_db.conn_errormsg()
def run_test_008(self):
op = {ifx_db.ATTR_CASE: ifx_db.CASE_NATURAL}
conn = ifx_db.connect(config.ConnStr, config.user, config.password, op)
server = ifx_db.server_info(conn)
if (server.DBMS_NAME[0:3] == 'IDS'):
result = ifx_db.columns(conn, None, None, "employee")
else:
result = ifx_db.columns(conn, None, None, "EMPLOYEE")
row = ifx_db.fetch_both(result)
value1 = None
value2 = None
value3 = None
value4 = None
if (row.has_key('TABLE_NAME')):
value1 = row['TABLE_NAME']
if (row.has_key('COLUMN_NAME')):
value2 = row['COLUMN_NAME']
if (row.has_key('table_name')):
value3 = row['table_name']
if (row.has_key('column_name')):
value4 = row['column_name']
print value1
print value2
print value3
print value4
op = {ifx_db.ATTR_CASE: ifx_db.CASE_UPPER}
ifx_db.set_option(conn, op, 1)
if (server.DBMS_NAME[0:3] == 'IDS'):
result = ifx_db.columns(conn, None, None, "employee")
else:
result = ifx_db.columns(conn, None, None, "EMPLOYEE")
row = ifx_db.fetch_both(result)
value1 = None
value2 = None
value3 = None
value4 = None
if (row.has_key('TABLE_NAME')):
value1 = row['TABLE_NAME']
if (row.has_key('COLUMN_NAME')):
value2 = row['COLUMN_NAME']
if (row.has_key('table_name')):
value3 = row['table_name']
if (row.has_key('column_name')):
value4 = row['column_name']
print value1
print value2
print value3
print value4
op = {ifx_db.ATTR_CASE: ifx_db.CASE_LOWER}
ifx_db.set_option(conn, op, 1)
if (server.DBMS_NAME[0:3] == 'IDS'):
result = ifx_db.columns(conn, None, None, "employee")
else:
result = ifx_db.columns(conn, None, None, "EMPLOYEE")
row = ifx_db.fetch_both(result)
value1 = None
value2 = None
value3 = None
value4 = None
if (row.has_key('TABLE_NAME')):
value1 = row['TABLE_NAME']
if (row.has_key('COLUMN_NAME')):
value2 = row['COLUMN_NAME']
if (row.has_key('table_name')):
value3 = row['table_name']
if (row.has_key('column_name')):
value4 = row['column_name']
print value1
print value2
print value3
print value4