def msgSortMark(self,ids,sort_id): repo = WeixinDB() create_time = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') count = 0 with repo: for msg_id in ids: try: sql_str = 'update approve_metadata set sort_id = %d where id = %d ' % (sort_id,msg_id) repo.execute_query(sql_str) count = count + 1 except Exception, e: print e print ' at %s' % (create_time)
def gen_query_number(self,sql_str): result = 0 create_time = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') repo = WeixinDB() with repo: try: query_tuple = repo.execute_query(sql_str) except Exception, e: print e print 'at %s ' % (create_time) else:
def gen_query_tuple(self,sql_str,*param): count = 0 result = list() create_time = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') repo = WeixinDB() with repo: try: query_tuple = repo.execute_query(sql_str,param[0]) except Exception, e: print e print ' at %s' % (create_time) else: