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