Mercurial > libervia-backend
comparison libervia/backend/memory/migration/versions/129ac51807e4_create_virtual_table_for_full_text_.py @ 4270:0d7bb4df2343
Reformatted code base using black.
author | Goffi <goffi@goffi.org> |
---|---|
date | Wed, 19 Jun 2024 18:44:57 +0200 |
parents | 4b842c1fb686 |
children |
comparison
equal
deleted
inserted
replaced
4269:64a85ce8be70 | 4270:0d7bb4df2343 |
---|---|
3 Revision ID: 129ac51807e4 | 3 Revision ID: 129ac51807e4 |
4 Revises: 8974efc51d22 | 4 Revises: 8974efc51d22 |
5 Create Date: 2021-08-13 19:13:54.112538 | 5 Create Date: 2021-08-13 19:13:54.112538 |
6 | 6 |
7 """ | 7 """ |
8 | |
8 from alembic import op | 9 from alembic import op |
9 import sqlalchemy as sa | 10 import sqlalchemy as sa |
10 | 11 |
11 | 12 |
12 # revision identifiers, used by Alembic. | 13 # revision identifiers, used by Alembic. |
13 revision = '129ac51807e4' | 14 revision = "129ac51807e4" |
14 down_revision = '8974efc51d22' | 15 down_revision = "8974efc51d22" |
15 branch_labels = None | 16 branch_labels = None |
16 depends_on = None | 17 depends_on = None |
17 | 18 |
18 | 19 |
19 def upgrade(): | 20 def upgrade(): |
30 "CREATE TRIGGER pubsub_items_fts_sync_upd AFTER UPDATE ON pubsub_items BEGIN" | 31 "CREATE TRIGGER pubsub_items_fts_sync_upd AFTER UPDATE ON pubsub_items BEGIN" |
31 " INSERT INTO pubsub_items_fts(pubsub_items_fts, rowid, data) VALUES" | 32 " INSERT INTO pubsub_items_fts(pubsub_items_fts, rowid, data) VALUES" |
32 "('delete', old.id, old.data);" | 33 "('delete', old.id, old.data);" |
33 " INSERT INTO pubsub_items_fts(rowid, data) VALUES(new.id, new.data);" | 34 " INSERT INTO pubsub_items_fts(rowid, data) VALUES(new.id, new.data);" |
34 "END", | 35 "END", |
35 "INSERT INTO pubsub_items_fts(rowid, data) SELECT id, data from pubsub_items" | 36 "INSERT INTO pubsub_items_fts(rowid, data) SELECT id, data from pubsub_items", |
36 ] | 37 ] |
37 for q in queries: | 38 for q in queries: |
38 op.execute(sa.DDL(q)) | 39 op.execute(sa.DDL(q)) |
39 | 40 |
40 | 41 |