python连接几种数据库方法

狐狸情

1、连接oracle数据库：

• #encoding:utf-8
  
  
• from sqlalchemy.ext.sqlsoup import SqlSoup
  
• from sqlalchemy import create_engine
  
• """连接数据库"""
  
• db_data = create_engine('oracle://username:password@xxx.xxx.xxx.xxx:1521/logpub',pool_recycle=60)
  
• db = SqlSoup(db_data)
  
• 
  
• """查询数据"""
  
• sql = "select t.user_name,t.channel_name,t.channel_id,t.local_path from PUB_URL t where t.content_date = to_date('2015-02-26','yyyy-mm-dd') and t.local_path like '%%/data/Data%%'"
  
• channels_massage = db.connection().execute(sql).fetchall()
  
• db.session.close()
  

2、连接mysql数据库：

• import MySQLdb
  
  
• 
  
• conn_athena = MySQLdb.connect(host="192.168.xx.xx",user='xxx',passwd='xxxx',db='xxx')
  
• cursor_athena = conn_athena.cursor()
  
• sql = "update hadoop_jobs t set t.status = 0"
  
• cursor_athena.execute(sql)
  
• cursor_athena.commit()
  
• cursor_athena.close()
  
• conn_athena.close()
  

3、连接redis数据库：

• import redis
  
  
• 
  
• r = redis.Redis(host=ip, port=port, password=pwd, db=db)
  
• keys = r.keys()
  
• print keys
  

仅用于个人总结，仅供参考！