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