# coding=utf-8

import httpConn
import dbConn

def getCode():
    url = 'http://41.push2.eastmoney.com/api/qt/clist/get?pn=1&pz=4000&po=1&np=1&ut=&fltt=2&invt=2&fid=f3&fs=m:0+t:6,m:0+t:13,m:0+t:80,m:1+t:2,m:1+t:23&fields=f12,f13,f14'
    conn = httpConn.HttpConnect()
    data = conn.request_get(url)
    # print(data)

    if data == '':
        print('查询code失败')

    else:
        db = dbConn.MY_SQL()
        db.save_code_table(data['data']['diff'])


def getBankuai(cate):
    url = 'http://push2.eastmoney.com/api/qt/clist/get?pn=1&pz=300&po=1&np=1&fields=f12,f14&fid=f62&fs=m:90+t:'+cate+'&ut='
    conn = httpConn.HttpConnect()
    data = conn.request_get(url)

    if data == '':
        print('查询banKuai失败')

    else:
        db = dbConn.MY_SQL()
        db.save_bankuai_table(data['data']['diff'], cate)

getCode()
# getBankuai('1')
# getBankuai('2')
# getBankuai('3')