import SQAlchemy

class Users(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name_first = db.Column(db.String(20), nullable=False)
    name_last = db.Column(db.String(20), nullable=False)

    def __repr__(self):
        return f"<User {self.name_first} {self.name_last}>"


class Projects(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(20), nullable=False)
    name_full = db.Column(db.String(20), nullable=False)
    nickname = db.Column(db.String(20), nullable=False)
    city = db.Column(db.String(20), nullable=False)

    def __repr__(self):
        return f"<Project {self.name}>"


class Modules(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(20), unique=True, nullable=False)
    description = db.Column(db.String(50), nullable=False)

    def __repr__(self):
        return f"<Module {self.name}>"


class Doobie:
    def __init__(self, name, prices, quantity):
        self.name = name
        self.prices = prices
        self.quantity = quantity

    def __repr__(self):
        return self.name