def run_test_190(self):
conn = IfxPy.connect(config.ConnStr, config.user, config.password)
server = IfxPy.server_info(conn)
if conn:
if (server.DBMS_NAME[0:3] == 'Inf'):
result = IfxPy.columns(conn, None, config.user, "employee")
else:
result = IfxPy.columns(conn, None, None, "EMPLOYEE")
row = IfxPy.fetch_tuple(result)
while (row):
str = row[1] + "/" + row[3]
print(str)
row = IfxPy.fetch_tuple(result)
print("done!")
else:
print("no connection:", IfxPy.conn_errormsg())
def run_test_191(self):
conn = IfxPy.connect(config.ConnStr, config.user, config.password)
server = IfxPy.server_info( conn )
if conn:
result = IfxPy.columns(conn,None,config.user,"emp_photo");
i = 0
row = IfxPy.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 = IfxPy.fetch_both(result)
print "done!"
else:
print "no connection: ", IfxPy.conn_errormsg()
def run_test_008(self):
op = {IfxPy.ATTR_CASE: IfxPy.CASE_NATURAL}
conn = IfxPy.connect(config.ConnStr, config.user, config.password, op)
server = IfxPy.server_info(conn)
result = IfxPy.columns(conn, None, None, "employee")
row = IfxPy.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 = {IfxPy.ATTR_CASE: IfxPy.CASE_UPPER}
IfxPy.set_option(conn, op, 1)
result = IfxPy.columns(conn, None, None, "employee")
row = IfxPy.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 = {IfxPy.ATTR_CASE: IfxPy.CASE_LOWER}
IfxPy.set_option(conn, op, 1)
result = IfxPy.columns(conn, None, None, "employee")
row = IfxPy.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
