class StoreModel(db.Model): __tablename__ = 'stores' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(90)) items = db.relationship('ItemModel', lazy='dynamic') def __init__(self, name): self.name = name def json(self): #str para o json return { 'id': self.id, 'name': self.name, 'items': [item.json() for item in self.items.all()] } @classmethod def find_by_name(cls, name): #SELECT * FROM items WHERE name=name cls=ItemModel return cls.query.filter_by(name=name, ).first() @classmethod def find_all(cls): return cls.query.all() def save_to_db(self): #funciona como insert/update db.session.add(self) db.session.commit() def delete_from_db(self): db.session.delete(self) db.session.commit()
class ItemModel(db.Model): __tablename__ = 'items' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(90)) price = db.Column(db.Float(precision=2)) store_id = db.Column(db.Integer, db.ForeignKey('stores.id')) store = db.relationship('StoreModel') def __init__(self, name, price, store_id): self.name = name self.price = price self.store_id = store_id def json(self): return {'name': self.name, 'price': self.price} def save_to_db(self): db.session.add(self) db.session.commit() def delete_from_db(self): db.session.delete(self) db.session.commit() @classmethod def find_by_name(cls, name): return cls.query.filter_by(name=name, ).first()
class UserModel( db.Model ): #continua sendo User porem UserModel fica mais inteligivel/compreensivo __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(30)) password = db.Column(db.String(80)) def __init__(self, username, password): self.username = username self.password = password def json(self): return {'id': self.id, 'usename': self.username} def delete_from_db(self): db.session.delete(self) db.session.commit() def save_to_db(self): #funciona como insert/update db.session.add(self) db.session.commit() @classmethod def find_by_username(cls, username): return cls.query.filter_by(username=username).first() @classmethod def find_by_id(cls, _id): return cls.query.filter_by(id=_id).first()
class UserModel(db.Model): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(30)) password = db.Column(db.String(80)) def __init__(self, username, password): self.username = username self.password = password def save_to_db(self): #funciona como insert/update db.session.add(self) db.session.commit() @classmethod def find_by_username(cls, username): return cls.query.filter_by(username=username).first() @classmethod def find_by_id(cls, _id): return cls.query.filter_by(id=_id).first()
class ItemModel(db.Model): __tablename__ = 'items' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(90)) price = db.Column(db.Float(precision=2)) store_id = db.Column(db.Integer, db.ForeignKey('stores.id')) store = db.relationship('StoreModel') def __init__(self, name, price, store_id): self.name = name self.price = price self.store_id = store_id def save_to_db(self): #funciona como insert/update db.session.add(self) db.session.commit() def delete_from_db(self): db.session.delete(self) db.session.commit() def json(self): #str para o json return { 'id': self.id, 'name': self.name, 'price': self.price, 'store_id': self.store_id } @classmethod def find_by_name(cls, name): #SELECT * FROM items WHERE name=name cls=ItemModel return cls.query.filter_by(name=name, ).first() @classmethod def find_all(cls): return cls.query.all()