CRUD Practice to MySQL

crud_mysql.py

import pymysql


def db_connection():
    db = pymysql.connect("localhost", "root", "", "djangogirls")  # host, user, password, db
    return db


def select():
    """CRUD - Reading"""
    db = db_connection()
    cursor = db.cursor()

    cursor.execute("select * from person")
    data = cursor.fetchall()

    for item in data:
        print(item)

    cursor.close()
    db.close()


def insert():
    """CRUD - Creating"""
    db = db_connection()
    cursor = db.cursor()

    _insert_value = {
        'email': '[email protected]',
        'name': 'kwangyoun',
        'gender': 'm'
    }

    sql = """INSERT INTO person (email, name, gender) values """
    sql += """('{email}', '{name}', '{gender}')""".format(**_insert_value)

    try:
        cursor.execute(sql)
        db.commit()
    except pymysql.IntegrityError as e:
        print(e)
        db.rollback()

    cursor.close()
    db.close()


def update():
    """CRUD - Update"""
    # do something


def delete():
    """CRUD -  Delete"""
    # do somethin


if __name__ == '__main__':
    insert()