class User(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) def __init__(self, id, name): self.id = id self.name = name #def insert_user_value_db(self): # print("++++++++id: " + str(self.id)) # print("++++++++name: " + str(self.name)) # conn = sqlite3.connect('user_db.sqlite') # cur = conn.cursor() # cur.execute('INSERT INTO experiments (id, name) values ("1", "JoelRest")') # conn.commit() # conn.close() @classmethod def all(cls): items = [] for i in db.session.query(cls).all(): items.append(i.to_dict()) print("======: " + str(items)) return items def to_dict(self): return dict((k, getattr(self, k)) for k in self.__table__.c.keys()) @classmethod def get(cls, key): return db.session.query(cls).get(key) def update(self): db.session.commit() return self
class AuthnRole(db.Model): id = db.Column(db.Integer, primary_key=True) role_name = db.Column(db.String(80)) def __init__(self, role_name): self.role_name = role_name def __repr__(self): return '<AuthnRole %r>' % self.role_name
class Item(db.Model): id = db.Column(db.Integer, primary_key=True) role_name = db.Column(db.String(80)) def __init__(self, role_name): self.role_name = role_name def __repr__(self): return '<Generic Item %r>' % self.role_name
class Category(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) def __init__(self, name): self.name = name def __repr__(self): return '<Category %r>' % self.name
class AuthzFeature(db.Model): id = db.Column(db.Integer, primary_key=True) feature_name = db.Column(db.String(80)) def __init__(self, feature_name): self.feature_name = feature_name def __repr__(self): return '<Feature %r>' % self.feature_name
class Pet(db.Model): id = db.Column(db.Integer, primary_key=True) pet_name = db.Column(db.String(50)) def __init__(self, name): self.pet_name = name def __repr__(self): return '<Pet %r>' % self.pet_name
class Context(db.Model): id = db.Column(db.Integer, primary_key=True) practice_name = db.Column(db.String(80)) location_name = db.Column(db.String(80)) def __init__(self, practice_name, location_name): self.practice_name = practice_name self.location_name = location_name def __repr__(self): return '<Context %r %s>' % self.practice_name, self.location_name
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True) email = db.Column(db.String(120), unique=True) def __init__(self, username, email): self.username = username self.email = email def __repr__(self): return '<User %r, Email %r>' % (self.username, self.email)
class User(db.Model): id = db.Column(db.Integer, primary_key=True) user_name = db.Column(db.String(80)) role_id = db.Column(db.Integer, db.ForeignKey('role.id')) role = db.relationship('Role', backref=db.backref('users', lazy='dynamic')) def __init__(self, user_name, role): self.user_name = user_name self.role = role def __repr__(self): return '<User %r %r>' % self.user_name, self.role.role_name
class Bid(db.Model): id = db.Column(db.Integer, primary_key=True) bid_amount = db.Column(db.Integer) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) user = db.relationship('User', backref=db.backref('bid', lazy='dynamic')) pet_id = db.Column(db.Integer, db.ForeignKey('pet.id')) pet = db.relationship('Pet', backref=db.backref('bid', lazy='dynamic')) def __init__(self, bid_amount, user, pet): self.bid_amount = bid_amount self.user = user self.pet = pet def __repr__(self): return '<Bid %r>' % self.bid_amount
class AuthzWebAction(db.Model): id = db.Column(db.Integer, primary_key=True) resource_name = db.Column(db.String(80)) resource_action = db.Column(db.String(8)) feature_id = db.Column(db.Integer, db.ForeignKey('authz_feature.id')) feature = db.relationship('AuthzFeature', backref=db.backref('web_actions', lazy='dynamic')) def __init__(self, resource_name, resource_action, feature): self.resource_name = resource_name self.resource_action = resource_action self.feature = feature def __repr__(self): return '<AuthzWebAction %r %r %r>' % self.resource_name, self.resource_action, self.feature.feature_name
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(80)) body = db.Column(db.Text) pub_date = db.Column(db.DateTime) category_id = db.Column(db.Integer, db.ForeignKey('category.id')) category = db.relationship('Category', backref=db.backref('posts', lazy='dynamic')) def __init__(self, title, body, category, pub_date=None): self.title = title self.body = body if pub_date is None: pub_date = datetime.utcnow() self.pub_date = pub_date self.category = category def __repr__(self): return '<Post %r>' % self.title
class Bid(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(80)) body = db.Column(db.Text) pub_date = db.Column(db.DateTime) vehicle_id = db.Column(db.Integer, db.ForeignKey('vehicle.id')) vehicle = db.relationship('Vehicle', backref=db.backref('bids', lazy='dynamic')) def __init__(self, title, body, vehicle, pub_date=None): self.title = title self.body = body if pub_date is None: pub_date = datetime.utcnow() self.pub_date = pub_date self.vehicle = vehicle def __repr__(self): return '<Bid %r>' % self.title
class InsuranceInfo(db.Model): id = db.Column(db.Integer(), primary_key=True)
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False)