def database(): import pymysql as mysql if app.config['DATABASE'] is not None: ### mysql database connection = app.config['DATABASE'] db = mysql.connect(**connection) # unfuck the innodb tables db.autocommit(True) cursor = db.cursor(mysql.cursors.DictCursor) return cursor else: return False
def db_init(self): # db = pymysql.connect( # host = r'localhost', # user = r'root', # password = r'mysql', # database = r'api', # ) db = pymysql.connect( host=os.getenv('DB_HOST'), user=os.getenv('DB_USER'), password=os.getenv('DB_PASSWORD'), database=os.getenv('DB_SCHEMA'), ) #將拿到的資料dict化 cursor = db.cursor(pymysql.cursors.DictCursor) return db, cursor
def db_init(self): db = pymysql.connect("localhost", "root", "passWord854", "api") cursor = db.cursor(pymysql.cursors.DictCursor) return db, cursor
def db_init(self): db = pymysql.connect(os.getenv("DB_HOST"),os.getenv("DB_USER"),os.getenv("DB_PASSWORD"),os.getenv("DB_SCHEMA")) cursor = db.cursor(pymysql.cursors.DictCursor) return db, cursor
def db_init(self): db = pymysql.connect(DB_HOST, DB_USER, DB_PASSWORD, DB_SCHEMA) cursor = db.cursor(pymysql.cursors.DictCursor) return db, cursor