Mercurial > p > roundup > code
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 2073:261c2e6ceb1e | 2075:b1704ba7be41 |
|---|---|
| 1 # $Id: back_sqlite.py,v 1.14 2004-03-05 00:08:09 richard Exp $ | 1 # $Id: back_sqlite.py,v 1.15 2004-03-12 04:08:59 richard Exp $ |
| 2 '''Implements a backend for SQLite. | 2 '''Implements a backend for SQLite. |
| 3 | 3 |
| 4 See https://pysqlite.sourceforge.net/ for pysqlite info | 4 See https://pysqlite.sourceforge.net/ for pysqlite info |
| 5 ''' | 5 ''' |
| 6 __docformat__ = 'restructuredtext' | 6 __docformat__ = 'restructuredtext' |
| 32 try: | 32 try: |
| 33 self.load_dbschema() | 33 self.load_dbschema() |
| 34 except sqlite.DatabaseError, error: | 34 except sqlite.DatabaseError, error: |
| 35 if str(error) != 'no such table: schema': | 35 if str(error) != 'no such table: schema': |
| 36 raise | 36 raise |
| 37 self.database_schema = {} | 37 self.init_dbschema() |
| 38 self.cursor.execute('create table schema (schema varchar)') | 38 self.cursor.execute('create table schema (schema varchar)') |
| 39 self.cursor.execute('create table ids (name varchar, num integer)') | 39 self.cursor.execute('create table ids (name varchar, num integer)') |
| 40 self.cursor.execute('create index ids_name_idx on ids(name)') | 40 self.cursor.execute('create index ids_name_idx on ids(name)') |
| 41 self.create_version_2_tables() | 41 self.create_version_2_tables() |
| 42 | 42 |
| 43 def create_version_2_tables(self): | 43 def create_version_2_tables(self): |
| 44 self.cursor.execute('create table otks (key varchar, ' | 44 self.cursor.execute('create table otks (otk_key varchar, ' |
| 45 'value varchar, __time varchar)') | 45 'otk_value varchar, otk_time varchar)') |
| 46 self.cursor.execute('create index otks_key_idx on otks(key)') | 46 self.cursor.execute('create index otks_key_idx on otks(otk_key)') |
| 47 self.cursor.execute('create table sessions (key varchar, ' | 47 self.cursor.execute('create table sessions (s_key varchar, ' |
| 48 'last_use varchar, user varchar)') | 48 's_last_use varchar, s_user varchar)') |
| 49 self.cursor.execute('create index sessions_key_idx on sessions(key)') | 49 self.cursor.execute('create index sessions_key_idx on sessions(s_key)') |
| 50 | 50 |
| 51 def sql_close(self): | 51 def sql_close(self): |
| 52 ''' Squash any error caused by us already having closed the | 52 ''' Squash any error caused by us already having closed the |
| 53 connection. | 53 connection. |
| 54 ''' | 54 ''' |