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