class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) # primary keys are required by SQLAlchemy email = db.Column(db.String(100), unique=True) password = db.Column(db.String(100)) name = db.Column(db.String(1000)) def __repr__(self): return '<User %r>' % self.username
class Garage(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True, unique=True) name = db.Column(db.String(1000)) surname = db.Column(db.String(1000)) phone = db.Column(db.String(1000)) email = db.Column(db.String(1000)) passport = db.Column(db.String(1000)) user = db.Column(db.String(1000)) isBusy = db.Column(db.Boolean, unique=False, nullable=False, default=False) password = db.Column(db.String(1000)) isBlocked = db.Column(db.Integer) company = db.Column(db.String(1000)) def __repr__(self): return '<Garage %r>' % self.name @property def serialize(self): return { 'id': self.id, 'name': self.name, 'user': self.user, 'password': self.password }
class Apriser(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True, unique=True) name = db.Column(db.String(1000)) user = db.Column(db.String(1000), unique=True) password = db.Column(db.String(1000)) email = db.Column(db.String(100)) login = db.Column(db.String(1000)) mobile = db.Column(db.Integer) phone = db.Column(db.Integer) fax = db.Column(db.Integer) organization = db.Column(db.String(1000)) adres = db.Column(db.String(1000)) city = db.Column(db.String(1000)) passportid = db.Column(db.Integer) sim = db.Column(db.String(1000)) deviceid = db.Column(db.String(1000)) model = db.Column(db.String(1000)) importer = db.Column(db.String(1000)) code = db.Column(db.String(1000)) isBusy = db.Column(db.Boolean) isBlocked = db.Column(db.Integer) def __repr__(self): return '<Apriser %r>' % self.username @property def serialize(self): return { 'id': self.id, 'name': self.name, 'user': self.user, 'password': self.password, 'email': self.email, 'login': self.login, 'mobile': self.mobile, 'phone': self.phone, 'fax': self.fax, 'organization': self.organization, 'adres': self.adres, 'city': self.city, 'passportid': self.city }