-
Notifications
You must be signed in to change notification settings - Fork 191
/
test_6561_InsertNULLValues.py
52 lines (42 loc) · 1.31 KB
/
test_6561_InsertNULLValues.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
#
# Licensed Materials - Property of IBM
#
# (c) Copyright IBM Corp. 2007-2008
#
from __future__ import print_function
import sys
import unittest
import ibm_db
import config
from testfunctions import IbmDbTestFunctions
class IbmDbTestCase(unittest.TestCase):
def test_6561_InsertNULLValues(self):
obj = IbmDbTestFunctions()
obj.assert_expect(self.run_test_6561)
def run_test_6561(self):
conn = ibm_db.connect(config.database, config.user, config.password)
if conn:
ibm_db.autocommit(conn, ibm_db.SQL_AUTOCOMMIT_OFF)
stmt = ibm_db.exec_immediate(conn, "INSERT INTO animals (id, breed, name, weight) VALUES (null, null, null, null)")
statement = "SELECT count(id) FROM animals"
result = ibm_db.exec_immediate(conn, statement)
if ( (not result) and ibm_db.stmt_error() ):
print("ERROR: %s" % (ibm_db.stmt_errormsg(), ))
row = ibm_db.fetch_tuple(result)
while ( row ):
for i in row:
print(i)
row = ibm_db.fetch_tuple(result)
ibm_db.rollback(conn)
ibm_db.close(conn)
else:
print("Connection failed.")
#__END__
#__LUW_EXPECTED__
#7
#__ZOS_EXPECTED__
#7
#__SYSTEMI_EXPECTED__
#7
#__IDS_EXPECTED__
#7