python自动化之连接数据库

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

"""

Created on Fri Mar 20 10:50:56 2015

 

@author: sl

"""

import os

import MySQLdb

import pandas as pd

MySQL_NAME = os.getenv('MySQL_NAME', '*')

MySQL_USER = os.getenv('MySQL_USER', '*')

MySQLPASSWORD = os.getenv('MySQL_PASSWORD', '*')

MySQL_HOST = os.getenv('MySQL_HOST', '*')

MySQL_PORT = os.getenv('MySQL_PORT','*')

 

#MySQL_NAME = os.getenv('MySQL_NAME', 'mysql')

#MySQL_USER = os.getenv('MySQL_USER', 'root')

#MySQLPASSWORD = os.getenv('MySQL_PASSWORD', '123456')

#MySQL_HOST = os.getenv('MySQL_HOST', 'localhost')

#MySQL_PORT = os.getenv('MySQL_PORT','3306')

 

 

def connect():

    db=MySQLdb.connect(host=MySQL_HOST, user=MySQL_USER, passwd=MySQLPASSWORD, db=MySQL_NAME, charset="utf8")   

    return db

 

def sqlSelect(sql,db):

        #include:select

        cr=db.cursor()

        cr.execute(sql)

        rs=cr.fetchall()

        cr.close()

        return rs