from config import PASSWORD_LENGTH
from sqlalchemy import BigInteger, Column, ForeignKey, String
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()


class User(Base):
    __tablename__ = 'user'

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    password = Column(String(PASSWORD_LENGTH))
    fight_id = Column(BigInteger, ForeignKey('fight.id'))

    def __init__(self, password: str):
        self.password = password


class Fight(Base):
    __tablename__ = 'fight'

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    user_id = Column(BigInteger)

    def __init__(self, user_id: int):
        self.user_id = user_id

from config import PASSWORD_LENGTH
from sqlalchemy import BigInteger, Column, ForeignKey, String
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()


class User(Base):
    __tablename__ = 'user'

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    password = Column(String(PASSWORD_LENGTH))

    def __init__(self, password: str):
        self.password = password


class Fight(Base):
    __tablename__ = 'fight'

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    user_id = Column(BigInteger, ForeignKey(User.id))

    def __init__(self, user_id: int):
        self.user_id = user_id

Update user, fight foreign key dependency
Update user, fight foreign key dependency

  from config import PASSWORD_LENGTH
  from sqlalchemy import BigInteger, Column, ForeignKey, String
  from sqlalchemy.ext.declarative import declarative_base
  
  Base = declarative_base()
  
  
  class User(Base):
      __tablename__ = 'user'
  
      id = Column(BigInteger, primary_key=True, autoincrement=True)
      password = Column(String(PASSWORD_LENGTH))
-     fight_id = Column(BigInteger, ForeignKey('fight.id'))
  
      def __init__(self, password: str):
          self.password = password
  
  
  class Fight(Base):
      __tablename__ = 'fight'
  
      id = Column(BigInteger, primary_key=True, autoincrement=True)
-     user_id = Column(BigInteger)
+     user_id = Column(BigInteger, ForeignKey(User.id))
  
      def __init__(self, user_id: int):
          self.user_id = user_id
  
Update user, fight foreign key dependency
## Code Before:
from config import PASSWORD_LENGTH
from sqlalchemy import BigInteger, Column, ForeignKey, String
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()


class User(Base):
    __tablename__ = 'user'

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    password = Column(String(PASSWORD_LENGTH))
    fight_id = Column(BigInteger, ForeignKey('fight.id'))

    def __init__(self, password: str):
        self.password = password


class Fight(Base):
    __tablename__ = 'fight'

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    user_id = Column(BigInteger)

    def __init__(self, user_id: int):
        self.user_id = user_id

## Instruction:
Update user, fight foreign key dependency
## Code After:
from config import PASSWORD_LENGTH
from sqlalchemy import BigInteger, Column, ForeignKey, String
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()


class User(Base):
    __tablename__ = 'user'

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    password = Column(String(PASSWORD_LENGTH))

    def __init__(self, password: str):
        self.password = password


class Fight(Base):
    __tablename__ = 'fight'

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    user_id = Column(BigInteger, ForeignKey(User.id))

    def __init__(self, user_id: int):
        self.user_id = user_id
