Python set_mysql_collation_for_column 예제들

예제 #1

파일: env.py 프로젝트: rmoch/pootle

    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()

예제 #2

파일: 0005_case_sensitive_schema.py 프로젝트: sshyran/zing

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)"
    )

예제 #3

파일: 0003_case_sensitive_schema.py 프로젝트: RevelSystems/cat-pootle

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)")

예제 #4

파일: 0002_case_insensitive_schema.py 프로젝트: AlfredWei/pootle

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)")

예제 #5

파일: 0002_set_cs_schema.py 프로젝트: SafaAlfulaij/pootle

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)")

예제 #6

파일: 0003_case_sensitive_schema.py 프로젝트: Finntack/pootle

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)")

예제 #7

파일: 0003_case_sensitive_schema.py 프로젝트: AlfredWei/pootle

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)")

예제 #8

파일: 0001_initial.py 프로젝트: ratanasoth/zing

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)'
    )

예제 #9

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)",
    )

예제 #10

파일: 0005_case_sensitive_schema.py 프로젝트: AlfredWei/pootle

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)")

예제 #11

파일: 0003_case_sensitive_schema.py 프로젝트: AlfredWei/pootle

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)")

예제 #12

파일: 0001_initial.py 프로젝트: ratanasoth/zing

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)',
    )

예제 #13

    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()

예제 #14

파일: vfolders.py 프로젝트: RevelSystems/cat-pootle

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")

예제 #15

파일: vfolders.py 프로젝트: AshishNamdev/pootle

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")

예제 #16

파일: site.py 프로젝트: haf/pootle

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)")

예제 #17

파일: env.py 프로젝트: rmoch/pootle

    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)")

예제 #18

파일: env.py 프로젝트: yar0d/pootle

    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)")

예제 #19

    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)',
        )

예제 #20

파일: 0003_case_sensitive_schema.py 프로젝트: RevelSystems/cat-pootle

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)")

예제 #21

파일: 0003_case_sensitive_schema.py 프로젝트: RevelSystems/cat-pootle

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)")

예제 #22

파일: 0002_set_cs_schema.py 프로젝트: yiyibooks/pootle

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)")