def test_select_with_where(self): sqlhash.set_state({"a_table": [{"a_column": "1"}, {"a_column": "2"}]}) query = "SELECT a_column FROM a_table WHERE a_column = '1'" result = sqlhash.execute(query) self.assertEquals([{"a_column": "1"}], result)
def test_select_from_empty_table(self): sqlhash.set_state({"empty_table": []}) query = "SELECT * FROM empty_table" result = sqlhash.execute(query) self.assertEquals([], result)
def test_select_one_row_two_columns(self): sqlhash.set_state({"a_table": [{"a_column": "1", "b_column": "2", "c_column": "3"}]}) query = "SELECT a_column, b_column FROM a_table" result = sqlhash.execute(query) self.assertEquals([{"a_column": "1", "b_column": "2"}], result)