python2.7脚本连接MongoDB、redis、mysql的操作

最新推荐文章于 2021-08-29 15:56:29 发布

wsywb111

最新推荐文章于 2021-08-29 15:56:29 发布

阅读量665

点赞数 1

分类专栏： Python学习文章标签： python2.7连接redis、mysql、MongoDB

本文链接：https://blog.csdn.net/wsywb111/article/details/87970110

版权

Python学习专栏收录该内容

9 篇文章 1 订阅

订阅专栏

1.首先建立一个db.py用来专门连接这些基本的库

# -*- coding: utf-8 -*-

import MySQLdb
import MySQLdb.cursors
import redis
from pymongo import MongoClient
mongoUrl = 'mongodb://root:localhost:3717/?authSource=admin'
mongo_db = MongoClient(mongoUrl)
config_slive = {
    'host': 'localhost',
    'port': 3306,
    'user': 'slive',
    'passwd': '123456',
    'charset': 'utf8',
    'db': 'slive',
    'cursorclass': MySQLdb.cursors.DictCursor
}

r_slive = redis.StrictRedis(host='localhost', port=6379, db=0, password='123456')

db_slive= MySQLdb.connect(**config_slive)

2.操作mongoDB、mysql

# -*- coding: utf-8 -*-
import sys
reload(sys)
sys.setdefaultencoding("utf-8")
from db import *

def query():
    //操作mysql
    cur.execute('select uid,room_id,num from table')
    result=cur.fetchall()
    for data in result:
        //操作mongodb
        user = mongo_db.userdata['userprofile'].find_one({'uid':data['uid']})
        name=''
        try:
           name=user['name']
        except KeyError:
           name=''

        print '%s| %s| %s|%s' % (data['uid'],data['room_id'],name,data['num'])

query()

3.操作redis

# -*- coding: utf-8 -*-

import json
from db import *

s1 = r_slive.get('redisKey')
cur = db_slive.cursor()
j1 = json.loads(s1)
def query(data):
    for marOne in data:
        cur.execute("SELECT uid,room_id from t_slive_room_info where uid =" + marOne['uid'])
        user = cur.fetchone()
        name=''
        try:
           name=marOne['nickname']
        except KeyError:
           name=''
        room_id = str(user['room_id'])
        print '%s, %s, %s, %s,%s' % (marOne['rank'],marOne['uid'],room_id,name, marOne['score'])

query(j1)

4.操作redis的zset（不需要json.loads）

# -*- coding: utf-8 -*-

import json
from db import *
import time
import datetime
s1 = r_slive_user.zrange('paopao_user_room_closure_list',0,-1,withscores=True)
cur = db_slive.cursor()
def query(data):
    for user in data:
        cur.execute("SELECT room_id from t_slive_room_info where uid =" + user[0])
        timeStamp = int(user[1])/1000
        x = time.localtime(timeStamp)
        otherStyleTime=time.strftime('%Y-%m-%d %H:%M:%S',x)
        room = cur.fetchone()
        room_id = str(room['room_id'])
        print '%s, %s,%s' % (user[0],room_id,otherStyleTime)

query(s1)