migrations/versions/6dca6eceb04d_.py

   1 """empty message
   2
   3 Revision ID: 6dca6eceb04d
   4 Revises: fd25bf3e57c3
   5 Create Date: 2020-01-18 17:32:21.885068
   6
   7 """
   8 from alembic import op
   9 import sqlalchemy as sa
  10 from sqlalchemy.dialects import postgresql
  11 from sqlalchemy_searchable import sync_trigger
  12
  13
  14 # revision identifiers, used by Alembic.
  15 revision = '6dca6eceb04d'
  16 down_revision = 'fd25bf3e57c3'
  17 branch_labels = None
  18 depends_on = None
  19
  20
  21 def upgrade():
  22         conn = op.get_bind()
  23         sync_trigger(conn, 'package', 'search_vector', ["name", "title", "short_desc", "desc"])
  24         op.create_check_constraint("name_valid", "package", "name ~* '^[a-z0-9_]+$'")
  25
  26
  27 def downgrade():
  28         conn = op.get_bind()
  29         sync_trigger(conn, 'package', 'search_vector', ["title", "short_desc", "desc"])
  30         op.drop_constraint("name_valid", "package", type_="check")