def test_end_to_end(self): d = get_all_dicts() c = Csv() text = c.outbound([d[0]]) s = Sqlite() s.outbound(ru, text) r = s.inbound(ru)
def test_table_insert(self):
s = Sqlite()
c = Csv()
d = get_all_dicts()
text = c.outbound([d[0]])
s.outbound(ru, text)
conn = sqlite3.connect(ru.get_full_path())
results = conn.execute("SELECT * FROM %s" % ru.frag)
conn.close()
def test_table_create(self):
d = get_all_dicts()
conn = sqlite3.connect(ru.get_full_path())
if Sqlite.is_table_exist(conn, ru.frag):
conn.execute("DROP TABLE " + ru.frag)
Sqlite.create_table_from_dataset(conn, ru.frag, [d[0]])
conn.execute("DROP TABLE " + ru.frag)
conn.commit()
conn.close()