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