old_contents: """
  byceps.services.orga_team.dbmodels
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  
  :Copyright: 2006-2021 Jochen Kupperschmidt
  :License: Revised BSD (see `LICENSE` file for details)
  """
  
  from ...database import db, generate_uuid
  from ...typing import PartyID, UserID
  from ...util.instances import ReprBuilder
  
  from ..party.dbmodels.party import Party
  from ..user.dbmodels.user import User
  
  from .transfer.models import OrgaTeamID
  
  
  class OrgaTeam(db.Model):
      """A group of organizers for a single party."""
  
      __tablename__ = 'orga_teams'
      __table_args__ = (
          db.UniqueConstraint('party_id', 'title'),
      )
  
      id = db.Column(db.Uuid, default=generate_uuid, primary_key=True)
      party_id = db.Column(db.UnicodeText, db.ForeignKey('parties.id'), index=True, nullable=False)
      party = db.relationship(Party)
      title = db.Column(db.UnicodeText, nullable=False)
  
      def __init__(self, party_id: PartyID, title: str) -> None:
          self.party_id = party_id
          self.title = title
  
      def __repr__(self) -> str:
          membership_count = len(self.memberships)
  
          return ReprBuilder(self) \
              .add_with_lookup('id') \
              .add_with_lookup('party_id') \
              .add_with_lookup('title') \
              .add_custom(f'{membership_count:d} members') \
              .build()
  
  
  class Membership(db.Model):
      """The assignment of a user to an organizer team."""
  
      __tablename__ = 'orga_team_memberships'
      __table_args__ = (
          db.UniqueConstraint('orga_team_id', 'user_id'),
      )
  
      id = db.Column(db.Uuid, default=generate_uuid, primary_key=True)
      orga_team_id = db.Column(db.Uuid, db.ForeignKey('orga_teams.id'), index=True, nullable=False)
      orga_team = db.relationship(OrgaTeam, collection_class=set, backref='memberships')
      user_id = db.Column(db.Uuid, db.ForeignKey('users.id'), index=True, nullable=False)
      user = db.relationship(User, collection_class=set, backref='orga_team_memberships')
      duties = db.Column(db.UnicodeText)
  
      def __init__(self, orga_team_id: OrgaTeamID, user_id: UserID) -> None:
          self.orga_team_id = orga_team_id
          self.user_id = user_id
  
      def __repr__(self) -> str:
          return ReprBuilder(self) \
              .add_with_lookup('id') \
              .add_with_lookup('orga_team') \
              .add_with_lookup('user') \
              .build()
  
new_contents: """
  byceps.services.orga_team.dbmodels
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  
  :Copyright: 2006-2021 Jochen Kupperschmidt
  :License: Revised BSD (see `LICENSE` file for details)
  """
  
  from ...database import db, generate_uuid
  from ...typing import PartyID, UserID
  from ...util.instances import ReprBuilder
  
  from ..party.dbmodels.party import Party
  from ..user.dbmodels.user import User
  
  from .transfer.models import OrgaTeamID
  
  
  class OrgaTeam(db.Model):
      """A group of organizers for a single party."""
  
      __tablename__ = 'orga_teams'
      __table_args__ = (
          db.UniqueConstraint('party_id', 'title'),
      )
  
      id = db.Column(db.Uuid, default=generate_uuid, primary_key=True)
      party_id = db.Column(db.UnicodeText, db.ForeignKey('parties.id'), index=True, nullable=False)
      party = db.relationship(Party)
      title = db.Column(db.UnicodeText, nullable=False)
  
      def __init__(self, party_id: PartyID, title: str) -> None:
          self.party_id = party_id
          self.title = title
  
      def __repr__(self) -> str:
          return ReprBuilder(self) \
              .add_with_lookup('id') \
              .add_with_lookup('party_id') \
              .add_with_lookup('title') \
              .build()
  
  
  class Membership(db.Model):
      """The assignment of a user to an organizer team."""
  
      __tablename__ = 'orga_team_memberships'
      __table_args__ = (
          db.UniqueConstraint('orga_team_id', 'user_id'),
      )
  
      id = db.Column(db.Uuid, default=generate_uuid, primary_key=True)
      orga_team_id = db.Column(db.Uuid, db.ForeignKey('orga_teams.id'), index=True, nullable=False)
      orga_team = db.relationship(OrgaTeam, collection_class=set, backref='memberships')
      user_id = db.Column(db.Uuid, db.ForeignKey('users.id'), index=True, nullable=False)
      user = db.relationship(User, collection_class=set, backref='orga_team_memberships')
      duties = db.Column(db.UnicodeText)
  
      def __init__(self, orga_team_id: OrgaTeamID, user_id: UserID) -> None:
          self.orga_team_id = orga_team_id
          self.user_id = user_id
  
      def __repr__(self) -> str:
          return ReprBuilder(self) \
              .add_with_lookup('id') \
              .add_with_lookup('orga_team') \
              .add_with_lookup('user') \
              .build()
  
subject: Remove membership count from orga team model text representation