def save_and_select(self, d):
dt = DumpTruck()
dt.insert({'foo': d})
observed = dt.dump()[0]['foo']
self.assertEqual(d, observed)
def test_save(self):
h = DumpTruck(dbname = '/tmp/test.db')
data = [{'firstname': 'Robert', 'lastname': 'LeTourneau'}]
h.insert(data, 'foo')
self.assertEqual(data, h.dump('foo'))
h.close()
def test_save(self):
h = DumpTruck(dbname="/tmp/test.db")
data = [{"firstname": "Robert", "lastname": "LeTourneau"}]
h.insert(data, "foo")
self.assertEqual(data, h.dump("foo"))
h.close()
def test_no_adapt_list(self):
dt = DumpTruck(dbname="/tmp/test.db", adapt_and_convert=False)
dt.execute("create table foo (bar jsontext)")
dt.execute("insert into foo values ('[3,5]')")
self.assertListEqual(dt.dump("foo"), [OrderedDict([("bar", "[3,5]")])])
def test_convert_lxml(self):
dt = DumpTruck(dbname="/tmp/test.db", adapt_and_convert=True)
elementstringresult = lxml.html.fromstring("<html>Hi</html>").xpath("//*/text()")[0]
dt.insert({"bar": elementstringresult}, "foo")
self.assertEqual(type(dt.dump("foo")[0]["bar"]), unicode)
def test_convert_lxml(self):
dt = DumpTruck(dbname = '/tmp/test.db', adapt_and_convert = True)
elementstringresult = lxml.html.fromstring('<html>Hi</html>').xpath('//*/text()')[0]
dt.insert({'bar': elementstringresult}, 'foo')
self.assertEqual(type(dt.dump('foo')[0]['bar']), unicode)
def test_adapt_list(self):
dt = DumpTruck(dbname = '/tmp/test.db', adapt_and_convert = True)
dt.execute('create table foo (bar jsontext)')
dt.execute("insert into foo values ('[3,5]')")
self.assertListEqual(dt.dump('foo'), [OrderedDict([('bar', [3,5])])])
