|
|
from flask_login import UserMixin |
|
|
from werkzeug.security import generate_password_hash, check_password_hash |
|
|
from datetime import datetime |
|
|
from create_app import db |
|
|
|
|
|
|
|
|
class User(UserMixin, db.Model): |
|
|
id = db.Column(db.Integer, primary_key=True) |
|
|
email = db.Column(db.String(100), unique=True, nullable=False) |
|
|
nickname = db.Column(db.String(100), unique=True, nullable=False) |
|
|
password_hash = db.Column(db.String(200)) |
|
|
|
|
|
def set_password(self, password): |
|
|
self.password_hash = generate_password_hash(password) |
|
|
|
|
|
def check_password(self, password): |
|
|
return check_password_hash(self.password_hash, password) |
|
|
|
|
|
def get_id(self): |
|
|
return str(self.id) |
|
|
|
|
|
@property |
|
|
def is_active(self): |
|
|
return True |
|
|
|
|
|
class History(db.Model): |
|
|
id = db.Column(db.Integer, primary_key=True) |
|
|
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) |
|
|
topic = db.Column(db.String(255), nullable=False) |
|
|
essay = db.Column(db.Text, nullable=False) |
|
|
created_at = db.Column(db.DateTime, default=datetime.utcnow) |
|
|
score_tr = db.Column(db.Integer, nullable=False) |
|
|
score_cc = db.Column(db.Integer, nullable=False) |
|
|
score_lr = db.Column(db.Integer, nullable=False) |
|
|
score_gra = db.Column(db.Integer, nullable=False) |
|
|
user = db.relationship('User', backref=db.backref('histories', lazy=True)) |
