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)