python_files/cppc_python脚本/服务器脚本/demo_reciveElemeBxEt.py

# -*- codeing = utf-8 -*-
# @Time : 2023/11/13 19:38
# @Author : Clown
# @File : demo_reciveElemeBxEt.py
# @Software : PyCharm
import json
import pymysql
import time

def linkTomySql(host, passwd, db_name, port):
    '''连接至数据库返回【db】,v2新增local_infile=1 打开文件导入权限'''
    try:
        # 本地连接为：localhost  服务器连接为：124.222.188.59
        db = pymysql.connect (
            host=host, user="root",
            passwd=passwd,
            db=db_name,
            charset='utf8mb4',
            local_infile=1,
            port=port)
        # print ('\nconnect to mysql server 成功')
        # print ('---------------------------------------')

    except:
        print ("\ncould not connect to mysql server")
        db = "连接失败"
    return db

def reciveElemeBxEt(post_text):
    brandDict = {'91064057': 'JXB', '99731295': 'ZXX', '95911482': 'LLS'}
    host = 'localhost'
    port = 3306
    passwd = '111???clown'
    db_name = 'hexingxing'
    db = linkTomySql(host, passwd, db_name, port)
    cursor = db.cursor()
    sql = '''REPLACE INTO eleme_bx_et VALUES (%s,%s,%s,%s);'''
    # post_text = '''{"name":"eleme","ksid":"YJYYMJMTA1Mjg5MjA0OTM5NjAxUDBrQ0VvYjBQ","shopId":"99731295","bx_ets":["dejHri9I8w8QBNRhlWKQYDy83Iz9dXt54_nJw3dz7CR6JwCJvLqysT1J93Brq8fv6eQpYy6PUC55wJ_de1qwpKieLUuEb1ff1XLRwHKkEg5Dy0eByCxlFT5kPJOJaQfRUweTDoBCd3tyZSEYDWNJV3u8PQ_Pd9tW4QA34mBIqaxa6TkZ2cJ4kiyHkIDSigErKcYkg9RNp9IwKjdVLCmr4CvhQ-uZu4pIVdyRb4gW8d9MM3uE4uf..","dpjDrs9juZ8beaRcRSKb0myTLBz-cjt1b1n96hdazQRWkZC9DdqwZO19MhBZjRfpwEQv0r6NQQ516-_AB_qyHpi23Fuq4_fCNjLO6nKMIG5HWceXWQxGCO5M5-O9_CfOQZe8vkBfhhtwsWELvSN9fhuT5C_Nhtt6bCA0bDBjjNxzwT8qX0JUJMyDJBDstGEZncYMTtRPHtIynXdF3QmZbQvcQqur8VpjfLyO4Vg6uL9k9huqblf..","dHjkrs9Sza87HZRl57K740yLQCzxPbtCY6np9HdUuIRXyaCp2pqei91pwHBExJf9MUQJ4z6FLI5C98_Rpsq2ediyUeur0sf1GbLd93KHKM5MJDeWJIxhd95HR8OpTBfdLaeYXlB5FHtet5ETX7NpAHuLRB_FFTtBYBAuYcBSxwx4MT8qvmJaWGykWCDIsMEEEcTH_TRVeTI2EfdNUImEYIvlQSuq72pSAKyd02gBzK9D6HurYkf..","dl_wreT-aPUaAWJ_2hY28TEbqQY9rUe7nZ9XisfD1dvG15FV3TCwmV_X5sjFF9j6m1NOLE5Aidb1llUV0pAZsAvMjH4HNpQXCV1bgtWfENI1GKg2mKX2hK_VMqRcitF9h5EC61Lvo8wWuz1O6FqTF8OjMBZekE27FE8N9PYAUIL4RTrC1lFaXn2lwpbTk2hTL7C2Lq0qwC-MEzpEoqbe_1JlQtDvtbpfkGkm0hApTLNUTHOtwn5..","d1AXr7O_UoqfiW6TgjgyVBXGK2f6fnGE6P_9-FF4WsCv15tkqCz2Wiz6fFjy31uDWCN12hsNbsn051t24iUYHSIRwN_bHinGglp6q30D_m3DCNKe7I3c_1zDEH8LgIkc_51cs1nEYXleuEfG6sGSTXy9UpjqYDlETE-Dsrne3Ox6kTkg--ESTFi7Z7PU5xqUwqVbGQ_xjMLfVabkNZ6fvtI5Q-VFAeYgCz631asEP4wgIDZ3QsC..","dqO2rdfL8jhqF4SjptfNaHHsKwfAG6nIjCs1SFYGlijDlq3wbHLVISO1GFvyA3vfIEgv4189SiAX1xhwQgb4oojcnTclRgd1cSTs7h-6xIpX5GNNIGxNfGOwW57MSh3AfqHWkECOsDiC_XTvksDxAD__WaMP61mIA152yjf9YNCZNT8Wlx3qHOmHJgAx67Ux448N45VaJZWcxXIzs5APuEShQKqOryI66KrgQtbRzMgrzT_YJO5..","dnAkrn_7ULWSkKSkC0CSa7uK7GkxFu1BTHFdv6IE3iSfeLKdwwcFmetd26LUt2xODTpRaYTe8i-Bv49JJncVyNNPz9yzgnx6cuBpv_Ch-B-GpW35pifHRe-hd4sdYMxp8L3x6fLWP61Fxcht60idO6yKdM9ePU1CTMjoT5L7tpfqDTk79S7ZBCulBG4QjBhUrcXFbUS2yUdVrlIwziVUTiblQsy4QJQ7OZupgJwCUZ_cX6yzTXf..","dDp9r9glx20Gn4e94PhnuukYn8iHWdKwYF-7nZbgGeLp-UBcSqPM9ZTw8ZfjbE2v9eYR5cWcneQv7EKGiONsdysfDiZ1fOsvk3ThnNcZuwyvJ3OGmVhwcn6wKC2cSVWvcUXxr4DoEh-NgtgorFUpbh-Jt--jEYxwbsWElzDob6maATSsu8HILRp9nGG0Rl4eVPJ5X1Q8nweYHmjO6at1JqgfQvJkewFzraI01DnLgS51YxZHiH1..","dlvBr397_y4CK-18Lviw5KflimX5FeMqeusJm3eU29BpF8TMSLre2wrWP3bwTToH2Lw5WU_Pz933VTTe7wEL9JQOBgsQ9w3lLzdWSFmHU2nHNgL24pnhUTrHsE-YLplhU86hET3quxk2YHXle9Ms3xPJ_IbEuqkq3H8HEk32T_YWvTWgmWUs33g_IRy4VX44BA2QddsKrZKC5GjMCM1Ck6Q1QS2VlnxuNl10FG_qfcNuZqa0a9C..","divHrmsQTB5IXC7HG2BILJo-0Zl9dy6WUUeRyTQr_N719BLRpgDPS3TRJTKzE0YAW6ddLXty4N8WyDOp2FDNviwFY_PUQFYX5yCJy9BlqL8cw8nCwNXkV38lND_RzaYJ4BntHxKBAT6PrqHxH2gRFTP-NaOyAH65UabnU-KQEQXZWTkQeRSqMKohMZq7oLHzxffPuH7wvHpNxrQ2YN2zUNjhQqPag7IQFGoJQ7N5TGsGkTPUUYf..","depvr9ghq40cI2evYrho7kkTIJikXKK24E-QINb01ULJreBGoVPDwNT2zNfs0F29wUYdlmWGIUQ9uFKcstNjFzs1XGZfcts9WHTlIZcq7ay9yHOcjqh2fh62EI2GoqW9feXt-2DnKn-V_Ogn-EUJ0n-pZR-sKvx201Wr5yDn0_m4VT5j7JHSU-pvIiGgPo4yA5JCDsQLIaeTBcjAMwtfyVg1QXJHpaFU-wIgG0n8_55f4AZks31..","ddvWrb9Qgz45ER1LUYi2ldfhscXCPUMZpkspjHezvTBJdJTDopryvarBRHb2a9okvpwCke_F8T3uA9TyuaE8w8QAHMs7wa3hUydBoEmkL4nkOMLwYLnlL9rkiF-TULllLJ6lK93Z7Akw43XhpTMjQAPpgCbr7VkZQ38kKu3wa6YB2T-0j7UjQHgbn-yaAb4aHA27FKs--NK5lijDhg15W_QfQj2N5hx3Oo1gdi_ZcmN3tVagTTC..","d5pyrdXTbYHrGm7S6_XF3FhIsGXR9O3s-p_CxHxhVabkV0ne8FKPt89CFHA25EA5t3iJu9-pxavWdbHeTZjzqzblZsDcfZpCP8tIYe8BSLdWAwwFtwYFRw9evJSHxenRR0hX23BdKVg1LAtJ2Tc-5VsQviGVp90s59WyDYXp7MBEhTJwVbnrw60MXZv-p-E-uftFuJ2UXg5lSAQ4KJvV437GQ-4dmlQBpQz3T_jA0Niq0ss8X65..","diterNjY3DnE5A5IkwjPbI3SotjdPihjZ315ELvld6fHdvHyaIpFrkt5ALYwGCYCrpMp_gJJE6xBV2nyz1XUKWfh-NmGh1K5Ok9SUQRWiHLBF_ZPr_APN_tyeuWkEQHdNv36ppIRqjGf4m9ppM0KGj67eOgN2gcjGgSeBDjJgTIrfT5Bd2HEJacDH1xK2leK_4JP_uqzH97himCaquxNLp5cQxVRI-CW2ePuzwXOQsMZQN6LHa5..","d2KvrvGhEbccjXEvLS3o_JoTjkMlWnp2UIJQj1f05QdJZBIGifzDy1O2a1bs3Cq9yQAdGxSGjQC9gCpcSiajV761BOwfhi696pOljs0q__r9wpTcIj32Cds2qEqGijS9CBjttXmnxKJV7GGntIFJ3KJprlJsxDv23NSr1Wmn3aD4FTPj_knS4oKvjtggN-Vydl-CHZCLj_ETXAXAk69fwfG1Qk-Hv_UUt6BglYH87P7fUcwkSL1..","dQt2rwsLLmnqPY5jJZjN4B3s-9jASMhIsh11IdvGhsfDhxHw_BpVSot1cdYyOQYfSKMvaGJ9IsxXfqnw7_X4nSfcoamld_K1Go9sQCR6tnLXC1ZNS1AN11twBlWMICHA1x3WHKIOjXGCbD9vHi0xOX6_BTgPXGcIOGS2emj9TOIZVTWWhqHqkNcHp_xxXuexa4JNalqapt7ctDCzjlxP3K5hQxVOEJC6XEPg7ZXRU6MrUa6YpN5..","dJKJreGGnjclxfEJQ73mTRoLxlMc93py3QJ_x6fuRIdviCIhZXzkk6Oyg6bIUBqpkIAONYShxICpaBpl-gaScS6Cp9w5Fg6p9dOcx_0rTsrpMdTlKb3ydpsymUqhZbSpdCjKsfmijLJP8MGisQFvULJ9okJIjcvyUwSqO5miUZDzhTysTlnj0uKJxTg3G8V2Co-1eaCTxsELvvXRy195MXGCQJ-MXsUas1B3PxHY8y753DwD-K1..","dDT6rbTbYR21SzsY7VGedUjcqbbbfdgrkS1vZIUaMNQ9lr9HKEPwMOPXhIXebZlMMEafpK6V3NHgGZ9wLOFTXPBdJs1_XOHc7-KXKpcMuAhMcspygFhGuZPMxLR87FoGur_GoZHrU4uy_CbckNgIz4rvY3XZUYurzCJMo5HybivX6Ty4ZleIzIMQ-yzzGc2zJmU_5e1tnTd1d6fHR1s1eGBCQx4PFQA0cWsul66rOXZ0mYwu0NC..","dr8MrS1_bhSs9HWMVAQs7PlxaToLXR_XuKUAHZBqY9WCXhpAWs0VKI9ABZd4ojvRpGKO7cO2g9JXHft9Mp0F6_aN_ira8pvWdRIvHNQciEJlDrh1D9bDGIJccf6A3tvvghhKy4d61Z_VnY3-yAMAlZrxctt21C_futXiuzd_onbEpTzQky5r2UlG2TVbEE34s5jVUCWe6CLFs8By_944u9fGQnrU4oC_l6lv8oZfb61heZrauqf..","dlYBr3T7bJ2C-rs882GwCEjlmjb7dpgqy71JiQUUwwQpPz9MIUPew9PWFQXwYalHwUa5BL6PUwH3Na9eQ9FLvyBOW_1Qv9Hl88KWIdcHzvhHV_p2aehhzaPHjKRY8eohzz_hraHq3qu2TBblywgsuqrJbnXE3xuquBJHrWH2YgvW9TzgikesuQM_SPz4ND24WR4QRF1KEtdCC1fM56sCHMB1Qj4VhIAuV5s0P16q1fZuqxw04wC..","dBLerNbYg23EffWIDMbP7KnSmsbdvZHjEU65ZQAlO9XHOXhyUKdFqyT5RQxwhdxCqBGpQaRJZ9YBPD3y4OfUtJXhxG0GGOL5dyOSaLJWneKBNTaPqTvPFTTywz5kZLhdFXn69BQRrxMfzqOp9wmKhx17w1iNyaDjha7e62bJ3_Qr5TSwODhEvgDDMOYKyPFKQ8APQz4zM6ShnqBarzYNTBWcQt2RsSBWyHyu4MfO_tGZ_G1LMg5..","dULvrJMhZYDcSvUvT-noQWuTSyGuDEd2aKRQSOX0fLpJEpQGnArD2O92UOjsgd492Lvdhj7GSLB93ddcjZZjP81161NfGZ19BB9lStmqQTz9eBtcsxn21C_2rn4Gnx791pbtKv0n-IRVbNMnKKeJgIRpqPRs-2A2gG7rCJ0nggc4NT-rQy3SzrLvSsigFS2yObYCMiBLSTUTWffAD9OfeAM1QX8HJTEUK9Cgcbh8blSfaVNkjQ1..","dLLyrw_T_43rcjWSXgbFudnIj1bR4NHsKe6CtBAhNTXkNbheLddPxzTCPBx2CKx5xQGJ3wRptTYWR03eYtfzZ8Xlqi0c1tLCFzOITpJBIUKWO9aFx9vFd9Te9y5HtphRdbnXwQQd-AM18VOJwam-CA1Q9siVJwDsCw7yM4bpQ6QElT7WN0hr2MDM6tY-JrF-38RF3y4U6_SlIVB4-yYVaQWGQt2di5BBJ3y3YgfAgOGqgi186M5..","dIlMrIa1QAy6JvriFhF6_18vzuJpXGNjgmCYDSE2LkrQBAnY6rA4xqiYXS3ViEm8vRHT_dgqukojDFMtkDAUWz1a7-WNTDmSAGexD5F0ojouHsL_HkVmlqo0hFZY0omxuALpwQ3s5SN4m3dJwhtYGSWvhoMq5VNbgoqMg_31ixVevT8CM6zyeb8geubfqjdVSG244VrEWVhUSgEr7kfVgk4GQsWFUtU1Gy8xTt6bQya32SWNgIf..","dqhprpt0Shx3ZnCKuMpM4ZRRZsTG2X3E7DufZuqhFcntjmFux3WnBuiEbu2W80f-BcmYAePuZcE-Y033EW6B1Ga7yz_QRWa-2qigZkve4l5-XqM3rHpEP4NEsvfuxHP-PmVJmnADi2uUU7tDmDIt82uxI_uWiI0E88PwViAD8RYF5Tre4sd6_6hKZy9lfwjZlncbJJEAZlCRwU4LpogQX3t5QklmMlBVmoUldFLOUTyQ7Q_iEV1..","dcGerAVAuBdeCFrBHJVz_mpWnrVLCSKXqbZ7r40uRkqnReLr4m3UE6G7O4DZccDQE2TKb7u-rkcINpdrUl4F-Mq3KRAgllh7A6gWz0oSmXHIPu1zEumzVuGry_zor0LLVepsJ2F8ZntbaIgKJWvpcna5yP9aw7xXc7PEWBV-0zFy1TSZRpLep8xmklcpw1Qpba0zb_fPkyy3mIENZ_ca82rcQKj8SZESwvSlUJ4T7oTw7Radk85..","dwhvrpt3r3x0sHCx8ipkbwROs6TlWj3qzmuCslqcC0n-qDFgmhWmeliq4l26ucfte0mLcEPgs0Et0c30IS6XNga_WP_blSatX2iusov2bu5t22M0Snpq5VNqZxfgmnPt5DV9xHAHtqu4Q5tHxmI-uquKE1u6tB0quRPyfMAHu8YVPTrXb6dWashxsr9GVZjrRhlQk-EdsuCO6F4YHkgb2ht1Qkln9uBFxkUGhULRQOybzC_oI41..","d9GWr7GC3gj7Z1wdaQTqcf23IFVBV0Ow9waKS2CPJ7F-O6immX7rJu7IA2qqUW8oJX1QDDZUY7KlRWir0uQRe_EYMya5euK3aMHImmYoT3LodynZ8bLuTW7oncuOabJuT6NutWKwbCRZz4V397OX_CWK3AqybhRw_4ootaKZUJmIyTRVSTIX_2tfis5NRLjNMNC5NjaJxl37cr4mGzw7X8EfQSfafV0hdZwGOrZwlE6hKhsGL7C..","duGkrs45UYyWkxroC3FWa_8p7lJxogNITDCLvWEe3orbeYnLwyAUm2iL2W3FtemTD8H8aLgE8ooIvUM-JmA4yP1zzJWPgmmscgeKv7F3-Xogp6L7poVnR2o3dUZLYkmK8YLv6C3SPWNUxhd963tLOWWpdkMEP4NQTkqkT135tvV2DTJR9szwBf8uBlbCjXdFrMeUb4rqy4h4rGEZzofFTo4lQsWVQ9U5Or8Kg96QUra0XWWPTBf..","dGD6r7MfTNb_ITNAQdtERYV0Z32XfV9yHiZxqmBNDRethtgn-xSZDPSjlm4E_--iDx6bJqa4uRLGc-gZ8PIO6OULpoZ16PL0QZhj-2xi3FKiGo3r0AKg3-Sit4oRQARg3twgn-LyzLJrbc20HR9BUL5xTb4wzUJyUcuinGLr_S0jXTzcq1QBUmTCK9WPcCbPpiX1CvZ9ozn_RkqndlN_y5UCQ-XzP0mcGMNlhkayAH1ciU_lgRC.."]}'''
    post_json = json.loads(post_text)
    try:
        brandName = brandDict[post_json['shopId']]
    except:
        brandName = 'noFound'
    for bx_et in post_json['bx_ets']:
        sql_value = (brandName, bx_et, 0, 1)
        cursor.execute(sql, sql_value)
    db.commit()
    db.close()

def sendElemeBxEt(db,mode,times,bx_et):
    brandName = 'using'
    if mode == 'select':
        cursor = db.cursor()
        sql = '''select * from eleme_bx_et where is_useful = 1 order by use_times desc limit 1;'''
        cursor.execute(sql)
        bx_et_value = cursor.fetchall()[0]
        bx_et = bx_et_value[1]
        use_times = bx_et_value[2]
        json_out = {'bx_et':bx_et,'use_times':use_times}
    if mode == 'update':
        cursor = db.cursor()
        sql = '''REPLACE INTO eleme_bx_et VALUES (%s,%s,%s,%s);'''
        sql_value = (brandName, bx_et, times, 1)
        cursor.execute(sql,sql_value)
        db.commit()
        json_out = 1
    if mode == 'error':
        cursor = db.cursor()
        sql = '''REPLACE INTO eleme_bx_et VALUES (%s,%s,%s,%s);'''
        sql_value = (brandName, bx_et, times, 0)
        cursor.execute(sql, sql_value)
        db.commit()
        json_out = 0
    print(json_out)
    return json_out

if __name__ == '__main__':
    # post_text = '''{"name":"eleme","ksid":"YJYYMJMTA1Mjg5MjA0OTM5NjAxUDBrQ0VvYjBQ","shopId":"99731295","bx_ets":["dejHri9I8w8QBNRhlWKQYDy83Iz9dXt54_nJw3dz7CR6JwCJvLqysT1J93Brq8fv6eQpYy6PUC55wJ_de1qwpKieLUuEb1ff1XLRwHKkEg5Dy0eByCxlFT5kPJOJaQfRUweTDoBCd3tyZSEYDWNJV3u8PQ_Pd9tW4QA34mBIqaxa6TkZ2cJ4kiyHkIDSigErKcYkg9RNp9IwKjdVLCmr4CvhQ-uZu4pIVdyRb4gW8d9MM3uE4uf..","dpjDrs9juZ8beaRcRSKb0myTLBz-cjt1b1n96hdazQRWkZC9DdqwZO19MhBZjRfpwEQv0r6NQQ516-_AB_qyHpi23Fuq4_fCNjLO6nKMIG5HWceXWQxGCO5M5-O9_CfOQZe8vkBfhhtwsWELvSN9fhuT5C_Nhtt6bCA0bDBjjNxzwT8qX0JUJMyDJBDstGEZncYMTtRPHtIynXdF3QmZbQvcQqur8VpjfLyO4Vg6uL9k9huqblf..","dHjkrs9Sza87HZRl57K740yLQCzxPbtCY6np9HdUuIRXyaCp2pqei91pwHBExJf9MUQJ4z6FLI5C98_Rpsq2ediyUeur0sf1GbLd93KHKM5MJDeWJIxhd95HR8OpTBfdLaeYXlB5FHtet5ETX7NpAHuLRB_FFTtBYBAuYcBSxwx4MT8qvmJaWGykWCDIsMEEEcTH_TRVeTI2EfdNUImEYIvlQSuq72pSAKyd02gBzK9D6HurYkf..","dl_wreT-aPUaAWJ_2hY28TEbqQY9rUe7nZ9XisfD1dvG15FV3TCwmV_X5sjFF9j6m1NOLE5Aidb1llUV0pAZsAvMjH4HNpQXCV1bgtWfENI1GKg2mKX2hK_VMqRcitF9h5EC61Lvo8wWuz1O6FqTF8OjMBZekE27FE8N9PYAUIL4RTrC1lFaXn2lwpbTk2hTL7C2Lq0qwC-MEzpEoqbe_1JlQtDvtbpfkGkm0hApTLNUTHOtwn5..","d1AXr7O_UoqfiW6TgjgyVBXGK2f6fnGE6P_9-FF4WsCv15tkqCz2Wiz6fFjy31uDWCN12hsNbsn051t24iUYHSIRwN_bHinGglp6q30D_m3DCNKe7I3c_1zDEH8LgIkc_51cs1nEYXleuEfG6sGSTXy9UpjqYDlETE-Dsrne3Ox6kTkg--ESTFi7Z7PU5xqUwqVbGQ_xjMLfVabkNZ6fvtI5Q-VFAeYgCz631asEP4wgIDZ3QsC..","dqO2rdfL8jhqF4SjptfNaHHsKwfAG6nIjCs1SFYGlijDlq3wbHLVISO1GFvyA3vfIEgv4189SiAX1xhwQgb4oojcnTclRgd1cSTs7h-6xIpX5GNNIGxNfGOwW57MSh3AfqHWkECOsDiC_XTvksDxAD__WaMP61mIA152yjf9YNCZNT8Wlx3qHOmHJgAx67Ux448N45VaJZWcxXIzs5APuEShQKqOryI66KrgQtbRzMgrzT_YJO5..","dnAkrn_7ULWSkKSkC0CSa7uK7GkxFu1BTHFdv6IE3iSfeLKdwwcFmetd26LUt2xODTpRaYTe8i-Bv49JJncVyNNPz9yzgnx6cuBpv_Ch-B-GpW35pifHRe-hd4sdYMxp8L3x6fLWP61Fxcht60idO6yKdM9ePU1CTMjoT5L7tpfqDTk79S7ZBCulBG4QjBhUrcXFbUS2yUdVrlIwziVUTiblQsy4QJQ7OZupgJwCUZ_cX6yzTXf..","dDp9r9glx20Gn4e94PhnuukYn8iHWdKwYF-7nZbgGeLp-UBcSqPM9ZTw8ZfjbE2v9eYR5cWcneQv7EKGiONsdysfDiZ1fOsvk3ThnNcZuwyvJ3OGmVhwcn6wKC2cSVWvcUXxr4DoEh-NgtgorFUpbh-Jt--jEYxwbsWElzDob6maATSsu8HILRp9nGG0Rl4eVPJ5X1Q8nweYHmjO6at1JqgfQvJkewFzraI01DnLgS51YxZHiH1..","dlvBr397_y4CK-18Lviw5KflimX5FeMqeusJm3eU29BpF8TMSLre2wrWP3bwTToH2Lw5WU_Pz933VTTe7wEL9JQOBgsQ9w3lLzdWSFmHU2nHNgL24pnhUTrHsE-YLplhU86hET3quxk2YHXle9Ms3xPJ_IbEuqkq3H8HEk32T_YWvTWgmWUs33g_IRy4VX44BA2QddsKrZKC5GjMCM1Ck6Q1QS2VlnxuNl10FG_qfcNuZqa0a9C..","divHrmsQTB5IXC7HG2BILJo-0Zl9dy6WUUeRyTQr_N719BLRpgDPS3TRJTKzE0YAW6ddLXty4N8WyDOp2FDNviwFY_PUQFYX5yCJy9BlqL8cw8nCwNXkV38lND_RzaYJ4BntHxKBAT6PrqHxH2gRFTP-NaOyAH65UabnU-KQEQXZWTkQeRSqMKohMZq7oLHzxffPuH7wvHpNxrQ2YN2zUNjhQqPag7IQFGoJQ7N5TGsGkTPUUYf..","depvr9ghq40cI2evYrho7kkTIJikXKK24E-QINb01ULJreBGoVPDwNT2zNfs0F29wUYdlmWGIUQ9uFKcstNjFzs1XGZfcts9WHTlIZcq7ay9yHOcjqh2fh62EI2GoqW9feXt-2DnKn-V_Ogn-EUJ0n-pZR-sKvx201Wr5yDn0_m4VT5j7JHSU-pvIiGgPo4yA5JCDsQLIaeTBcjAMwtfyVg1QXJHpaFU-wIgG0n8_55f4AZks31..","ddvWrb9Qgz45ER1LUYi2ldfhscXCPUMZpkspjHezvTBJdJTDopryvarBRHb2a9okvpwCke_F8T3uA9TyuaE8w8QAHMs7wa3hUydBoEmkL4nkOMLwYLnlL9rkiF-TULllLJ6lK93Z7Akw43XhpTMjQAPpgCbr7VkZQ38kKu3wa6YB2T-0j7UjQHgbn-yaAb4aHA27FKs--NK5lijDhg15W_QfQj2N5hx3Oo1gdi_ZcmN3tVagTTC..","d5pyrdXTbYHrGm7S6_XF3FhIsGXR9O3s-p_CxHxhVabkV0ne8FKPt89CFHA25EA5t3iJu9-pxavWdbHeTZjzqzblZsDcfZpCP8tIYe8BSLdWAwwFtwYFRw9evJSHxenRR0hX23BdKVg1LAtJ2Tc-5VsQviGVp90s59WyDYXp7MBEhTJwVbnrw60MXZv-p-E-uftFuJ2UXg5lSAQ4KJvV437GQ-4dmlQBpQz3T_jA0Niq0ss8X65..","diterNjY3DnE5A5IkwjPbI3SotjdPihjZ315ELvld6fHdvHyaIpFrkt5ALYwGCYCrpMp_gJJE6xBV2nyz1XUKWfh-NmGh1K5Ok9SUQRWiHLBF_ZPr_APN_tyeuWkEQHdNv36ppIRqjGf4m9ppM0KGj67eOgN2gcjGgSeBDjJgTIrfT5Bd2HEJacDH1xK2leK_4JP_uqzH97himCaquxNLp5cQxVRI-CW2ePuzwXOQsMZQN6LHa5..","d2KvrvGhEbccjXEvLS3o_JoTjkMlWnp2UIJQj1f05QdJZBIGifzDy1O2a1bs3Cq9yQAdGxSGjQC9gCpcSiajV761BOwfhi696pOljs0q__r9wpTcIj32Cds2qEqGijS9CBjttXmnxKJV7GGntIFJ3KJprlJsxDv23NSr1Wmn3aD4FTPj_knS4oKvjtggN-Vydl-CHZCLj_ETXAXAk69fwfG1Qk-Hv_UUt6BglYH87P7fUcwkSL1..","dQt2rwsLLmnqPY5jJZjN4B3s-9jASMhIsh11IdvGhsfDhxHw_BpVSot1cdYyOQYfSKMvaGJ9IsxXfqnw7_X4nSfcoamld_K1Go9sQCR6tnLXC1ZNS1AN11twBlWMICHA1x3WHKIOjXGCbD9vHi0xOX6_BTgPXGcIOGS2emj9TOIZVTWWhqHqkNcHp_xxXuexa4JNalqapt7ctDCzjlxP3K5hQxVOEJC6XEPg7ZXRU6MrUa6YpN5..","dJKJreGGnjclxfEJQ73mTRoLxlMc93py3QJ_x6fuRIdviCIhZXzkk6Oyg6bIUBqpkIAONYShxICpaBpl-gaScS6Cp9w5Fg6p9dOcx_0rTsrpMdTlKb3ydpsymUqhZbSpdCjKsfmijLJP8MGisQFvULJ9okJIjcvyUwSqO5miUZDzhTysTlnj0uKJxTg3G8V2Co-1eaCTxsELvvXRy195MXGCQJ-MXsUas1B3PxHY8y753DwD-K1..","dDT6rbTbYR21SzsY7VGedUjcqbbbfdgrkS1vZIUaMNQ9lr9HKEPwMOPXhIXebZlMMEafpK6V3NHgGZ9wLOFTXPBdJs1_XOHc7-KXKpcMuAhMcspygFhGuZPMxLR87FoGur_GoZHrU4uy_CbckNgIz4rvY3XZUYurzCJMo5HybivX6Ty4ZleIzIMQ-yzzGc2zJmU_5e1tnTd1d6fHR1s1eGBCQx4PFQA0cWsul66rOXZ0mYwu0NC..","dr8MrS1_bhSs9HWMVAQs7PlxaToLXR_XuKUAHZBqY9WCXhpAWs0VKI9ABZd4ojvRpGKO7cO2g9JXHft9Mp0F6_aN_ira8pvWdRIvHNQciEJlDrh1D9bDGIJccf6A3tvvghhKy4d61Z_VnY3-yAMAlZrxctt21C_futXiuzd_onbEpTzQky5r2UlG2TVbEE34s5jVUCWe6CLFs8By_944u9fGQnrU4oC_l6lv8oZfb61heZrauqf..","dlYBr3T7bJ2C-rs882GwCEjlmjb7dpgqy71JiQUUwwQpPz9MIUPew9PWFQXwYalHwUa5BL6PUwH3Na9eQ9FLvyBOW_1Qv9Hl88KWIdcHzvhHV_p2aehhzaPHjKRY8eohzz_hraHq3qu2TBblywgsuqrJbnXE3xuquBJHrWH2YgvW9TzgikesuQM_SPz4ND24WR4QRF1KEtdCC1fM56sCHMB1Qj4VhIAuV5s0P16q1fZuqxw04wC..","dBLerNbYg23EffWIDMbP7KnSmsbdvZHjEU65ZQAlO9XHOXhyUKdFqyT5RQxwhdxCqBGpQaRJZ9YBPD3y4OfUtJXhxG0GGOL5dyOSaLJWneKBNTaPqTvPFTTywz5kZLhdFXn69BQRrxMfzqOp9wmKhx17w1iNyaDjha7e62bJ3_Qr5TSwODhEvgDDMOYKyPFKQ8APQz4zM6ShnqBarzYNTBWcQt2RsSBWyHyu4MfO_tGZ_G1LMg5..","dULvrJMhZYDcSvUvT-noQWuTSyGuDEd2aKRQSOX0fLpJEpQGnArD2O92UOjsgd492Lvdhj7GSLB93ddcjZZjP81161NfGZ19BB9lStmqQTz9eBtcsxn21C_2rn4Gnx791pbtKv0n-IRVbNMnKKeJgIRpqPRs-2A2gG7rCJ0nggc4NT-rQy3SzrLvSsigFS2yObYCMiBLSTUTWffAD9OfeAM1QX8HJTEUK9Cgcbh8blSfaVNkjQ1..","dLLyrw_T_43rcjWSXgbFudnIj1bR4NHsKe6CtBAhNTXkNbheLddPxzTCPBx2CKx5xQGJ3wRptTYWR03eYtfzZ8Xlqi0c1tLCFzOITpJBIUKWO9aFx9vFd9Te9y5HtphRdbnXwQQd-AM18VOJwam-CA1Q9siVJwDsCw7yM4bpQ6QElT7WN0hr2MDM6tY-JrF-38RF3y4U6_SlIVB4-yYVaQWGQt2di5BBJ3y3YgfAgOGqgi186M5..","dIlMrIa1QAy6JvriFhF6_18vzuJpXGNjgmCYDSE2LkrQBAnY6rA4xqiYXS3ViEm8vRHT_dgqukojDFMtkDAUWz1a7-WNTDmSAGexD5F0ojouHsL_HkVmlqo0hFZY0omxuALpwQ3s5SN4m3dJwhtYGSWvhoMq5VNbgoqMg_31ixVevT8CM6zyeb8geubfqjdVSG244VrEWVhUSgEr7kfVgk4GQsWFUtU1Gy8xTt6bQya32SWNgIf..","dqhprpt0Shx3ZnCKuMpM4ZRRZsTG2X3E7DufZuqhFcntjmFux3WnBuiEbu2W80f-BcmYAePuZcE-Y033EW6B1Ga7yz_QRWa-2qigZkve4l5-XqM3rHpEP4NEsvfuxHP-PmVJmnADi2uUU7tDmDIt82uxI_uWiI0E88PwViAD8RYF5Tre4sd6_6hKZy9lfwjZlncbJJEAZlCRwU4LpogQX3t5QklmMlBVmoUldFLOUTyQ7Q_iEV1..","dcGerAVAuBdeCFrBHJVz_mpWnrVLCSKXqbZ7r40uRkqnReLr4m3UE6G7O4DZccDQE2TKb7u-rkcINpdrUl4F-Mq3KRAgllh7A6gWz0oSmXHIPu1zEumzVuGry_zor0LLVepsJ2F8ZntbaIgKJWvpcna5yP9aw7xXc7PEWBV-0zFy1TSZRpLep8xmklcpw1Qpba0zb_fPkyy3mIENZ_ca82rcQKj8SZESwvSlUJ4T7oTw7Radk85..","dwhvrpt3r3x0sHCx8ipkbwROs6TlWj3qzmuCslqcC0n-qDFgmhWmeliq4l26ucfte0mLcEPgs0Et0c30IS6XNga_WP_blSatX2iusov2bu5t22M0Snpq5VNqZxfgmnPt5DV9xHAHtqu4Q5tHxmI-uquKE1u6tB0quRPyfMAHu8YVPTrXb6dWashxsr9GVZjrRhlQk-EdsuCO6F4YHkgb2ht1Qkln9uBFxkUGhULRQOybzC_oI41..","d9GWr7GC3gj7Z1wdaQTqcf23IFVBV0Ow9waKS2CPJ7F-O6immX7rJu7IA2qqUW8oJX1QDDZUY7KlRWir0uQRe_EYMya5euK3aMHImmYoT3LodynZ8bLuTW7oncuOabJuT6NutWKwbCRZz4V397OX_CWK3AqybhRw_4ootaKZUJmIyTRVSTIX_2tfis5NRLjNMNC5NjaJxl37cr4mGzw7X8EfQSfafV0hdZwGOrZwlE6hKhsGL7C..","duGkrs45UYyWkxroC3FWa_8p7lJxogNITDCLvWEe3orbeYnLwyAUm2iL2W3FtemTD8H8aLgE8ooIvUM-JmA4yP1zzJWPgmmscgeKv7F3-Xogp6L7poVnR2o3dUZLYkmK8YLv6C3SPWNUxhd963tLOWWpdkMEP4NQTkqkT135tvV2DTJR9szwBf8uBlbCjXdFrMeUb4rqy4h4rGEZzofFTo4lQsWVQ9U5Or8Kg96QUra0XWWPTBf..","dGD6r7MfTNb_ITNAQdtERYV0Z32XfV9yHiZxqmBNDRethtgn-xSZDPSjlm4E_--iDx6bJqa4uRLGc-gZ8PIO6OULpoZ16PL0QZhj-2xi3FKiGo3r0AKg3-Sit4oRQARg3twgn-LyzLJrbc20HR9BUL5xTb4wzUJyUcuinGLr_S0jXTzcq1QBUmTCK9WPcCbPpiX1CvZ9ozn_RkqndlN_y5UCQ-XzP0mcGMNlhkayAH1ciU_lgRC.."]}'''
    # reciveElemeBxEt(post_text)
    host = 'localhost'
    port = 3306
    passwd = '111???clown'
    db_name = 'hexingxing'
    db = linkTomySql(host, passwd, db_name, port)
    mode = 'select'
    times = 2
    bx_et = 0
    bx_et_value = sendElemeBxEt(db,'select',0,0)
    bx_et = bx_et_value['bx_et']
    use_times = bx_et_value['use_times']
    sendElemeBxEt(db, 'update', use_times+1, bx_et)
    sendElemeBxEt(db, 'error', use_times, bx_et)


    if 1==0:
        # host = '124.222.188.59'
        # passwd = '111...Clown'
        # db_name = 'zuzu_data'
        # port = 63306
        brandDict = {'91064057':'JXB','99731295':'ZXX','95911482':'LLS'}
        host = 'localhost'
        port = 3306
        passwd = '111???clown'
        db_name = 'hexingxing'

        db = linkTomySql(host, passwd, db_name, port)

        cursor = db.cursor()
        sql = '''REPLACE INTO eleme_bx_et VALUES (%s,%s,%s,%s);'''

        post_json = json.loads(post_text)
        brandName = brandDict[post_json['shopId']]
        for bx_et in post_json['bx_ets']:
            sql_value = (brandName,bx_et,0,1)
            cursor.execute(sql,sql_value)
        db.commit()
        db.close()