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_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_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)
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)
appendpickle(table, 'test.dat')
# look what it did
look(testdat)
# tosqlite3
table = [['foo', 'bar'],
['a', 1],
['b', 2],
['c', 2]]
from petl import tosqlite3, look
look(table)
# by default, if the table does not already exist, it will be created
tosqlite3(table, 'test.db', 'foobar')
# look what it did
from petl import fromsqlite3
look(fromsqlite3('test.db', 'select * from foobar'))
# appendsqlite3
moredata = [['foo', 'bar'],
['d', 7],
['e', 9],
['f', 1]]
from petl import appendsqlite3, look
look(moredata)
appendsqlite3(moredata, 'test.db', 'foobar')
appendpickle(table, 'test.dat')
# look what it did
look(testdat)
# tosqlite3
table = [['foo', 'bar'],
['a', 1],
['b', 2],
['c', 2]]
from petl import tosqlite3, look
look(table)
# by default, if the table does not already exist, it will be created
tosqlite3(table, 'test.db', 'foobar')
# look what it did
from petl import fromsqlite3
look(fromsqlite3('test.db', 'select * from foobar'))
# appendsqlite3
moredata = [['foo', 'bar'],
['d', 7],
['e', 9],
['f', 1]]
from petl import appendsqlite3, look
look(moredata)
appendsqlite3(moredata, 'test.db', 'foobar')
os.remove('example.db')
import petl as etl
import sqlite3
# set up a database to demonstrate with
data = [['a', 1], ['b', 2], ['c', 2.0]]
connection = sqlite3.connect('example.db')
c = connection.cursor()
_ = c.execute('drop table if exists foobar')
_ = c.execute('create table foobar (foo, bar)')
for row in data:
_ = c.execute('insert into foobar values (?, ?)', row)
connection.commit()
c.close()
# now demonstrate the petl.fromsqlite3 function
table = etl.fromsqlite3('example.db', 'select * from foobar')
table
# tosqlite3()
##############
os.remove('example.db')
import petl as etl
table1 = [['foo', 'bar'], ['a', 1], ['b', 2], ['c', 2]]
_ = etl.tosqlite3(table1, 'example.db', 'foobar', create=True)
# look what it did
table2 = etl.fromsqlite3('example.db', 'select * from foobar')
table2
['b', 2],
['c', 2.0]]
connection = sqlite3.connect('example.db')
c = connection.cursor()
_ = c.execute('drop table if exists foobar')
_ = c.execute('create table foobar (foo, bar)')
for row in data:
_ = c.execute('insert into foobar values (?, ?)', row)
connection.commit()
c.close()
# now demonstrate the petl.fromsqlite3 function
table = etl.fromsqlite3('example.db', 'select * from foobar')
table
# tosqlite3()
##############
os.remove('example.db')
import petl as etl
table1 = [['foo', 'bar'],
['a', 1],
['b', 2],
['c', 2]]
_ = etl.tosqlite3(table1, 'example.db', 'foobar', create=True)
# look what it did
table2 = etl.fromsqlite3('example.db', 'select * from foobar')
table2
