sqlite specific implementation for sql_[create|drop]_index

1 files changed, 10 insertions, 0 deletions

diff --git a/adbh.py b/adbh.py
index 828d870..7aeb1e4 100644
--- a/adbh.py
+++ b/adbh.py
@@ -427,6 +427,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