def queryModel(self, **kwargs):
"""以分页方式提取model 记录，参数：start 游标起始位置；size:每次返回的记录条数;
fields:field list
if size = 0,then不分页，返回所有记录集
order_by(text("id"))
"""
start = int(kwargs['start'])
size = int(kwargs['size'])
# fields = kwargs['fields']
if size != 0:
models = kb_session.query("xhdm", "xhmc").\
from_statement(
text("select * from model order by modelId desc limit :start,:size").\
params(start=start,size=size)).all()
else:
# import pdb
# pdb.set_trace()
nums = kb_session.query(func.count(Model.modelId)).scalar()
# nums = kb_session.query("xhdm", "xhmc").from_statement(text("select * from model")).count()
return int(nums)
try:
kb_session.commit()
return models
except:
kb_session.rollback()
pass
def query(self, **kwargs):
"""以分页方式提取model 记录，参数：start 游标起始位置；size:每次返回的记录条数;
fields:field list
if size = 0,then不分页，返回所有记录集
order_by(text("id"))
"""
start = int(kwargs['start'])
size = int(kwargs['size'])
# fields = kwargs['fields']
if size != 0:
recorders = kb_session.query("sbdm", "sbmc","pcdm","location",
"freq","pd_upper","pd_lower","num",
"freq_upper","freq_lower","bw","base_power",
"tzlx","bzf","mid_freq","comment1").\
from_statement(
text("select * from fashej order by fashejId desc limit :start,:size").\
params(start=start,size=size)).all()
else:
nums = kb_session.query(func.count(Fashej.fashejId)).scalar()
return int(nums)
try:
kb_session.commit()
return recorders
except:
kb_session.rollback()
pass
def query(self, **kwargs):
"""以分页方式提取model 记录，参数：start 游标起始位置；size:每次返回的记录条数;
fields:field list
if size = 0,then不分页，返回所有记录集
order_by(text("id"))
"""
start = int(kwargs['start'])
size = int(kwargs['size'])
# fields = kwargs['fields']
if size != 0:
recorders = kb_session.query("cssbdm", "cssbmc","pcdm","location",
"fb_upper","fb_lower","freq",
"f_upper","f_lower","order1","s21").\
from_statement(
text("select * from lvboq order by lvboqId desc limit :start,:size").\
params(start=start,size=size)).all()
else:
nums = kb_session.query(func.count(Lvboq.lvboqId)).scalar()
return int(nums)
try:
kb_session.commit()
return recorders
except:
kb_session.rollback()
pass
def query(self, **kwargs):
"""以分页方式提取model 记录，参数：start 游标起始位置；size:每次返回的记录条数;
fields:field list
if size = 0,then不分页，返回所有记录集
order_by(text("id"))
"""
start = int(kwargs['start'])
size = int(kwargs['size'])
# fields = kwargs['fields']
if size != 0:
recorders = kb_session.query("cssbdm", "cssbmc","pcdm","location",
"gain","polarization","fwbskd","fybskd",
"txzxj").\
from_statement(
text("select * from jieshoutx order by jieshoutxId desc limit :start,:size").\
params(start=start,size=size)).all()
else:
nums = kb_session.query(func.count(Jieshoutx.jieshoutxId)).scalar()
return int(nums)
try:
kb_session.commit()
return recorders
except:
kb_session.rollback()
pass
def updateByCode(self, **kwargs):
"update the speicy xhdm branch recorder"
"""
session.query(User).from_statement(text("SELECT * FROM users where name=:name")).\
params(name='ed').all()
session.query(User).from_statement(
text("SELECT * FROM users where name=:name")).params(name='ed').all()
"""
xhdm = kwargs['xhdm']
# import pdb
# pdb.set_trace()
if xhdm != "":
try:
branch = kb_session.query(Branch).\
from_statement(text("SELECT * FROM branch where xhdm=:xhdm")).\
params(xhdm=xhdm).one()
# for kw in kwargs.keys():
# branch.kw = kwargs[kw]
branch.xhmc = kwargs['xhmc']
kb_session.commit()
except:
kb_session.rollback()
pass
else:
return None
def updateByCode(self, **kwargs):
"update the speicy xhdm model recorder"
"""
session.query(User).from_statement(text("SELECT * FROM users where name=:name")).\
params(name='ed').all()
session.query(User).from_statement(
text("SELECT * FROM users where name=:name")).params(name='ed').all()
"""
xhdm = kwargs['xhdm']
# import pdb
# pdb.set_trace()
if xhdm != "":
try:
model = kb_session.query(Model).\
from_statement(text("SELECT * FROM model where xhdm=:xhdm")).\
params(xhdm=xhdm).one()
# import pdb
# pdb.set_trace()
updatedattrs = [kw for kw in kwargs.keys() if kw != 'xhdm']
for kw in updatedattrs:
setattr(model, kw, kwargs[kw])
# model.xhmc = kwargs['xhmc']
kb_session.commit()
except:
kb_session.rollback()
pass
else:
return None
def add(self, kwargs):
"""parameters db fashej table"""
recorder = Fashej()
for kw in kwargs.keys():
setattr(recorder, kw, kwargs[kw])
kb_session.add(recorder)
try:
kb_session.commit()
except:
kb_session.rollback()
pass
def getByCode(self, sbdm):
if sbdm != "":
try:
recorder = kb_session.query(Fashej).\
from_statement(text("SELECT * FROM fashej WHERE sbdm=:sbdm")).\
params(sbdm=sbdm).one()
return recorder
except:
kb_session.rollback()
None
else:
return None
def getByCode(self, cssbdm):
if cssbdm != "":
try:
recorder = kb_session.query(Jieshoutx).\
from_statement(text("SELECT * FROM jieshoutx WHERE cssbdm=:cssbdm")).\
params(cssbdm=cssbdm).one()
return recorder
except:
kb_session.rollback()
None
else:
return None
def add(self, argsdic):
"""parameters db branch table"""
branch = Branch()
for kw in argsdic.keys():
setattrib(branch, kw, argsdic[kw])
kb_session.add(branch)
try:
kb_session.commit()
except:
kb_session.rollback()
pass
def Addmodel(self,modelId,xhdm,xhmc):
"""parameters db model table"""
model = Model()
model.id = modelId
model.xhdm = xhdm
model.xhmc = xhmc
kb_session.add(model)
try:
kb_session.commit()
except:
kb_session.rollback()
raise
def getByCode(self, xhdm):
# xhdm = kwargs['xhdm']
if xhdm != "":
try:
branch = kb_session.query(Branch).\
from_statement(text("SELECT * FROM branch where xhdm=:xhdm")).\
params(xhdm=xhdm).one()
return branch
except:
kb_session.rollback()
None
else:
return None
def getModelByCode(self, xhdm):
# xhdm = kwargs['xhdm']
if xhdm != "":
try:
model = kb_session.query(Model).\
from_statement(text("SELECT * FROM model where xhdm=:xhdm")).\
params(xhdm=xhdm).one()
return model
except:
kb_session.rollback()
None
else:
return None
def DeleteByCode(self, sbdm):
"delete the specify sbdm fashej recorder"
# xhdm = kwargs['xhdm']
if sbdm != "":
try:
recorder = kb_session.query(Fashej).\
from_statement(text("SELECT * FROM fashej WHERE sbdm=:sbdm")).\
params(sbdm=sbdm).one()
kb_session.delete(recorder)
kb_session.commit()
except:
kb_session.rollback()
pass
else:
return None
def DeleteByCode(self, cssbdm):
"delete the specify cssbdm jieshoutx recorder"
# xhdm = kwargs['xhdm']
if cssbdm != "":
try:
recorder = kb_session.query(Jieshoutx).\
from_statement(text("SELECT * FROM jieshoutx WHERE cssbdm=:cssbdm")).\
params(cssbdm=cssbdm).one()
kb_session.delete(recorder)
kb_session.commit()
except:
kb_session.rollback()
pass
else:
return None
def DeleteByCode(self, xhdm):
"delete the specify xhdm model recorder"
# xhdm = kwargs['xhdm']
if xhdm != "":
try:
model = kb_session.query(Model).\
from_statement(text("SELECT * FROM model where xhdm=:xhdm")).\
params(xhdm=xhdm).one()
kb_session.delete(model)
kb_session.commit()
except:
kb_session.rollback()
pass
else:
return None
def addModel(self, **kwargs):
"""parameters db model table"""
model = Model()
# model.modelId = kwargs['modelId']
model.xhdm = kwargs['xhdm']
model.xhmc = kwargs['xhmc']
# # registry db sources
#
# saconnect = ISQLAlchemyConnectionStrings(getSite())
# # Register z3c.saconfig utilities for mysql parameters db
# dbURI = saconnect['mysql']
# # Register z3c.saconfig utilities for pas.plugins.sqlarchemy
# engine = EngineFactory(dbURI, echo=False, convert_unicode=False)
# provideUtility(engine, name=u"mysql.parameters")
# session = GloballyScopedSession(engine=u"mysql.parameters", twophase=False)
# provideUtility(session,name=u"mysql.parameters")
kb_session.add(model)
try:
kb_session.commit()
except:
kb_session.rollback()
pass
def updateByCode(self, kwargs):
"update the speicy sbdm fashej recorder"
"""
session.query(User).from_statement(text("SELECT * FROM users WHERE name=:name")).\
params(name='ed').all()
session.query(User).from_statement(
text("SELECT * FROM users WHERE name=:name")).params(name='ed').all()
"""
sbdm = kwargs['sbdm']
if sbdm != "":
try:
recorder = kb_session.query(Fashej).\
from_statement(text("SELECT * FROM fashej WHERE sbdm=:sbdm")).\
params(sbdm=sbdm).one()
updatedattrs = [kw for kw in kwargs.keys() if kw != 'sbdm']
for kw in updatedattrs:
setattr(recorder, kw, kwargs[kw])
kb_session.commit()
except:
kb_session.rollback()
pass
else:
return None
def updateByCode(self, kwargs):
"update the speicy cssbdm jieshoutx recorder"
"""
session.query(User).from_statement(text("SELECT * FROM users WHERE name=:name")).\
params(name='ed').all()
session.query(User).from_statement(
text("SELECT * FROM users WHERE name=:name")).params(name='ed').all()
"""
cssbdm = kwargs['cssbdm']
if cssbdm != "":
try:
recorder = kb_session.query(Jieshoutx).\
from_statement(text("SELECT * FROM jieshoutx WHERE cssbdm=:cssbdm")).\
params(cssbdm=cssbdm).one()
updatedattrs = [kw for kw in kwargs.keys() if kw != 'cssbdm']
for kw in updatedattrs:
setattr(recorder, kw, kwargs[kw])
kb_session.commit()
except:
kb_session.rollback()
pass
else:
return None
