Пример #1
0
class Tomog(db.Model):
    id = db.Column(db.Integer(), primary_key=True)
    manufacture_id = db.Column(db.Integer,
                               db.ForeignKey('manufactures.id'),
                               nullable=False)
    tomog_model = db.Column(db.String(128), nullable=False)
    spiraltype = db.Column(db.String(128))
    tubecount = db.Column(db.String(128))
    gantry = db.Column(db.Integer())
    slicecount = db.Column(db.Integer())
    slice_thicness = db.Column(db.Float())
    fov_x = db.Column(db.Integer())
    fov_z = db.Column(db.Integer())
    spatial_resolution = db.Column(db.Float())
    rotation_time = db.Column(db.Float())
    fps = db.Column(db.Integer())
    room_size = db.Column(db.Float())
    performance = db.Column(db.Float())
    tube_id = db.Column(db.Integer, db.ForeignKey('tubes.id'), nullable=False)
    generator_id = db.Column(db.Integer,
                             db.ForeignKey('generator.id'),
                             nullable=False)
    table_id = db.Column(db.Integer,
                         db.ForeignKey('tables.id'),
                         nullable=False)
    technologies = db.relationship('Technologies',
                                   secondary=tomog_techno,
                                   backref=db.backref('tomog', lazy='dynamic'))
    image_id = db.Column(db.Integer, db.ForeignKey('image.id'))

    def __repr__(self):
        return '{}'.format(self.tomog_model)
Пример #2
0
class ShowSong(db.Model):
    __tablename__ = 'show_song'
    song_id = db.Column(db.Integer,
                        db.ForeignKey('songs.id'),
                        primary_key=True)
    show_id = db.Column(db.Integer,
                        db.ForeignKey('shows.id'),
                        primary_key=True)
Пример #3
0
class ArticleKeyword(db.Model):
    __tablename__='articlekeywords'
    id=db.Column(db.Integer, primary_key=True )
    article_id=db.Column(db.Integer, db.ForeignKey('articles.nyt_id'))
    keyword_id=db.Column(db.Integer, db.ForeignKey('keywords.id'))
    # article=db.relationship('Article', backref="articlekeywords", cascade='all, delete-orphan', single_parent=True)
    # keyword=db.relationship('Keyword', backref="articlekeywords", cascade='all, delete-orphan', single_parent=True)
    article=db.relationship('Article', backref="articlekeywords")
    keyword=db.relationship('Keyword', backref="articlekeywords")
Пример #4
0
class President(db.Model):
    __tablename__='presidents'
    id=db.Column(db.Integer, primary_key=True )
    name=db.Column(db.Text)
    articles=db.relationship('Article', back_populates="president")
    article_id=db.Column(db.Integer, db.ForeignKey('articles.id'))
    #a president can have many articles
    keywords=db.relationship('Keyword', back_populates='president')
    keyword_id=db.Column(db.Integer, db.ForeignKey('keywords.id'))
Пример #5
0
class Claim(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    date = db.Column(db.Date)
    make_date = db.Column(db.Date)
    executor_comment = db.Column(db.String(1024))
    claim = db.Column(db.String(1024), nullable=False)
    comment = db.Column(db.String(255), nullable=False)
    source_user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    executer_user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
Пример #6
0
class Order(db.Model):
    __tablename__ = 'orders'
    id = db.Column(db.Integer, primary_key=True)
    customer_id = db.Column(db.Integer,
                            db.ForeignKey('customers.id'),
                            default=None)
    customer = db.relationship('Customer', back_populates="orders")
    bartender_id = db.Column(db.Integer, db.ForeignKey('bartenders.id'))

    drink_id = db.Column(db.Integer, db.ForeignKey('drinks.id'))
Пример #7
0
class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.Text, nullable=False)
    description = db.Column(db.Text, nullable=False)
    body = db.Column(db.Text, nullable=False)
    subject = db.Column(db.Integer, db.ForeignKey('path.id'), nullable=False)
    creator = db.Column(db.Integer, db.ForeignKey('admin.id'), nullable=False)
    track = db.Column(db.Integer, db.ForeignKey('tracks.id'))
    image = db.Column(db.String)
    video = db.Column(db.String)

    def __repr__(self):
        return f"{self.title},{self.description},{self.author}"
Пример #8
0
class Player(db.Model):
    __tablename__ = "players"
    id = db.Column(db.Integer, primary_key=True)
    team_id = db.Column(db.Integer, db.ForeignKey('teams.id'))
    team = db.relationship('Team', back_populates='players')
    team_code = db.Column(db.Integer)
    name = db.Column(db.String)
    position = db.Column(db.String)
    cost = db.Column(db.Float)
    total_points = db.Column(db.Integer)
    roi = db.Column(db.Float)
    bonus = db.Column(db.Integer)
    red_cards = db.Column(db.Integer)
    minutes = db.Column(db.Integer)
    status = db.Column(db.String)
    transfers_out = db.Column(db.Integer)
    transfers_in = db.Column(db.Integer)

    def to_dict(self):
        player_d = {
            'id': self.id,
            'name': self.name,
            'position': self.position,
            'cost': self.cost,
            'total_points': self.total_points,
            'roi': self.roi,
            'bonus': self.bonus,
            'red_cards': self.red_cards,
            'minutes': self.minutes,
            'status': self.status,
            'transfers_out': self.transfers_out,
            'transfers_in': self.transfers_in,
            'team': self.team.name
        }
        return player_d
Пример #9
0
class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    body = db.Column(db.String(140))
    timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

    def __repr__(self):
        return '<Post {}>'.format(self.body)
Пример #10
0
class Path(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100))
    track = db.Column(db.Integer, db.ForeignKey('tracks.id'), nullable=False)
    rela = db.relationship('Post', backref='course', lazy=True)

    def __repr__(self):
        return f"Course({self.title},{self.track})"
Пример #11
0
class Song(db.Model):
    __tablename__ = 'songs'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.Text)
    shows = db.relationship('Show',
                            secondary='show_song',
                            back_populates='songs')
    artist = db.relationship('Artist', back_populates='songs')
    artist_id = db.Column(db.Integer, db.ForeignKey('artists.id'))
Пример #12
0
class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100), nullable=False)
    date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
    content = db.Column(db.Text, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

    def __repr__(self):
        return f"Post('{self.title}', '{self.date_posted}')"
Пример #13
0
class Technologies(db.Model):
    id = db.Column(db.Integer(), primary_key=True)
    manufacture_id = db.Column(db.Integer,
                               db.ForeignKey('manufactures.id'),
                               nullable=False)
    technology_name = db.Column(db.String(128), nullable=False)
    technology_text = db.Column(db.Text)
    category = db.Column(db.String(128))

    def __repr__(self):
        return "%s, %s" % (self.technology_name, self.manufacture)
Пример #14
0
class Poll(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    code = db.Column(db.String(8), nullable=False)
    date_polled = db.Column(db.DateTime,
                            nullable=False,
                            default=datetime.utcnow)
    preferrence = db.Column(db.Integer, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

    def __repr__(self):
        return f"Poll('{self.code}','{self.name}')"
Пример #15
0
class Tables(db.Model):
    id = db.Column(db.Integer(), primary_key=True)
    manufacture_id = db.Column(db.Integer,
                               db.ForeignKey('manufactures.id'),
                               nullable=False)
    table_name = db.Column(db.String(128), nullable=False)
    horizont_range = db.Column(db.Integer())
    max_weight = db.Column(db.Integer())
    tomog = db.relationship('Tomog', backref='table', lazy=True)

    def __repr__(self):
        return '{}'.format(self.table_name)
Пример #16
0
class Generator(db.Model):
    id = db.Column(db.Integer(), primary_key=True)
    manufacture_id = db.Column(db.Integer,
                               db.ForeignKey('manufactures.id'),
                               nullable=False)
    generator_name = db.Column(db.String(128), nullable=False)
    power = db.Column(db.Integer())
    current = db.Column(db.Integer())
    voltage = db.Column(db.Integer())
    tomog = db.relationship('Tomog', backref='generator', lazy=True)

    def __repr__(self):
        return '{}'.format(self.generator_name)
Пример #17
0
class Tubes(db.Model):
    id = db.Column(db.Integer(), primary_key=True)
    manufacture_id = db.Column(db.Integer,
                               db.ForeignKey('manufactures.id'),
                               nullable=False)
    tube_model = db.Column(db.String(128), nullable=False)
    focus = db.Column(db.String(128))
    capacity = db.Column(db.Float())
    coolingrate = db.Column(db.Float())
    servise_life = db.Column(db.Integer())
    tomog = db.relationship('Tomog', backref='tube', lazy=True)

    def __repr__(self):
        return '{}'.format(self.tube_model)
Пример #18
0
class Show(db.Model):
    __tablename__ = 'shows'
    id = db.Column(db.Integer, primary_key=True)
    fmid = db.Column(db.Text, nullable=False)
    date = db.Column(db.Text, nullable=False)
    venue = db.Column(db.Text)
    city = db.Column(db.Text)
    lat = db.Column(db.Integer)
    lng = db.Column(db.Integer)
    songs = db.relationship('Song',
                            secondary='show_song',
                            back_populates='shows')
    country_id = db.Column(db.Integer, db.ForeignKey('countries.id'))
    country = db.relationship('Country', back_populates='shows')

    @classmethod
    def venue_locations(cls):
        return {show.venue: [show.lat, show.lng] for show in Show.query.all()}
Пример #19
0
class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    login = db.Column(db.String(128), nullable=False, unique=True)
    email = db.Column(db.String(length=120))
    fullname = db.Column(db.String(128), nullable=False)
    password = db.Column(db.String(255), nullable=False)
    group_user_id = db.Column(db.Integer, db.ForeignKey('usergroup.id'))
    Claims = db.relationship('Claim',
                             primaryjoin="Claim.source_user_id==User.id",
                             foreign_keys=[Claim.source_user_id],
                             backref=db.backref('user', lazy='joined'),
                             lazy='dynamic',
                             cascade='all, delete-orphan')
    Claims_executer = db.relationship(
        'Claim',
        primaryjoin="Claim.executer_user_id==User.id",
        foreign_keys=[Claim.executer_user_id],
        backref=db.backref('executer_user', lazy='joined'),
        lazy='dynamic',
        cascade='all, delete-orphan')
Пример #20
0
from package import db
from flask_security import UserMixin, RoleMixin

role_user = db.Table(
    'role_user', db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
    db.Column('role_id', db.Integer, db.ForeignKey('role.id')))


class User(db.Model, UserMixin):
    id = db.Column(db.Integer(), primary_key=True)
    name = db.Column(db.String(128), unique=True)
    email = db.Column(db.String(128), unique=True)
    password = db.Column(db.String(128), )
    active = db.Column(db.Boolean())
    roles = db.relationship('Role',
                            secondary=role_user,
                            backref=db.backref('user', lazy='dynamic'))


class Role(db.Model, RoleMixin):
    id = db.Column(db.Integer(), primary_key=True)
    name = db.Column(db.String(128), nullable=False)
    description = db.Column(db.String(255))


class Tubes(db.Model):
    id = db.Column(db.Integer(), primary_key=True)
    manufacture_id = db.Column(db.Integer,
                               db.ForeignKey('manufactures.id'),
                               nullable=False)
    tube_model = db.Column(db.String(128), nullable=False)