def getDataById(id): rs = None try: sql = "select * from gonggaobody WHERE ggId='%s' order BY insertTime;" % id rs = dbmysql.first(sql) except Exception as e: util.logger.error(e) return rs
def qiyexx_eid(**kwargs): rs = None try: sql = "select * from q_psname where qyname='%s';" % (kwargs['qyname']) rs = dbmysql.first(sql) except Exception as e: util.logger.error(e) return rs
def qiyexx(**kwargs): rs = None try: sql = "select * from q_psname where zt is null ORDER BY eid DESC LIMIT 1;" rs = dbmysql.first(sql) except Exception as e: util.logger.error(e) return rs
def getData(): rs = None try: sql = "select * from gonggaobody order BY insertTime;" rs = dbmysql.first(sql) except Exception as e: util.logger.error(e) return rs
def getDataByUrl(url): rs = None try: sql = "select count(1) from zhaoping WHERE url='%s';" % url rs = dbmysql.first(sql) except Exception as e: util.logger.error(e) return rs
def selectryurl_ys1(**kwargs): rs = None try: sql = "select ry_num_zd from tbl_fupa_temp where eid='%s';" % kwargs[ 'eid'] rs = dbmysql.first(sql) except Exception as e: util.logger.error(e) return rs
def select_xw_nr(**kwargs): rs = None try: sql = f"select * from xw_nr where biaoti='{kwargs['biaoti']}';" rs = dbmysql.first(sql) return rs except Exception as e: util.logger.error(e) return rs
def select_hua(**kwargs): rs = None try: sql = f"select * from hua where shop='{kwargs['shop']}' or diqu='{kwargs['diqu']}';" rs = dbmysql.first(sql) return rs except Exception as e: util.logger.error(e) return rs
def selecttbl_qyname(**kwargs): rs = None try: sql = "select * from tbl_fupa_temp where eid ='%s';" % kwargs["eid"] rs = dbmysql.first(sql) return rs except Exception as e: util.logger.error(e) return rs
def select_qycookie(**kwargs): rs = None try: sql = f"select * from ipo_title where zt='0';" rs = dbmysql.first(sql) return rs except Exception as e: util.logger.error(e) return rs
def selecttbl_qy(**kwargs): rs = None try: sql = "select * from tbl_qy where qyid ='%s';" % kwargs["qyid"] rs = dbmysql.first(sql) return rs except Exception as e: util.logger.error(e) return rs
def jichutoken(**kwargs): rs = None try: sql = "select * from token_ceshi where yxq ='%s';" % kwargs["yxq"] rs = dbmysql.first(sql) return rs except Exception as e: util.logger.error(e) return rs
def select_fj(**kwargs): rs = None try: sql = f"select * from tbl_fj where qyname='{kwargs['qyname']}' and qyurl='{kwargs['qyurl']}';" rs = dbmysql.first(sql) return rs except Exception as e: util.logger.error(e) return rs
def seletoken(**kwargs): rs = None try: sql = "select token from token_ceshi where token ='%s';" % kwargs[ "token"] rs = dbmysql.first(sql) return rs except Exception as e: util.logger.error(e) return rs
def selecttbl_qy_xm_weizhi(**kwargs): rs = None try: sql = "select * from tbl_qy_xm_weizhi where xmid='%s' and qyid = '%s';" % ( kwargs["xmid"], kwargs['qyid']) sql = sql.replace('\\', '-').replace('\n', '').replace('\r', '').replace('\t', '') rs = dbmysql.first(sql) except Exception as e: util.logger.error(e) return rs
def selecttbl_qy_zz(**kwargs): rs = None try: sql = "select * from tbl_qy_zz where qyid ='%s' and zsh='%s' and zzmc='%s';" % ( kwargs["qyid"], kwargs["zsh"], kwargs["zzmc"]) sql = sql.replace('\\', '-').replace('\n', '').replace('\r', '').replace('\t', '') rs = dbmysql.first(sql) return rs except Exception as e: util.logger.error(e) return rs
def selecttbl_user_zcxx(**kwargs): rs = None try: sql = "select * from tbl_user_zcxx where zc_dwid ='%s' and userid ='%s' and zclb='%s' and zyyzh='%s' and zc_zy='%s';" % ( kwargs["zc_dwid"], kwargs["userid"], kwargs["zclb"], kwargs["zyyzh"], kwargs["zc_zy"]) sql = sql.replace('\\', '-').replace('\n', '').replace('\r', '').replace('\t', '') rs = dbmysql.first(sql) # print(sql) except Exception as e: util.logger.error(e) return rs
def selecttbl_qiye_user_qyid(**kwargs): rs = None try: sql = "select userid from tbl_user where qyid='%s' and username='******' and sex='%s' and zjlx='%s' and zjhm='%s';" % ( kwargs["qyid"], kwargs["username"], kwargs["sex"], kwargs["zjlx"], kwargs["zjhm"], ) sql = sql.replace('\\', '-').replace('\n', '').replace('\r', '').replace('\t', '') rs = dbmysql.first(sql) except Exception as e: util.logger.error(e) return rs
def fxh(): try: for i in range(1,26): print(i) url = "https://dncapi.feixiaohao.com/api/coin/web-coinrank?page=%s&type=0&pagesize=100&webp=1"%i a = requests.get(url=url).content.decode() b = json.loads(a) c = b["data"] for cc in c: fullname = "%s-%s"%(cc["name"],cc["fullname"]) print(fullname) price = cc["current_price"] inserttime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) opentime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) sql = "SELECT * FROM feixiaohao where fullname ='%s'"%fullname a = dbmysql.first(sql) if a == None: sql = "INSERT INTO feixiaohao(fullname,price,inserttime,opentime) VALUES ('%s','%s','%s','%s')"%(fullname,price,inserttime,opentime) dbmysql.execute(sql) else: sql = "UPDATE feixiaohao SET price = '%s',opentime = '%s' WHERE fullname = '%s'"%(price,opentime,fullname) dbmysql.execute(sql) except Ellipsis as e: print(e)