def setup_vfolders(self): from pytest_pootle.factories import VirtualFolderDBFactory from django.db import connection from django.apps import apps from pootle.core.utils.db import set_mysql_collation_for_column from pootle_language.models import Language from pootle_project.models import Project cursor = connection.cursor() # VirtualFolder set_mysql_collation_for_column(apps, cursor, "virtualfolder.VirtualFolder", "name", "utf8_bin", "varchar(70)") project0 = Project.objects.get(code="project0") language0 = Language.objects.get(code="language0") VirtualFolderDBFactory(filter_rules="store0.po") VirtualFolderDBFactory(filter_rules="store1.po") vf = VirtualFolderDBFactory(all_languages=True, is_public=False, filter_rules="store0.po") vf.projects.add(project0) vf.save() vf = VirtualFolderDBFactory(all_languages=True, is_public=False, filter_rules="store1.po") vf.projects.add(project0) vf.save() vf = VirtualFolderDBFactory(filter_rules="subdir0/store4.po") vf.languages.add(language0) vf.projects.add(project0) vf.save()
def make_directory_paths_cs(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column( apps, cursor, "pootle_app.Directory", "pootle_path", "utf8_bin", "varchar(255)" ) set_mysql_collation_for_column( apps, cursor, "pootle_app.Directory", "name", "utf8_bin", "varchar(255)" )
def make_project_codes_cs(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column( apps, cursor, "pootle_project.Project", "code", "utf8_bin", "varchar(255)")
def make_lang_codes_ci(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column( apps, cursor, "pootle_language.Language", "code", "utf8_general_ci", "varchar(50)")
def make_stem_root_cs(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column( apps, cursor, "pootle_word.Stem", "root", "utf8_bin", "varchar(255)")
def make_vfti_paths_cs(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column( apps, cursor, "virtualfolder.VirtualFolderTreeItem", "pootle_path", "utf8_bin", "varchar(255)")
def make_project_codes_cs(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column( apps, cursor, 'pootle_project.Project', 'code', 'utf8_bin', 'varchar(255)' )
def make_lang_codes_ci(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column( apps, cursor, "pootle_language.Language", "code", "utf8_general_ci", "varchar(50)", )
def make_directory_paths_cs(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column( apps, cursor, "pootle_app.Directory", "pootle_path", "utf8_bin", "varchar(255)") set_mysql_collation_for_column( apps, cursor, "pootle_app.Directory", "name", "utf8_bin", "varchar(255)")
def make_virtualfolder_paths_cs(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column( apps, cursor, "virtualfolder.VirtualFolder", "name", "utf8_bin", "varchar(70)") set_mysql_collation_for_column( apps, cursor, "virtualfolder.VirtualFolder", "location", "utf8_bin", "varchar(255)")
def make_store_paths_cs(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column( apps, cursor, 'pootle_store.Store', 'pootle_path', 'utf8_bin', 'varchar(255)', ) set_mysql_collation_for_column( apps, cursor, 'pootle_store.Store', 'name', 'utf8_bin', 'varchar(255)', )
def setup_vfolders(self): from pytest_pootle.factories import VirtualFolderDBFactory from django.db import connection from django.apps import apps from pootle.core.utils.db import set_mysql_collation_for_column from pootle_language.models import Language from pootle_project.models import Project cursor = connection.cursor() # VirtualFolder set_mysql_collation_for_column( apps, cursor, "virtualfolder.VirtualFolder", "name", "utf8_bin", "varchar(70)") project0 = Project.objects.get(code="project0") language0 = Language.objects.get(code="language0") VirtualFolderDBFactory(filter_rules="store0.po") VirtualFolderDBFactory(filter_rules="store1.po") vf = VirtualFolderDBFactory( all_languages=True, is_public=False, filter_rules="store0.po") vf.projects.add(project0) vf.save() vf = VirtualFolderDBFactory( all_languages=True, is_public=False, filter_rules="store1.po") vf.projects.add(project0) vf.save() vf = VirtualFolderDBFactory( filter_rules="subdir0/store4.po") vf.languages.add(language0) vf.projects.add(project0) vf.save()
def vfolders(): from pytest_pootle.factories import VirtualFolderDBFactory from django.db import connection from django.apps import apps from pootle.core.utils.db import set_mysql_collation_for_column cursor = connection.cursor() # VirtualFolderTreeItem set_mysql_collation_for_column(apps, cursor, "virtualfolder.VirtualFolderTreeItem", "pootle_path", "utf8_bin", "varchar(255)") # VirtualFolder set_mysql_collation_for_column(apps, cursor, "virtualfolder.VirtualFolder", "name", "utf8_bin", "varchar(70)") set_mysql_collation_for_column(apps, cursor, "virtualfolder.VirtualFolder", "location", "utf8_bin", "varchar(255)") VirtualFolderDBFactory(filter_rules="store0.po") VirtualFolderDBFactory(filter_rules="store1.po") VirtualFolderDBFactory(location='/{LANG}/project0/', is_public=False, filter_rules="store0.po") VirtualFolderDBFactory(location='/{LANG}/project0/', is_public=False, filter_rules="store1.po") VirtualFolderDBFactory(location='/language0/project0/', filter_rules="subdir0/store4.po")
def vfolders(): from pytest_pootle.factories import VirtualFolderDBFactory from django.db import connection from django.apps import apps from pootle.core.utils.db import set_mysql_collation_for_column cursor = connection.cursor() # VirtualFolderTreeItem set_mysql_collation_for_column( apps, cursor, "virtualfolder.VirtualFolderTreeItem", "pootle_path", "utf8_bin", "varchar(255)") # VirtualFolder set_mysql_collation_for_column( apps, cursor, "virtualfolder.VirtualFolder", "name", "utf8_bin", "varchar(70)") set_mysql_collation_for_column( apps, cursor, "virtualfolder.VirtualFolder", "location", "utf8_bin", "varchar(255)") VirtualFolderDBFactory(filter_rules="store0.po") VirtualFolderDBFactory(filter_rules="store1.po") VirtualFolderDBFactory( location='/{LANG}/project0/', is_public=False, filter_rules="store0.po") VirtualFolderDBFactory( location='/{LANG}/project0/', is_public=False, filter_rules="store1.po") VirtualFolderDBFactory( location='/language0/project0/', filter_rules="subdir0/store4.po")
def case_sensitive_schema(db): from django.db import connection from django.apps import apps from pootle.core.utils.db import set_mysql_collation_for_column cursor = connection.cursor() # Language set_mysql_collation_for_column(apps, cursor, "pootle_language.Language", "code", "utf8_general_ci", "varchar(50)") # Project set_mysql_collation_for_column(apps, cursor, "pootle_project.Project", "code", "utf8_bin", "varchar(255)") # Directory set_mysql_collation_for_column(apps, cursor, "pootle_app.Directory", "pootle_path", "utf8_bin", "varchar(255)") set_mysql_collation_for_column(apps, cursor, "pootle_app.Directory", "name", "utf8_bin", "varchar(255)") # Store set_mysql_collation_for_column(apps, cursor, "pootle_store.Store", "pootle_path", "utf8_bin", "varchar(255)") set_mysql_collation_for_column(apps, cursor, "pootle_store.Store", "name", "utf8_bin", "varchar(255)") # VirtualFolderTreeItem set_mysql_collation_for_column( apps, cursor, "virtualfolder.VirtualFolderTreeItem", "pootle_path", "utf8_bin", "varchar(255)" ) # VirtualFolder set_mysql_collation_for_column(apps, cursor, "virtualfolder.VirtualFolder", "name", "utf8_bin", "varchar(70)") set_mysql_collation_for_column(apps, cursor, "virtualfolder.VirtualFolder", "location", "utf8_bin", "varchar(255)")
def setup_case_sensitive_schema(self): from django.db import connection from django.apps import apps from pootle.core.utils.db import set_mysql_collation_for_column cursor = connection.cursor() # Language set_mysql_collation_for_column(apps, cursor, "pootle_language.Language", "code", "utf8_general_ci", "varchar(50)") # Project set_mysql_collation_for_column(apps, cursor, "pootle_project.Project", "code", "utf8_bin", "varchar(255)") # Directory set_mysql_collation_for_column(apps, cursor, "pootle_app.Directory", "pootle_path", "utf8_bin", "varchar(255)") set_mysql_collation_for_column(apps, cursor, "pootle_app.Directory", "name", "utf8_bin", "varchar(255)") # Store set_mysql_collation_for_column(apps, cursor, "pootle_store.Store", "pootle_path", "utf8_bin", "varchar(255)") set_mysql_collation_for_column(apps, cursor, "pootle_store.Store", "name", "utf8_bin", "varchar(255)") # Word.Stem set_mysql_collation_for_column(apps, cursor, "pootle_word.Stem", "root", "utf8_bin", "varchar(255)")
def setup_case_sensitive_schema(self): from django.db import connection from django.apps import apps from pootle.core.utils.db import set_mysql_collation_for_column cursor = connection.cursor() # Language set_mysql_collation_for_column( apps, cursor, "pootle_language.Language", "code", "utf8_general_ci", "varchar(50)") # Project set_mysql_collation_for_column( apps, cursor, "pootle_project.Project", "code", "utf8_bin", "varchar(255)") # Directory set_mysql_collation_for_column( apps, cursor, "pootle_app.Directory", "pootle_path", "utf8_bin", "varchar(255)") set_mysql_collation_for_column( apps, cursor, "pootle_app.Directory", "name", "utf8_bin", "varchar(255)") # Store set_mysql_collation_for_column( apps, cursor, "pootle_store.Store", "pootle_path", "utf8_bin", "varchar(255)") set_mysql_collation_for_column( apps, cursor, "pootle_store.Store", "name", "utf8_bin", "varchar(255)")
def setup_case_sensitive_schema(self): from django.db import connection from django.apps import apps from pootle.core.utils.db import set_mysql_collation_for_column if connection.vendor != 'mysql': return cursor = connection.cursor() # Language set_mysql_collation_for_column( apps, cursor, 'pootle_language.Language', 'code', 'utf8_general_ci', 'varchar(50)', ) # Project set_mysql_collation_for_column( apps, cursor, 'pootle_project.Project', 'code', 'utf8_bin', 'varchar(255)', ) # Directory set_mysql_collation_for_column( apps, cursor, 'pootle_app.Directory', 'pootle_path', 'utf8_bin', 'varchar(255)', ) set_mysql_collation_for_column( apps, cursor, 'pootle_app.Directory', 'name', 'utf8_bin', 'varchar(255)', ) # Store set_mysql_collation_for_column( apps, cursor, 'pootle_store.Store', 'pootle_path', 'utf8_bin', 'varchar(255)', ) set_mysql_collation_for_column( apps, cursor, 'pootle_store.Store', 'name', 'utf8_bin', 'varchar(255)', )
def make_virtualfolder_paths_cs(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column(apps, cursor, "virtualfolder.VirtualFolder", "name", "utf8_bin", "varchar(70)") set_mysql_collation_for_column(apps, cursor, "virtualfolder.VirtualFolder", "location", "utf8_bin", "varchar(255)")
def make_vfti_paths_cs(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column(apps, cursor, "virtualfolder.VirtualFolderTreeItem", "pootle_path", "utf8_bin", "varchar(255)")
def make_stem_root_cs(apps, schema_editor): cursor = schema_editor.connection.cursor() set_mysql_collation_for_column(apps, cursor, "pootle_word.Stem", "root", "utf8_bin", "varchar(255)")