LongArticleAlgServer/test/migrate_account.py

"""
@author: luojunhui
"""
import pymysql

from tqdm import tqdm

account_list = [
    {
        "account_name": "gh_59b9f8ef99a4_职场鸢说",
        "account_nickname": "职场鸢说",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营v4",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_6b7c2a257263_幸福晚年知音",
        "account_nickname": "幸福晚年知音",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营v3",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_bfe5b705324a_奇趣百味生活",
        "account_nickname": "奇趣百味生活",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营v3",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_1d887d61088c_乐享生活小窍门",
        "account_nickname": "乐享生活小窍门",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营v3",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_3ed305b5817f_看不够妙招",
        "account_nickname": "看不够妙招",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营v3",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_dd4c857bbb36_无忧自在生活",
        "account_nickname": "无忧自在生活",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营v3",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_f902cea89e48_无忧潮生活",
        "account_nickname": "无忧潮生活",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营v3",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_b676b7ad9b74_无忧生活小妙招",
        "account_nickname": "无忧生活小妙招",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营v3",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_b6f2c5332c72_巷尾风声",
        "account_nickname": "巷尾风声",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营v3",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_ee78360d06f5_实用妙招800个",
        "account_nickname": "实用妙招800个",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营v3",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_1b27dd1beeca_小贝生活课堂",
        "account_nickname": "小贝生活课堂",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营v3",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_93e00e187787_小惠爱厨房",
        "account_nickname": "小惠爱厨房",
        "account_kind_1": "自营",
        "account_kind_2": "投流_v1",
        "account_type": "订阅号",
        "min_time": "20240601"
    },
    {
        "account_name": "gh_4568b5a7e2fe_窦都事说",
        "account_nickname": "窦都事说",
        "account_kind_1": "自营",
        "account_kind_2": "买号v2",
        "account_type": "订阅号",
        "min_time": "20240601"

    },
    {
        "account_name": "gh_adca24a8f429_史记趣言",
        "account_nickname": "史记趣言",
        "account_kind_1": "自营",
        "account_kind_2": "买号v2",
        "account_type": "订阅号",
        "min_time": "20240601"
    },
    {
        "account_name": "gh_e0eb490115f5_心灵情感驿站",
        "account_nickname": "心灵情感驿站",
        "account_kind_1": "自营",
        "account_kind_2": "买号",
        "account_type": "订阅号",
        "min_time": "20240201",
        "example_url": "https://mp.weixin.qq.com/s?__biz=Mzk0NTYxNDA2Nw==&mid=2247490448&idx=2&sn=5ec4ea0b0ec8601dfdd27c97f91e84ef&chksm=c313e60cf4646f1a35189c512ada181ed6a19457165cf3cfe9761cbbc9a945ba876909eb405a&token=2069955866&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_e24da99dc899_缘来养心厅",
        "account_nickname": "缘来养心厅",
        "account_kind_1": "自营",
        "account_kind_2": "买号",
        "account_type": "订阅号",
        "min_time": "20240201",
        "example_url": "https://mp.weixin.qq.com/s?__biz=MzkzNjYxMjY0Nw==&mid=2247491448&idx=2&sn=820f612b3dbef915db99c3c78ecc8245&chksm=c29d5930f5ead02633311132c8c886fd49e707f1d623a802bf2da82d6e566771deedc373f2e2&token=382421805&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_084a485e859a_生活情感叁读",
        "account_nickname": "生活情感叁读",
        "account_kind_1": "自营",
        "account_kind_2": "买号",
        "account_type": "订阅号",
        "min_time": "20230601",
        "example_url": "https://mp.weixin.qq.com/s?__biz=MzkwODUwNzMzMA==&mid=2247499602&idx=2&sn=e98ebb724c4cf071c5dae0b8c31c6064&chksm=c0ca5efff7bdd7e98374380f6359bc6260b080efabc053af010ea5b61b8882483c7d91d10dfd&token=1246049706&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_6d9f36e3a7be_音药养心馆",
        "account_nickname": "音药养心馆",
        "account_kind_1": "自营",
        "account_kind_2": "买号",
        "account_type": "订阅号",
        "min_time": "20240201",
        "example_url": "https://mp.weixin.qq.com/s?__biz=MzkzNjYxMzMxNw==&mid=2247489721&idx=2&sn=b763d7847275493b3990c59383e827a9&chksm=c29d5c13f5ead505a8e78ab9d68029d5edf18b2d94fc1c05ccf3b6654d3bc059256bd68a04ea&token=1122911933&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_9f8dc5b0c74e_音药金曲厅",
        "account_nickname": "音药金曲厅",
        "account_kind_1": "自营",
        "account_kind_2": "买号",
        "account_type": "订阅号",
        "min_time": "20240401",
        "example_url": "https://mp.weixin.qq.com/s/__nMo09Cp4yb1gCS08R0cQ"
    },
    {
        "account_name": "gh_5ff48e9fb9ef_祝福养心厅",
        "account_nickname": "祝福养心厅",
        "account_kind_1": "自营",
        "account_kind_2": "买号",
        "account_type": "订阅号",
        "min_time": "20240401",
        "example_url": "https://mp.weixin.qq.com/s/skCQCJz8BVBZfCeWNZh0yw"
    },
    {
        "account_name": "gh_183d80deffb8_生活良读",
        "account_nickname": "生活良读",
        "account_kind_1": "自营",
        "account_kind_2": "买号",
        "account_type": "订阅号",
        "min_time": "20230601",
        "example_url": "https://mp.weixin.qq.com/s?__biz=MzkzNzU4OTI0MQ==&mid=2247486489&idx=2&sn=bdca965ce642d7a2764186f4e83e70ce&chksm=c28c6c8ff5fbe59935eaa6aa8dbb10d6cdac40b89139be3206413dabc08481da7cf744a1db21&token=788224128&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_9161517e5676_宝娃趣味游戏",
        "account_nickname": "宝娃趣味游戏",
        "account_kind_1": "自营",
        "account_kind_2": "买号",
        "account_type": "订阅号",
        "example_url": "https://mp.weixin.qq.com/s/Q0dfNLoFU45D83iHaCMnpg"
    },
    {
        "account_name": "gh_26a307578776_票圈美文速递",
        "account_nickname": "票圈美文速递",
        "account_kind_1": "自营",
        "account_kind_2": "自导-订阅号",
        "account_type": "订阅号",
        "example_url": "https://mp.weixin.qq.com/s?__biz=Mzg3OTk4MTY2MA==&mid=2247497182&idx=2&sn=ae70dfd5e26926c06153675ccf2f303e&chksm=cf7e90edf80919fbc0af22cfa29d7f88920ce508dc55c70549a8b542490edbc8e1f0f0074b75&token=57207778&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_d2cc901deca7_票圈极速版",
        "account_nickname": "票圈极速版",
        "account_kind_1": "自营",
        "account_kind_2": "自导-订阅号",
        "account_type": "订阅号",
        "example_url": "https://mp.weixin.qq.com/s?__biz=MzIzNzQ5MDQ0Mg==&mid=2247557653&idx=2&sn=4e4a4e55d4d83d9bbc8714e3e2fb903e&chksm=e8c47a70dfb3f36660ec5a83c1bdcee6c2dc3dffae14ed59d2be6fefce8c2c4607f9061e70be&token=1037153386&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_1ee2e1b39ccf_票圈最新消息",
        "account_nickname": "票圈最新消息",
        "account_kind_1": "自营",
        "account_kind_2": "自导-订阅号",
        "account_type": "订阅号",
        "example_url": "https://mp.weixin.qq.com/s?__biz=MzkzNTUwNzYzMQ==&mid=2247489847&idx=2&sn=9830b4926999fbaefcea9e7ba858465e&chksm=c2adbaf7f5da33e10c74ea3517e1db015433b868a1d2b5c9fa76b183eacbacc47973c938c97e&token=544068113&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_e75dbdc73d80_票圈正能量",
        "account_nickname": "票圈正能量",
        "account_kind_1": "自营",
        "account_kind_2": "自导-订阅号",
        "account_type": "订阅号",
        "example_url": "https://mp.weixin.qq.com/s?__biz=MzI3OTI0NDA3OQ==&mid=2247485091&idx=2&sn=a4a5436e7b877bb3652e0bdcf6cd7d8b&chksm=eb4bfae3dc3c73f536c831c0bc0a769dd850b63dce356fae0ea71ac156025a325b110dce6adf&token=546235938&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_b8baac4296cb_票圈原创视频精选",
        "account_nickname": "票圈原创视频精选",
        "account_kind_1": "自营",
        "account_kind_2": "自导-服务号",
        "account_type": "服务号",
        "example_url": "https://mp.weixin.qq.com/s?__biz=MzI5NzgwMzk4Ng==&mid=2247488691&idx=2&sn=7932b1f5df6ad7326fe817f12d195d4c&chksm=ecaedd0edbd9541842f99c9257161a49569187d16a37f847b6fa0d0b23e62a05eaa01de579e5&token=688518322&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_45beb952dc74_票圈乐活",
        "account_nickname": "票圈乐活",
        "account_kind_1": "自营",
        "account_kind_2": "自导-服务号",
        "account_type": "服务号",
        "example_url": "https://mp.weixin.qq.com/s?__biz=MzIyNzUwNDU0Mw==&mid=2247488612&idx=2&sn=d8822b4241ede2a18359af8577a150c5&chksm=e8616c94df16e582df2187915dcf574e0aa8cb2f951290bd05cd7a34affcd6e9fd8fe8bcea37&token=1128731380&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_9cf3b7ff486b_票圈热门",
        "account_nickname": "票圈热门",
        "account_kind_1": "自营",
        "account_kind_2": "自导-服务号",
        "account_type": "服务号",
        "example_url": "https://mp.weixin.qq.com/s?__biz=Mzg5MTY3MjMzMw==&mid=2247485253&idx=2&sn=e329fc08e9160bebecffcab83d7c9512&chksm=cfc88527f8bf0c3141d0ac4f935bec8f859fe78c33020015704c0dc6b031dde3821e85caf981&token=689050650&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_b32125c73861_票圈奇闻",
        "account_nickname": "票圈奇闻",
        "account_kind_1": "自营",
        "account_kind_2": "自导-服务号",
        "account_type": "服务号",
        "example_url": "https://mp.weixin.qq.com/s?__biz=MzIxMjg2MzE2Mg==&mid=2247483930&idx=2&sn=27e573be47b8e9d60a8941b16bc01d3c&chksm=97bed3cfa0c95ad9ed13d5f50aebb093f1a193c087aee8e8840a4e3714d752059bd28e3bc6eb&token=1172173724&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_5e543853d8f0_票圈精彩",
        "account_nickname": "票圈精彩",
        "account_kind_1": "自营",
        "account_kind_2": "自导-服务号",
        "account_type": "服务号",
        "example_url": "https://mp.weixin.qq.com/s?__biz=MzIzMDQ5MDc4Ng==&mid=2247483812&idx=2&sn=3e2d919e6696303c83e444853e763bb8&chksm=e8b3d669dfc45f7f604594747c82b9d17ff813ccefebf02a5b23e2b32d5279f11da2e45e2da8&token=951337792&lang=zh_CN#rd"
    },
    {
        "account_name": "gh_b3ffc1ca3a04_票圈内容精选",
        "account_nickname": "票圈内容精选",
        "account_kind_1": "自营",
        "account_kind_2": "自导-服务号",
        "account_type": "服务号",
        "example_url": "https://mp.weixin.qq.com/s/h_4qW7pQ9sV4OvbtTEz9eQ"
    },
    {
        "account_name": "gh_efaf7da157f5_票圈热议",
        "account_nickname": "票圈热议",
        "account_kind_1": "自营",
        "account_kind_2": "自导-服务号",
        "account_type": "服务号",
        "example_url": "https://mp.weixin.qq.com/s/T1YHqu-5OKdd3mO6G9G1kA"
    },
    {
        "account_name": "gh_6d205db62f04_指尖奇文",
        "account_nickname": "指尖奇文",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_c69776baf2cd_老友欢聚地",
        "account_nickname": "老友欢聚地",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_9877c8541764_退休老年圈",
        "account_nickname": "退休老年圈",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_a2901d34f75b_畅聊奇闻",
        "account_nickname": "畅聊奇闻",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_89ef4798d3ea_生活百态观",
        "account_nickname": "生活百态观",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_b15de7c99912_人生百事观",
        "account_nickname": "人生百事观",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_7e5818b2dd83_便捷生活好方法",
        "account_nickname": "便捷生活好方法",
        "account_kind_1": "代运营",
        "account_kind_2": "代运营",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_6cfd1132df94_趣味晚年",
        "account_nickname": "趣味晚年",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_9eef14ad6c16_快乐精选集",
        "account_nickname": "快乐精选集",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_c5cdf60d9ab4_老友快乐谈",
        "account_nickname": "老友快乐谈",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_0c89e11f8bf3_幸福启示",
        "account_nickname": "幸福启示",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_d49df5e974ca_生活指示录",
        "account_nickname": "生活指示录",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_080bb43aa0dc_态度说",
        "account_nickname": "态度说",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_72bace6b3059_幸福妙招合集",
        "account_nickname": "幸福妙招合集",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_bff0bcb0694a_喜乐生活派",
        "account_nickname": "喜乐生活派",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_5ae65db96cb7_路边闲聊社",
        "account_nickname": "路边闲聊社",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_7f5075624a50_都市镜头",
        "account_nickname": "都市镜头",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_192c9cf58b13_天天学生活技巧",
        "account_nickname": "天天学生活技巧",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_29074b51f2b7_老来生活家",
        "account_nickname": "老来生活家",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_f25b5fb01977_生活晓常识",
        "account_nickname": "生活晓常识",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_d4dffc34ac39_情为老友",
        "account_nickname": "情为老友",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    },
    {
        "account_name": "gh_ff487cb5dab3_趣味生活达人",
        "account_nickname": "趣味生活达人",
        "account_kind_1": "代运营v2",
        "account_kind_2": "代运营v2",
        "account_type": "订阅号",
        "example_url": ""
    }
]


def migrate_each_obj(account_obj):
    """
    迁移账号
    :param account_obj:
    :return:
    """
    account_name = account_obj['account_nickname']
    gh_id = account_obj['account_name'].replace("_{}".format(account_name), "")
    account_k1 = account_obj['account_kind_1']
    account_k2 = account_obj['account_kind_2']
    account_type = account_obj['account_type']
    insert_sql = f"""
        INSERT INTO long_articles_account
            (account_name, gh_id, account_type, account_kind, account_sub_kind)
        VALUES 
            (%s, %s, %s, %s, %s);
    """
    # print(insert_sql)
    connection = pymysql.connect(
        host='rm-bp1159bu17li9hi94.mysql.rds.aliyuncs.com',
        port=3306,
        user='crawler',
        password='crawler123456@',
        db='piaoquan-crawler',
        charset='utf8mb4'
    )
    cursor = connection.cursor()
    cursor.execute(
        insert_sql,
        (account_name, gh_id, account_type, account_k1, account_k2)
    )
    connection.commit()

print(len(account_list))

for account in tqdm(account_list):
    try:
        migrate_each_obj(account)
    except:
        print("数据已经存在")