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