class OAuth(OAuthConsumerMixin, db.Model): __table_args__ = (db.UniqueConstraint("provider", "provider_user_id"),) provider_user_id = db.Column(db.String(256), nullable=False) provider_user_login = db.Column(db.String(256), nullable=False) user_id = db.Column(db.Integer, db.ForeignKey(User.id), nullable=False) user = db.relationship( User, # This `backref` thing sets up an `oauth` property on the User model, # which is a dictionary of OAuth models associated with that user, # where the dictionary key is the OAuth provider name. backref=db.backref( "oauth", collection_class=attribute_mapped_collection("provider"), cascade="all, delete-orphan", ), )
class Character(db.Model): __tablename__ = 'character' __table_args__ = {'extend_existing': True} Id = db.Column(db.Integer(), primary_key=True) Name = db.Column(db.String(), nullable=False) Age = db.Column(db.Integer(), nullable=False) Weight = db.Column(db.Integer() ,nullable=False) Human = db.Column(db.Boolean(), nullable=False) Hat_id = db.Column(db.Integer(), db.ForeignKey('hat.Id'), nullable =True) Hat = db.relationship("Hat", single_parent= True,uselist=False, cascade = "all, delete, delete-orphan" ) def create(self): db.session.add(self) db.session.commit() return self def __init__(self,Name,Age,Weight,Human,Hat): self.Name = Name self.Age = Age self.Weight = Weight #print('Human',Human) self.Human = Human self.Hat = Hat def __repr__(self): return '' % self.Id
class Keywords(db.Model): id = db.Column('keyword_id', db.Integer, primary_key=True) keyword = db.Column(db.String(100), unique=True, nullable=False) def __init__(self, keyword): self.keyword = keyword def __repr__(self): return self.keyword
class Keywords(db.Model): ''' # insert sample data with ignore stmt = Keyword.__table__.insert().prefix_with('OR IGNORE').values([ {'keyword': 'apple'}, {'keyword': 'apple pie'} ]) db.session.execute(stmt) db.session.commit() ''' id = db.Column('keyword_id', db.Integer, primary_key=True) keyword = db.Column(db.String(100), unique=True, nullable=False) def __init__(self, keyword): self.keyword = keyword
class Result(db.Model): __tablename__ = 'results' id = db.Column(db.Integer, primary_key=True) url = db.Column(db.String()) result_all = db.Column(JSON) result_no_stop_words = db.Column(JSON) def __init__(self, url, result_all, result_no_stop_words): self.url = url self.result_all = result_all self.result_no_stop_words = result_no_stop_words def __str__(self): return '<id {}>'.format(self.id)