python与数据库交互结构_python与各数据库的交互

from redis import StrictRedis

from pymongo import MongoClient

import pymysql

#redis客户端

redis_cli = StrictRedis(host='localhost',decode_responses=1)

#mongo客户端

client = MongoClient()

db=client.loacl

collenction=db.stu

#MySQL客户端

mysql_conn=pymysql.connect(host='localhost',port=3306,user='root',password='123456',database='python')

mysql_cursor = mysql_conn.cursor()

sql2='select * from yy;'

# sql1 = """insert into yy values ('bb');"""

mysql_cursor.execute(sql2)

data = mysql_cursor.fetchone()

print(data,type(data))

redis_cli.execute_command('flushall')

a = redis_cli.set('name',str(data))

print(a)

re = redis_cli.get('name')

print(re,type(re))

redis_cli.lpush('list',123,123,534,567,678)

s = redis_cli.lrange('list',0,-1)

print(s,type(s))

collenction.save({'name':s})

redis

#创建strictredis对象,与服务器链接

sr = StrictRedis(decode_responses=1)

# 添加键

s1 = sr.set('name','yy')

print(s1) >> 成功添加返回True,失败返回False

# 查找

s1_get = sr.get('name')

添加键对应的值，如果键存在则返回对应的值，如果键不存在则返回None

print(s1_get) >> yy

#删除

result = sr.delete('name')

print(result) 输出响应结果，如果删除成功则返回受影响的键数，否则则返回0

获取所有的键

result=sr.keys()

输出响应结果，所有的键构成1个列表，如果没有键则返回空列表

StrictRedis中的方法

string

set

setex

mset

append

get

mget

key

keys

exists

type

delete

expire

getrange

ttl

hash

hset

hmset

hkeys

hget

hmget

hvals

hdel

list

lpush

rpush

linsert

lrange

lset

lrem

set

sadd

smembers

srem

zset

zadd

zrange

zrangebyscore

zscore

zrem

zremrangebyscore

oracle

import cx_Oracle

注意sid，有时候需要使用本地监听器调用