diff options
author | Stephanie Marcu <stephanie.marcu@logilab.fr> | 2008-10-06 08:41:18 +0200 |
---|---|---|
committer | Stephanie Marcu <stephanie.marcu@logilab.fr> | 2008-10-06 08:41:18 +0200 |
commit | 02315464a5a6d91aa1981d9e6c99f37fab4d03b9 (patch) | |
tree | 9a775f9ce580d7676fc1027b70642dc85cb3ec55 /adbh.py | |
parent | f5c1e0bdec77eb6580276d1465372b239d65611a (diff) | |
parent | 4978625fe47703ef78a8022ffc37f4c154754bba (diff) | |
download | logilab-common-02315464a5a6d91aa1981d9e6c99f37fab4d03b9.tar.gz |
merge
Diffstat (limited to 'adbh.py')
-rw-r--r-- | adbh.py | 10 |
1 files changed, 10 insertions, 0 deletions
@@ -428,6 +428,16 @@ class _SqliteAdvFuncHelper(_GenericAdvFuncHelper): ilike_support = False union_parentheses_support = False + def sql_create_index(self, table, column, unique=False): + idx = self._index_name(table, column, unique) + if unique: + return 'CREATE UNIQUE INDEX %s ON %s(%s);' % (idx, table, column) + else: + return 'CREATE INDEX %s ON %s(%s);' % (idx, table, column) + + def sql_drop_index(self, table, column, unique=False): + return 'DROP INDEX %s' % self._index_name(table, column, unique) + def list_tables(self, cursor): """return the list of tables of a database""" # filter type='table' else we get indices as well |