"""empty message

Revision ID: 2f3192e76e5
Revises: 3dbc20af3c9
Create Date: 2015-11-24 15:28:41.695124

"""

# revision identifiers, used by Alembic.
revision = '2f3192e76e5'
down_revision = '3dbc20af3c9'

from alembic import op
import sqlalchemy as sa
import sqlalchemy_utils
from sqlalchemy_searchable import sync_trigger


def upgrade():
    conn = op.get_bind()
    sync_trigger(conn, 'word', 'search_vector',
                 ['singular', 'plural', 'infinitive', 'past_tense',
                  'present_perfect_tense', 'positive', 'comparative',
                  'superlative', 'adverb', 'conjunction', 'preposition',
                  'meaning', 'examples'])
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('word',
                  sa.Column('search_vector',
                            sqlalchemy_utils.TSVectorType(),
                            nullable=True))
    op.create_index('ix_word_search_vector',
                    'word',
                    ['search_vector'],
                    unique=False,
                    postgresql_using='gin')
    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_index('ix_word_search_vector', table_name='word')
    op.drop_column('word', 'search_vector')
    ### end Alembic commands ###

@@ -339,334 +339,8 @@
 ():%0A
-    conn = op.get_bind()%0A    sync_trigger(conn, 'word', 'search_vector',%0A                 %5B'singular', 'plural', 'infinitive', 'past_tense',%0A                  'present_perfect_tense', 'positive', 'comparative',%0A                  'superlative', 'adverb', 'conjunction', 'preposition',%0A                  'meaning', 'examples'%5D)%0A
     
@@ -798,16 +798,342 @@
 nds ###%0A
+    conn = op.get_bind()%0A    sync_trigger(conn, 'word', 'search_vector',%0A                 %5B'singular', 'plural', 'infinitive', 'past_tense',%0A                  'present_perfect_tense', 'positive', 'comparative',%0A                  'superlative', 'adverb', 'conjunction', 'preposition',%0A                  'meaning', 'examples'%5D)%0A
 %0A%0Adef do

Fix search_vector migration