def run_test_112(self): conn = ibm_db.connect(config.database, config.user, config.password) if conn: drop = "DROP TABLE ftest" try: ibm_db.exec_immediate( conn, drop ) except: pass create = "CREATE TABLE ftest ( \"TEST\" INTEGER, \"test\" INTEGER, \"Test\" INTEGER )" ibm_db.exec_immediate(conn, create) insert = "INSERT INTO ftest VALUES (1,2,3)" ibm_db.exec_immediate(conn, insert) stmt = ibm_db.exec_immediate(conn, "SELECT * FROM ftest") num1 = ibm_db.field_num(stmt, "TEST") num2 = ibm_db.field_num(stmt, 'test') num3 = ibm_db.field_num(stmt, 'Test') print("int(%d)" % num1) print("int(%d)" % num2) print("int(%d)" % num3) else: print("Connection failed.")
def run_test_110(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info(conn) if conn: stmt = ibm_db.exec_immediate( conn, "SELECT * FROM animals ORDER BY breed") if (server.DBMS_NAME[0:3] == 'IDS'): num1 = ibm_db.field_num(stmt, "id") num2 = ibm_db.field_num(stmt, "breed") num3 = ibm_db.field_num(stmt, "name") num4 = ibm_db.field_num(stmt, "weight") num5 = ibm_db.field_num(stmt, "test") num6 = ibm_db.field_num(stmt, 8) num7 = ibm_db.field_num(stmt, 1) num8 = ibm_db.field_num(stmt, "WEIGHT") else: num1 = ibm_db.field_num(stmt, "ID") num2 = ibm_db.field_num(stmt, "BREED") num3 = ibm_db.field_num(stmt, "NAME") num4 = ibm_db.field_num(stmt, "WEIGHT") num5 = ibm_db.field_num(stmt, "TEST") num6 = ibm_db.field_num(stmt, 8) num7 = ibm_db.field_num(stmt, 1) num8 = ibm_db.field_num(stmt, "weight") print "int(%d)" % num1 print "int(%d)" % num2 print "int(%d)" % num3 print "int(%d)" % num4 print "%s" % num5 print "%s" % num6 print "int(%d)" % num7 print "%s" % num8 else: print "Connection failed."
def run_test_111(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info(conn) if conn: ibm_db.autocommit(conn, ibm_db.SQL_AUTOCOMMIT_OFF) insert = "INSERT INTO animals values (7, 'cat', 'Benji', 5.1)" ibm_db.exec_immediate(conn, insert) stmt = ibm_db.exec_immediate( conn, "SELECT breed, COUNT(breed) AS number FROM animals GROUP BY breed ORDER BY breed" ) if (server.DBMS_NAME[0:3] == 'IDS'): num1 = ibm_db.field_num(stmt, "id") num2 = ibm_db.field_num(stmt, "breed") num3 = ibm_db.field_num(stmt, "number") num4 = ibm_db.field_num(stmt, "NUMBER") num5 = ibm_db.field_num(stmt, "bREED") num6 = ibm_db.field_num(stmt, 8) num7 = ibm_db.field_num(stmt, 1) num8 = ibm_db.field_num(stmt, "WEIGHT") else: num1 = ibm_db.field_num(stmt, "ID") num2 = ibm_db.field_num(stmt, "BREED") num3 = ibm_db.field_num(stmt, "NUMBER") num4 = ibm_db.field_num(stmt, "number") num5 = ibm_db.field_num(stmt, "Breed") num6 = ibm_db.field_num(stmt, 8) num7 = ibm_db.field_num(stmt, 1) num8 = ibm_db.field_num(stmt, "weight") print("%s" % num1) print("int(%d)" % num2) print("int(%d)" % num3) print("%s" % num4) print("%s" % num5) print("%s" % num6) print("int(%d)" % num7) print("%s" % num8) ibm_db.rollback(conn) else: print("Connection failed.")
def run_test_110(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info( conn ) if conn: stmt = ibm_db.exec_immediate(conn, "SELECT * FROM animals ORDER BY breed") if (server.DBMS_NAME[0:3] == 'IDS'): num1 = ibm_db.field_num(stmt, "id") num2 = ibm_db.field_num(stmt, "breed") num3 = ibm_db.field_num(stmt, "name") num4 = ibm_db.field_num(stmt, "weight") num5 = ibm_db.field_num(stmt, "test") num6 = ibm_db.field_num(stmt, 8) num7 = ibm_db.field_num(stmt, 1) num8 = ibm_db.field_num(stmt, "WEIGHT") else: num1 = ibm_db.field_num(stmt, "ID") num2 = ibm_db.field_num(stmt, "BREED") num3 = ibm_db.field_num(stmt, "NAME") num4 = ibm_db.field_num(stmt, "WEIGHT") num5 = ibm_db.field_num(stmt, "TEST") num6 = ibm_db.field_num(stmt, 8) num7 = ibm_db.field_num(stmt, 1) num8 = ibm_db.field_num(stmt, "weight") print("int(%d)" % num1) print("int(%d)" % num2) print("int(%d)" % num3) print("int(%d)" % num4) print("%s" % num5) print("%s" % num6) print("int(%d)" % num7) print("%s" % num8) else: print("Connection failed.")
def run_test_111(self): conn = ibm_db.connect(config.database, config.user, config.password) server = ibm_db.server_info( conn ) if conn: ibm_db.autocommit(conn, ibm_db.SQL_AUTOCOMMIT_OFF) insert = "INSERT INTO animals values (7, 'cat', 'Benji', 5.1)" ibm_db.exec_immediate(conn, insert) stmt = ibm_db.exec_immediate(conn, "SELECT breed, COUNT(breed) AS number FROM animals GROUP BY breed ORDER BY breed") if (server.DBMS_NAME[0:3] == 'IDS'): num1 = ibm_db.field_num(stmt, "id") num2 = ibm_db.field_num(stmt, "breed") num3 = ibm_db.field_num(stmt, "number") num4 = ibm_db.field_num(stmt, "NUMBER") num5 = ibm_db.field_num(stmt, "bREED") num6 = ibm_db.field_num(stmt, 8) num7 = ibm_db.field_num(stmt, 1) num8 = ibm_db.field_num(stmt, "WEIGHT") else: num1 = ibm_db.field_num(stmt, "ID") num2 = ibm_db.field_num(stmt, "BREED") num3 = ibm_db.field_num(stmt, "NUMBER") num4 = ibm_db.field_num(stmt, "number") num5 = ibm_db.field_num(stmt, "Breed") num6 = ibm_db.field_num(stmt, 8) num7 = ibm_db.field_num(stmt, 1) num8 = ibm_db.field_num(stmt, "weight") print "%s" % num1 print "int(%d)" % num2 print "int(%d)" % num3 print "%s" % num4 print "%s" % num5 print "%s" % num6 print "int(%d)" % num7 print "%s" % num8 ibm_db.rollback(conn) else: print "Connection failed."
pass # If The SQL Statement Could Not Be Executed, Display An Error Message And Exit if resultSet is False: print("\nERROR: Unable to execute the SQL statement specified.") conn.closeConnection() exit(-1) # Otherwise, Complete The Status Message else: print("Done!\n") # Find Out Which Column In The Result Set Produced By The Query Just Executed Contains Data # That Was Retrieved From The "BIRTHDATE" Column Of The Table try: columnNumber = ibm_db.field_num(resultSet, 'BIRTHDATE') except Exception: pass # If The Column Number For The "BIRTHDATE" Column Could Not Be Obtained, Display An Error # Message And Exit if columnNumber is False: print( "\nERROR: Unable to obtain information about the result set produced.") conn.closeConnection() exit(-1) # Format And Display The Data Retrieved print("\'BIRTHDATE\' data can be found in column number {:<2} ".format( columnNumber), end="")