class CourseCollege(db.Model): __tablename__ = "curso_faculdade" id_course_college = db.Column('id_curso_faculdade', db.Integer, primary_key=True) id_college = db.Column('id_faculdade', db.Integer, nullable=False) id_course = db.Column('id_curso', db.Integer, nullable=False) semesters = db.Column('semestres', db.Integer, nullable=False) period = db.Column('turno', db.String(10), nullable=False) modality = db.Column('modalidade', db.String(10), nullable=False) def __init__(self, kwargs): self.id_course_college = kwargs.get('id_course_college') self.id_course = kwargs.get('id_course') self.id_college = kwargs.get('id_college') self.semesters = kwargs.get('semesters') self.period = kwargs.get('period') self.modality = kwargs.get('modality') def to_json(self) -> dict: return { 'id': self.id_course_college, 'semesters': self.semesters, 'period': self.period, 'modality': self.modality }
class College(db.Model): __tablename__ = "faculdade" id = db.Column('id', db.Integer, primary_key=True) name = db.Column('nome', db.String(70), nullable=False) city = db.Column('cidade', db.String(50), nullable=False) def __init__(self, **kwargs) -> None: self.id = kwargs.get('id') self.name = kwargs.get('name') self.city = kwargs.get('city') def to_json(self) -> dict: return {'id': self.id, 'name': self.name, 'city': self.city}
class Student(db.Model): __tablename__ = "aluno" id = db.Column('id_aluno', db.Integer, primary_key=True) id_sponsor = db.Column('id_padrinho', db.Integer) id_course_college = db.Column('id_curso_faculdade', db.Integer) description = db.Column('descricao', db.String(200)) id_person = db.Column('id_pessoa', db.Integer, nullable=False) def __init__(self, **kwargs) -> None: self.id = kwargs.get('id') self.id_sponsor = kwargs.get('id_sponsor') self.description = kwargs.get('description') self.id_person = kwargs.get('id_person') def set_id_person(self, id_person: int) -> None: self.id_person = id_person def to_json(self) -> dict: return { 'id': self.id, 'sponsor_id': self.id_sponsor, 'course_college_id': self.id_course_college, 'description': self.description } def basic_to_json(self) -> dict: return { 'id': self.id, 'description': self.description }
class Course(db.Model): __tablename__ = "curso" id = db.Column('id', db.Integer, primary_key=True) name = db.Column('nome', db.String(75), nullable=False) id_category = db.Column('id_categoria', db.Integer, nullable=False) def __init__(self, **kwargs) -> None: self.id = kwargs.get('id') self.name = kwargs.get('name') self.id_category = kwargs.get('id_category') def basic_to_json(self) -> dict: return {"course": self.name}
class Category(db.Model): __tablename__ = "categoria" id = db.Column('id', db.Integer, primary_key=True) name = db.Column('nome', db.String(50), nullable=False) def __init__(self, **kwargs) -> None: self.id = kwargs.get('id') self.name = kwargs.get('name') def to_json(self) -> dict: return {'id': self.id, 'name': self.name} def basic_to_json(self) -> dict: return {"category": self.name}
class Sponsor(db.Model): __tablename__ = "padrinho" id = db.Column('id_padrinho', db.Integer, primary_key=True) reasons = db.Column('motivos', db.String(200), nullable=False) id_person = db.Column('id_pessoa', db.Integer, nullable=False) def __init__(self, **kwargs) -> None: self.id = kwargs.get('id') self.reasons = kwargs.get('reasons') self.id_person = kwargs.get('id_person') def to_json(self) -> dict: return { 'id': self.id, 'reasons': self.reasons }
class Person(db.Model): __tablename__ = "pessoa" id = db.Column('id_pessoa', db.Integer, primary_key=True) name = db.Column('nome', db.String(50), nullable=False) email = db.Column('email', db.String(50), nullable=False) password = db.Column('senha', db.String(30), nullable=False) phone = db.Column('tel_celular', db.String(11), nullable=False) income = db.Column('renda_mensal', db.Float, nullable=False) document = db.Column('doc_cpf_ou_cnpj', db.String(14), nullable=False) person_type = db.Column('tipo_pessoa', db.String(8), nullable=False) birth_date = db.Column('data_nascimento', db.String(10), nullable=False) def __init__(self, **kwargs) -> None: self.id = kwargs.get('id') self.name = kwargs.get('name') self.email = kwargs.get('email') self.password = kwargs.get('password') self.phone = kwargs.get('phone') self.income = kwargs.get('income') self.document = kwargs.get('document') self.person_type = kwargs.get('person_type') self.birth_date = kwargs.get('birth_date') def to_json(self) -> dict: return { 'name': self.name, 'email': self.email, 'phone': self.phone, 'income': self.income, 'document': self.document, 'person_type': self.person_type, 'birth_date': f"{self.birth_date[0:2]}/{self.birth_date[3:5]}/{self.birth_date[6:]}" } def basic_to_json(self) -> dict: return { 'name': self.name, 'email': self.email, 'phone': self.phone, 'income': self.income, 'birth_date': f"{self.birth_date[0:2]}/{self.birth_date[3:5]}/{self.birth_date[6:]}" }