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)
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)
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")
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'))
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'))
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'))
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}"
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
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)
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})"
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'))
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}')"
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)
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}')"
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)
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)
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)
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()}
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')
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)