qc-dgp/dgp/userchanges_daily.py

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()