# - in_room_acls (RoomPrincipal.local_group) # - in_session_acls (SessionPrincipal.local_group) # - in_settings_acls (SettingPrincipal.local_group) # - in_track_acls (TrackPrincipal.local_group) def __repr__(self): return f'<LocalGroup({self.id}, {self.name})>' @property def proxy(self): """Return a GroupProxy wrapping this group.""" from indico.modules.groups import GroupProxy return GroupProxy(self.id, _group=self) group_members_table = db.Table('group_members', db.metadata, db.Column('group_id', db.Integer, db.ForeignKey('users.groups.id'), primary_key=True, nullable=False, index=True), db.Column('user_id', db.Integer, db.ForeignKey('users.users.id'), primary_key=True, nullable=False, index=True), schema='users')
# Indico is free software; you can redistribute it and/or # modify it under the terms of the MIT License; see the # LICENSE file for more details. from __future__ import unicode_literals from indico.core.db import db favorite_room_table = db.Table( 'favorite_rooms', db.metadata, db.Column( 'user_id', db.Integer, db.ForeignKey('users.users.id'), primary_key=True, nullable=False, index=True ), db.Column( 'room_id', db.Integer, db.ForeignKey('roombooking.rooms.id'), primary_key=True, nullable=False, index=True ), schema='roombooking' )
# - revisions (EditingRevision.tags) @property def verbose_title(self): """Properly formatted title, including tag code.""" return f'{self.code}: {self.title}' def __repr__(self): return format_repr(self, 'id', 'event_id', system=False, _text=self.title) db.Table( 'revision_tags', db.metadata, db.Column( 'revision_id', db.ForeignKey('event_editing.revisions.id'), primary_key=True, autoincrement=False, index=True ), db.Column( 'tag_id', db.ForeignKey('event_editing.tags.id'), primary_key=True, autoincrement=False, index=True ), schema='event_editing' )
lazy=True)) file_types = db.relationship( 'EditingFileType', secondary='event_editing.review_condition_file_types', collection_class=set, lazy=False, backref=db.backref('review_conditions', collection_class=set, lazy=True)) # relationship backrefs: # - file_types (EditingFileType.review_conditions) def __repr__(self): return format_repr(self, 'id', 'event_id') db.Table('review_condition_file_types', db.metadata, db.Column('review_condition_id', db.ForeignKey('event_editing.review_conditions.id'), primary_key=True, autoincrement=False, index=True), db.Column('file_type_id', db.ForeignKey('event_editing.file_types.id'), primary_key=True, autoincrement=False, index=True), schema='event_editing')
# modify it under the terms of the MIT License; see the # LICENSE file for more details. from indico.core.db import db from indico.util.string import format_repr RoomEquipmentAssociation = db.Table( 'room_equipment', db.metadata, db.Column( 'equipment_id', db.Integer, db.ForeignKey('roombooking.equipment_types.id'), primary_key=True, ), db.Column( 'room_id', db.Integer, db.ForeignKey('roombooking.rooms.id'), primary_key=True ), schema='roombooking' ) equipment_features_table = db.Table( 'equipment_features', db.metadata, db.Column( 'equipment_id',
# You should have received a copy of the GNU General Public License # along with Indico; if not, see <http://www.gnu.org/licenses/>. from indico.core.db import db from indico.util.string import return_ascii RoomEquipmentAssociation = db.Table( 'room_equipment', db.metadata, db.Column( 'equipment_id', db.Integer, db.ForeignKey('roombooking.equipment_types.id'), primary_key=True, ), db.Column( 'room_id', db.Integer, db.ForeignKey('roombooking.rooms.id'), primary_key=True ), schema='roombooking' ) ReservationEquipmentAssociation = db.Table( 'reservation_equipment', db.metadata, db.Column( 'equipment_id', db.Integer,
def get_category_role_by_id(cat, id): """ Get a category role in the context of the specified category. If the role is not defined in the category or one of its parents, it is considered non-existing. """ return CategoryRole.query.filter_by(id=id).join(cat.chain_query.subquery()).first() role_members_table = db.Table( 'role_members', db.metadata, db.Column( 'role_id', db.Integer, db.ForeignKey('categories.roles.id'), primary_key=True, nullable=False, index=True ), db.Column( 'user_id', db.Integer, db.ForeignKey('users.users.id'), primary_key=True, nullable=False, index=True ), schema='categories' )
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU # General Public License for more details. # # You should have received a copy of the GNU General Public License # along with Indico; if not, see <http://www.gnu.org/licenses/>. from __future__ import unicode_literals from indico.core.db import db _track_conveners_table = db.Table( 'track_conveners', db.metadata, db.Column('id', db.Integer, primary_key=True), db.Column('user_id', db.Integer, db.ForeignKey('users.users.id'), index=True, nullable=False), db.Column('event_id', db.Integer, db.ForeignKey('events.events.id'), index=True), db.Column('track_id', db.Integer, db.ForeignKey('events.tracks.id'), index=True), db.CheckConstraint('(track_id IS NULL) != (event_id IS NULL)', name='track_xor_event_id_null'), schema='events')
# LICENSE file for more details. from indico.core.db import db _paper_judges = db.Table( 'judges', db.metadata, db.Column( 'contribution_id', db.Integer, db.ForeignKey('events.contributions.id'), primary_key=True, autoincrement=False, index=True ), db.Column( 'user_id', db.Integer, db.ForeignKey('users.users.id'), primary_key=True, autoincrement=False, index=True ), schema='event_paper_reviewing' ) _paper_content_reviewers = db.Table( 'content_reviewers', db.metadata,
# LICENSE file for more details. from indico.core.db import db favorite_user_table = db.Table( 'favorite_users', db.metadata, db.Column( 'user_id', db.Integer, db.ForeignKey('users.users.id'), primary_key=True, nullable=False, index=True ), db.Column( 'target_id', db.Integer, db.ForeignKey('users.users.id'), primary_key=True, nullable=False, index=True ), schema='users' ) favorite_category_table = db.Table( 'favorite_categories', db.metadata, db.Column(
assert event_id is not None return increment_and_get(Event._last_friendly_registration_id, Event.id == event_id) registrations_tags_table = db.Table( 'registration_tags', db.metadata, db.Column( 'registration_id', db.Integer, db.ForeignKey('event_registration.registrations.id', ondelete='CASCADE'), primary_key=True, nullable=False, index=True, ), db.Column( 'registration_tag_id', db.Integer, db.ForeignKey('event_registration.tags.id', ondelete='CASCADE'), primary_key=True, nullable=False, index=True, ), schema='event_registration') class PublishRegistrationsMode(RichIntEnum): __titles__ = [ L_('Hide all participants'),