SQL,Redis,python操作

§ redis

import

import redis
from redis.sentinel import Sentinel

redis连接方式

redis_sentinel = Sentinel([(host_1, port_1), (host_2, port_2)])
r = redis_sentinel.master_for("master_test", db=0, max_connections=1)
print r, type(r)
>>> StrictRedis<SentinelConnectionPool<service=master_test(master)>
>>> <class 'redis.client.StrictRedis'>

redis中通过redis.keys()查看当前表中所有key，key中存放哈希表格式{field: value}

redis hash常用函数

hkeys("key")

hvals("key")

hgetall("key")返回所有键值对。

hlen("key")

hget("key", "field")

hset("key", "field")

hexists("key", "field")field是否在key中。

hdel("key", "field")删除key中某个field和field对应的value。

delete("key")删除key和key下所有哈希值。

§ MySQL

import mysql.connector

config = {
    "host": "",
    "user": "",
    "password": "",
    "port": "",
    "database": "",
    "charset": "utf-8",
}

conn = mysql.conncector.connect(**config)
cursor = conn.cursor()

cursor.close()
conn.close()

§ PostgreSQL

import psycopg2

conn = psycopg2.connect(
    database="",
    user="",
    password="",
    host="",
    port=""
)
cur = conn.cursor()

conn.commit()
conn.close()