class Refill(db.Model):
__tablename__ = 'refill'
id = db.Column('id', Integer, primary_key=True)
dispenser_id = db.Column('dispenser_id',
ForeignKey("dispenser.id"),
nullable=False)
product_id = db.Column('product_id',
ForeignKey("product.id"),
nullable=False)
timestamp = db.Column('timestamp', DateTime())
class User(db.Model):
__tablename__ = 'user'
uid = db.Column('uid', Integer, primary_key=True)
login = db.Column('login', String(255))
password = db.Column('password', String(100))
first_name = db.Column('first_name', String(100))
last_name = db.Column('last_name', String(100))
postcode = db.Column('postcode', String(100))
created_on = db.Column('created_on', DateTime())
class UserTransaction(db.Model):
__tablename__ = 'user_transaction'
id = db.Column('id', Integer, primary_key=True)
user_uid = db.Column('user_uid', ForeignKey("user.uid"), nullable=False)
dispenser_id = db.Column('dispenser_id',
ForeignKey("dispenser.id"),
nullable=False)
product_id = db.Column('product_id',
ForeignKey("product.id"),
nullable=False)
weight = db.Column('weight', Integer())
cost = db.Column('cost', Float())
timestamp = db.Column('timestamp', DateTime())
class DispenserTransactionEvent(db.Model):
__tablename__ = 'dispenser_transaction_event'
id = db.Column('id', Integer, primary_key=True)
user_uid = db.Column('user_uid', ForeignKey("user.uid"), nullable=False)
dispenser_id = db.Column('dispenser_id',
ForeignKey("dispenser.id"),
nullable=False)
event = db.Column('event', Integer())
weight = db.Column('weight', Integer())
timestamp = db.Column('timestamp', DateTime())
class Product(db.Model):
__tablename__ = 'product'
id = db.Column('id', Integer, primary_key=True)
name = db.Column('name', String(500))
allergens = db.Column('allergens', String(1000))
description = db.Column('description', String(1000))
density = db.Column('density', Float()) # grams/cm**3
price_per_gram = db.Column('price_per_gram', Float())
def to_dict(self):
return {
'id': self.id,
'name': self.name,
'allergens': self.allergens,
'description': self.description,
'density': self.density,
'price_per_gram': self.price_per_gram
}
class Dispenser(db.Model):
__tablename__ = 'dispenser'
id = db.Column('id', Integer, primary_key=True)
product_id = db.Column('product_id',
ForeignKey("product.id"),
nullable=False)