Python drop_old_fts примеры использования

Пример #1

Файл: 0006_auto_20190321_1448.py Проект: matthiask/workbench

class Migration(migrations.Migration):

    dependencies = [("logbook", "0005_auto_20190312_1254")]

    operations = [
        migrations.RunSQL(search.drop_old_fts("logbook_loggedcost")),
        migrations.RunSQL(search.drop_old_fts("logbook_loggedhours")),
        migrations.RunSQL(search.create_structure("logbook_loggedcost")),
        migrations.RunSQL(search.create_structure("logbook_loggedhours")),
        migrations.RunSQL(search.fts("logbook_loggedcost", ["description"])),
        migrations.RunSQL(search.fts("logbook_loggedhours", ["description"])),
    ]

Пример #2

Файл: 0006_auto_20190321_1445.py Проект: matthiask/workbench

class Migration(migrations.Migration):

    dependencies = [("contacts", "0005_auto_20190321_1025")]

    operations = [
        migrations.RunSQL(search.drop_old_fts("contacts_organization")),
        migrations.RunSQL(search.drop_old_fts("contacts_person")),
        migrations.RunSQL(search.create_structure("contacts_organization")),
        migrations.RunSQL(search.create_structure("contacts_person")),
        migrations.RunSQL(search.fts("contacts_organization", ["name"])),
        migrations.RunSQL(
            search.fts(
                "contacts_person", ["given_name", "family_name", "address", "notes"]
            )
        ),
    ]

Пример #3

class Migration(migrations.Migration):

    dependencies = [("invoices", "0009_auto_20190321_0833")]

    operations = [
        migrations.RunSQL(search.drop_old_fts("invoices_invoice")),
        migrations.RunSQL(search.drop_old_fts("invoices_recurringinvoice")),
        migrations.RunSQL(search.create_structure("invoices_invoice")),
        migrations.RunSQL(search.create_structure("invoices_recurringinvoice")),
        migrations.RunSQL(
            search.fts("invoices_invoice", ["title", "description", "postal_address"])
        ),
        migrations.RunSQL(
            search.fts(
                "invoices_recurringinvoice", ["title", "description", "postal_address"]
            )
        ),
    ]

Пример #4

class Migration(migrations.Migration):

    dependencies = [("projects", "0006_auto_20190312_1254")]

    operations = [
        migrations.RunSQL(search.drop_old_fts("projects_project")),
        migrations.RunSQL(search.create_structure("projects_project")),
        migrations.RunSQL(
            search.fts("projects_project", ["title", "description"])),
    ]

Пример #5

Файл: 0004_auto_20190321_1449.py Проект: matthiask/workbench

class Migration(migrations.Migration):

    dependencies = [("offers", "0003_auto_20190304_2247")]

    operations = [
        migrations.RunSQL(search.drop_old_fts("offers_offer")),
        migrations.RunSQL(search.create_structure("offers_offer")),
        migrations.RunSQL(
            search.fts("offers_offer", ["title", "description", "postal_address"])
        ),
    ]

Пример #6

Файл: 0003_auto_20190321_1447.py Проект: matthiask/workbench

class Migration(migrations.Migration):

    dependencies = [("credit_control", "0002_auto_20190308_1752")]

    operations = [
        migrations.RunSQL(search.drop_old_fts("credit_control_creditentry")),
        migrations.RunSQL(search.create_structure("credit_control_creditentry")),
        migrations.RunSQL(
            search.fts(
                "credit_control_creditentry",
                ["reference_number", "total", "payment_notice", "notes"],
            )
        ),
    ]

Пример #7

Файл: 0002_auto_20200219_1234.py Проект: matthiask/workbench

class Migration(migrations.Migration):

    dependencies = [
        ("deals", "0001_initial"),
    ]

    operations = [
        migrations.RunSQL(search.drop_old_fts("deals_deal")),
        migrations.RunSQL(search.create_structure("deals_deal")),
        migrations.RunSQL(
            search.fts(
                "deals_deal",
                ["title", "description", "closing_notice", "_fts"],
            )
        ),
        migrations.RunSQL(
            "SELECT audit_audit_table('deals_valuetype');"
            "SELECT audit_audit_table('deals_value');"
            "SELECT audit_audit_table('deals_deal', ARRAY['_fts', 'fts_document']);"
        ),
    ]