def init_postgresql_fts(apps, schema_editor): conn = schema_editor.connection if hasattr(conn, 'vendor') and conn.vendor == 'postgresql': script_path = os.path.join(askbot.get_install_directory(), 'search', 'postgresql', 'thread_and_post_models_03012016.plsql') setup_full_text_search(script_path)
def forwards(self, orm): "Write your forwards methods here." if 'postgresql_psycopg2' in askbot.get_database_engine_name(): script_path = os.path.join(askbot.get_install_directory(), 'search', 'postgresql', 'question_answer_comment_models.plsql') setup_full_text_search(script_path)
def handle_noargs(self, **options): script_path = os.path.join( askbot.get_install_directory(), 'search', 'postgresql', 'thread_and_post_models_01162012.plsql' ) setup_full_text_search(script_path)
def forwards(self, orm): "Write your forwards methods here." db_engine_name = askbot.get_database_engine_name() if 'postgresql_psycopg2' in db_engine_name: script_path = os.path.join( askbot.get_install_directory(), 'search', 'postgresql', 'thread_and_post_models_10032013.plsql') postgresql.setup_full_text_search(script_path)
def forwards(self, orm): "Write your forwards methods here." db_engine_name = askbot.get_database_engine_name() if 'postgresql_psycopg2' in db_engine_name: script_path = os.path.join(askbot.get_install_directory(), 'search', 'postgresql', 'user_profile_search_16102012.plsql') postgresql.setup_full_text_search(script_path)
def handle(self, **options): dir_path = askbot.get_install_directory() script_path = os.path.join(dir_path, 'search', 'postgresql', 'thread_and_post_models_03012016.plsql') setup_full_text_search(script_path) script_path = os.path.join(dir_path, 'search', 'postgresql', 'user_profile_search_12202015.plsql') setup_full_text_search(script_path)
def forwards(self, orm): "Write your forwards methods here." if 'postgresql_psycopg2' in askbot.get_database_engine_name(): script_path = os.path.join( askbot.get_install_directory(), 'search', 'postgresql', 'thread_and_post_models_01162012.plsql' ) setup_full_text_search(script_path)
def init_postgresql_fts(apps, schema_editor): conn = schema_editor.connection if hasattr(conn, 'vendor') and conn.vendor == 'postgresql': script_path = os.path.join( askbot.get_install_directory(), 'search', 'postgresql', 'thread_and_post_models_03012016.plsql' ) setup_full_text_search(script_path)
def forwards(self, orm): "Write your forwards methods here." if 'postgresql_psycopg2' in askbot.get_database_engine_name(): script_path = os.path.join( askbot.get_install_directory(), 'search', 'postgresql', 'exercise_problem_comment_models.plsql' ) setup_full_text_search(script_path)
def handle_noargs(self, **options): script_path = os.path.join(askbot.get_install_directory(), 'search', 'postgresql', 'thread_and_post_models_10032013.plsql') setup_full_text_search(script_path) script_path = os.path.join(askbot.get_install_directory(), 'search', 'postgresql', 'user_profile_search_12192015.plsql') setup_full_text_search(script_path)
def forwards(self, orm): "Write your forwards methods here." db_engine_name = askbot.get_database_engine_name() if 'postgresql_psycopg2' in db_engine_name: script_path = os.path.join( askbot.get_install_directory(), 'search', 'postgresql', 'user_profile_search_02262013.plsql' ) postgresql.setup_full_text_search(script_path)
def init_postgresql_fts(apps, schema_editor): conn = schema_editor.connection if hasattr(conn, "vendor") and conn.vendor == "postgresql": script_path = os.path.join( askbot.get_install_directory(), "search", "postgresql", "thread_and_post_models_10032013.plsql" ) setup_full_text_search(script_path) script_path = os.path.join( askbot.get_install_directory(), "search", "postgresql", "user_profile_search_12202015.plsql" ) setup_full_text_search(script_path)
def init_postgresql_fts(apps, schema_editor): conn = schema_editor.connection # if conn does not have an attribute vendor, there is probalby something # wrong with Django and we should raise an exception, i.e. provoke the # AttributeError if not hasattr(conn, 'vendor') or conn.vendor != 'postgresql': return script_path = os.path.join(askbot.get_install_directory(), 'search', 'postgresql', 'thread_and_post_models_03012016.plsql') setup_full_text_search(script_path)
def init_postgresql_fts(apps, schema_editor): conn = schema_editor.connection # if conn does not have an attribute vendor, there is probalby something # wrong with Django and we should raise an exception, i.e. provoke the # AttributeError if not hasattr(conn, 'vendor') or conn.vendor != 'postgresql': return #there used to be also setup of thread and post model FTS, #but now we have a better migration 0009 script_path = os.path.join(askbot.get_install_directory(), 'search', 'postgresql', 'user_profile_search_12202015.plsql') setup_full_text_search(script_path)
def forwards(self, orm): "Write your forwards methods here." # Note: Remember to use orm['appname.ModelName'] rather than "from appname.models..." if db.backend_name == 'mysql': table_name = orm['askbot.Thread']._meta.db_table if mysql_table_supports_full_text_search(table_name): columns = ('title', 'tagnames') sql = get_create_full_text_index_sql(INDEX_NAME, table_name, columns) db.execute(sql) elif db.backend_name == 'postgres': script_path = os.path.join( askbot.get_install_directory(), 'search', 'postgresql', 'thread_and_post_models_27112012.plsql') postgresql.setup_full_text_search(script_path)
def handle_noargs(self, **options): script_path = os.path.join( askbot.get_install_directory(), 'search', 'postgresql', 'thread_and_post_models_10032013.plsql' ) setup_full_text_search(script_path) script_path = os.path.join( askbot.get_install_directory(), 'search', 'postgresql', 'user_profile_search_12192015.plsql' ) setup_full_text_search(script_path)
def forwards(self, orm): "Write your forwards methods here." # Note: Remember to use orm['appname.ModelName'] rather than "from appname.models..." if db.backend_name == 'mysql': table_name = orm['askbot.Thread']._meta.db_table if mysql_table_supports_full_text_search(table_name): columns = ('title', 'tagnames') sql = get_create_full_text_index_sql(INDEX_NAME, table_name, columns) db.execute(sql) elif db.backend_name == 'postgres': script_path = os.path.join( askbot.get_install_directory(), 'search', 'postgresql', 'thread_and_post_models_27112012.plsql' ) postgresql.setup_full_text_search(script_path)
def forwards(self, orm): "Write your forwards methods here." profiles = orm['askbot.GroupProfile'].objects.all() items = profiles.iterator() count = profiles.count() message = 'Transfering group information from Tag to Group model' for profile in ProgressBar(items, count, message): group_tag = profile.group_tag group_name = group_tag.name.replace('-', ' ') group = orm['askbot.Group']() group.name = group_name group.logo_url = profile.logo_url group.moderate_email = profile.moderate_email group.is_open = profile.is_open group.preapproved_emails = profile.preapproved_emails group.preapproved_email_domains = profile.preapproved_email_domains try: #see if such group is already there auth_group = orm['auth.Group'].objects.get(name=group_name) group.group_ptr = auth_group except orm['auth.Group'].DoesNotExist: pass group.save() #update thread groups thread_groups = orm['askbot.ThreadToGroup'].objects thread_groups = thread_groups.filter(tag=group_tag) thread_groups.update(group=group) #update post groups post_groups = orm['askbot.PostToGroup'].objects post_groups = post_groups.filter(tag=group_tag) post_groups.update(group=group) #update user groups memberships = group_tag.user_memberships.all() for membership in memberships: membership.user.groups.add(group) db_engine_name = askbot.get_database_engine_name() if 'postgresql_psycopg2' in db_engine_name: from django.db import connection cursor = connection.cursor() cursor.execute( 'DROP TRIGGER IF EXISTS group_membership_tsv_update_trigger ' 'ON askbot_groupmembership' ) message = 'Deleting old group information' items = profiles.iterator() for profile in ProgressBar(items, count, message): group_tag = profile.group_tag group_tag.user_memberships.all().delete() profile.delete() #for postgresql setup new user full text search if 'postgresql_psycopg2' in db_engine_name: script_path = os.path.join( askbot.get_install_directory(), 'search', 'postgresql', 'user_profile_search_08312012.plsql' ) setup_full_text_search(script_path)