class Charge(db.Model):
__tablename__ = "charge"
charge_id = db.Column(db.Integer, primary_key=True)
# pl_id = db.Column(db.Integer, db.ForeignKey('parkinglot.id'))
pl_id = db.Column(db.Integer, nullable=False)
price_snapshot = db.Column(db.String(2500), nullable=False)
ch_active = db.Column(db.Boolean, default=False, nullable=False)
update_date = db.Column(db.DateTime, default=db.func.current_timestamp())
def __init__(self, pl_id, price_snapshot, ch_active):
self.pl_id = pl_id
self.price_snapshot = price_snapshot
self.ch_active = ch_active
class Users(db.Model):
__tablename__ = "user"
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(255), unique=True, nullable=False)
password = db.Column(db.String(255), nullable=False)
first_name = db.Column(db.String(255), nullable=False)
last_name = db.Column(db.String(255), nullable=False)
verified = db.Column(db.Boolean, default=False, nullable=False)
def __init__(self, email, password, first_name, last_name):
self.email = email
self.password = argon2.hash(password)
self.first_name = first_name
self.last_name = last_name
def authenticate(self, password):
return argon2.verify(password, self.password)
def change_password(self, old_password, new_password):
if not argon2.verify(old_password, self.password):
return False
self.password = argon2.hash(new_password)
self.save()
return True
class Utilization(db.Model):
__tablename__ = "utilization"
id = db.Column(db.Integer, primary_key=True)
pl_id = db.Column(db.Integer, db.ForeignKey('parkinglot.id'))
util_date = db.Column(db.Date, unique=True, nullable=False)
util_per_hour = db.Column(db.String(175), nullable=False)
rev_per_hour = db.Column(db.String(175), nullable=False)
avg_util = db.Column(db.Float, nullable=False)
total_rev = db.Column(db.Float, nullable=False)
def __init__(self, pl_id, util_date, util_per_hour, rev_per_hour, avg_util,
total_rev):
self.pl_id = pl_id
self.util_date = util_date
self.util_per_hour = util_per_hour
self.rev_per_hour = rev_per_hour
self.avg_util = avg_util
self.total_rev = total_rev
class ParkingLot(db.Model):
__tablename__ = "parkinglot"
id = db.Column(db.Integer, primary_key=True)
pl_name = db.Column(db.String(255), unique=True, nullable=False)
pl_address = db.Column(db.String(255), nullable=False)
pl_capacity = db.Column(db.Integer, nullable=False)
pl_default_price = db.Column(db.Float, nullable=False)
pl_active = db.Column(db.Boolean, default=False, nullable=False)
def __init__(self, pl_name, pl_address, pl_capacity, pl_default_price,
pl_active):
self.pl_name = pl_name
self.pl_address = pl_address
self.pl_capacity = pl_capacity
self.pl_default_price = pl_default_price
self.pl_active = pl_active
class Users(db.Model):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(255), unique=True, nullable=False)
password = db.Column(db.String(255), nullable=False)
first_name = db.Column(db.String(255), nullable=False)
last_name = db.Column(db.String(255), nullable=False)
authenticated = db.Column(db.Boolean, default=False)
def __init__(self, first_name, last_name, email, password):
self.first_name = first_name
self.last_name = last_name
self.email = email
self.password = argon2.hash(password)
def authenticate(self, password):
return argon2.verify(password, self.password)
def change_password(self, old_password, new_password):
if not argon2.verify(old_password, self.password):
return False
self.password = argon2.hash(new_password)
self.save()
return True
@property
def is_authenticated(self):
return self.authenticated
@property
def is_active(self):
return True
@property
def is_anonymous(self):
return False
def get_id(self):
return unicode(self.id)
def __repr__(self):
return '<User {0}>'.format(self.email)