PythonNote033---操作Redis

Intro

关注点：

• 目前只看hashset内容
• 增改删除常规操作就可
• 类似mysql，怎么减少长连接的操作

增改删查

import redis

db = redis.Redis(host='127.0.0.1',
                 port=6379,
                 password='12345',
                 db=0,
                 encoding='utf-8',
                 decode_responses=True)  #password='12345',

库下key数量

db.dbsize()

1

增

db.hset(name="student",mapping={"name":"jack","sex":"male","score":90})

3

db.dbsize()

1

查

查指定field

db.hget(name="student",key="name")

'jack'

db.hget(name="student",key="score")

'90'

查询时，name是key，key相当于field。python这个为啥不和原生命令保持一致？

查所有field

db.hgetall("student")

{'name': 'jack', 'sex': 'male', 'score': '90'}

field数量

db.hlen("student")

3

改

修改指定field值

db.hset(name="student",key="score",value=100)
db.hgetall("student")

{'name': 'jack', 'sex': 'male', 'score': '100'}

修改or覆盖原来的key

db.hset(name="student",mapping={"name":"jack","sex":"male","score":990})
db.hgetall("student")

{'name': 'jack', 'sex': 'male', 'score': '990'}

删

db.delete("student")
db.dbsize()

0

Redis的其他操作

db.dbsize()

0

设置过期时间

db.hset(name="student:jack",mapping={"sex":"male","score":70})
db.expire("student:jack",60)
db.hset(name="student:leo",mapping={"sex":"male","score":80})
db.expire("student:leo",200)
db.hset(name="student:marry",mapping={"sex":"female","score":90})
db.expire("student:marry",600)
db.dbsize()

3

查看所有key

db.keys()

['student:jack', 'student:marry', 'student:leo']

查询剩余生存时间

ttl key 以秒为单位返回key的剩余生存时间（time to live），当key不存在时返回-2，当key存在未设置生存时间时返回-1

db.ttl("student:jack")

-2

db.ttl("student:leo")

195

db.close()

批量写入redis

所谓连接池的操作，更常规的是不是批量写入，每次写入的时候连接即可？
先记录一下

import datetime
def timer(start_time=None):
    if not start_time:
        start_time = datetime.datetime.now()
        return start_time
    elif start_time:
        thour, temp_sec = divmod((datetime.datetime.now() - start_time).total_seconds(), 3600)
        tmin, tsec = divmod(temp_sec, 60)
        print('\n Time taken: %i hours %i minutes and %s seconds.' % (thour, tmin, round(tsec, 2)))

直接连接

start_time = timer()
db = redis.Redis(host='127.0.0.1',
                 port=6379,
                 password='12345',
                 db=0,
                 encoding='utf-8',
                 decode_responses=True)  
for i in range(0,100000):
    db.hset(name="student:"+str(i),mapping={"name":"jack","sex":"male","score":90})
timer(start_time)
db.close()

 Time taken: 0 hours 0 minutes and 14.03 seconds.

for i in db.keys():db.delete(i)

start_time = timer()
pool=redis.ConnectionPool(password='12345')
db = redis.Redis(connection_pool=pool,
                 host='127.0.0.1',
                 port=6379,
#                  password='12345',
                 db=0,
                 encoding='utf-8',
                 decode_responses=True)  
for i in range(0,100000):
    db.hset(name="student:"+str(i),mapping={"name":"jack","sex":"male","score":90})
timer(start_time)
db.close()

 Time taken: 0 hours 0 minutes and 16.18 seconds.

单次写入好像没啥差别，查询时候有差别吧，不用每次查询都连接？先不管了，后面用到再说

Ref

[1] https://blog.csdn.net/qq_42690811/article/details/95084583
[2] https://www.runoob.com/redis/redis-install.html
[3] https://www.redis.com.cn/redis-installation.html