class User(db.Model):
__tablename__ = "users"
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(32), unique=True)
password = db.Column(db.String(32))
token = db.Column(db.String(32))
#manageinstruments的外键，该用户管理了哪些仪器
manageinstruments = db.relationship('manageinstrument',
foreign_keys=[manageinstrument.userid],
backref=db.backref('manageuser',
lazy='joined'),
lazy='dynamic',
cascade='all, delete-orphan')
def add(self):
try:
tempuser = User.query.filter_by(username=self.username).first()
if tempuser is None:
db.session.add(self)
db.session.commit()
return 0
else:
return 1
except Exception, e:
print e
db.session.rollback()
return 2
class instrument(db.Model):
__tablename__ = "instruments"
id = db.Column(db.Integer, primary_key=True)
instrumentID = db.Column(db.String(64), unique=True)
password = db.Column(db.String(32))
timestamp = db.Column(db.DateTime, default=datetime.now)
measuredatas = db.relationship('Measuredata',
backref='instrument',
lazy='dynamic')
savedatas = db.relationship('savedata',
backref='instrument',
lazy='dynamic')
#管理这个仪器的所有帐号用户
manageusers = db.relationship('manageinstrument',
foreign_keys=[manageinstrument.instrumentid],
backref=db.backref('managewhatinstrument',
lazy='joined'),
lazy='dynamic',
cascade='all, delete-orphan')
def add(self):
try:
temp = instrument.query.filter_by(
instrumentID=self.instrumentID).first()
if temp is None:
db.session.add(self)
db.session.commit()
return 0
else:
return 1
except Exception, e:
print e
db.session.rollback()
return 2
class Scene(db.Model):
__tablename__ = 'scenes'
id = db.Column(db.Integer,primary_key=True)
taskcode = db.Column(db.String)
user_id = db.Column(db.Integer)
sceneid = db.Column(db.Integer)
def add(self):
try:
db.session.add(self)
db.session.commit()
except Exception, e:
print e
db.session.rollback()
return exception
class HistoryData(db.Model):
__tablename__="historydatas"
id = db.Column(db.Integer,primary_key=True)
starttime=db.Column(db.DateTime,default=datetime.now)
endtime=db.Column(db.DateTime,default=datetime.now)
amount=db.Column(db.Integer)
device_id=db.Column(db.Integer,db.ForeignKey('devicelists.id'))
def add(self):
try:
db.session.add(self)
db.session.commit()
except Exception, e:
print e
db.session.rollback()
return exception
class manageinstrument(db.Model):
__tablename__ = 'manageinstruments'
id = db.Column(db.Integer, primary_key=True)
userid = db.Column(db.Integer, db.ForeignKey('users.id'), primary_key=True)
instrumentid = db.Column(db.Integer,
db.ForeignKey('instruments.id'),
primary_key=True)
timestamp = db.Column(db.DateTime, default=datetime.now)
def add(self):
try:
db.session.add(self)
db.session.commit()
except Exception, e:
print e
db.session.rollback()
return 2
class User(db.Model):
__tablename__='users'
id = db.Column(db.Integer,primary_key=True)
username = db.Column(db.String(32),unique = True)
password = db.Column(db.String(32))
def add(self):
try:
tempUser=User.query.filter_by(username=self.username).first()
if tempUser is None:
db.session.add(self)
db.session.commit()
return success
else:
return fail
except Exception, e:
print e
db.session.rollback()
return exception
class revise(db.Model):
"""docstring for revises"""
__tablename__ = "revises"
id = db.Column(db.Integer, primary_key=True)
instrumentID = db.Column(db.String(32))
type = db.Column(db.String(32))
realvalue = db.Column(db.Float)
measurevalue = db.Column(db.Float)
flag = db.Column(db.Boolean)
def add(self):
try:
tempuser = revise.query.filter_by(
instrumentID=self.instrumentID,
type=self.type,
realvalue=self.realvalue).first()
if tempuser is None:
db.session.add(self)
db.session.commit()
return 0
else:
return 1
except Exception, e:
print e
db.session.rollback()
return 2
class TimingTask(db.Model):
__tablename__="timingtasks"
id = db.Column(db.Integer,primary_key=True)
deviceid = db.Column(db.Integer)
starttime=db.Column(db.String)
amount=db.Column(db.Integer)
days = db.Column(db.String)
devicetype = db.Column(db.String)
setflag = db.Column(db.String,default='0')
userid = db.Column(db.Integer)
sceneid = db.Column(db.Integer)
def add(self):
try:
db.session.add(self)
db.session.commit()
except Exception, e:
print e
db.session.rollback()
return exception
class DeviceList(db.Model):
__tablename__="devicelists"
id = db.Column(db.Integer,primary_key=True)
password = db.Column(db.String(32))
type = db.Column(db.String(32))
name = db.Column(db.String(32))
user_id=db.Column(db.Integer,db.ForeignKey('users.id'))
state = db.Column(db.String(32))
def add(self):
try:
db.session.add(self)
db.session.commit()
except Exception, e:
print e
db.session.rollback()
return exception
class UsersInfo(db.Model):
__tablename__='usersinfos'
id = db.Column(db.Integer,primary_key=True)
name = db.Column(db.String(32))
phone = db.Column(db.String(32))
qq = db.Column(db.String(32))
wechat = db.Column(db.String(32))
token = db.Column(db.String(32))
def add(self):
try:
db.session.add(self)
db.session.commit()
except Exception, e:
print e
db.session.rollback()
return exception
class savedata(db.Model):
__tablename__ = "savedatas"
id = db.Column(db.Integer, primary_key=True)
instrumentID = db.Column(db.String(32),
db.ForeignKey('instruments.instrumentID'))
datatype = db.Column(db.String(32))
value = db.Column(db.String(32))
separation = db.Column(db.String(32))
VWRTHD = db.Column(db.String(32))
stand = db.Column(db.String(32))
up = db.Column(db.String(32))
down = db.Column(db.String(32))
fre = db.Column(db.String(32))
timestamp = db.Column(db.DateTime, default=datetime.now)
def add(self):
try:
db.session.add(self)
db.session.execute('set names utf8mb4')
db.session.commit()
except Exception, e:
print e
db.session.rollback()
return 2
