Mercurial > libervia-backend
diff 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 |
line wrap: on
line diff
--- a/libervia/backend/memory/migration/versions/129ac51807e4_create_virtual_table_for_full_text_.py Tue Jun 18 12:06:45 2024 +0200 +++ b/libervia/backend/memory/migration/versions/129ac51807e4_create_virtual_table_for_full_text_.py Wed Jun 19 18:44:57 2024 +0200 @@ -5,13 +5,14 @@ Create Date: 2021-08-13 19:13:54.112538 """ + from alembic import op import sqlalchemy as sa # revision identifiers, used by Alembic. -revision = '129ac51807e4' -down_revision = '8974efc51d22' +revision = "129ac51807e4" +down_revision = "8974efc51d22" branch_labels = None depends_on = None @@ -32,7 +33,7 @@ "('delete', old.id, old.data);" " INSERT INTO pubsub_items_fts(rowid, data) VALUES(new.id, new.data);" "END", - "INSERT INTO pubsub_items_fts(rowid, data) SELECT id, data from pubsub_items" + "INSERT INTO pubsub_items_fts(rowid, data) SELECT id, data from pubsub_items", ] for q in queries: op.execute(sa.DDL(q))