Пример #1
0
# -*- coding: utf-8 -*-
import local_functions
import securitydb
import sqlite3

import sys
reload(sys)
sys.setdefaultencoding('utf-8')

infos = [
    {
        'code': '600996',
        'listingDate': local_functions.string_to_date('2016-12-26')
    },
]

codes = securitydb.revise_listing_date(infos)
# -*- coding: utf-8 -*-
import local_functions
import securitydb
import sqlite3

import sys
reload(sys)
sys.setdefaultencoding('utf-8')

raw_sh = "../../../data/raw/sh/"
fileName = raw_sh + "1_security/shA.xls"

lines = local_functions.readlines(fileName)
info_array = [line.split() for line in lines[1:]]
infos = [{
    'code': info[0],
    'listingdate': local_functions.string_to_date(info[4])
} for info in info_array]

securitydb.init_db()
securitydb.insert_security_info(infos)