Examples for pymysql lib with python 3

pymysql_examples.py

""""
:link: https://github.com/PyMySQL/PyMySQL
"""""

import pymysql
import pymysql.cursors

connection = pymysql.connect(host="localhost",
                             user="root",
                             password="1234",
                             db="test",
                             charset="utf8mb4",
                             cursorclass=pymysql.cursors.DictCursor
                             )
try:
    # Example for multibatching to insert many values in the same time
    with connection.cursor() as cursor:
        sql = "INSERT INTO projects (title, description) VALUES (%s, %s)"

        args = (('test project 1', "this project added by python"),
                ('test project 2', "this project added by python 2"))
        cursor.executemany(sql, args)

    connection.commit()

    with connection.cursor() as cursor:
        sql = "SELECT title FROM projects"
        cursor.execute(sql)
        result = cursor.fetchall()
        print(result)
finally:
    connection.close()