def getSMO(self): stmt=u"""select infisCode,shortName from Organisation where id in (select insurer_id from clientpolicy where insurer_id is not null group by insurer_id)""" query = DBManager.executeSql(stmt) return query
def updatekladr(self,listspr): for spr in listspr: for row in spr: query=DBManager.executeSql(u"""select KOD_T_ST from kladr.SOCRBASE where SOCRNAME='{0}' and infisCode='{1}'""".format(spr[row],row)) if len(query)>0: continue else: query=DBManager.executeSqlNonQuery(u"""update kladr.SOCRBASE set infisCode='{1}' where SOCRNAME='{0}'""".format(spr[row],row))