database_model.py

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

from app import app

db = SQLAlchemy()
app.app_context().push()


class User(db.Model):
    """A user"""

    __tablename__ = "users"

    id = db.Column(db.Integer, autoincrement=True, primary_key=True)
    name = db.Column(db.String(25), nullable=False)
    phone = db.Column(db.String(25), nullable=False)
    email = db.Column(db.String(50), unique=True, nullable=False)
    resume_order = db.Column(db.String(30), nullable=False)

    def __repr__(self):
        return f"<User id={self.id} fname={self.name} email={self.email} resume_order={self.resume_order}>"


class Skill(db.Model):
    """A skill"""

    __tablename__ = "skills"

    id = db.Column(db.Integer, autoincrement=True, primary_key=True)
    name = db.Column(db.String(25), nullable=False)
    proficiency = db.Column(db.String(25), unique=False, nullable=False)
    logo = db.Column(db.String(30), nullable=True)

    def __repr__(self):
        return f"<Skill id={self.id} skill name={self.name} proficiency={self.proficiency}>"


class Experience(db.Model):
    """A experience"""

    __tablename__ = "experiences"

    id = db.Column(db.Integer, autoincrement=True, primary_key=True)
    title = db.Column(db.String(25), nullable=False)
    company = db.Column(db.String(50), unique=False, nullable=False)
    start_date = db.Column(db.String(30), nullable=False)
    end_date = db.Column(db.String(30), nullable=False)
    description = db.Column(db.String(500), nullable=False)
    logo = db.Column(db.String(30), nullable=True)

    def __repr__(self):
        return f"<Experience id={self.id} title={self.title}, company={self.company}>"


class Education(db.Model):
    """A education"""

    __tablename__ = "educations"

    id = db.Column(db.Integer, autoincrement=True, primary_key=True)
    course = db.Column(db.String(25), nullable=False)
    school = db.Column(db.String(50), unique=False, nullable=False)
    start_date = db.Column(db.String(30), nullable=False)
    end_date = db.Column(db.String(30), nullable=False)
    grade = db.Column(db.String(25), nullable=False)
    logo = db.Column(db.String(30), nullable=True)

    def __repr__(self):
        return f"Education id={self.id} course={self.course} school={self.school}>"


def connect_to_db(app, db_name):
    """Connect flask service to the database."""

    app.config["SQLALCHEMY_DATABASE_URI"] = f"sqlite:///{db_name}"
    app.config["SQLALCHEMY_ECHO"] = True
    app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = False

    db.app = app
    db.init_app(app)
    print("Connected to the db!")


if __name__ == "__main__":  # check if we run the file or import it
    connect_to_db(app, "resume")  # conncet the flask app to database