langflow icon indicating copy to clipboard operation
langflow copied to clipboard

The error - duplicate 'folder_id' in alembic

Open songjinu opened this issue 8 months ago • 3 comments

Describe the bug The error - duplicate 'folder_id' in alembic

at src/backend/base/langflow/alembic/versions/012fb73ac359_add_folder_table.py

    if "folder_id" not in inspector.get_columns("flow"):
        with op.batch_alter_table("flow", schema=None) as batch_op:
            batch_op.add_column(sa.Column("folder_id", sqlmodel.sql.sqltypes.GUID(), nullable=True))
            batch_op.create_foreign_key("flow_folder_id_fkey", "folder", ["folder_id"], ["id"])
            batch_op.drop_column("folder")

inspector.get_columns("flow") return List[Dict] I modifed like this

    flow = inspector.get_columns("flow")
    if any('folder_id' in columns["name"] for columns in flow):
        with op.batch_alter_table("flow", schema=None) as batch_op:
            batch_op.create_foreign_key("flow_folder_id_fkey", "folder", ["folder_id"], ["id"])
            batch_op.drop_column("folder")
    else:
        with op.batch_alter_table("flow", schema=None) as batch_op:
            batch_op.add_column(sa.Column("folder_id", sqlmodel.sql.sqltypes.GUID(), nullable=True))
            batch_op.create_foreign_key("flow_folder_id_fkey", "folder", ["folder_id"], ["id"])
            batch_op.drop_column("folder")

Browser and Version

  • Browser [chrome]
  • Version [v1.0.0.a37]

songjinu avatar May 28 '24 03:05 songjinu