class Users(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(250), nullable=False, unique=True)
password = db.Column(db.String(250), nullable=False)
name = db.Column(db.String(250), nullable=True, unique=True)
createddate = db.Column(db.DateTime,
nullable=True,
default=datetime.utcnow)
createdby = db.Column(db.String(250), nullable=False)
updateddate = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
updatedby = db.Column(db.String(250), nullable=False)
def __init__(
self,
email,
password,
name,
createdby,
updatedby,
):
self.email = email
self.password = password
self.name = name
self.createdby = createdby
self.updatedby = updatedby
class Users(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(250), nullable=False, unique=True)
password = db.Column(db.String(250), nullable=False)
name = db.Column(db.String(250), nullable=False)
active = db.Column(db.Integer, nullable=False)
creation_time = db.Column(db.TIMESTAMP,
server_default=db.func.current_timestamp(),
nullable=False)
role = db.Column(db.String(250), db.ForeignKey('roles.name'))
role_relation = db.relationship('Roles', backref="users")
def __init__(
self,
email,
password,
name,
active,
role,
):
self.email = email
self.password = password
self.name = name
self.active = active
self.role = role
class Posts(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(250), nullable=False)
title = db.Column(db.Text, nullable=False)
slug = db.Column(db.String(250), nullable=False)
date = db.Column(
db.TIMESTAMP, server_default=db.func.current_timestamp(), nullable=False)
date_gmt = db.Column(
db.TIMESTAMP, server_default=db.func.current_timestamp(), nullable=False)
content = db.Column(db.Text, nullable=False)
excerpt = db.Column(db.Text, nullable=False)
status = db.Column(db.String(250), server_default='publish', nullable=False)
modified = db.Column(
db.TIMESTAMP, server_default=db.func.current_timestamp(), nullable=False)
modified_gmt = db.Column(
db.TIMESTAMP, server_default=db.func.current_timestamp(), nullable=False)
type = db.Column(db.String(250), server_default='post', nullable=False)
parent = db.Column(db.Integer, nullable=False)
#featured Image Path
path = db.Column(db.Text)
terms = db.relationship('Terms', secondary=term_relationships, backref='posts' )
comments = db.relationship('Comments', backref="post", cascade="all, delete-orphan" , lazy='dynamic')
def __init__(self, author, title, slug, content, excerpt, status, type, parent, path):
self.author = author
self.title = title
self.slug = slug
self.content = content
self.excerpt = excerpt
self.status = status
self.type = type
self.parent = parent
self.path = path
class Faces(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(250), nullable=False)
company = db.Column(db.String(250), nullable=False)
document = db.Column(db.String(250), nullable=False)
count = db.Column(db.Integer, nullable=False)
lastSeen = db.Column(db.TIMESTAMP,
server_default=db.func.current_timestamp(),
nullable=False)
picture = db.Column(db.Text, nullable=False)
def __init__(
self,
name,
company,
document,
count,
lastSeen,
picture,
):
self.name = name
self.company = company
self.document = document
self.count = count
self.lastSeen = lastSeen
self.picture = picture
class Comments(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
post_id = db.Column(db.Integer, db.ForeignKey('posts.id'), nullable=False)
author_name = db.Column(db.String(250), nullable=False)
author_email = db.Column(db.String(250), nullable=False)
author_url = db.Column(db.Text)
created_on = db.Column(
db.TIMESTAMP, server_default=db.func.current_timestamp(), nullable=False)
content = db.Column(db.Text, nullable=False)
karma = db.Column(db.Integer, default = 0 )
approved = db.Column(db.String(250), nullable=False)
agent = db.Column(db.Text)
type = db.Column(db.String(250))
parent = db.Column(db.Integer, default = 0, nullable=False)
def __init__(self, post_id, author_name, author_email, author_url, created_on, content, karma, approved, agent, type, parent, ):
self.post_id = post_id
self.author_name = author_name
self.author_email = author_email
self.author_url = author_url
self.created_on = created_on
self.content = content
self.karma = karma
self.approved = approved
self.agent = agent
self.type = type
self.parent = parent
class Surveys(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(250), nullable=False)
description = db.Column(db.String(250), nullable=False)
active = db.Column(db.Integer, nullable=False)
creation_time = db.Column(db.TIMESTAMP,
server_default=db.func.current_timestamp())
modification_time = db.Column(db.TIMESTAMP,
server_default=db.func.current_timestamp())
# Relationships
questions = db.relationship('Questions', backref='surveys', lazy='dynamic')
def __init__(
self,
title,
description,
active,
creation_time,
modification_time,
question,
):
self.title = title
self.description = description
self.active = active
self.creation_time = creation_time
self.modification_time = modification_time
self.question = question
class Students(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
studentname = db.Column(db.String(250), nullable=False)
degree = db.Column(db.String(250), nullable=False)
major = db.Column(db.String(250), nullable=False)
courses = db.relationship('Courses', secondary=student_course, backref='students')
def __init__(self, studentname, degree, major):
self.studentname = studentname
self.degree = degree
self.major = major
class Roles(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(250), nullable=True, unique=True)
description = db.Column(db.String(250))
def __init__(
self,
name,
):
self.name = name
class UserHasImage(db.Model, CRUD_MixIn):
#id = db.Column(db.Integer, primary_key=True)
users_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False, primary_key=True)
images_id = db.Column(db.Integer, db.ForeignKey('images.id'), nullable=False, primary_key=True)
progress = db.Column(db.Integer, nullable=True)
n_segments = db.Column(db.Integer, nullable=True)
crop_orig_filepath = db.Column(db.String(250), nullable=True, unique=True)
crop_overlay_filepath = db.Column(db.String(250), nullable=True, unique=True)
crop_segm_filepath = db.Column(db.String(250), nullable=True, unique=True)
def __init__(self, fullsize_orig_filepath):
self.progress = 0
class Posts(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
tittle = db.Column(db.String(250), nullable=False)
body = db.Column(db.Text, nullable=False)
author = db.Column(db.String(250), nullable=False)
creation_date = db.Column(db.Date, nullable=False)
published = db.Column(db.Integer, nullable=False)
def __init__(self, tittle, body, author, creation_date, published, ):
self.tittle = tittle
self.body = body
self.author = author
self.creation_date = creation_date
self.published = published
class Comments(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(250), nullable=False)
body = db.Column(db.Text, nullable=False)
author_url = db.Column(db.String(250), nullable=False)
created_on = db.Column(db.Date, nullable=False)
approved = db.Column(db.Integer, nullable=False)
def __init__(self, author, body, author_url, created_on, approved, ):
self.author = author
self.body = body
self.author_url = author_url
self.created_on = created_on
self.approved = approved
class Gallery(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(250), nullable=False)
tags = db.Column(db.Text, nullable=False)
path = db.Column(db.Text, nullable=False)
creation_date = db.Column(db.TIMESTAMP,
server_default=db.func.current_timestamp(),
nullable=False)
category = db.Column(db.String(250), nullable=False)
def __init__(self, name, tags, path, category):
self.name = name
self.tags = tags
self.path = path
self.category = category
class Authors(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(250), nullable=False)
profile = db.Column(db.Text, nullable=False)
url = db.Column(db.String(250), nullable=False)
def __init__(
self,
name,
profile,
url,
):
self.name = name
self.profile = profile
self.url = url
class Images(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
fullsize_orig_filepath = db.Column(db.String(250),
nullable=False,
unique=True)
def __init__(self, fullsize_orig_filepath):
self.fullsize_orig_filepath = fullsize_orig_filepath
class Commands(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(250), nullable=False)
task_id = db.Column(db.Text)
status = db.Column(db.String(250))
result = db.Column(db.Text)
def __init__(
self,
name,
task_id,
status,
result,
):
self.name = name
self.task_id = task_id
self.status = status
self.result = result
class Courses(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
coursename = db.Column(db.String(250), nullable=False)
def __init__(
self,
coursename,
):
self.coursename = coursename
class Users(db.Model, CRUD):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(250), unique=True, nullable=False)
password = db.Column(db.String(250), nullable=False)
name = db.Column(db.String(250), nullable=False)
is_active = db.Column(db.Boolean, server_default="false", nullable=False)
created_at = db.Column(db.TIMESTAMP,
server_default=db.func.current_timestamp(),
nullable=False)
modified_at = db.Column(db.TIMESTAMP,
server_default=db.func.current_timestamp(),
nullable=False)
def __init__(self, email, password, name, is_active):
self.email = email
self.password = password
self.name = name
self.is_active = is_active
class Users(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(250), nullable=False)
email = db.Column(db.String(250), nullable=False)
address = db.Column(db.Text, nullable=False)
website = db.Column(db.String(250), nullable=False)
creation_date = db.Column(
db.TIMESTAMP, server_default=db.func.current_timestamp(), nullable=False)
is_active = db.Column(db.Boolean, nullable=False)
mobile = db.Column(db.Integer, nullable=False)
Birthday = db.Column(db.Date, nullable=False)
def __init__(self, name, email, address, website, is_active, mobile, Birthday, ):
self.name = name
self.email = email
self.address = address
self.website = website
self.is_active = is_active
self.mobile = mobile
self.Birthday = Birthday
class Terms(db.Model, CRUD_MixIn):
__table_args__ = (db.UniqueConstraint('name', 'taxonomy'), )
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(250), nullable=False)
slug = db.Column(db.String(250), nullable=False)
description = db.Column(db.Text)
taxonomy = db.Column(db.String(250), nullable=False)
parent = db.Column(db.Integer, server_default=None, nullable=False)
def __init__(
self,
name,
slug,
description,
taxonomy,
parent,
):
self.name = name
self.slug = slug
self.description = description
self.taxonomy = taxonomy
self.parent = parent
class Responses(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
question_id = db.Column(db.Integer(),
db.ForeignKey('questions.id', ondelete='CASCADE'))
user_id = db.Column(db.Integer(),
db.ForeignKey('users.id', ondelete='CASCADE'))
answer = db.Column(db.String(200))
modification_time = db.Column(db.TIMESTAMP,
server_default=db.func.current_timestamp())
def __init__(
self,
user,
answer,
question,
modification_time,
):
self.user = user
self.answer = answer
self.question = question
self.modification_time = modification_time
class Questions(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(250), nullable=False)
survey_id = db.Column(db.Integer(),
db.ForeignKey('surveys.id', ondelete='CASCADE'))
order = db.Column(db.Integer())
creation_time = db.Column(db.TIMESTAMP,
server_default=db.func.current_timestamp())
updated = db.Column(db.DateTime,
default=db.func.current_timestamp(),
onupdate=db.func.current_timestamp())
# Relationships
responses = db.relationship('Responses',
backref='questions',
lazy='dynamic')
def __init__(
self,
name,
):
self.name = name
class Users(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(250), nullable=False, unique=True)
password = db.Column(db.String(250), nullable=False)
name = db.Column(db.String(250), nullable=False)
active = db.Column(db.Integer, nullable=False)
classified = db.Column(db.Integer, nullable=False)
in_queue = db.Column(db.Integer, nullable=False)
firstTime = db.Column(db.Integer, nullable=False)
activeLabels = db.Column(db.Integer, nullable=False)
label1 = db.Column(db.String(250), nullable=False)
label2 = db.Column(db.String(250), nullable=False)
label3 = db.Column(db.String(250), nullable=False)
label4 = db.Column(db.String(250), nullable=False)
label5 = db.Column(db.String(250), nullable=False)
label6 = db.Column(db.String(250), nullable=False)
label7 = db.Column(db.String(250), nullable=False)
label8 = db.Column(db.String(250), nullable=False)
label9 = db.Column(db.String(250), nullable=False)
label10 = db.Column(db.String(250), nullable=False)
color1 = db.Column(db.String(250), nullable=False)
color2 = db.Column(db.String(250), nullable=False)
color3 = db.Column(db.String(250), nullable=False)
color4 = db.Column(db.String(250), nullable=False)
color5 = db.Column(db.String(250), nullable=False)
color6 = db.Column(db.String(250), nullable=False)
color7 = db.Column(db.String(250), nullable=False)
color8 = db.Column(db.String(250), nullable=False)
color9 = db.Column(db.String(250), nullable=False)
color10 = db.Column(db.String(250), nullable=False)
creation_time = db.Column(db.TIMESTAMP,
server_default=db.func.current_timestamp(),
nullable=False)
modification_time = db.Column(db.TIMESTAMP)
role = db.Column(db.String(250))
# db.ForeignKey('roles.name')
# many users to one role relationship
# role_relation = db.relationship('Roles', backref="users")
def __init__(self, email, password, name, active, role, classified,
in_queue):
self.email = email
self.password = password
self.name = name
self.active = active
self.role = role
self.classified = classified
self.in_queue = in_queue
