Skip to content

Instantly share code, notes, and snippets.

import pandas as pd
import numpy as np
import xlrd
import datetime as dt
import xlsxwriter
from datetime import datetime
import pymysql
serverName = '192.168.1.106' # 使用106只读
userName = 'zeusquery'
# __*__ conding:utf-8 __*__
# author: dust
# python -V : 3.7
import time
import logging
import traceback
import pymysql
import pymysql.cursors
skip_url_4 = f'havana_iv_token=66666&sub=false&c_is_scure=true&from=tb&style=default&css_style=default&tpl_redirect_url=https%3A%2F%2Fwww.taobao.com%2F&user_num_id=66666&login_type=3&loginsite=0&lang=zh_CN&appkey=00000000&new_iv_check=true'
skip_url_5 = f'sub=true&c_is_scure=true&from=sycm&style=minisimple&minipara=0%2C0%2C0&css_style=default&tpl_redirect_url=http%3A%2F%2Fsycm.taobao.com%2Fportal%2Fhome.htm&full_redirect=true&user_num_id=6666&login_type=3&loginsite=0&lang=zh_CN&appkey=00000000'
d4 = skip_url_4.split('&')
d5 = skip_url_5.split('&')
d4 = {i.split('=')[0]:i.split('=')[0] for i in d4}
d5 = {i.split('=')[0]:i.split('=')[0] for i in d5}
# print(d4)
skip_url_4 = f'havana_iv_token=66666&sub=false&c_is_scure=true&from=tb&style=default&css_style=default&tpl_redirect_url=https%3A%2F%2Fwww.taobao.com%2F&user_num_id=66666&login_type=3&loginsite=0&lang=zh_CN&appkey=00000000&new_iv_check=true'
skip_url_5 = f'sub=true&c_is_scure=true&from=sycm&style=minisimple&minipara=0%2C0%2C0&css_style=default&tpl_redirect_url=http%3A%2F%2Fsycm.taobao.com%2Fportal%2Fhome.htm&full_redirect=true&user_num_id=6666&login_type=3&loginsite=0&lang=zh_CN&appkey=00000000'
d4 = skip_url_4.split('&')
d5 = skip_url_5.split('&')
d4 = {i.split('=')[0]:i.split('=')[0] for i in d4}
d5 = {i.split('=')[0]:i.split('=')[0] for i in d5}
# print(d4)