class Media(db.Model, Mixin):
__tablename__ = "media"
id = db.Column(db.Integer, primary_key=True)
vid = db.Column(db.Boolean())
audio = db.Column(db.Boolean())
img = db.Column(db.Boolean())
used = db.Column(db.Boolean())
name = db.Column(db.String(50))
def __init__(self,
vid=False,
audio=False,
img=False,
used=False,
name=" "):
self.vid = vid
self.audio = audio
self.img = img
self.used = used
self.name = name
def is_used(self):
return any([
Vid.query.filter_by(vkey=self.id).first(),
Slides.query.filter_by(ikey=self.id).first(),
Display_store.query.filter(
or_(Display_store.ikey == self.id,
Display_store.akey == self.id)).first(),
Touch_store.query.filter(
or_(Touch_store.ikey == self.id,
Touch_store.akey == self.id)).first()
])
class Media(db.Model):
__tablename__ = "media"
id = db.Column(db.Integer, primary_key=True)
vid = db.Column(db.Boolean())
audio = db.Column(db.Boolean())
img = db.Column(db.Boolean())
used = db.Column(db.Boolean())
name = db.Column(db.String(50))
def __init__(self, vid=False, audio=False,
img=False, used=False, name=" "):
self.vid = vid
self.audio = audio
self.img = img
self.used = used
self.name = name
class Printer(db.Model, Mixin):
__tablename__ = "printers"
id = db.Column(db.Integer, primary_key=True)
vendor = db.Column(db.Integer, nullable=True, unique=True)
product = db.Column(db.Integer, nullable=True, unique=True)
in_ep = db.Column(db.Integer, nullable=True)
out_ep = db.Column(db.Integer, nullable=True)
active = db.Column(db.Boolean())
langu = db.Column(db.String(100))
value = db.Column(db.Integer)
scale = db.Column(db.Integer, default=1)
name = db.Column(db.String(100), nullable=True)
def __init__(self,
vendor=0,
product=0,
in_ep=None,
out_ep=None,
active=False,
langu='en',
value=1,
scale=1,
name=None):
self.vendor = vendor
self.product = product
self.in_ep = in_ep
self.out_ep = out_ep
self.active = active
self.value = value
self.scale = scale
self.name = name
class Printer(db.Model):
__tablename__ = "printers"
id = db.Column(db.Integer, primary_key=True)
vendor = db.Column(db.String(100), nullable=True, unique=True)
product = db.Column(db.String(100), unique=True)
in_ep = db.Column(db.Integer, nullable=True)
out_ep = db.Column(db.Integer, nullable=True)
active = db.Column(db.Boolean())
langu = db.Column(db.String(100))
value = db.Column(db.Integer)
def __init__(self, vendor=" ", product=" ",
in_ep=0, out_ep=0, active=False,
langu='en', value=1):
self.vendor = vendor
self.product = product
self.in_ep = in_ep
self.out_ep = out_ep
self.active = active
self.value = value
