1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
#
# Copyright (c) 2006, 2007 Canonical
#
# Written by Gustavo Niemeyer <gustavo@niemeyer.net>
#
# This file is part of Storm Object Relational Mapper.
#
# Storm is free software; you can redistribute it and/or modify
# it under the terms of the GNU Lesser General Public License as
# published by the Free Software Foundation; either version 2.1 of
# the License, or (at your option) any later version.
#
# Storm is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU Lesser General Public License for more details.
#
# You should have received a copy of the GNU Lesser General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
from storm.databases.sqlite import SQLite
from storm.uri import URI
from tests.store.base import StoreTest, EmptyResultSetTest
from tests.helper import TestHelper, MakePath
class SQLiteStoreTest(TestHelper, StoreTest):
helpers = [MakePath]
def setUp(self):
TestHelper.setUp(self)
StoreTest.setUp(self)
def tearDown(self):
TestHelper.tearDown(self)
StoreTest.tearDown(self)
def create_database(self):
self.database = SQLite(URI("sqlite:" + self.make_path()))
def create_tables(self):
connection = self.connection
connection.execute("CREATE TABLE foo "
"(id INTEGER PRIMARY KEY,"
" title VARCHAR DEFAULT 'Default Title')")
connection.execute("CREATE TABLE bar "
"(id INTEGER PRIMARY KEY,"
" foo_id INTEGER, title VARCHAR)")
connection.execute("CREATE TABLE bin "
"(id INTEGER PRIMARY KEY, bin BLOB)")
connection.execute("CREATE TABLE link "
"(foo_id INTEGER, bar_id INTEGER)")
# We have to use TEXT here, since NUMERIC would cause SQLite
# to interpret values as float, and thus lose precision.
connection.execute("CREATE TABLE money "
"(id INTEGER PRIMARY KEY, value TEXT)")
connection.execute("CREATE TABLE selfref "
"(id INTEGER PRIMARY KEY, title VARCHAR,"
" selfref_id INTEGER)")
connection.commit()
def drop_tables(self):
pass
class SQLiteEmptyResultSetTest(TestHelper, EmptyResultSetTest):
helpers = [MakePath]
def setUp(self):
TestHelper.setUp(self)
EmptyResultSetTest.setUp(self)
def tearDown(self):
TestHelper.tearDown(self)
EmptyResultSetTest.tearDown(self)
def create_database(self):
self.database = SQLite(URI("sqlite:" + self.make_path()))
def create_tables(self):
self.connection.execute("CREATE TABLE foo "
"(id INTEGER PRIMARY KEY,"
" title VARCHAR DEFAULT 'Default Title')")
self.connection.commit()
def drop_tables(self):
pass
|