class Key(db.Model): """api key记录表""" id = db.Column(db.Integer, primary_key=True, autoincrement=True) consumer_id = db.Column(db.Integer) api_key = db.Column(db.String(50)) secret_key = db.Column(db.String(50)) name = db.Column(db.String(50))
class InsurerSpec(db.Model): __tablename__ = 'insurerspeccontentbiz' numCode = db.Column(db.String(50), primary_key=True) insurerName = db.Column(db.String(50)) insurerType = db.Column(db.String(50)) specContent = db.Column(db.String(50)) remark = db.Column(db.String(50)) def __init__(self): self.guid = None def save(self): db.session.add(self) db.session.commit() def delete(self): db.session.delete(self) db.session.commit() def update(self): db.session.commit() def to_json(self): dict = self.__dict__ if "_sa_instance_state" in dict: del dict["_sa_instance_state"] return dict
class Face(db.Model): """人脸数据表""" id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(50)) id_card = db.Column(db.String(50)) arr = db.Column(db.String(4000)) consumer_id = db.Column(db.Integer)
class User(UserMixin, db.Model): __tablename__ = 'user' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(48), unique=True, nullable=False) email = db.Column(db.String(48), db.ForeignKey('registLink.email'), unique=True, nullable=False) password_hash = db.Column(db.String(128), nullable=False) regist_time = db.Column(db.DateTime) regist_ip = db.Column(db.String(48)) last_login_time = db.Column(db.DateTime) last_login_ip = db.Column(db.String(48)) user_relation = db.relationship('RegistLink', backref=db.backref('userInfo', lazy='joined')) def __init__(self, username, password, email, regist_ip): self.username = username self.password = password self.email = email self.regist_time = datetime.utcnow() self.regist_ip = regist_ip self.last_login_time = self.regist_time self.last_login_ip = self.regist_ip def __repr__(self): return '<User %r>' % self.username @property def password(self): raise AttributeError('Password is readonly.') @password.setter def password(self, password): self.password_hash = generate_password_hash(password) def verify_password(self, password): return check_password_hash(self.password_hash, password) def isAdmin(self): if self.email == '*****@*****.**': return True else: return False
class RegistLink(db.Model): __tablename__ = 'registLink' work_id = db.Column(db.String(48), unique=True, nullable=False, primary_key=True) email = db.Column(db.String(48), unique=True, nullable=False) regist_link = db.Column(db.String(64), unique=True) link_create_time = db.Column(db.DateTime) link_failure_time = db.Column(db.DateTime) regist_if = db.Column(db.Boolean)
class LicenseRecords(db.Model): __tablename__ = 'licenseRecords' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(48), nullable=False) from_ip = db.Column(db.String(48), nullable=False) create_time = db.Column(db.DateTime, nullable=False) device_code = db.Column(db.String(25), nullable=False) license_path = db.Column(db.String(128), nullable=False) download_time = db.Column(db.DateTime) def __init__(self, username, from_ip, device_code, license_path): self.username = username self.from_ip = from_ip self.create_time = datetime.utcnow() self.device_code = device_code self.license_path = license_path
class jm_ht_remotedata(db.Model): __tablename__ = 'jm_ht_remotedata' guid = db.Column(db.String, primary_key=True) appkey = db.Column(db.String(50), nullable=False) custId = db.Column(db.String(50)) custCoName = db.Column(db.String(200)) custUserName = db.Column(db.String(50)) custEmail = db.Column(db.String(200)) custPhone = db.Column(db.String(50)) shipperId = db.Column(db.String(50)) shipperName = db.Column(db.String(200)) insuredName = db.Column(db.String(200)) channelOrderId = db.Column(db.String(50)) bizContent = db.Column(db.String(50)) termContent = db.Column(db.String(50)) deliveryOrderId = db.Column(db.String(500)) shipId = db.Column(db.String(50)) licenseId = db.Column(db.String(500)) cargoFreight = db.Column(db.String(50)) claimLimit = db.Column(db.String(50)) cargeValue = db.Column(db.String(50)) invoicePrice = db.Column(db.String(10)) includeTax = db.Column(db.String(10)) insuranceFee = db.Column(db.String(50)) trafficType = db.Column(db.String(10)) shippingType = db.Column(db.String(20)) lotType = db.Column(db.String(10)) packageType = db.Column(db.String(500)) cargoType = db.Column(db.String(50)) cargoName = db.Column(db.String(4000)) departProvince = db.Column(db.String(20)) departCity = db.Column(db.String(100)) departDistrict = db.Column(db.String(20)) destinationProvice = db.Column(db.String(20)) destinationCity = db.Column(db.String(100)) destinationDistrict = db.Column(db.String(20)) consigneeName = db.Column(db.String(200)) consigneePhone = db.Column(db.String(50)) departDateTime = db.Column(db.String(50)) cargoCount = db.Column(db.String(50)) cargoWeight = db.Column(db.String(50)) stealFlag = db.Column(db.String(10)) CreateDate = db.Column(db.String(50)) policyNo = db.Column(db.String(50)) deliveryAddress = db.Column(db.String(500)) volume = db.Column(db.String(50)) relationType = db.Column(db.String(500)) departSpot = db.Column(db.String(500)) transitSpot = db.Column(db.String(500)) arriveStation = db.Column(db.String(500)) systemOrderId = db.Column(db.String(50)) custProperty = db.Column(db.String(50)) shipperProperty = db.Column(db.String(50)) departStation = db.Column(db.String(500)) Status = db.Column(db.String(50)) errLog = db.Column(db.String(500)) FeedbackStatus = db.Column(db.String(50)) ExceptionStatus = db.Column(db.String(50)) shipperContact = db.Column(db.String(50)) arriveStreet = db.Column(db.String(500)) arriveProperty = db.Column(db.String(50)) deliveryContact = db.Column(db.String(50)) alarmEvent = db.Column(db.String(50)) departStreet = db.Column(db.String(50)) cargoKind = db.Column(db.String(50)) invoiceTitle = db.Column(db.String(100)) mpAmount = db.Column(db.String(50)) mpRate = db.Column(db.String(50)) mpObject = db.Column(db.String(50)) mpRelation = db.Column(db.String(50)) policyRate = db.Column(db.String(50)) policySolutionID = db.Column(db.String(50)) claimLimit2 = db.Column(db.String(50)) AdjustId = db.Column(db.String(50)) def __init__(self): self.guid = None def save(self): db.session.add(self) db.session.commit() def delete(self): db.session.delete(self) db.session.commit() def update(self): db.session.commit() def to_json(self): dict = self.__dict__ if "_sa_instance_state" in dict: del dict["_sa_instance_state"] return dict
class ValidInsured(db.Model): __tablename__ = 'validinsured' GUID = db.Column(db.String, primary_key=True) Appkey = db.Column(db.String(50), nullable=False) ValidInsuredName = db.Column(db.String(50)) UniCode = db.Column(db.String(50)) PolicyNo = db.Column(db.String(50)) ClntMrk = db.Column(db.String(50)) CertfCls = db.Column(db.String(50)) CertfCde = db.Column(db.String(50)) Province = db.Column(db.String(50)) City = db.Column(db.String(50)) Tel = db.Column(db.String(50)) EstablishTm = db.Column(db.String(50)) InvoiceTitle = db.Column(db.String(50)) CertfClsName = db.Column(db.String(50)) DetailAddress = db.Column(db.String(50)) def __init__(self): self.guid = None def save(self): db.session.add(self) db.session.commit() def delete(self): db.session.delete(self) db.session.commit() def update(self): db.session.commit() def to_json(self): dict = self.__dict__ if "_sa_instance_state" in dict: del dict["_sa_instance_state"] return dict
class districts(db.Model): __tablename__ = 'districts' guid = db.Column(db.String, primary_key=True) DistrictName = db.Column(db.String(50), nullable=False) HeadGUID = db.Column(db.String(50), nullable=False) DistrictCode = db.Column(db.String(6)) DistrictLevelID = db.Column(db.String(1)) DistrictLevelName = db.Column(db.String(2)) LicenceCode = db.Column(db.String(10)) PostCode = db.Column(db.String(6)) Duplicate = db.Column(db.String(1)) Pingyin = db.Column(db.String(50)) DisplayName = db.Column(db.String(50)) ZACode = db.Column(db.String(50)) DistrictSimple = db.Column(db.String(50)) # DisplayOrder = db.Column(db.Integer(11)) DisplayOrder = db.Column(db.String(11)) cutData = db.Column(db.String(1)) modifyContent = db.Column(db.String(50)) modifyRela = db.Column(db.String(50)) PACode = db.Column(db.String(50)) YGCode = db.Column(db.String(50)) DHCode = db.Column(db.String(50)) StandardDisplayName = db.Column(db.String(100)) longitude = db.Column(db.String(50)) latitude = db.Column(db.String(50)) Shortname = db.Column(db.String(50)) ZLCode = db.Column(db.String(50)) ZHCode = db.Column(db.String(50)) HTCode = db.Column(db.String(50)) def __init__(self): self.guid = None def save(self): db.session.add(self) db.session.commit() def delete(self): db.session.delete(self) db.session.commit() def update(self): db.session.commit() def to_json(self): dict = self.__dict__ if "_sa_instance_state" in dict: del dict["_sa_instance_state"] return dict
class Consumer(db.Model): """api 调用者""" id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(50), nullable=False) pwd = db.Column(db.String(50))
class GJXXPTProduct(db.Model): __tablename__ = 'gjxxpt_product' GUID = db.Column(db.String, primary_key=True) appkey = db.Column(db.String(50), nullable=False) InsuranceCoverageCode = db.Column(db.String(50)) numCode = db.Column(db.String(50)) InsuranceCode = db.Column(db.String(50)) InsuranceCoverageName = db.Column(db.String(50)) ChargeTypeCode = db.Column(db.String(50)) Rate = db.Column(db.String(50)) deductible = db.Column(db.String(50)) MonetaryAmount = db.Column(db.String(50)) CargoTypeClassification1 = db.Column(db.String(50)) Remark = db.Column(db.String(50)) TransportModeCode = db.Column(db.String(50)) InsurerCode = db.Column(db.String(50)) SendMode = db.Column(db.String(50)) Rate2 = db.Column(db.String(50)) PolicyAmount = db.Column(db.Numeric(18, 2)) BXcargoCode = db.Column(db.String(50)) BXcargoName = db.Column(db.String(50)) CustCode = db.Column(db.String(50)) PolicyNo = db.Column(db.String(50)) CustName = db.Column(db.String(50)) def __init__(self): self.guid = None def save(self): db.session.add(self) db.session.commit() def delete(self): db.session.delete(self) db.session.commit() def update(self): db.session.commit() def to_json(self): dict = self.__dict__ if "_sa_instance_state" in dict: del dict["_sa_instance_state"] return dict
class RBProductInfo(db.Model): __tablename__ = 'rbproductinfo' line_no = db.Column(db.String, primary_key=True) Insurance = db.Column(db.String(50)) MainGlauses = db.Column(db.String(50)) MainGlausesCode = db.Column(db.String(50)) AdditiveNo = db.Column(db.String(50)) Additive = db.Column(db.String(50)) GoodsTypeNo = db.Column(db.String(50)) SpecialAnnounce = db.Column(db.String(50)) Deductible = db.Column(db.String(50)) OtherInfo = db.Column(db.String(50)) UserName = db.Column(db.String(50)) DeductiblePercent = db.Column(db.String(50)) DeductibleAmount = db.Column(db.String(50)) def __init__(self): self.guid = None def save(self): db.session.add(self) db.session.commit() def delete(self): db.session.delete(self) db.session.commit() def update(self): db.session.commit() def to_json(self): dict = self.__dict__ if "_sa_instance_state" in dict: del dict["_sa_instance_state"] return dict