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