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 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 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 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