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