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)
