ephraimbuddy commented on issue #24247:
URL: https://github.com/apache/airflow/issues/24247#issuecomment-1147670126
Can someone test with this patch for your upgrade if you're in 2.2.5:
```diff
diff --git a/airflow/www/fab_security/sqla/models.py
b/airflow/www/fab_security/sqla/models.py
index c6eb65ead..d6dc18e0c 100644
--- a/airflow/www/fab_security/sqla/models.py
+++ b/airflow/www/fab_security/sqla/models.py
@@ -87,7 +87,7 @@ class Action(Model):
"""Represents permission actions such as `can_read`."""
__tablename__ = "ab_permission"
- id = Column(Integer, get_sequence_or_identity("ab_permission_id_seq"),
primary_key=True)
+ id = Column(Integer, primary_key=True)
name = Column(String(100), unique=True, nullable=False)
def __repr__(self):
@@ -98,7 +98,7 @@ class Resource(Model):
"""Represents permission object such as `User` or `Dag`."""
__tablename__ = "ab_view_menu"
- id = Column(Integer, get_sequence_or_identity("ab_view_menu_id_seq"),
primary_key=True)
+ id = Column(Integer, primary_key=True)
name = Column(String(250), unique=True, nullable=False)
def __eq__(self, other):
@@ -114,7 +114,7 @@ class Resource(Model):
assoc_permission_role = Table(
"ab_permission_view_role",
Model.metadata,
- Column("id", Integer,
get_sequence_or_identity("ab_permission_view_role_id_seq"), primary_key=True),
+ Column("id", Integer, primary_key=True),
Column("permission_view_id", Integer,
ForeignKey("ab_permission_view.id")),
Column("role_id", Integer, ForeignKey("ab_role.id")),
UniqueConstraint("permission_view_id", "role_id"),
@@ -126,7 +126,7 @@ class Role(Model):
__tablename__ = "ab_role"
- id = Column(Integer, get_sequence_or_identity("ab_role_id_seq"),
primary_key=True)
+ id = Column(Integer, primary_key=True)
name = Column(String(64), unique=True, nullable=False)
permissions = relationship("Permission",
secondary=assoc_permission_role, backref="role", lazy="joined")
@@ -139,7 +139,7 @@ class Permission(Model):
__tablename__ = "ab_permission_view"
__table_args__ = (UniqueConstraint("permission_id", "view_menu_id"),)
- id = Column(Integer,
get_sequence_or_identity("ab_permission_view_id_seq"), primary_key=True)
+ id = Column(Integer, primary_key=True)
action_id = Column("permission_id", Integer,
ForeignKey("ab_permission.id"))
action = relationship(
"Action",
@@ -160,7 +160,7 @@ class Permission(Model):
assoc_user_role = Table(
"ab_user_role",
Model.metadata,
- Column("id", Integer, get_sequence_or_identity("ab_user_role_id_seq"),
primary_key=True),
+ Column("id", Integer, primary_key=True),
Column("user_id", Integer, ForeignKey("ab_user.id")),
Column("role_id", Integer, ForeignKey("ab_role.id")),
UniqueConstraint("user_id", "role_id"),
@@ -171,7 +171,7 @@ class User(Model):
"""Represents an Airflow user which has roles assigned to it."""
__tablename__ = "ab_user"
- id = Column(Integer, get_sequence_or_identity("ab_user_id_seq"),
primary_key=True)
+ id = Column(Integer, primary_key=True)
first_name = Column(String(64), nullable=False)
last_name = Column(String(64), nullable=False)
username = Column(String(256), unique=True, nullable=False)
@@ -264,7 +264,7 @@ class RegisterUser(Model):
"""Represents a user registration."""
__tablename__ = "ab_register_user"
- id = Column(Integer,
get_sequence_or_identity("ab_register_user_id_seq"), primary_key=True)
+ id = Column(Integer, primary_key=True)
first_name = Column(String(64), nullable=False)
last_name = Column(String(64), nullable=False)
username = Column(String(256), unique=True, nullable=False)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
