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)
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
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 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 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 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 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 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 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.DateTime,
default=datetime.datetime.utcnow,
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 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 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 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 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 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 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 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 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 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 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 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
from marshmallow_jsonapi import Schema, fields
from marshmallow import validate
from app.basemodels import db, CRUD_MixIn
from app.courses.models import Courses
student_course=db.Table('student_course',
db.Column('studentid', db.Integer,db.ForeignKey('students.id'), nullable=False),
db.Column('courseid',db.Integer,db.ForeignKey('courses.id'),nullable=False),
db.PrimaryKeyConstraint('studentid', 'courseid') )
class StudentCourse():
def __init__(self,courseid,studentid):
self.courseid=courseid
self.studentid=studentid
db.mapper(StudentCourse, student_course)
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
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 {Resources}(db.Model, CRUD_MixIn):
id = db.Column(db.Integer, primary_key=True)
{db_rows}
def __init__(self, {init_args}):
{init_self_vars}
class Video(db.Model, CRUD_MixIn):
uuid = db.Column(db.Integer, primary_key=True)
status = db.Column(db.Integer, nullable=False)
video_id = db.Column(db.Text, nullable=False)
timestamp_creation = db.Column(db.DateTime, nullable=False)
timestamp_publish = db.Column(db.DateTime, nullable=False)
url = db.Column(db.Text, nullable=False)
site = db.Column(db.Text, nullable=False)
title = db.Column(db.Text, nullable=False)
description = db.Column(db.Text, nullable=False)
thumbnail_url = db.Column(db.Text, nullable=False)
description_snippet = db.Column(db.Text, nullable=False)
def __init__(
self,
status,
video_id,
url,
site,
title,
description,
thumbnail_url,
timestamp_creation,
timestamp_publish,
description_snippet,
):
self.status = status
self.video_id = video_id
self.url = url
self.site = site
self.title = title
self.description = description
self.thumbnail_url = thumbnail_url
self.timestamp_creation = timestamp_creation
self.timestamp_publish = timestamp_publish
self.description_snippet = description_snippet
from marshmallow_jsonapi import Schema, fields
from marshmallow import validate
from app.basemodels import db, CRUD_MixIn
from app.terms.models import TermsSchema
# Many to Many Relationships with Posts and terms
term_relationships=db.Table('term_relationships',
db.Column('post_id', db.Integer,db.ForeignKey('posts.id'), nullable=False),
db.Column('term_id',db.Integer,db.ForeignKey('terms.id'),nullable=False),
db.PrimaryKeyConstraint('post_id', 'term_id')
)
class TermRelationships():
def __init__(self,post_id,term_id):
self.post_id=post_id
self.term_id=term_id
db.mapper(TermRelationships, term_relationships)
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)
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 News(db.Model, CRUD_MixIn):
uuid = db.Column(db.Integer, primary_key=True)
status = db.Column(db.Integer, nullable=False)
news_id = db.Column(db.Text, nullable=False)
timestamp_creation = db.Column(db.DateTime, nullable=False)
timestamp_publish = db.Column(db.DateTime, nullable=False)
title = db.Column(db.Text, nullable=False)
news_type = db.Column(db.Text, nullable=False)
site = db.Column(db.Text, nullable=False)
lang = db.Column(db.Text, nullable=False)
excerpt = db.Column(db.Text, nullable=False)
news_category = db.Column(db.Text, nullable=False)
url = db.Column(db.Text, nullable=False)
image_url = db.Column(db.Text, nullable=False)
body = db.Column(db.Text, nullable=False)
body_markdown = db.Column(db.Text, nullable=False)
def __init__(
self,
status,
news_id,
timestamp_creation,
timestamp_publish,
title,
news_type,
site,
lang,
excerpt,
news_category,
url,
image_url,
body,
body_markdown,
):
self.status = status
self.news_id = news_id
self.timestamp_creation = timestamp_creation
self.timestamp_publish = timestamp_publish
self.title = title
self.news_type = news_type
self.site = site
self.lang = lang
self.excerpt = excerpt
self.news_category = news_category
self.url = url
self.image_url = image_url
self.body = body
self.body_markdown = body_markdown
