파이썬 pymysql 모듈

import pymysql

def connect():
    db_info = pymysql.connect(
        user='아이디',
        passwd='비밀번호',
        host='호스트주소',
        db='DB명',
        charset='utf8'
    )
    cursor = db_info.cursor(pymysql.cursors.DictCursor)
    return db_info, cursor

 

def select(query):
    try:
        db_info, cursor = connect()
        sql = query
        cursor.execute(sql)
        result = cursor.fetchall()
        db_info.close()
        return result
    except:
        return None

def IUD(query):
    try:
        db_info, cursor = connect()
        sql = query
        cursor.execute(sql)
        db_info.commit()
        db_info.close()
        return True
    except:
        print('except', query)
        return False