
# revision identifiers, used by Alembic.
revision = '2507366cb6f2'
down_revision = '2a31d97fa618'

from alembic import op
import sqlalchemy as sa

from models.person import Person
from utils.nlp.utils.translit import translit


person_t = sa.sql.table(
    'person',
    sa.sql.column('id', sa.Integer),
    sa.sql.column('name', sa.Unicode(20)),
    sa.sql.column('name_en', sa.String(80))
)


def upgrade():
    people = Person.query.all()
    for person in people:
        name_en = translit(person.name, 'ko', 'en', 'name')
        op.execute(person_t.update().\
                where(person_t.c.id == person.id).\
                values({'name_en': op.inline_literal(name_en)})
        )


def downgrade():
    op.execute(person_t.update().\
            values({'name_en': op.inline_literal('')})
    )


# revision identifiers, used by Alembic.
revision = '2507366cb6f2'
down_revision = '2a31d97fa618'

from os.path import abspath, dirname, join
import sys

from alembic import op
import sqlalchemy as sa

parentdir = dirname(dirname(dirname(abspath(__file__))))
sys.path.insert(0,parentdir)
from models.person import Person
from utils.nlp.utils.translit import translit


person_t = sa.sql.table(
    'person',
    sa.sql.column('id', sa.Integer),
    sa.sql.column('name', sa.Unicode(20)),
    sa.sql.column('name_en', sa.String(80))
)


def upgrade():
    people = Person.query.all()
    for person in people:
        name_en = translit(person.name, 'ko', 'en', 'name')
        op.execute(person_t.update().\
                where(person_t.c.id == person.id).\
                values({'name_en': op.inline_literal(name_en)})
        )


def downgrade():
    op.execute(person_t.update().\
            values({'name_en': op.inline_literal('')})
    )

Fix broken alembic revision generation
Fix broken alembic revision generation

  
  # revision identifiers, used by Alembic.
  revision = '2507366cb6f2'
  down_revision = '2a31d97fa618'
  
+ from os.path import abspath, dirname, join
+ import sys
+ 
  from alembic import op
  import sqlalchemy as sa
  
+ parentdir = dirname(dirname(dirname(abspath(__file__))))
+ sys.path.insert(0,parentdir)
  from models.person import Person
  from utils.nlp.utils.translit import translit
  
  
  person_t = sa.sql.table(
      'person',
      sa.sql.column('id', sa.Integer),
      sa.sql.column('name', sa.Unicode(20)),
      sa.sql.column('name_en', sa.String(80))
  )
  
  
  def upgrade():
      people = Person.query.all()
      for person in people:
          name_en = translit(person.name, 'ko', 'en', 'name')
          op.execute(person_t.update().\
                  where(person_t.c.id == person.id).\
                  values({'name_en': op.inline_literal(name_en)})
          )
  
  
  def downgrade():
      op.execute(person_t.update().\
              values({'name_en': op.inline_literal('')})
      )
  
Fix broken alembic revision generation
## Code Before:

# revision identifiers, used by Alembic.
revision = '2507366cb6f2'
down_revision = '2a31d97fa618'

from alembic import op
import sqlalchemy as sa

from models.person import Person
from utils.nlp.utils.translit import translit


person_t = sa.sql.table(
    'person',
    sa.sql.column('id', sa.Integer),
    sa.sql.column('name', sa.Unicode(20)),
    sa.sql.column('name_en', sa.String(80))
)


def upgrade():
    people = Person.query.all()
    for person in people:
        name_en = translit(person.name, 'ko', 'en', 'name')
        op.execute(person_t.update().\
                where(person_t.c.id == person.id).\
                values({'name_en': op.inline_literal(name_en)})
        )


def downgrade():
    op.execute(person_t.update().\
            values({'name_en': op.inline_literal('')})
    )

## Instruction:
Fix broken alembic revision generation
## Code After:

# revision identifiers, used by Alembic.
revision = '2507366cb6f2'
down_revision = '2a31d97fa618'

from os.path import abspath, dirname, join
import sys

from alembic import op
import sqlalchemy as sa

parentdir = dirname(dirname(dirname(abspath(__file__))))
sys.path.insert(0,parentdir)
from models.person import Person
from utils.nlp.utils.translit import translit


person_t = sa.sql.table(
    'person',
    sa.sql.column('id', sa.Integer),
    sa.sql.column('name', sa.Unicode(20)),
    sa.sql.column('name_en', sa.String(80))
)


def upgrade():
    people = Person.query.all()
    for person in people:
        name_en = translit(person.name, 'ko', 'en', 'name')
        op.execute(person_t.update().\
                where(person_t.c.id == person.id).\
                values({'name_en': op.inline_literal(name_en)})
        )


def downgrade():
    op.execute(person_t.update().\
            values({'name_en': op.inline_literal('')})
    )
