def run_test_064(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info( conn ) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, 't') else: result = ibm_db.tables(conn, None, 'T') for i in range(0, ibm_db.num_fields(result)): print("%s, " % ibm_db.field_name(result, i)) print() print() i = 0 row = ibm_db.fetch_tuple(result) while ( row ): ibm_db.num_fields(result) if (i < 4): print(", " + row[1] + ", " + row[2] + ", " + row[3] + ", , \n") i = i + 1 row = ibm_db.fetch_tuple(result) ibm_db.free_result(result) ibm_db.exec_immediate(conn, 'DROP TABLE t.t1') ibm_db.exec_immediate(conn, 'DROP TABLE t.t2') ibm_db.exec_immediate(conn, 'DROP TABLE t.t3') ibm_db.exec_immediate(conn, 'DROP TABLE t.t4')
def run_test_064(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info(conn) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, 't') else: result = ibm_db.tables(conn, None, 'T') for i in range(0, ibm_db.num_fields(result)): print "%s, " % ibm_db.field_name(result, i) print print i = 0 row = ibm_db.fetch_tuple(result) while (row): ibm_db.num_fields(result) if (i < 4): print ", " + row[1] + ", " + row[2] + ", " + row[3] + ", , \n" i = i + 1 row = ibm_db.fetch_tuple(result) ibm_db.free_result(result) ibm_db.exec_immediate(conn, 'DROP TABLE t.t1') ibm_db.exec_immediate(conn, 'DROP TABLE t.t2') ibm_db.exec_immediate(conn, 'DROP TABLE t.t3') ibm_db.exec_immediate(conn, 'DROP TABLE t.t4')
def run_test_065(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info( conn ) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, '%', "t3") else: result = ibm_db.tables(conn, None, '%', "T3") columns = ibm_db.num_fields(result) for i in range(0, columns): print "%s, " % ibm_db.field_name(result, i) print "\n\n" row = ibm_db.fetch_tuple(result) while ( row ): final = ", " + row[1] + ", " + row[2] + ", " + row[3] + ", , "; row = ibm_db.fetch_tuple(result) print final ibm_db.free_result(result) ibm_db.exec_immediate(conn, 'DROP TABLE t.t1') ibm_db.exec_immediate(conn, 'DROP TABLE t.t2') ibm_db.exec_immediate(conn, 'DROP TABLE t.t3') ibm_db.exec_immediate(conn, 'DROP TABLE t.t4')
def run_test_065(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info(conn) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, '%', "t3") else: result = ibm_db.tables(conn, None, '%', "T3") columns = ibm_db.num_fields(result) for i in range(0, columns): print("%s, " % ibm_db.field_name(result, i)) print("\n\n") row = ibm_db.fetch_tuple(result) while (row): final = ", " + row[1] + ", " + row[2] + ", " + row[3] + ", , " row = ibm_db.fetch_tuple(result) print(final) ibm_db.free_result(result) ibm_db.exec_immediate(conn, 'DROP TABLE t.t1') ibm_db.exec_immediate(conn, 'DROP TABLE t.t2') ibm_db.exec_immediate(conn, 'DROP TABLE t.t3') ibm_db.exec_immediate(conn, 'DROP TABLE t.t4')
def run_test_060(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info(conn) create = "CREATE SCHEMA AUTHORIZATION t" try: result = ibm_db.exec_immediate(conn, create) except: pass create = "CREATE TABLE t.t1( c1 INTEGER, c2 VARCHAR(40))" try: result = ibm_db.exec_immediate(conn, create) except: pass create = "CREATE TABLE t.t2( c1 INTEGER, c2 VARCHAR(40))" try: result = ibm_db.exec_immediate(conn, create) except: pass create = "CREATE TABLE t.t3( c1 INTEGER, c2 VARCHAR(40))" try: result = ibm_db.exec_immediate(conn, create) except: pass create = "CREATE TABLE t.t4( c1 INTEGER, c2 VARCHAR(40))" try: result = ibm_db.exec_immediate(conn, create) except: pass if conn: if server.DBMS_NAME[0:3] == "IDS": result = ibm_db.tables(conn, None, "t") else: result = ibm_db.tables(conn, None, "T") i = 0 row = ibm_db.fetch_both(result) while row: if i < 4: print "/%s/%s" % (row[1], row[2]) i = i + 1 row = ibm_db.fetch_both(result) ibm_db.exec_immediate(conn, "DROP TABLE t.t1") ibm_db.exec_immediate(conn, "DROP TABLE t.t2") ibm_db.exec_immediate(conn, "DROP TABLE t.t3") ibm_db.exec_immediate(conn, "DROP TABLE t.t4") print "done!" else: print "no connection: #{ibm_db.conn_errormsg}"
def run_test_060(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info(conn) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 INTEGER, c2 VARCHAR(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 INTEGER, c2 VARCHAR(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 INTEGER, c2 VARCHAR(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 INTEGER, c2 VARCHAR(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass if conn: if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, 't') else: result = ibm_db.tables(conn, None, 'T') i = 0 row = ibm_db.fetch_both(result) while (row): if (i < 4): print("/%s/%s" % (row[1], row[2])) i = i + 1 row = ibm_db.fetch_both(result) ibm_db.exec_immediate(conn, 'DROP TABLE t.t1') ibm_db.exec_immediate(conn, 'DROP TABLE t.t2') ibm_db.exec_immediate(conn, 'DROP TABLE t.t3') ibm_db.exec_immediate(conn, 'DROP TABLE t.t4') print("done!") else: print("no connection: #{ibm_db.conn_errormsg}")
def _cache_table_exists(self): exists = False try: if not self.is_postgre_sql: stmt = ibm_db.tables(self.db_connection, None, self.schema, self.cache_tablename, None) try: fetch_value = ibm_db.fetch_row(stmt, 0) if fetch_value: exists = True finally: ibm_db.free_result(stmt) else: exists = dbhelper.check_table_exist(self.db_connection, self.db_type, self.schema, self.cache_tablename) except Exception as ex: raise Exception( 'Error while probing for table %s.%s' % (self.quoted_schema, self.quoted_cache_tablename)) from ex logger.debug('Table %s.%s %s.' % (self.quoted_schema, self.quoted_cache_tablename, 'exists' if exists else 'does not exist')) return exists
def run_test_061(self): conn = ibm_db.connect(config.database, config.user, config.password) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass if conn: server = ibm_db.server_info( conn ) if (server.DBMS_NAME[0:3] == 'IDS'): op = {ibm_db.ATTR_CASE: ibm_db.CASE_UPPER} ibm_db.set_option(conn, op, 0) result = ibm_db.tables(conn, None, 'T'); i = 0 row = ibm_db.fetch_both(result) while ( row ): str = row['TABLE_SCHEM'] + row['TABLE_NAME'] + row['TABLE_TYPE'] if (i < 4): print str i = i + 1 row = ibm_db.fetch_both(result) ibm_db.exec_immediate(conn, 'DROP TABLE t.t1') ibm_db.exec_immediate(conn, 'DROP TABLE t.t2') ibm_db.exec_immediate(conn, 'DROP TABLE t.t3') ibm_db.exec_immediate(conn, 'DROP TABLE t.t4') print "done!" else: print "no connection: %s" % ibm_db.conn_errormsg()
def run_test_062(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info( conn ) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass if conn: if (server.DBMS_NAME[0:3] == 'IDS'): schema = 't' else: schema = 'T' result = ibm_db.tables(conn,None,schema); i = 0 row = ibm_db.fetch_both(result) while ( row ): str = row[1] + "/" + row[2] + "/" + row[3] if (i < 4): print(str) i = i + 1 row = ibm_db.fetch_both(result) ibm_db.exec_immediate(conn, 'DROP TABLE t.t1') ibm_db.exec_immediate(conn, 'DROP TABLE t.t2') ibm_db.exec_immediate(conn, 'DROP TABLE t.t3') ibm_db.exec_immediate(conn, 'DROP TABLE t.t4') print("done!") else: print("no connection: #{ibm_db.conn_errormsg}");
def run_test_063(self): conn = ibm_db.connect(config.database, config.user, config.password) result = ibm_db.tables(conn, None, "SYSIBM", "", "VIEW") if (type(result) == ibm_db.IBM_DBStatement): print "Resource is a DB2 Statement" ibm_db.free_result(result)
def run_test_063(self): conn = ibm_db.connect(config.database, config.user, config.password) result = ibm_db.tables(conn, None, "SYSIBM", "", "VIEW") if (type(result) == ibm_db.IBM_DBStatement): print("Resource is a DB2 Statement") ibm_db.free_result(result)
def run_test_062(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info( conn ) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass if conn: if (server.DBMS_NAME[0:3] == 'IDS'): schema = 't' else: schema = 'T' result = ibm_db.tables(conn,None,schema); i = 0 row = ibm_db.fetch_both(result) while ( row ): str = row[1] + "/" + row[2] + "/" + row[3] if (i < 4): print str i = i + 1 row = ibm_db.fetch_both(result) ibm_db.exec_immediate(conn, 'DROP TABLE t.t1') ibm_db.exec_immediate(conn, 'DROP TABLE t.t2') ibm_db.exec_immediate(conn, 'DROP TABLE t.t3') ibm_db.exec_immediate(conn, 'DROP TABLE t.t4') print "done!" else: print "no connection: #{ibm_db.conn_errormsg}";
def run_test_061(self): conn = ibm_db.connect(config.database, config.user, config.password) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass if conn: server = ibm_db.server_info(conn) if (server.DBMS_NAME[0:3] == 'IDS'): op = {ibm_db.ATTR_CASE: ibm_db.CASE_UPPER} ibm_db.set_option(conn, op, 0) result = ibm_db.tables(conn, None, 'T') i = 0 row = ibm_db.fetch_both(result) while (row): str = row['TABLE_SCHEM'] + row['TABLE_NAME'] + row['TABLE_TYPE'] if (i < 4): print str i = i + 1 row = ibm_db.fetch_both(result) ibm_db.exec_immediate(conn, 'DROP TABLE t.t1') ibm_db.exec_immediate(conn, 'DROP TABLE t.t2') ibm_db.exec_immediate(conn, 'DROP TABLE t.t3') ibm_db.exec_immediate(conn, 'DROP TABLE t.t4') print "done!" else: print "no connection: %s" % ibm_db.conn_errormsg()
def chk_table(self, conn, schema, tabname): tables = [] tables_set = ibm_db.tables(conn, None, schema) result = ibm_db.fetch_both(tables_set) while (result): tables.append(result[2]) result = ibm_db.fetch_both(tables_set) if tabname in tables: return True return False
def run_test_060(self): conn = ibm_db.connect(config.database, config.user, config.password) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 INTEGER, c2 VARCHAR(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 INTEGER, c2 VARCHAR(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 INTEGER, c2 VARCHAR(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 INTEGER, c2 VARCHAR(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass if conn: result = ibm_db.tables(conn, None, 'T') i = 0 row = ibm_db.fetch_both(result) while ( row ): if (i < 4): print "/%s/%s" % (row[1], row[2]) i = i + 1 row = ibm_db.fetch_both(result) ibm_db.exec_immediate(conn, 'DROP TABLE t.t1') ibm_db.exec_immediate(conn, 'DROP TABLE t.t2') ibm_db.exec_immediate(conn, 'DROP TABLE t.t3') ibm_db.exec_immediate(conn, 'DROP TABLE t.t4') print "done!" else: print "no connection: #{ibm_db.conn_errormsg}";
def run_test_066(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info(conn) if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, config.user.lower(), 'animals') else: result = ibm_db.tables(conn, None, config.user.upper(), 'ANIMALS') # NOTE: This is a workaround # function fetch_object() to be implemented... # row = ibm_db.fetch_object(result) class Row: pass data = ibm_db.fetch_assoc(result) while (data): row = Row() if (server.DBMS_NAME[0:3] == 'IDS'): row.table_schem = data['table_schem'] row.table_name = data['table_name'] row.table_type = data['table_type'] row.remarks = data['remarks'] print("Schema: %s" % row.table_schem) print("Name: %s" % row.table_name) print("Type: %s" % row.table_type) print("Remarks: %s\n" % row.remarks) else: row.TABLE_SCHEM = data['TABLE_SCHEM'] row.TABLE_NAME = data['TABLE_NAME'] row.TABLE_TYPE = data['TABLE_TYPE'] row.REMARKS = data['REMARKS'] print("Schema: %s" % row.TABLE_SCHEM) print("Name: %s" % row.TABLE_NAME) print("Type: %s" % row.TABLE_TYPE) print("Remarks: %s\n" % row.REMARKS) # row = ibm_db.fetch_object(result) data = ibm_db.fetch_assoc(result) if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, config.user.lower(), 'animal_pics') else: result = ibm_db.tables(conn, None, config.user.upper(), 'ANIMAL_PICS') # row = ibm_db.fetch_object(result) data = ibm_db.fetch_assoc(result) while (data): row = Row() if (server.DBMS_NAME[0:3] == 'IDS'): row.table_schem = data['table_schem'] row.table_name = data['table_name'] row.table_type = data['table_type'] row.remarks = data['remarks'] print("Schema: %s" % row.table_schem) print("Name: %s" % row.table_name) print("Type: %s" % row.table_type) print("Remarks: %s\n" % row.remarks) else: row.TABLE_SCHEM = data['TABLE_SCHEM'] row.TABLE_NAME = data['TABLE_NAME'] row.TABLE_TYPE = data['TABLE_TYPE'] row.REMARKS = data['REMARKS'] print("Schema: %s" % row.TABLE_SCHEM) print("Name: %s" % row.TABLE_NAME) print("Type: %s" % row.TABLE_TYPE) print("Remarks: %s\n" % row.REMARKS) # row = ibm_db.fetch_object(result) data = ibm_db.fetch_assoc(result) if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, config.user.lower(), 'anime_cat') else: result = ibm_db.tables(conn, None, config.user.upper(), 'ANIME_CAT') # row = ibm_db.fetch_object(result) data = ibm_db.fetch_assoc(result) while (data): row = Row() if (server.DBMS_NAME[0:3] == 'IDS'): row.table_schem = data['table_schem'] row.table_name = data['table_name'] row.table_type = data['table_type'] row.remarks = data['remarks'] print("Schema: %s" % row.table_schem) print("Name: %s" % row.table_name) print("Type: %s" % row.table_type) print("Remarks: %s\n" % row.remarks) else: row.TABLE_SCHEM = data['TABLE_SCHEM'] row.TABLE_NAME = data['TABLE_NAME'] row.TABLE_TYPE = data['TABLE_TYPE'] row.REMARKS = data['REMARKS'] print("Schema: %s" % row.TABLE_SCHEM) print("Name: %s" % row.TABLE_NAME) print("Type: %s" % row.TABLE_TYPE) print("Remarks: %s\n" % row.REMARKS) # row = ibm_db.fetch_object(result) data = ibm_db.fetch_assoc(result) ibm_db.free_result(result) ibm_db.close(conn)
def run_test_066(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info( conn ) if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, config.user.lower(), 'animals') else: result = ibm_db.tables(conn, None, config.user.upper(), 'ANIMALS') # NOTE: This is a workaround # function fetch_object() to be implemented... # row = ibm_db.fetch_object(result) class Row: pass data = ibm_db.fetch_assoc(result) while ( data ): row = Row() if (server.DBMS_NAME[0:3] == 'IDS'): row.table_schem = data['table_schem'] row.table_name = data['table_name'] row.table_type = data['table_type'] row.remarks = data['remarks'] print("Schema: %s" % row.table_schem) print("Name: %s" % row.table_name) print("Type: %s" % row.table_type) print("Remarks: %s\n" % row.remarks) else: row.TABLE_SCHEM = data['TABLE_SCHEM'] row.TABLE_NAME = data['TABLE_NAME'] row.TABLE_TYPE = data['TABLE_TYPE'] row.REMARKS = data['REMARKS'] print("Schema: %s" % row.TABLE_SCHEM) print("Name: %s" % row.TABLE_NAME) print("Type: %s" % row.TABLE_TYPE) print("Remarks: %s\n" % row.REMARKS) # row = ibm_db.fetch_object(result) data = ibm_db.fetch_assoc(result) if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, config.user.lower(), 'animal_pics') else: result = ibm_db.tables(conn, None, config.user.upper(), 'ANIMAL_PICS') # row = ibm_db.fetch_object(result) data = ibm_db.fetch_assoc(result) while (data ): row = Row() if (server.DBMS_NAME[0:3] == 'IDS'): row.table_schem = data['table_schem'] row.table_name = data['table_name'] row.table_type = data['table_type'] row.remarks = data['remarks'] print("Schema: %s" % row.table_schem) print("Name: %s" % row.table_name) print("Type: %s" % row.table_type) print("Remarks: %s\n" % row.remarks) else: row.TABLE_SCHEM = data['TABLE_SCHEM'] row.TABLE_NAME = data['TABLE_NAME'] row.TABLE_TYPE = data['TABLE_TYPE'] row.REMARKS = data['REMARKS'] print("Schema: %s" % row.TABLE_SCHEM) print("Name: %s" % row.TABLE_NAME) print("Type: %s" % row.TABLE_TYPE) print("Remarks: %s\n" % row.REMARKS) # row = ibm_db.fetch_object(result) data = ibm_db.fetch_assoc(result) if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, config.user.lower(), 'anime_cat') else: result = ibm_db.tables(conn, None, config.user.upper(), 'ANIME_CAT') # row = ibm_db.fetch_object(result) data = ibm_db.fetch_assoc(result) while ( data ): row = Row() if (server.DBMS_NAME[0:3] == 'IDS'): row.table_schem = data['table_schem'] row.table_name = data['table_name'] row.table_type = data['table_type'] row.remarks = data['remarks'] print("Schema: %s" % row.table_schem) print("Name: %s" % row.table_name) print("Type: %s" % row.table_type) print("Remarks: %s\n" % row.remarks) else: row.TABLE_SCHEM = data['TABLE_SCHEM'] row.TABLE_NAME = data['TABLE_NAME'] row.TABLE_TYPE = data['TABLE_TYPE'] row.REMARKS = data['REMARKS'] print("Schema: %s" % row.TABLE_SCHEM) print("Name: %s" % row.TABLE_NAME) print("Type: %s" % row.TABLE_TYPE) print("Remarks: %s\n" % row.REMARKS) # row = ibm_db.fetch_object(result) data = ibm_db.fetch_assoc(result) ibm_db.free_result(result) ibm_db.close(conn)
def run_test_064(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info( conn ) create = 'CREATE SCHEMA AUTHORIZATION t' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t1( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t2( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t3( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass create = 'CREATE TABLE t.t4( c1 integer, c2 varchar(40))' try: result = ibm_db.exec_immediate(conn, create) except: pass if (server.DBMS_NAME[0:3] == 'IDS'): result = ibm_db.tables(conn, None, 't') else: result = ibm_db.tables(conn, None, 'T') for i in range(0, ibm_db.num_fields(result)): print "%s, " % ibm_db.field_name(result, i) print print i = 0 row = ibm_db.fetch_tuple(result) while ( row ): ibm_db.num_fields(result) if (i < 4): print ", " + row[1] + ", " + row[2] + ", " + row[3] + ", , \n" i = i + 1 row = ibm_db.fetch_tuple(result) ibm_db.free_result(result) ibm_db.exec_immediate(conn, 'DROP TABLE t.t1') ibm_db.exec_immediate(conn, 'DROP TABLE t.t2') ibm_db.exec_immediate(conn, 'DROP TABLE t.t3') ibm_db.exec_immediate(conn, 'DROP TABLE t.t4') #__END__ #__LUW_EXPECTED__ #TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, # #, T, T1, TABLE, , #, T, T2, TABLE, , #, T, T3, TABLE, , #, T, T4, TABLE, , #__ZOS_EXPECTED__ #TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, # #, T, T1, TABLE, , #, T, T2, TABLE, , #, T, T3, TABLE, , #, T, T4, TABLE, , #__SYSTEMI_EXPECTED__ #TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, # #, T, T1, TABLE, , #, T, T2, TABLE, , #, T, T3, TABLE, , #, T, T4, TABLE, , #__IDS_EXPECTED__ #table_cat, table_schem, table_name, table_type, remarks, # #, t, t1, TABLE%s, , #, t, t2, TABLE%s, , #, t, t3, TABLE%s, , #, t, t4, TABLE%s, ,
ret = [] result = fetch_assoc(command) while result: # This builds a list in memory. Theoretically, if there's a lot of rows, # we could run out of memory. In practice, I've never had that happen. # If it's ever a problem, you could use # yield result # Then this function would become a generator. You lose the ability to access # results by index or slice them or whatever, but you retain # the ability to iterate on them. ret.append(result) result = fetch_assoc(command) return ret # Ditch this line if you choose to use a generator. t = results(tables(connection)) sql = 'SELECT * FROM ' + t[0][ 'TABLE_NAME'] # Using our list of tables t from before... print(sql) rows = results(exec_immediate(connection, sql)) print(rows) # In[142]: import ibm_db conn = ibm_db.connect(dsn='SAMPLE', uid='sriniintraning', pwd='prime14773-')
# Create An Instance Of The Db2ConnectionMgr Class And Use It To Connect To A Db2 Database conn = Db2ConnectionMgr('DB', dbName, '', '', userID, passWord) conn.openConnection() if conn.returnCode is True: dbConnection = conn.connectionID else: conn.closeConnection() exit(-1) # Attempt To Retrieve Information About The Tables In The Current User's Schema Whose Name # Begins With The Letter "P" print("Obtaining information about select tables in the ", end="") print(schemaName + " schema ... ", end="") try: resultSet = ibm_db.tables(dbConnection, None, schemaName, 'P%', 'TABLE') except Exception: pass # If The Information Desired Could Not Be Retrieved, Display An Error Message And Exit if resultSet is False: print("\nERROR: Unable to obtain the information desired\n.") conn.closeConnection() exit(-1) # Otherwise, Complete The Status Message else: print("Done!\n") # As Long As There Are Records (That Were Produced By The ibm_db.tables API), ... noData = False