def test_array_support_with_empty(self):
try:
self.connection.execute("DROP TABLE array_test")
self.connection.commit()
except:
self.connection.rollback()
self.connection.execute("CREATE TABLE array_test "
"(id SERIAL PRIMARY KEY, a INT[])")
variable = ListVariable(IntVariable)
variable.set([])
state = State()
statement = compile(variable, state)
self.connection.execute("INSERT INTO array_test VALUES (1, %s)"
% statement, state.parameters)
result = self.connection.execute("SELECT a FROM array_test WHERE id=1")
array = result.get_one()[0]
self.assertTrue(isinstance(array, list))
variable = ListVariable(IntVariable)
result.set_variable(variable, array)
self.assertEquals(variable.get(), [])
def test_array_support_with_empty(self):
try:
self.connection.execute("DROP TABLE array_test")
self.connection.commit()
except:
self.connection.rollback()
self.connection.execute("CREATE TABLE array_test "
"(id SERIAL PRIMARY KEY, a INT[])")
variable = ListVariable(IntVariable)
variable.set([])
state = State()
statement = compile(variable, state)
self.connection.execute(
"INSERT INTO array_test VALUES (1, %s)" % statement,
state.parameters)
result = self.connection.execute("SELECT a FROM array_test WHERE id=1")
array = result.get_one()[0]
self.assertTrue(isinstance(array, list))
variable = ListVariable(IntVariable)
result.set_variable(variable, array)
self.assertEquals(variable.get(), [])