def test_load_better_generate_metas(self):
sql = SQL_LITE_POOL.get(self.dataset_name)
table = sql.load_better(self.schema, True, \
{"identity" : ID, "fooo" : "foo", "baar": "bar + 1"}, \
None, "foo", None, None)
table.printit()
def test_load_better(self):
sql = SQL_LITE_POOL.get(self.dataset_name)
table = sql.load_better(self.schema, False, \
{"identity" : ID, "fooo" : "foo", "baar": "bar + 1"}, \
"bar < 50", \
None, \
None, \
"fooo")
table.printit()
def insert_entries(self):
sql = SQL_LITE_POOL.get(self.dataset_name)
entries = [ \
Entry.create_new(self.schema, 2, "sqll", \
{"foo": "lorem", "bar": 99, "baz": 11.11}),
Entry.create_new(self.schema, 3, "sqll", \
{"foo": "ipsum", "bar": 11, "baz": -1.01}),
Entry.create_new(self.schema, 4, "sqll", \
{"foo": "dolor", "bar": 11, "baz": 3.14})
]
sql.insert_entries(self.schema, entries)
def insert_entry(self):
sql = SQL_LITE_POOL.get(self.dataset_name)
entry = Entry.create_new(self.schema, 1, "sqll", \
{ "foo": "hello", "bar": 42, "baz": 99.9 })
sql.insert_entry(self.schema, entry)
def delete_table(self):
sql = SQL_LITE_POOL.get(self.dataset_name)
sql.delete_table()
def create_table(self):
sql = SQL_LITE_POOL.get(self.dataset_name)
sql.create_table(self.schema)
def test_load_all(self):
sql = SQL_LITE_POOL.get(self.dataset_name)
table = sql.load(self.schema)
table.printit()