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(), [])