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