Python Column Examples

Example #1

File: hotel.py Project: alyshahudson/tuber

class RoomNightRequest(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    badge = db.Column(db.Integer, db.ForeignKey('badge.id'), nullable=False)
    requested = db.Column(db.Boolean)
    room_night = db.Column(db.Integer,
                           db.ForeignKey('hotel_room_night.id'),
                           nullable=False)

Example #2

File: badge.py Project: bitbyt3r/tuber

class RibbonType(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(128), unique=True, nullable=False)
    description = db.Column(db.String(256), nullable=False)

    def __repr__(self):
        return '<RibbonType %r>' % self.name

Example #3

File: hotel.py Project: alyshahudson/tuber

class RoomNightAssignment(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    badge = db.Column(db.Integer, db.ForeignKey('badge.id'))
    room_night = db.Column(db.Integer,
                           db.ForeignKey('hotel_room_night.id'),
                           nullable=False)
    hotel_room = db.Column(db.Integer, db.ForeignKey('hotel_room.id'))

Example #4

File: user.py Project: bitbyt3r/tuber

class Session(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.Integer, db.ForeignKey('user.id'))
    secret = db.Column(db.String(64))
    last_active = db.Column(db.DateTime)

    def __repr__(self):
        return '<Session %r>' % self.id

Example #5

File: hotel.py Project: bitbyt3r/tuber

class HotelAntiRoommateRequest(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    disallower = db.Column(db.Integer,
                           db.ForeignKey('badge.id'),
                           nullable=False)
    disallowed = db.Column(db.Integer,
                           db.ForeignKey('badge.id'),
                           nullable=False)

Example #6

File: hotel.py Project: bitbyt3r/tuber

class BadgeToRoomNight(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    badge = db.Column(db.Integer, db.ForeignKey('badge.id'), nullable=False)
    room_block = db.Column(db.Integer,
                           db.ForeignKey('hotel_room_block.id'),
                           nullable=False)
    room_night = db.Column(db.Integer,
                           db.ForeignKey('hotel_room_night.id'),
                           nullable=False)

Example #7

class Department(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    uber_id = db.Column(db.String(128), unique=True, nullable=True)
    description = db.Column(db.String(256), nullable=True)
    event = db.Column(db.Integer, db.ForeignKey('event.id'), nullable=False)
    name = db.Column(db.String(256))
    badges = db.relationship("Badge",
                             secondary="badge_to_department",
                             back_populates="departments")

Example #8

File: user.py Project: bitbyt3r/tuber

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    password = db.Column(db.String(128), default="")
    active = db.Column(db.Boolean)

    def __repr__(self):
        return '<User %r>' % self.username

Example #9

File: hotel.py Project: alyshahudson/tuber

class RoomNightApproval(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    badge = db.Column(db.Integer, db.ForeignKey('badge.id'), nullable=False)
    room_night = db.Column(db.Integer,
                           db.ForeignKey('hotel_room_night.id'),
                           nullable=False)
    department = db.Column(db.Integer,
                           db.ForeignKey('department.id'),
                           nullable=False)
    approved = db.Column(db.Boolean, nullable=False)

Example #10

File: user.py Project: alyshahudson/tuber

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    password = db.Column(db.String(128), default="")
    active = db.Column(db.Boolean)
    badges = db.relationship("Badge")
    sessions = db.relationship("Session")
    grants = db.relationship("Grant")

    def __repr__(self):
        return '<User %r>' % self.username

Example #11

File: badge.py Project: bitbyt3r/tuber

class Badge(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    event_id = db.Column(db.Integer, db.ForeignKey('event.id'), nullable=False)
    printed_number = db.Column(db.String(32), unique=False, nullable=True)
    printed_name = db.Column(db.String(256), nullable=False)
    first_name = db.Column(db.String(128), nullable=False)
    last_name = db.Column(db.String(128), nullable=False)
    legal_name = db.Column(db.String(256), nullable=False)
    legal_name_matches = db.Column(db.Boolean)
    email = db.Column(db.String(128), unique=False, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True)

    def __repr__(self):
        return '<Badge %r %r>' % (self.first_name, self.last_name)

Example #12

File: email.py Project: alyshahudson/tuber

class Email(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(128), unique=True, nullable=False)
    description = db.Column(db.String(256), nullable=False)
    event = db.Column(db.Integer, db.ForeignKey('event.id'), nullable=False)
    code = db.Column(db.String(4096), nullable=True)
    subject = db.Column(db.String(4096), nullable=False)
    body = db.Column(db.String(4096), nullable=False)
    active = db.Column(db.Boolean, nullable=False)
    send_once = db.Column(db.Boolean, nullable=False)
    source = db.Column(db.Integer, db.ForeignKey('email_source.id'), nullable=True)
    receipts = db.relationship("EmailReceipt")

    def __repr__(self):
        return '<Email %r>' % self.name

Example #13

File: email.py Project: alyshahudson/tuber

class EmailReceipt(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.Integer, db.ForeignKey('email.id'))
    badge = db.Column(db.Integer, db.ForeignKey('badge.id'))
    source = db.Column(db.Integer, db.ForeignKey('email_source.id'))
    to_address = db.Column(db.String(1024), nullable=False)
    from_address = db.Column(db.String(1024), nullable=False)
    subject = db.Column(db.String(4096), nullable=False)
    body = db.Column(db.String(4096), nullable=False)
    timestamp = db.Column(db.DateTime(), nullable=False)

    def __repr__(self):
        return '<EmailReceipt %r>' % self.id

Example #14

File: email.py Project: alyshahudson/tuber

class EmailSource(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(128), unique=True, nullable=False)
    description = db.Column(db.String(256), nullable=True)
    event = db.Column(db.Integer, db.ForeignKey('event.id'), nullable=False)
    address = db.Column(db.String(128), nullable=False)
    region = db.Column(db.String(64), nullable=False)
    ses_access_key = db.Column(db.String(128), nullable=False)
    ses_secret_key = db.Column(db.String(128), nullable=False)
    active = db.Column(db.Boolean)
    emails = db.relationship("Email")
    receipts = db.relationship("EmailReceipt")

    def __repr__(self):
        return '<EmailSource %r>' % self.name

Example #15

File: hotel.py Project: alyshahudson/tuber

class HotelRoom(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(128), nullable=True)
    notes = db.Column(db.String(512), nullable=True)
    messages = db.Column(db.String(512), nullable=True)
    hotel_block = db.Column(db.Integer,
                            db.ForeignKey('hotel_room_block.id'),
                            nullable=False)
    hotel_location = db.Column(db.Integer,
                               db.ForeignKey('hotel_location.id'),
                               nullable=False)
    completed = db.Column(db.Boolean)
    room_night_assignments = db.relationship('RoomNightAssignment')

Example #16

File: hotel.py Project: alyshahudson/tuber

class HotelRoomNight(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(16), nullable=False)
    event = db.Column(db.Integer, db.ForeignKey('event.id'), nullable=False)
    restricted = db.Column(db.Boolean, nullable=False, default=False)
    restriction_type = db.Column(db.String(64), nullable=True)
    hidden = db.Column(db.Boolean, nullable=False, default=False)
    requests = db.relationship("RoomNightRequest")
    assignments = db.relationship("RoomNightAssignment")
    approvals = db.relationship("RoomNightApproval")

Example #17

File: hotel.py Project: bitbyt3r/tuber

class HotelRoom(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(128), nullable=True)
    description = db.Column(db.String(256), nullable=True)
    disable_autofill = db.Column(db.Boolean, nullable=False, default=True)
    hotel_block = db.Column(db.Integer,
                            db.ForeignKey('hotel_room_block.id'),
                            nullable=False)
    hotel_location = db.Column(db.Integer,
                               db.ForeignKey('hotel_location.id'),
                               nullable=False)

Example #18

File: user.py Project: bitbyt3r/tuber

class Role(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(64), unique=True)
    description = db.Column(db.String(128))
    event = db.Column(db.Integer, nullable=True)

Example #19

File: user.py Project: bitbyt3r/tuber

class Grant(db.Model):
    # Null values become wildcards, i.e. if event is NULL, then the grant applies to all events
    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.Integer, nullable=True)
    role = db.Column(db.Integer, nullable=True)
    department = db.Column(db.Integer, nullable=True)

Example #20

File: hotel.py Project: alyshahudson/tuber

class HotelLocation(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(32), nullable=False)
    address = db.Column(db.String(128), nullable=False)
    event = db.Column(db.Integer, db.ForeignKey('event.id'), nullable=False)
    rooms = db.relationship("HotelRoom")

Example #21

File: user.py Project: bitbyt3r/tuber

class Permission(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    operation = db.Column(db.String(64), unique=True)
    role = db.Column(db.Integer, db.ForeignKey('role.id'))

Example #22

File: badge.py Project: bitbyt3r/tuber

class Group(db.Model):
    id = db.Column(db.Integer, primary_key=True)

Example #23

File: email.py Project: alyshahudson/tuber

class EmailTrigger(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    trigger = db.Column(db.String(128), nullable=False)
    badge = db.Column(db.Integer, db.ForeignKey('badge.id'))
    context = db.Column(db.String(4096))

Example #24

class Badge(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    event = db.Column(db.Integer, db.ForeignKey('event.id'), nullable=False)
    badge_type = db.Column(db.Integer,
                           db.ForeignKey('badge_type.id'),
                           nullable=False)
    printed_number = db.Column(db.String(32), unique=False, nullable=True)
    printed_name = db.Column(db.String(256), nullable=False)
    search_name = db.Column(db.String(256), nullable=False)
    first_name = db.Column(db.String(128), nullable=False)
    last_name = db.Column(db.String(128), nullable=False)
    legal_name = db.Column(db.String(256), nullable=False)
    legal_name_matches = db.Column(db.Boolean)
    phone = db.Column(db.String(64), nullable=True)
    email = db.Column(db.String(128), unique=False, nullable=False)
    user = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True)
    uber_id = db.Column(db.String(128), unique=True, nullable=True)
    departments = db.relationship("Department",
                                  secondary="badge_to_department",
                                  back_populates="badges")
    room_night_requests = db.relationship("RoomNightRequest")
    room_night_assignments = db.relationship("RoomNightAssignment")
    room_night_approvals = db.relationship("RoomNightApproval")
    hotel_room_request = db.relationship("HotelRoomRequest")

    def __repr__(self):
        return '<Badge %r %r>' % (self.first_name, self.last_name)

Example #25

File: badge.py Project: bitbyt3r/tuber

class RibbonToBadge(db.Model):
    id = db.Column(db.Integer, primary_key=True)

Example #26

class BadgeToDepartment(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    badge = db.Column(db.Integer, db.ForeignKey('badge.id'), nullable=False)
    department = db.Column(db.Integer,
                           db.ForeignKey('department.id'),
                           nullable=False)

Example #27

class RibbonToBadge(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    ribbon = db.Column(db.Integer, db.ForeignKey('ribbon_type.id'))
    badge = db.Column(db.Integer, db.ForeignKey('badge.id'))

Example #28

File: hotel.py Project: bitbyt3r/tuber

class HotelRoomNight(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(16), nullable=False)

Example #29

File: hotel.py Project: bitbyt3r/tuber

class HotelLocation(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(32), nullable=False)
    address = db.Column(db.String(128), nullable=False)

Example #30

File: hotel.py Project: bitbyt3r/tuber

class HotelRoomBlock(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    event = db.Column(db.Integer, db.ForeignKey('event.id'))
    name = db.Column(db.String(128), nullable=True)
    description = db.Column(db.String(256), nullable=True)