1c4af61d72a5_dialog_id_to_36.py 1.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. """dialog id to 36
  2. Revision ID: 1c4af61d72a5
  3. Revises: 0366cf835bba
  4. Create Date: 2024-12-13 11:24:57.138214
  5. """
  6. from typing import Sequence, Union
  7. from alembic import op
  8. import sqlalchemy as sa
  9. from sqlalchemy.dialects import mysql
  10. # revision identifiers, used by Alembic.
  11. revision: str = '1c4af61d72a5'
  12. down_revision: Union[str, None] = '0366cf835bba'
  13. branch_labels: Union[str, Sequence[str], None] = None
  14. depends_on: Union[str, Sequence[str], None] = None
  15. def upgrade() -> None:
  16. # ### commands auto generated by Alembic - please adjust! ###
  17. op.alter_column('dialogs', 'id',
  18. existing_type=mysql.VARCHAR(length=32),
  19. type_=sa.String(length=36),
  20. existing_nullable=False)
  21. op.alter_column('dialogs', 'agent_id',
  22. existing_type=mysql.VARCHAR(length=32),
  23. type_=sa.String(length=36),
  24. existing_nullable=True)
  25. op.alter_column('knowledgebase', 'id',
  26. existing_type=mysql.VARCHAR(length=32),
  27. type_=sa.String(length=36),
  28. existing_nullable=False)
  29. # ### end Alembic commands ###
  30. def downgrade() -> None:
  31. # ### commands auto generated by Alembic - please adjust! ###
  32. op.alter_column('knowledgebase', 'id',
  33. existing_type=sa.String(length=36),
  34. type_=mysql.VARCHAR(length=32),
  35. existing_nullable=False)
  36. op.alter_column('dialogs', 'agent_id',
  37. existing_type=sa.String(length=36),
  38. type_=mysql.VARCHAR(length=32),
  39. existing_nullable=True)
  40. op.alter_column('dialogs', 'id',
  41. existing_type=sa.String(length=36),
  42. type_=mysql.VARCHAR(length=32),
  43. existing_nullable=False)
  44. # ### end Alembic commands ###