def test_tosqlite3_appendsqlite3_connection(): conn = sqlite3.connect(':memory:') # exercise function table = (('foo', 'bar'), ('a', 1), ('b', 2), ('c', 2)) tosqlite3(table, conn, 'foobar', create=True) # check what it did actual = conn.execute('select * from foobar') expect = (('a', 1), ('b', 2), ('c', 2)) ieq(expect, actual) # check appending table2 = (('foo', 'bar'), ('d', 7), ('e', 9), ('f', 1)) appendsqlite3(table2, conn, 'foobar') # check what it did actual = conn.execute('select * from foobar') expect = (('a', 1), ('b', 2), ('c', 2), ('d', 7), ('e', 9), ('f', 1)) ieq(expect, actual)
def test_tosqlite3_appendsqlite3_connection(): conn = sqlite3.connect(':memory:') # exercise function table = (('foo', 'bar'), ('a', 1), ('b', 2), ('c', 2)) tosqlite3(table, conn, 'foobar', create=True) # check what it did actual = conn.execute('select * from foobar') expect = (('a', 1), ('b', 2), ('c', 2)) ieq(expect, actual) # check appending table2 = (('foo', 'bar'), ('d', 7), ('e', 9), ('f', 1)) appendsqlite3(table2, conn, 'foobar') # check what it did actual = conn.execute('select * from foobar') expect = (('a', 1), ('b', 2), ('c', 2), ('d', 7), ('e', 9), ('f', 1)) ieq(expect, actual)
def test_tosqlite3_appendsqlite3(): """Test the tosqlite3 and appendsqlite3 functions.""" # exercise function table = (('foo', 'bar'), ('a', 1), ('b', 2), ('c', 2)) f = NamedTemporaryFile(delete=False) tosqlite3(table, f.name, 'foobar', create=True) # check what it did conn = sqlite3.connect(f.name) actual = conn.execute('select * from foobar') expect = (('a', 1), ('b', 2), ('c', 2)) ieq(expect, actual) # check appending table2 = (('foo', 'bar'), ('d', 7), ('e', 9), ('f', 1)) appendsqlite3(table2, f.name, 'foobar') # check what it did conn = sqlite3.connect(f.name) actual = conn.execute('select * from foobar') expect = (('a', 1), ('b', 2), ('c', 2), ('d', 7), ('e', 9), ('f', 1)) ieq(expect, actual)
def test_tosqlite3_appendsqlite3(): """Test the tosqlite3 and appendsqlite3 functions.""" # exercise function table = (('foo', 'bar'), ('a', 1), ('b', 2), ('c', 2)) f = NamedTemporaryFile(delete=False) tosqlite3(table, f.name, 'foobar', create=True) # check what it did conn = sqlite3.connect(f.name) actual = conn.execute('select * from foobar') expect = (('a', 1), ('b', 2), ('c', 2)) ieq(expect, actual) # check appending table2 = (('foo', 'bar'), ('d', 7), ('e', 9), ('f', 1)) appendsqlite3(table2, f.name, 'foobar') # check what it did conn = sqlite3.connect(f.name) actual = conn.execute('select * from foobar') expect = (('a', 1), ('b', 2), ('c', 2), ('d', 7), ('e', 9), ('f', 1)) ieq(expect, actual)