class Appointments(db.Model): __tablename__ = 'appointments' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100)) date = db.Column(db.String(20)) time = db.Column(db.String(20)) active = db.Column(db.String(20))
class People(db.Model): __tablename__ = 'people' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100)) age = db.Column(db.Integer) birthday = db.Column(db.String(100)) about = db.Column(db.String(100)) social_media = db.Column(db.String(100))
class Products(db.Model): __tablename__ = 'products' barcode = db.Column(db.String(100), primary_key=True) price = db.Column(db.Float)# vat_price = db.Column(db.Float) selling_price = db.Column(db.Float) manufacturer = (db.Column(db.String(100), db.ForeignKey('manufacturers.name')))
class Users(UserMixin, db.Model): __tablename__ = 'users' id = db.Column(db.String(10), primary_key=True) name = db.Column(db.String(100)) password = db.Column(db.String(128)) admin_user = db.Column(db.Boolean, default=False) def set_hash(self, password): self.password = generate_password_hash(password, method="sha256") def check_hash(self, password): return check_password_hash(self.password, password)
class Product(db.Model): __tablename__ = 'product' barcode = db.Column(db.String(100), primary_key=True) price = db.Column(db.Float) name = db.Column(db.String(100)) description = db.Column(db.String(300)) category = db.Column(db.String(50)) category_id = db.Column(db.Integer) stock = db.Column(db.Integer) discontinued = db.Column(db.Boolean) vat_price = db.Column(db.Float) selling_price = db.Column(db.Float) manufacturer = (db.Column(db.Integer(), db.ForeignKey('manufacturer.id'), nullable=False))
class People(db.Model): __tablename__ = 'people' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100)) phone = db.Column(db.Integer) mobile = db.Column(db.Integer) email = db.Column(db.String(100)) facebook = db.Column(db.String(128)) twitter = db.Column(db.String(128)) linkedin = db.Column(db.String(128)) age = db.Column(db.Integer) birthday = db.Column(db.String(100)) notes = db.Column(db.String(100))
class Manufacturer(db.Model): __tablename__ = 'manufacturer' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100), unique=True) products = db.relationship( 'Product', backref='manufacturers', lazy=True, cascade="all, delete") def insert(self): """Save manufacturer to the database""" db.session.add(self) db.session.commit() def update(self): """Update manufacturer""" db.session.commit() def delete(self): """delete manufacturer""" db.session.delete(self) db.session.commit() @classmethod def manufacturer_exists(cls, name): return db.session.query(exists().where(cls.name == name)).scalar()
class Patients(db.Model): __tablename__ = 'patients' first_name = db.Column(db.String(100), primary_key=True) last_name = db.Column(db.String(100))
class Settings(db.Model): __tablename__ = 'settings' setting = db.Column(db.String(100), primary_key=True) value = db.Column(db.String(100))
class Manufacturers(db.Model): __tablename__ = 'manufacturers' name = db.Column(db.String(100), primary_key=True)