|
|
|
|
|
|
|
|
|
|
|
from app import db
|
|
|
from datetime import datetime
|
|
|
from flask_login import UserMixin
|
|
|
from werkzeug.security import generate_password_hash, check_password_hash
|
|
|
from .facebook_ad import FacebookAd
|
|
|
|
|
|
class User(UserMixin, db.Model):
|
|
|
id = db.Column(db.Integer, primary_key=True)
|
|
|
email = db.Column(db.String(120), unique=True, nullable=False)
|
|
|
password = db.Column(db.String(128), nullable=False)
|
|
|
role = db.Column(db.String(20), default="viewer")
|
|
|
created_at = db.Column(db.DateTime, default=datetime.utcnow)
|
|
|
updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
|
|
|
|
|
|
def __repr__(self):
|
|
|
return f'<User {self.email}>'
|
|
|
|
|
|
def set_password(self, password):
|
|
|
self.password = generate_password_hash(password)
|
|
|
|
|
|
def check_password(self, password):
|
|
|
return check_password_hash(self.password, password)
|
|
|
|
|
|
class Ad(db.Model):
|
|
|
id = db.Column(db.String(36), primary_key=True)
|
|
|
content = db.Column(db.Text)
|
|
|
sentiment = db.Column(db.JSON)
|
|
|
ad_metadata = db.Column(db.JSON)
|
|
|
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
|
|
|
versions = db.relationship('AdVersion', backref='ad')
|
|
|
|
|
|
class AdVersion(db.Model):
|
|
|
id = db.Column(db.Integer, primary_key=True)
|
|
|
ad_id = db.Column(db.String(36), db.ForeignKey('ad.id'))
|
|
|
content = db.Column(db.Text)
|
|
|
timestamp = db.Column(db.DateTime, default=datetime.utcnow) |
