1 files changed, 20 insertions, 0 deletions
diff --git a/askbot/migrations_api/__init__.py b/askbot/migrations_api/__init__.py
index 586c02d9..0260f51b 100644
--- a/askbot/migrations_api/__init__.py
+++ b/askbot/migrations_api/__init__.py
@@ -5,6 +5,7 @@ since models change with time, this api is implemented in different
 versions. Different versions do not need to have all the same functions.
 """
 from south.db import db
+from django.db import connection
 
 def safe_add_column(table, column, column_data, keep_default = False):
     """when user calls syncdb with askbot the first time
@@ -22,6 +23,25 @@ def safe_add_column(table, column, column_data, keep_default = False):
         return False
 
 
+def mysql_table_supports_full_text_search(table_name):
+    """true, if engine is MyISAM"""
+    cursor = connection.cursor()
+    cursor.execute("SHOW CREATE TABLE %s" % table_name)
+    data = cursor.fetchone()
+    return 'ENGINE=MyISAM' in data[1]
+
+
+def get_drop_index_sql(index_name, table_name):
+    """returns sql for dropping index by name on table"""
+    return 'ALTER TABLE %s DROP INDEX %s' % (table_name, index_name)
+
+
+def get_create_full_text_index_sql(index_name, table_name, column_list):
+    column_sql = '(%s)' % ','.join(column_list)
+    query_template = 'CREATE FULLTEXT INDEX %s on %s %s'
+    return query_template % (index_name, table_name, column_sql)
+
+
 class BaseAPI(object):
     def __init__(self, orm):
         self.orm = orm