Mercurial > p > roundup > code
diff roundup/backends/back_sqlite.py @ 2075:b1704ba7be41
make mysql / postgresql work again. beginnings of otk/session store in rdbmses
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Fri, 12 Mar 2004 04:09:00 +0000 |
| parents | 261c2e6ceb1e |
| children | 3e0961d6d44d |
line wrap: on
line diff
--- a/roundup/backends/back_sqlite.py Fri Mar 05 00:08:09 2004 +0000 +++ b/roundup/backends/back_sqlite.py Fri Mar 12 04:09:00 2004 +0000 @@ -1,4 +1,4 @@ -# $Id: back_sqlite.py,v 1.14 2004-03-05 00:08:09 richard Exp $ +# $Id: back_sqlite.py,v 1.15 2004-03-12 04:08:59 richard Exp $ '''Implements a backend for SQLite. See https://pysqlite.sourceforge.net/ for pysqlite info @@ -34,19 +34,19 @@ except sqlite.DatabaseError, error: if str(error) != 'no such table: schema': raise - self.database_schema = {} + self.init_dbschema() self.cursor.execute('create table schema (schema varchar)') self.cursor.execute('create table ids (name varchar, num integer)') self.cursor.execute('create index ids_name_idx on ids(name)') self.create_version_2_tables() def create_version_2_tables(self): - self.cursor.execute('create table otks (key varchar, ' - 'value varchar, __time varchar)') - self.cursor.execute('create index otks_key_idx on otks(key)') - self.cursor.execute('create table sessions (key varchar, ' - 'last_use varchar, user varchar)') - self.cursor.execute('create index sessions_key_idx on sessions(key)') + self.cursor.execute('create table otks (otk_key varchar, ' + 'otk_value varchar, otk_time varchar)') + self.cursor.execute('create index otks_key_idx on otks(otk_key)') + self.cursor.execute('create table sessions (s_key varchar, ' + 's_last_use varchar, s_user varchar)') + self.cursor.execute('create index sessions_key_idx on sessions(s_key)') def sql_close(self): ''' Squash any error caused by us already having closed the
