Mercurial > libervia-backend

comparison libervia/backend/memory/migration/versions/129ac51807e4_create_virtual_table_for_full_text_.py @ 4270:0d7bb4df2343

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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