class PandS(db.Model):
__tablename__ = 'pands'
id = db.Column(db.Integer, primary_key=True)
image = db.Column(db.String(128), nullable=False)
name = db.Column(db.String(64), nullable=False)
description = db.Column(db.Text, nullable=False)
class History(db.Model):
__tablename__ = 'history'
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.Text, nullable=False)
def __init__(self, text):
self.text = text
class Customer(db.Model):
__tablename__ = 'customer'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), nullable=False)
street = db.Column(db.String(128))
city = db.Column(db.String(128))
state = db.Column(db.String(32))
zipcode = db.Column(db.Integer)
phone = db.Column(db.String(11))
revenue = db.Column(db.Integer)
custclass = db.Column(db.String(32), nullable=False)
notes = db.Column(db.Text)
class FollowUp(db.Model):
__tablename__ = 'followup'
id = db.Column(db.Integer, primary_key=True)
salesman = db.Column(db.String(64), nullable=False)
jobname = db.Column(db.String(128))
job_address = db.Column(db.String(128))
amount = db.Column(db.Integer, nullable=False)
date = db.Column(db.DateTime,
nullable=False,
default=datetime.date.today())
nextfollowup = db.Column(db.DateTime,
nullable=False,
default=datetime.date.today() +
datetime.timedelta(days=7))
notes = db.Column(db.Text)
stoptracking = db.Column(db.Boolean, nullable=False, default=False)
closed = db.Column(db.String(64))
class User(db.Model, UserMixin):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(30))
access_level = db.Column(db.String(15))
email = db.Column(db.String(64), unique=True, index=True)
password_hash = db.Column(db.String(128))
def __init__(self, name, email, password, access_level):
self.name = name
self.access_level = access_level
self.email = email
self.password_hash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password_hash, password)
def __repr__(self):
return f'Email {self.email} and access level is {self.access_level}'
class Quote(db.Model):
__tablename__ = 'quotes'
id = db.Column(db.Integer, primary_key=True)
quote_num = db.Column(db.Integer)
revision_num = db.Column(db.Integer)
job_name = db.Column(db.String(128))
job_address = db.Column(db.String(128))
date = db.Column(db.DateTime,
nullable=False,
default=datetime.date.today())
def __init__(self, quote_num, revision_num, job_name, job_address):
self.quote_num = quote_num
self.revision_num = revision_num
self.job_name = job_name
self.job_address = job_address