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_identifiers():
# exercise function
table = (('foo foo', 'bar.baz.spong`'), ('a', 1), ('b', 2), ('c', 2))
f = NamedTemporaryFile(delete=False)
tosqlite3(table, f.name, 'foo " bar`', create=True)
# check what it did
conn = sqlite3.connect(f.name)
actual = conn.execute('select * from `foo " bar```')
expect = (('a', 1), ('b', 2), ('c', 2))
ieq(expect, actual)
def test_tosqlite3_identifiers():
# exercise function
table = (('foo foo', 'bar.baz.spong`'),
('a', 1),
('b', 2),
('c', 2))
f = NamedTemporaryFile(delete=False)
tosqlite3(table, f.name, 'foo " bar`', create=True)
# check what it did
conn = sqlite3.connect(f.name)
actual = conn.execute('select * from `foo " bar```')
expect = (('a', 1),
('b', 2),
('c', 2))
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)