python 下载csv文件保存到 redis

来源:互联网 发布:windows api编程 编辑:程序博客网 时间:2024/05/20 12:25
# coding:utf-8from redis import client # 这个很重要, redis中导入clientimport redisimport csv#import msgpack # 我测试的,msgpack还没cPickle效率高,如果不跨语言就用cPickle"""key-obj(string)方式存储类似memr, 主要管理好key,要唯一sudo gedit /etc/redis/redis.confrequirepass 选项是密码sudo service redis restart"""#r = client.Redis() # 默认# r = client.Redis(self, host='localhost', port=6379, db=0, password=None, socket_timeout=None, connection_pool=None, charset='utf-8', errors='strict', decode_responses=False, unix_socket_path=None)# r = client.StrictRedis.from_url("redis://127.0.0.1:6381")r = redis.Redis(host='127.0.0.1', port=6379, db=0, password='ceshi1')print r.ping()key = "000002"r.delete(key)#从文件读取reader = csv.reader(file('000002.csv','rb'))for row in reader:    if reader.line_num == 1:        continue    #忽略第一行    #print rows    #r.lpush(key, {'date': 'v122', 'price': 'v2'})    r.lpush(key, dict(date=row[0], open=row[1], high=row[2],low=row[3], close=row[4],volume=row[5],adj_close=row[6]))    #print row[0],row[1]    #split_row = row.split(",")    #print split_row[0],split_row[1]    #r.lpush(key, {'date': 'v122', 'price': 'v2'})    #r.lpush(key, dict(date='v123', price='v3'))def list_iter(name):    """                                                   自定义redis列表增量迭代                                        :param name: redis中的name,即:迭代name对应的列表                :return: yield 返回 列表元素                                """    list_count = r.llen(name)    for index in xrange(list_count):        yield r.lindex(name, index)for item in list_iter(key):    print item    del r # 不要忘了del r来关闭redis
0 0
原创粉丝点击