import requests import hashlib import time from urllib import parse import datetime import math import pymysql from apscheduler.schedulers.blocking import BlockingScheduler def md5value(s): md5 = hashlib.md5() md5.update(s.encode("utf-8")) return md5.hexdigest() def get_zzy_user_changes(): API_list = [ ['vip-songyi','098f17cc73cc4a74861ff4a87e3b526c',''], ['vip-wanger','aefabe89dfb84227bf7dae8ef0a59c89',''], ['vip-kuangwu','de5157d0e778400d84b2730626bd5787',''], ['vip-guangzhou500','ecce5c8566c24d63b8c829a10deb8601',''], ['vip-zhousi','b226af5f3cb243638b4a29d1a343d10d',''], ['vip-diwu1','7f2a1f03e53742c4acc49814b536ff59',''], ['vip-toutiao100','10ea6f1132084d86940c9b8b56fc5dad',''], ['vip-guangzhou3000','bac6f3c5d58244559b244c52bd1696b2',''], ['vip-guangzhou600','71873a3750bf49cdabb7a10441742950',''], ['vip-guangzhou3','385c7fadd05649e689a6bf272f3d59a7',''], ['vip-guangzhou5004','b8737034f23b4e5b9fa6256166faea57',''], ['vip-guangzhou5','5c65fd4b632a401097b6ca524eab551f',''], ['vip-guangzhou6','0939540ca8f34401b20b36e6c5409031',''], ['vip-guangzhoujiuqi','a7ede742affe457e8da4da181eb643d3',''], ['vip-guangzhou5003','9fefdc098ae54fe283dd2c5a6019b769',''], ['vip-qucheng2','e8cee00b1c3d42a6a75810a0d90e9e6a',''], ['vip-quchengsanqi','afc1e30e72ad41bf90c21aac41cb6ee1',''], ['vip-qucheng7qi','f8e7b801e63e43218111c1d8a5faf857',''], ['vip-qucheng8qi','17838a8f9ea64f809a88a5cd872c7375',''], ['vip-quchengjiuqi','80034ad8e7874ab99242ccce30ac1861',''], ['vip-ccsq','d8100098bf0d4fdb85e62150bb15a0b9',''], ['vip-qucheng11qi','e274b5bb5245444f806bc36b688f7a44',''], ['vip-qucheng12qi','b9de5355acbd414cb12f97786efe0376',''], ['vip-qucheng13qi','c8c91b7fdb8e476d81160c865f9bbf7b',''], ['vip-qucheng14qi','c9c27f53e40b4372a2bfe83dbd8fde03',''], ['vip-qucheng15qi','81909093d1db4374b5c545031380f3fe',''], ['vip-zanxiang10','04a2c53fbe3546dd8feb475592f9855c',''], ['ch-zzsw','d1a8e23df03a411a8353896e00751b23',''], ['ch-zhixiang','d0fc32aefdfb46ad959d6a09943b0d9e',''], ['ch-wenlan','520514c9c0cf46e19f0707ec28113a8b',''], ['ch-qxsww','b31211c625244e1a8123adf866a74935',''], ['ch-xixsc','25fc3c26d388410dbdb6ea5ce792fc1e',''], ['ch-zzsw5','fd5b6b28997f4880b398d0188f0fe68a',''], ['ch-yysf66','b194a98901ad4508aa0a984deedc35a5',''], ['ch-chyd','370c8494fd0c480f8c0b583d5eb3bd54',''], ['ch-xiangx5','4a196a83056d43ed82db2a9f941cd6cb',''], ['ch-shwg','d406794893de4175ab948fd028e43468',''], ['vip-diliu','0858b1566e0c4debb4cab808a0e207f7',''], ['ch-haotian2','7dd4a99a49b340a2a02822d9a83f64a8',''], ['ch-fysh6','645a6357d3ea413098f689dbf3d70c68',''], ['vip-qucheng16qi','bca1090368d44ec8a498d26e02ba06fe',''], ['vip-qucheng17qi','fd31bc211b4f42908163f68fdeabf869',''], ['vip-刘勇8','e35df1ac30b844eb81bd620674dc6937','刘勇8'], ['110456b2078','8621335fe2f61b7afa5d8697ba7669b1','趣程21期'], ['110512df033','4768493cc3c7517f1b3fcd8bfeeb80ed','趣程22期'], ['1044871a6fd','45b4123731e0b90b8c0bf2cf9af84106','刘勇6'], ['94697472f4','ce1da5aa6df13f34ec2417f70cf75fff','liuy123'], ['106672e2105','0c3f3ab6d9a82fb515fe3dd906d4d96b','刘勇3'] ] for x in API_list: my_key = x[0] secert = x[1] my_sign=md5value(secert+'key='+my_key) url = 'https://openapi.818tu.com/partners/channel/channels/list?' parameter = 'key='+my_key+'&sign='+my_sign channel_list = requests.get(url+parameter) #获取子渠道列表 items = channel_list.json()['data']['items'] for item in items: channel_id = item['id'] channel = item['nickname'] url1 = 'https://openapi.818tu.com/partners/channel/mp/access_token?' my_sign_1 =md5value(secert+'channel_id='+str(channel_id)+'&key='+my_key) parameter_1 = 'channel_id='+str(channel_id)+'&key='+my_key+'&sign='+my_sign_1 if channel not in ['飓风中文网','傲中原文悦','新世界阅读','新势力悦读','剑华阅读'] : a = requests.get(url1+parameter_1) access_token = a.json()['data']['token'] st_unix = int((time.time()+8*3600))//86400*86400-8*3600-86400 et_unix = int((time.time()+8*3600))//86400*86400-8*3600-86400 if access_token is not None: d = get_user_change(access_token,st_unix,et_unix,channel) mysql_insert_userchanges(d,channel) def get_other_user_changes(): key_list = [ ['wxf28f87197e1f16b2','c2e0644d05f45a88d7298f9fa4c6c455','彭湃阅读'], ['wx06a8c538b30666df','b5b71ccae606fd78f1bfb2a89195d1f1','亦晨书楼'], ['wx7201cb8f62e3e1b2','d532583ef0e75a94fab5d20977a02103','天钧文海'], ['wxdce0d883d1e1b586','b6c0eef2c6e8d2900ef0c0910c237f52','暮晨文库'], ['wx7d85d1192d6d126e','20de4de13d790abc47d244b677bd8bf0','宇墨书楼'], ['wx08b11f667d89feea','ac639f71cd28767c3c04729754b3ce87','骏驰文海'], ['wx47fe548157b430e4','c8c0e8965e0ff9a9b14161db4263b2f4','承洲书海'], ['wx7a7635c7ed23f25b','b5910d389381d0e5558532af750d9172','哲圣文海'], ['wx6a2eafa684d52aa4','27df0ba16e41e1b3320f9bca1764de0b','英逸文轩'], ['wx86454a84e24193bd','3e2353fa21d2e6a2db6da8bb0780a6b0','伏羲书海'], ['wxc0fa71d3dfdd9d81','b77312ab8283c2fc6262526f249b2d5d','青涛文阅'], ['wxf8de90e8557918fc','6ceb08c6067198e1fff1c6d96fa59db4','赤星书海'], ['wx1af6be7ab8de9698','20d63ac36fd7bd8335c856ef3964328b','飞羽文海'], ['wx60ac0914e603f965','e0e4e116c8346394aa9ddb905d36ba5f','流霜文库'], ['wx66b0bab1c52981e0','ee4f74f990eea23b969d18147834979c','七曜文库'], ['wx0e58a4663bf34782','89d49706a906041b839f7db67dbe17d0','亦玉文海'], ['wxf7c0417175c2b70e','73a0c7007c0b61d4c22ef2259fa45c73','悦竹文库'], ['wx17ff9d07ca739dba','cac6eb3c1016f1c7abfbad495d1eb1f9','紫晖文阁'], ['wx8bad7b34d591947a','8a296b5f4fa9806aaa6f463566c658ce','灵龙阅读'], ['wxd48241646117215f','24cd4b3f62a464bd7dc5b846e66dc705','紫虹书社'], ['wx27a3a679389711cb','95f30e4deda6670cc9341b0808f6528c','宸赫书楼'], ['wxaf1acb0a039eb9c9','65f6c1c9d6847c48b2de817222d9e702','翰墨书楼'], ['wxdd080ade6e9e8afc','b85e13c1e0299debff2499c94b8b7abe','屠龙书社'], ['wx86c2df7379b81033','9e02a26dd417ca898b9918a4e777e964','白虎文选'], ['wx2ca6d8373e8b9d9d','455977a6c058d8610d684614d6721e0e','怀风文轩'], ['wx5cfbb8a5d36234f7','f93e2a56aba34897c4486b6ae66c304a','承安文海'], ['wxec16302d323b4128','a75a1666af4d86a1d1ee4f38e6ba3976','明旭文库'], ['wx7a600ba7f52af6de','828a760c5aecf2ffb660c61cc6fd1ccb','豪风书楼'], ['wx910f6be29400a292','d755bf96179667a1cca7a4568c563e2d','逐天书楼'], ['wxc7aa6ddc957ee77b','1c8489a2b73128be395d79688c3fe781','沐城书海'], ['wx3ceece4ffe4a5c1e','115ef66ea2a61c89d0180f1f7b8e7b12','竟舟文学'], ['wxd3e66547b20ff5a3','8da2926bc5b692dc70c55240639203e3','夕暮文苑'], ['wxaf25e53fb9b53254','0c93949f17c680216d16cf8d34a1a731','远航文海'], ['wx4993183f80106354','2290b49b916bc5775424bedc2a49932d','荣轩文阁'], ['wx92359c67fbc5843d','c09bb269071a957c1b440fd5c21047cd','鹤轩书楼'], ['wxd74bb209835a038e','5935a95067817216248ab6489a44e989','山雁书海'], ['wx1862db18c7346904','7b0c87fc38f4fe487ffb5c2926e3742c','南风文海'], ['wx7be09068666095cf','75ac2905efb099b9cebd996240959716','星骇文阁'], ['wx3221dfec4c292d81','0a122fd7fdeff2ef633431447cb3f152','紫凰文海'], ['wx5adebde6ded1e7a2','ae7e7a067da1dff4f9fd8bcdaf61f943','碧涛书海'], ['wxa7ef819153e1e778','d02c774a8df651f0ccb7090cbd5b3e88','索鼎文阅'], ['wx5f9135a80b493ec8','5b6dfaac7d679c19d0ab094b08e1f6c2','博轩书楼'], ['wxa91dd3bc42cabc30','9d051937e65e1b5c907cdeb1f988da04','奋青书楼'], ['wxcde380829c792876','81b009dc358dcb64787648119754d5a3','茗昱文轩'], ['wx742bf720c70ee348','d3a8ac38e2a96d43504b819ac1785ca8','踏轩书楼'], ['wx6ae642b171bfb880','66669647475ae11073177b528eb78dc1','墨凡书海'], ['wx3eba0c0dbcb471ad','92ae3beb889f11b8f639d04e89433402','妍雨书楼'], ['wxdf6e87fad7bf70de','97495b32525961bb448b7e7a0f8c5d09','云汐文学'], ['wxb26a11ad5f23cc04','ee9609be192671d351c2c3c278b049eb','航舟看吧'], ['wx302d3eccbe6e118c','17da4ef4a95338d884f5eed8d0442374','悦阁文楼'], ['wx1e2221e75c6fcbc9','7ae1acaea2e4961792af445403f93eac','星烛书海'], ['wxb55e6176e82248a7','85edcae6a39ad4f1fe907d9d92281f81','豪天文轩'], ['wx68b3bedb2d667856','a008255aaa713e543260d97bc2fcdfc4','猛虎阅吧'], ['wxaf6055e7387e83aa','ceee1f276e4c7a838236b492b8756a34','鼎盛文海'], ['wxcdb32c5027a290b1','e9f55c25cbe9751d60e17579aae5cfd4','孤风书楼'], ['wxbef3c348991c251e','995092b3874d58ccaa497492ea87750e','冷雁文海'], ['wx95d7308b8d3d5142','0102f478cc3cae6a0d9a8c41bbf30e99','南烟书楼'], ['wx59d3446e3b4ddef8','322b4ba855f20c9b2e9076f52cdbe5d9','惊虹书海'], ['wxb4038c4fc34e0b3b','1c70073c4938e028cdc8ac98a7a93139','翔鱼书楼'], ['wx22150e7f8edfde97','def7d008ab14f944d8375b988e42e6af','沧翰文轩'], ['wx8a01cb8fdf8cc5a4','85e08f18836bd27dec430e5996e5f2d1','亢龙文库'], ['wx304feb52e335e3ee','c69dc41e5eb761f1a79c9b7755687ebe','崛天文海'], ['wx95f0632827f100ab','f67e7aaa33ec22365f36a3c59b4eb616','龙腾文海'], ['wx2149d03f71fea942','38544e0c420f430736c76aba5cd980d9','至尊文轩'], ['wxd3ecd10233040bde','fbaf9e14c5248049c6a04580b32643d3','天降悦读'], ['wx3897d09b26703343','102d3a3b9ffdd03c5ea20759f3bfdfd8','空亭文苑'], ['wx1651fe7bcec5506f','f18e6b1a88ced46dd4725ebf19af54b3','南菲悦读'], ['wxbf2532ad28852162','e35815dd04ca82b19fe0032615a8f828','飞鸿文海'], ['wx884cd06da789ad1d','b4a7b874393fb3fc823d86aab5a9d10d','霜华文库'], ['wx9e2e5523aa057479','328133739cd53ff14c2c216b9d08fed0','洛书文海'], ['wx40213d763f355ea2','928889e7779587246bc8f9ea0b349098','蓝翼文海'], ['wx570ae8da3dffd0bf','39d8481897c4fa1140131d4eac5f6ca2','雪松文库'], ['wxeffe41f4158cb6b0','7b134e3b9e9a399dc4de638f83dd6811','尚城文轩'], ['wx13483f19640c30e4','094ed9105507ce86aab7e1913b752214','白麓文轩'], ['wxf0d530dd4dbc8db9','17cd1eef872a19467c7cf0a83673640f','轩和看吧'], ['wxa2407d8a08381289','d50298152494a6a43b1b02106dda4e90','寒熙文库'], ['wx2c8d70f36136a013','853095237491eee4bda8746765e1e363','湛蓝文轩'], ['wxd3b87d32f5abce3d','fa9a31769d49d08e9bf03f9c9717c569','鑫曜文库'], ['wx46fe6ee51b963f9c','eb9f2090b45a981dfe8ade714dc40b59','海域书楼'], ['wx3b7b8061d81141e0','4a3a7f4d6c8fd3df9ed043bd15ca4583','沙逸书楼'], ['wx1d93ba5789bc01b6','1623b1097d80b1d263e7f0a9007fe68d','繁星书海'], ['wxeb15430c6da2c820','f8b68c17691c0e7e01999336a94339d7','红炎文轩'], ['wxf508c3274f2a878b','fb344f878af87e1aebaa4e17175154b8','阳俊文海'], ['wx3822b9f2f12c5b1f','c75d95654b325532a454ac1a929eaa3b','陶轩看吧'], ['wx5dcfebc31df0f9d8','9ae9d673ec77025eac87409a53dbd549','陶然读吧'], ['wx4fc9904940019b8e','09884af00def9ab419650113f318bac6','沧海文豪'], ['wxf3f6c6be20ec5e90','0ed17b9fd6f4055689cd4568758e4d84','青橙文选'], ['wx54c6a3971bad27f0','587ab8fb668cfb89c863e07c4cdd2452','暮风书馆'], ['wxb3b7311c69aa9a43','fe3a4f501337c7e39a2a41824e518c8c','霖羽文轩'], ['wx6e9413a58ec2ab1e','30c95958ed12e56bdbec9b8fad7eac58','鹰扉书楼'], ['wx24e1628d49781e28','a48bbd976cfb3f835f76e2f57fd06ed2','麒麟墨选'], ['wx7e38ed29ff360f2b','73f9e87c65d24a15fbbd65479516d840','晨曦墨轩'], ['wx1114e54979d12333','fe705f60119b358294736ff2e555692f','攀登文库'], ['wxfe8749c3044b8d2d','61467d2c5c503b33c786f5064e3771e7','丹墨悦读'], ['wx82b4b5e3f9589de4','479813f66d677024f725e29f66c6e888','青霞文苑'], ['wxbbad1552c91d8d6e','a1caabe1928e533d8a35b42bbcc730f4','桔橙文轩'], ['wx953faa0da62eb412','f4f7547d74c79ef159a77e3f1212253f','青峰悦读'], ['wx57c89ffad22113cc','e7d242c869da2854679d43fb56d38b07','悦苒看吧'], ['wxbd0142a772b75b2a','e99b3dc5716ccfe9b41e362a95fc713c','渲染悦轩'], ['wxccf1cca18bc26221','99edb5b520631ed2966f83f32e859aab','书剑文阁'], ['wx6d51019665c19299','3591015fe80e9774f7c18fab9104454e','承泽文轩'], ['wx714c483cfc9b285e','23220066bc8dadac98bc2f4c80427820','瑞祥文轩'], ['wx89edeeb729a6657a','5697014ff525360d3fc6c0874f6497bf','凌岳文轩'], ['wx771b42ff66137a61','62f5a0ced239b57e80bbefe8552fecd3','天武文阁'], ['wxe23dc4fb431266fe','be57f739f06394110a7c6828f2aedf00','屠神文海'], ['wxa5debf9bac972190','9d8c0c2b40f469c509ee2c6615bfa287','飞羽文苑'], ['wxc8f0716e28d5b722','75770a89a1928b44bbaf715137802d1f','悠然阅吧'], ['wx80af64b65b3e4fcd','5146ac55edcd61c152806f6ee8221263','心心相语'], ['wx4cc91dc73835e0d4','aa8fc53505ac7eadec35c67e90f28f66','绘影悦读'], ['wx7547d205d5a2d46d','a733ee469038b0a205a8aeb1ffe56428','玄远文轩'], ['wx98dece804d653db8','126065bb258f0acf6ad87033888422a7','宣城文苑'], ['wxa1f24f71bf67c48a','74cc3784127ef2f28b2a17cba7ebbb16','秀丽文轩'], ['wx078701fcaf7615c6','6540ec1b2478308b4403861733e9dcd3','水月文摘'], ['wxcf5309d88f0f519f','06812aafc0cb44b91a05a876d407c8e3','兰苑文库'], ['wxcd3ee046f0dfc122','acfefc564a076b0147ca6b9dfa0548a8','竟海文选'], ['wxd723ebfb628f9472','1ee45de3d1cadbfef461874a6d920c6c','庆昱文海'], ['wx6c0073d433e5cbb2','327295d86d16f936a652bee56da85ada','龙潇文阁'], ['wx7fa2126aae86a60d','5329a8351e8546e94e034d1ab7b20409','宗越书海'], ['wx6eb63f8fb1bc24c1','40129eb62156b68946a354546a117cdf','千鸳书楼'], ['wx317351b91bccfcde','c2a5e97ee753bd4dd2ea1d9b512644db','萧笙文轩'], ['wx140426366475ffcc','ad1df79e9ca39bb46bd0c154b6f9203d','墨亦文海'], ['wxc3e06c34eb1d5230','5de5f892bb13d699f9b356ae534d352b','达浪文学'], ['wxfa366b056d0b155b','630464c628f8ff2b97223b74b1143142','微光阅文'], ['wx06f235881c5ce69c','51051b917004479907e516bb9efd57e4','傲龙书社'], ['wx9ea66e69be72833f','7844a4b2538a43b2c58d9b6aebe517de','天降读物'], ['wxddbb496c50324479','0bf38761ed664187b24a7a195152278c','霄雄文学'], ['wx4357b61cf451e8e6','3d18c01ce7ca8aa0e1348995141044e9','如阅墨香 '], ['wxbf23cf0de8e7ab79','b9f56d4da0d77cb07f0af93e09d94378','阅胜文选'], ['wxd34d4f3d30af036f','ab0e60dcf4f93c4782971676182044fb','秋霞书社'], ['wx19b8b8cca239f2cf','f50a7028ffb9f364378a416e69f64827','枫林文选'], ['wxdce55ab3446a5492','fb6089a8beb968f23d77d3d1a36d1f94','奇汇看吧'], ['wx35a32327cd198e8e','a45b9d92cceb701c789ac5fb9b87fe6c','祁苑文阅'], ['wx1a4a77da279fb0d7','7b4e0c02fe9044b9df0e8076e719095d','追光悦读'], ['wx0b9fe893f85dca18','4cbbf38ea433e6d4fb5b45830457217a','冥影文海'], ['wxf395596b74ef774e','c3ee6d7b0eb68e73af1306475f813375','莹悦看吧'], ['wx32cd9f0b0c936831','675adb52ac20c94500db46247005695d','兰庭文鼎'], ['wx8d306e2cedb3c4e9','90a573464b4fe44d21ed74fa91e3b571','若汐文海'], ['wx84494b253ebd1b8a','394f0224d8b14508b691e461c2f0d1c5','青云文轩'], ['wx2a48930febe11087','4d82176af99a7418444eb682876aa6bd','琉焰文海'], ['wx905bfcc0a20d1f4f','fea870dc97b86f4fdd90de28df4b2ae6','宏宇悦吧'], ['wx0fee286ea9c001b1','4bae7c08fe27a0f80c097c90764cb439','虎啸书楼'], ['wx88635d1887122d3e','9ab474b321962c173d27aebd02812bbb','书墨轩楼'], ['wxdc37b6d0eddfbd30','090e677446be354418abe93ac4d6b5c0','暮雨文选'], ['wx89fabfa853592d10','ad96b9c27d605deebea6652c9083d0b6','鼎月文苑'], ['wxb53868e3547241c7','61d37dfba70b70e7af9425471fa9564c','锦墨书楼'], ['wx8fece930302aa457','6e806cd4092263dbc22bc84063cb3747','名炎文览'], ['wxa04c0961a2cc1698','113076e6043064fa7e6464eb96c7120a','神龍悦读'], ['wxf4001b4908497839','b98aa0a122b333a1d6cb1214ce624707','巨龍悦读'], ['wx20d226289c0a6bbf','123355a76eb6b6d2d5a1237a4923ce08','豪金书社'], ['wx11437220f617f22c','3100a2de005aae6c50f57db05da20c5e','侠客书楼'], ['wx56109576bfece0b5','0d72b0772045720b98c95a9141b4a784','尊圣中文网'], ['wxab4951d0fc344810','59045a592c1608ab53e2f790385f4ba2','绘色阅读'], ['wxc193c06f48807038','fe191753ea83d887429f6316431d9e98','西洲书舍'], ['wx1e8ffb8ffad4131e','8bc5cbf5324a74667b142dd3bd95bde4','鹤鸣书海'], ['wx05666232c7e2c0bb','5632fcd7381ccd23e68b207a1621677d','倾尘文轩'], ['wx86378c2b62add91a','2b222821533ba501abc647ac4420107a','桐暮书香'], ['wx9f8163fa6e4215a0','86ab935504dc5b04f0f89b7a918abdba','聚金文豪'], ['wx44db5e64aa93ef18','ce310656fafdaa467cf415357e865ccf','华亭文苑'], ['wxb52ae4bf50d0016e','53c2b5391f50cdcde266b57a7d3dc3af','浪涛书海'], ['wx4604a2caa195228d','213d3a61a2cf3bcd41f112e38863136b','非烟文苑'], ['wxf423416471dcb397','8a08411fe094ab144271e051a1d3a8e2','胥渡文学'], ['wxe1763c0e21c900ee','bfd2e575cef2835c2689c2b5f66adac1','宇轩阅文'], ['wx172accb3ee2fac00','7e32a92fe1d5b0483fbe3d8318262701','天域看吧'], ['wx0cde80e2f7f3f5ed','2932f5bfa2a58cdac3d0db4e1697a82f','金豪文库'], ['wx60984cb3aef3f397','aea6164b07d9a76f05249d0d42e67fde','苍穹文轩'], ['wx9f891a1af934c8d7','ef80ca497dd8b93b755ccf6298fc4352','冥悦文选'], ['wxe107cd7d0452fc7a','6eee1e879e3a7ed63626884a9944b7f1','晓凤悦读'], ['wx9cedfcc77d0f755a','26bd17854d10935b0df2d9ef68589f72','破霄文轩'], ['wx9dee6ed4f2d97b06','5f7cc9313b957e0382a1cab0035e2f1e','黄金阅文'], ['wx9cf564261d19908a','5e59928b15c391b611af9b30679a8398','金银阅读'], ['wx1154626198757a6f','cdab994a5bb375976818953c155f1526','星际书馆'], ['wxcdc50a79fadb9eab','7b6778a375ad3f470db48618763825b7','浩荡文书'], ['wx4533631ae7ced2c0','178f5effd381af3d1b2c44291a30d669','墨轩看吧'], ['wx19d2c03abfe673b6','d1a81344b33a30199b892d043ac13b62','鹿鸣文库'], ['wx48214201116e63d5','72c3aa91734bad7b8a1cced7e59a1f19','锦溪书楼'], ['wx48815d9f3da74baa','1a002219a698d96a7d7566a3ebc4c912','卓越看吧'], ['wx5a06fe0e5559c110','98cb7ba68ab3962453f9c4ad3bf2b3f3','富豪文选'], ['wx06d257da474651d7','556ef2efde3ae5a5e4b5230609066beb','魅力书楼'], ['wxc968c78da2cff718','797d166541bd68a21c9ba27268def1dd','新阅文轩'], ['wx979f3cdcb8d0387d','1b50605bb05212eed2951369077d49f9','源景文海'], ['wxa6ea400aaf1e625a','f340ca594cd408e7f084aeb963fab46e','舟乾文阅'], ['wx25e6564841ff234e','0be2ea5c6bd07083b2e7dbc9c5994f8b','亿万书海'], ['wx289d9b400d93abc7','ea95d59a8cf0bf512958998e8e4d3a22','镜月看吧'], ['wx5c39f79d7aa4c795','78901d82a9331adfd7539d76de4ce93c','飞烟文阁'], ['wx1dfd6dc6a0932174','224de6067393e2254684add5169c7c72','罗刹文海'], ['wx397ea64589f28ab3','c187afcf2cfca08319d7dc3b7cd6703b','神光看吧'], ['wxb862e7d0a49f5eee','642b6be178a961f8093ecf79df00cbcd','霓光文海'], ['wxfa81fe19acfd23ed','1b638245bd4be838dd3d002b09194051','山海文阅'], ['wx0c83840b0cf0fc7f','8b8ae2c8306bbb8ba7b6bea2dafbe0b0','天燕文海'], ['wx1be8b5ecfcb1ecb4','178198bf895c3396690c06fa985801ac','焚月看吧'], ['wx64e1834d06642ac7','f23fbd9092fcf997c1b7644c7d50175a','跌宕书海'], ['wx2bf914d2b563ce97','2202e845d72cb8ceb2fead5ff89a08a1','银鹤书海'], ['wxd74162872446ed94','e7b8d4ebfd016197f78f90ddb0dadf95','无涯文海'], ['wx89c60e21a3c2d387','a3d225b9259a3418376b9a194ac2df9e','孤鹜文海'], ['wx46d65fc8a154f853','7a5eff54af86ed3dff55b4ede0a17c3b','凌跃文阅'], ['wxe864390ce65bd173','70a792d119044c0e3051ef028532e0c7','零彦文海'], ['wx17c58e708a611c58','04e27a5308376518dff004322511c61e','羽申文海'], ['wx2729f577c66bbc04','89bc6f6184daf8fe00f329b34fab97c0','龙越文轩'], ['wxba29d397b32f7343','46d44f218b7effb13e1b00fb2df60401','桀骜文海'], ['wx38d5aaa8492dba1f','bbf154b2ab62dcaccf26eaace987bee0','星云文阁'], ['wxe349c2b02efdb479','795b977622033607ad4f2ca34a73d8bd','万烽看吧'], ['wxfab6859312782ec6','441697d383188c5ba053e10866c7998f','涧渊文轩'], ['wxd810c3efae7b2edb','05243499273e42db2376467d41d08184','玉羽书楼'], ['wx8915aa6f4f3c5339','cda45286d96733f890c52c3df7dcc574','灵绝文阅'], ['wxd4dedfcae3bdb990','6bbc610b220957724f07fc23f8b99316','龙庚文阅'], ['wxe74c9ffd51829a05','98f0d5e593a97d10e1cac59f881625e8','澜源阅读'], ['wx536cbcf7d1e78057','8e2b0d3c8d3bf10e49ec2d48d86b5b4b','血阳阅读'], ['wx2dc74fda3ada16f9','204c6b62d40eb9941392bed1c5cc6725','绝地文阅'], ['wxa30505d39b8d89fc','f88f91ac49a1da1390c86e582b92b594','森罗看吧'], ['wxf2f90c88adbbb218','a922d9013141b19e7e7c6b238df118f3','冥影文库'], ['wxd1ac6d64c37d0890','73737df94e95ee22b61cf5babfb64db7','大河中文网'], ['wx37a6cc05d9cdfab8','8d88a057e003be1f19c34d18e24be02e','林溪文苑'], ['wx75b868aef981eee6','3921e1fef0f3a5a234c6466f3044206d','慕云文库'], ['wx070f6624f6e8781e','7ff56bd04d4d03dfae3da852cbdb9942','鸠鹰看吧'], ['wx582f8907af9adb6a','df542cddd6729d092b4e20d890ff11f9','苍雷文库'], ['wx0248e57b0d0db521','37c0ab40d4964832ba34424956363c33','玄雾文海'], ['wx6ae643953e9695a0','8139c7e2c2abbf2cb7da5a1b970392ad','傲雪看吧'], ['wx30e53121ca884fd0','54f079818722facd2b2ecb32180aa4c5','瀚枫文轩'], ['wx82e98a7f7052f248','dd86499528263e514e28cdf9bde9676f','风浩文轩'], ['wx70bb764dae5cac46','9a2c625386865698a0df5cd2ca2df95b','鹰鹫看吧'], ['wx3eefc598478f1785','75e9101622721b224c04a5bc5cb193b3','盛浩看吧'], ['wx1ad2212d1511296c','e6b2430b10b0d04e26a38218cbf9df31','幻文看吧'], ['wx24e2f30a7b8b1d4d','0764744eaebae7ce0acaedca17e0e0d0','碧落文海'], ['wx9f4393899a593629','1d9fa9f5f83efaf90d70d94bae62d1f5','孤鸿文阁'], ['wx4beab9d80642cec9','c9eb94f454b4984fdc95bd51639dea01','苍空文海'], ['wxc7b2b9e4ffe60666','1e4b2d2628d5f83765eaae82757639b6','零翼看书'], ['wx2225ea69fbca4107','d6c580a886f06e32fb670fa13aca4894','龙镜看吧'], ['wx5fbe5b591c71767b','38211fc7f8a8c36df96f7890fba9bd6b','零羽文阅'], ['wx0f02ce8f2e51263b','b2929353693604d436aed9a94dc6f7e8','白鹤文阅'], ['wxd4ae81b1f8962266','040a56af477e08530def61558014a734','霜墨文阅'], ['wx4c191210fad011e5','fc3d1114349728dfda561ebd39536e4a','灵蛇文海'], ['wx93ead775b89c0969','00fd1341984b8e109a37c70a0a837bbf','烈光文苑'], ['wx341a3a6b9727691b','66461c34344db8ddeca560b4c6fd17db','残枫看吧'], ['wx68b363895aded2ad','c484dbdb6380f27a3c35662199ea95ea','极光看吧'], ['wxbe656f1ad53ac0dc','1be5e16b71255376ad93f13464b1694e','雪镜看吧'], ['wxaf4dc59279b10fc1','a550537f33ec83978bf684f8b22a6a79','星越文海'], ['wxb1e586d0fafcbb04','9b7faf0542c611ece2ed88ef6df37d3a','冷锋看吧'], ['wx4a2c86a646fb7944','47a53157c742ee569eef98068c480193','天极文海'], ['wxb2e0c4d3d0c88136','9ff404bb9ca7ac94d4a47555d606a4be','惊啸文海'], ['wxcb6fecaed03d69f4','408c0350c29567c9fc31e66e7ffd3f44','云中鹤文阅'], ['wx55f9e67e2267bd04','fb3ed621ddd06635e927ad10c8f4f9b5','夜鹰文阅'], ['wxdac8a99c3bb65b8b','500f64791db1240cce93f96be371902b','雲源文轩'], ['wxd47b18cb491ee4af','ee8a471625b3986a035e15b37a5c0a38','云龙文阁'], ['wxcbdd9fcd3e739482','b2af13f25a791bed201aef9937b21ed4','刀锋中文网'], ['wx9f5f5dbaceb842d1','79834727e26e949e0462f48c6ef733ac','思羽阅读'], ['wx2cce3709da148106','792fc3cc8f70868bf9414d48dc38f2de','万枫文海'], ['wxb31035d69bdb9969','823a4301f0eb15dca29af8b7d603ae41','浩宇文轩'], ['wxbe6644b629392a1c','578f08b3eebf6ac1636e598bbd037aec','千峰文海'], ['wx06ce307689c79c80','6206d85120c488ba4714e12b5d0a9f52','旷世文海'], ['wx1e746c030ed68bdf','2e15a3d5274745afaf87f7e9a732c11b','云飞扬文阅'], ['wx8b4eefc227bbeb63','f2218aa64bc594880c3a844764d30e0e','南三月读'], ['wx000f3acc9b3240b3','9734c82b2b736441456e9a9ca3b88a6a','老顽童悦读'], ['wx5af48f3cd9417f61','b64f6687b9fd3b11ef11e6e13e1aa475','虫洞文阅'], ['wx9c624def551ec279','347f5e68c4b2a160d475e51d2fac2525','摘星文阅'], ['wxd3acd3a0cd6e13da','29373728e33de078a9d1868313bb06df','紫霄看吧'], ['wx91208c6c8651a97d','92eee2c2728632aec32fe8efc5390e80','脑瓜崩悦读'], ['wxa6e7051e6347d49a','375f4d8f89708447da9b41e11a2ca571','有红看书'], ['wx899d2905ddd2b658','b4898032252ef747053201a47b9ba67e','皇冠文阅'], ['wx74ee023209e85028','5c54adaa4ecbed9b58735035da2c20a8','川穹文摘'], ['wxef40919bfc698437','2ea663abbe119c8343ef3d9af95a7b7f','风魔书海'], ['wxb3ef189807c7b55f','c3121c2ba99dcf9c1f91072b6358dd95','辉凰文阁'], ['wx36518b813e815ce8','f04ecd6420d6213f654ac5a598e95356','逍遥游文悦'], ['wx0693de558b30d090','9672c178f1561eeac84b635bb66093c7','探花文阅'], ['wxfabde4fcbff99a35','a4522fce835497f3314d014cfcbe2e44','浩天文阅'], ['wx07ec5f717ca76021','2a3e79ed7e224c2bad5f343013595c6e','凤澜文阁'], ['wx3e056a915cc86a2a','e0826b09b63a59e32e3aac781840c331','苍晓看吧'], ['wx43161de5974e4a2c','2f736dd02f8405f03769db33cea5e4be','烈焰文阁'], ['wx431dde44c71fbda9','ca56abf7c7c40ae14d7f95681b7856db','竖中指悦读'], ['wx88a9ef7c7e5e7252','8f9213166941573b4430da5cc473091c','新世界阅读'], ['wx270e41527b9cec1b','4cd8b027cf9501e095501249a85c68dd','杏野文阅'], ['wxb04176a5e864af40','fce94bf634c71725a2288cfb75c57eb7','虎啸文选'], ['wx2a62deeaf293ed7e','26f284aacdd580326083b72433e6b373','傲中原文悦'], ['wxc4b552e3ee774492','0acf96b52d27fb5f7086a27e566448f3','飓风中文网'], ['wxcb514df0cc2bb15d','5059512694cc825150d797307f8244c2','硝烟中文网'], ['wx1347403164b74c5e','be2ee360ac1c72b05ebff07baa6d8b4f','纹龙文学'], ['wxbb92a1a9fc89028d','f10ed64489105fcf6ada1dd36176e226','狐金书楼'], ['wxb2a7753ebaad4088','e915ad3da3d8387e747949a869bd489b','新势力悦读'], ['wxff3c72d37f83490c','e726f9a19b60f937f1021233187149b0','日不落文阅'], ['wx9cfcecfcd6fc89eb','55220add8f2b686fcffa5bd02a3885fa','赤阳文海'], ['wx3af2120398a6eb23','ac15f09480df9ddd0d55168b69aeea3e','清风文海'], ['wxbb3a6d83d03573e5','508fc5d9751eb84f146b01c46f875121','升龙书海'], ['wxc638119f07060263','d981603d80be9943aa61b68de804a264','盛凌看吧'], ['wx99483ce66741c735','71507e653c09fd060ae47b4c2a509107','苍弥文库'], ['wx6209a36a9741e854','83e86eec0648b8286ebcb859aa6a547f','黑衣人文阅'], ['wxe6c389c07c4aa955','c8273bc1b0ae51c260221e2489315465','霖昊文阅'], ['wx61b7785e9d52a598','42cddeb3555ac75f27d21199fc5e6bd3','却邪文库 '], ['wxbc40940d0aaba0b7','86fb77e79098188fc8609878d51b4c87','碧炎文海'], ['wx3d947be2dada22b6','44238bba94c8e89efc2b7f1b89f34141','逗你玩悦读'], ['wx30fc405ccd8ea290','3476433a510fda9f76e1a4139a18d0b0','惊鸿文海'], ['wx898240e37f46daae','1157842aad6b02d3ab4be34865d7abb9','霄浪文学'], ['wx66372dee04fd40be','53e923fd64e0a6af8888ae10839f8225','鸣城看吧'], ['wxc2fbcce9d7e94649','8cffabca6f8b3979e3cac8723b431672','飞星文轩 '], ['wx86b93de6f7d8f182','51fe428122d7bc76209c8ce0f26fb363','冥真文轩'], ['wxad612926b23c8fd3','96ce0e2eb88364b6513e87411e3640e8','青葱看吧'], ['wx12723c7021635167','b3cc3d1afc1373f1765cb4f36c646e1e','凤情书阁'], ['wx7eaa70313edf27c7','592511986a3b68f90e00b7f2b68cdcbd','夜情书房'], ['wx5d15d7ca0def2b80','dc5af7f71f43e555d6d35f87cd66e6a9','雨尘书阁'], ['wxf63ab7442478bac1','8e1ddd02999cd8ebca13c8585f606d5b','日月书房'], ['wx390b43b019e73324','acaa9f734730ba0d8d6073c48bc7f910','玄炎文苑'], ['wxb5be29791c51828c','38e07a5d4353990dcc6254b04ad21b91','蛟龙书楼'], ['wxd201eebc2c20b0c5','bdacc7353a064183e28e282f4ff44703','满月文阅'], ['wx81b3112f378fec2a','9b79be2fcf0673bb43077b31479bdf0c','雁南飞文阅'], ['wx631af0b58bad7837','8def9d6ad7938b119210ecbaa7a67349','银心文海'] ] url = 'https://api.weixin.qq.com/cgi-bin/token' for key in key_list: parameter = '?grant_type=client_credential&appid='+key[0]+'&secret='+key[1] list0 = requests.get(url+parameter).json() if 'access_token' in list0.keys(): access_token = list0['access_token'] channel = key[2] st = int((time.time()+8*3600))//86400*86400-8*3600-86400 et = int((time.time()+8*3600))//86400*86400-8*3600-86400 c = get_user_change(access_token,st,et,channel) if len(c)>0: mysql_insert_userchanges(c,channel) else: print(list0) def get_user_change(token,st,et,channel): url1 ='https://api.weixin.qq.com/datacube/getusersummary?access_token='+token url2 ='https://api.weixin.qq.com/datacube/getusercumulate?access_token='+token t = () start_time =st end_time =min(start_time+86400*6,et) for i in range(math.ceil(((et-st)/86400+1)/7)): begin_date = time.strftime("%Y-%m-%d",time.localtime(start_time)) end_date = time.strftime("%Y-%m-%d",time.localtime(end_time)) data = { "begin_date": begin_date, "end_date": end_date } l1 = requests.post(url1,json=data) l2 = requests.post(url2,json=data) if 'list' in l1.json().keys(): list1 =l1.json()['list'] list2 =l2.json()['list'] for i in range(len(list1)) : list1[i]['cumulate_user']=0 for j in range(len(list2)): if list1[i]['ref_date']==list2[j]['ref_date'] and list1[i]['user_source']==list2[j]['user_source']: list1[i]['cumulate_user']=list2[j]['cumulate_user'] list1[i]['channel']=channel list1[i] = tuple(list1[i].values()) t= t+((list1[i]),) else: break start_time =start_time+7*86400 end_time=min(start_time+86400*6,et) return t def mysql_insert_userchanges(data,channel): db = pymysql.connect('rm-bp1c9cj79872tx3aaro.mysql.rds.aliyuncs.com','superc','Cc719199895','quchen_text') cursor = db.cursor() sql = 'insert ignore into userchanges(reg_date,user_source,new_user,cancel_user,cumulate_user,channel) values (%s,%s,%s,%s,%s,%s)' try: cursor.executemany(sql,data) db.commit() print('insert userchanges success',len(data),channel) except: db.rollback() print('insert userchanges defeat',channel) def start_job(): get_zzy_user_changes() get_other_user_changes() start_job_time = '2020-07-15 08:00:00' if __name__ == '__main__': scheduler = BlockingScheduler() scheduler.add_job(start_job, 'interval',days=1,start_date=start_job_time) scheduler.start()