Python connection Exemples

Exemple #1

Fichier : db.py Projet : esernaalonso/dev

def connection(sql):
    host='mysql.insideanim.com'
    user='******'
    password='******'
    db='insideanim_school_db'
    charset='utf8mb4'

    if sql:
        return mysql.connection(host=host, user=user, password=password, db=db, charset=charset, sql=sql)

Exemple #2

Fichier : test_mysql_bytearray.py Projet : esernaalonso/dev

import pymysql
import esa.common.python.lib.db.mysql.mysql as mysql

sql = "SELECT content FROM `t_resource` WHERE id=1"

result = mysql.connection(host='mysql.insideanim.com',
            user='******',
            password='******',
            db='insideanim_school_db',
            charset='utf8mb4',
            cursorclass=pymysql.cursors.DictCursor,
            sql=sql)

print result