class EmailSignUp(db.Model):
id = db.Column(db.Integer, primary_key=True)
full_name = db.Column(db.String(120), nullable=True)
email = db.Column(db.String(120), unique=True, nullable=False)
def save(self, commit=True):
if commit:
instance = self
if not instance.id:
db.session.add(instance)
try:
db.session.commit()
except Exception as e:
print("Exception occured\n", e, '\n')
db.session.rollback()
return False
return True
return False
def delete(self, commit=True):
if self.id:
db.session.delete(self)
try:
db.session.commit()
except Exception as e:
print("Exception occured\n", e, '\n')
db.session.rollback()
return False
return True
return False
class Message(db.Model):
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.String(1024), nullable=False)
details = db.Column(db.String(1024), nullable=False)
def __init__(self, text, tags, details):
self.text = text.strip()
self.details = details.strip()
self.tags = [
Tag(text=tag.strip()) for tag in tags.split(',')
]
class EmailSignup(db.Model):
id = db.Column(db.Integer, primary_key=True) # primary_key
full_name = db.Column(db.String(120), nullable=True)
email = db.Column(db.String(120), unique=True, nullable=False)
def save(self, commit=True):
# create and update
if commit:
instance = self
if not instance.id:
db.session.add(instance)
try:
db.session.commit()
except Exception as e:
print("Exception occured\n", e, '\n')
db.session.rollback()
return False
return True
return False
def delete(self, commit=True):
# delete
if self.id:
db.session.delete(self)
try:
db.session.commit()
except Exception as e:
print("Exception occured\n", e, '\n')
db.session.rollback()
return False
return True
return False
# id, full_name, email
# 1, <>, <email>
# 2, justin, [email protected]
class Video(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(255), nullable=True)
link = db.Column(db.String(255), nullable=True)
thumbanil = db.Column(db.String(20),
nullable=False,
default='default_thumb.jpg')
def save(self, commit=True):
if commit:
instance = self
if not instance.id:
db.session.add(instance)
try:
db.session.commit()
except Exception as e:
print("Exception occured\n", e, '\n')
db.session.rollback()
return False
return True
return False
def delete(self, commit=True):
if self.id:
db.session.delete(self)
try:
db.session.commit()
except Exception as e:
print("Exception occured\n", e, '\n')
db.session.rollback()
return False
return True
return False
# admin.add_view(ModelView(Video, db.session))
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
class User (db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
login = db.Column(db.String(128), nullable=False, unique=True)
password = db.Column(db.String(255), nullable=False)
class Tag(db.Model):
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.String(32), nullable=False)
message_id = db.Column(db.Integer, db.ForeignKey('message.id'), nullable=False)
message = db.relationship('Message', backref=db.backref('tags', lazy=True))