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="")
