- 전체
- Python 일반
- Python 수학
- Python 그래픽
- Python 자료구조
- Python 인공지능
- Python 인터넷
- Python SAGE
- wxPython
- TkInter
- iPython
- wxPython
- pyQT
- Jython
- django
- flask
- blender python scripting
- python for minecraft
- Python 데이터 분석
- Python RPA
- cython
- PyCharm
- pySide
- kivy (python)
flask Welcome to Flask-MySQLdb’s documentation!
2017.07.22 19:40
Welcome to Flask-MySQLdb’s documentation!
Flask-MySQLdb provides MySQL connection for Flask.
Quickstart
First, install Flask-MySQLdb:
$ pip install flask-mysqldb
Flask-MySQLdb depends, and will install for you, recent versions of Flask (0.10.1 or later) and mysqlclient. Flask-MySQLdb is compatible with and tested on Python 2.7, 3.4 and 3.5.
Next, add a MySQL instance to your code:
from flask import Flask
from flask_mysqldb import MySQL
app = Flask(__name__)
mysql = MySQL(app)
@app.route('/')
def users():
cur = mysql.connection.cursor()
cur.execute('''SELECT user, host FROM mysql.user''')
rv = cur.fetchall()
return str(rv)
if __name__ == '__main__':
app.run(debug=True)
Configuration
MySQL understands the following configuration directives:
MYSQL_HOST |
name of host to connect to. Default: use the local host via a UNIX socket (where applicable) |
MYSQL_USER |
user to authenticate as. Default: current effective user. |
MYSQL_PASSWORD |
password to authenticate with. Default: no password. |
MYSQL_DB |
database to use. Default: no default database. |
MYSQL_PORT |
TCP port of MySQL server. Default: 3306. |
MYSQL_UNIX_SOCKET |
location of UNIX socket. Default: use default location or TCP for remote hosts. |
MYSQL_CONNECT_TIMEOUT |
Abort if connect is not completed within given number of seconds. Default: 10 |
MYSQL_READ_DEFAULT_FILE |
MySQL configuration file to read; see the MySQL documentation for mysql_options(). |
MYSQL_USE_UNICODE |
If True, CHAR and VARCHAR and TEXT columns are returned as Unicode strings, using the configured character set. |
MYSQL_CHARSET |
If present, the connection character set will be changed to this character set, if they are not equal. Default: ‘utf-8’ |
MYSQL_SQL_MODE |
If present, the session SQL mode will be set to the given string. |
MYSQL_CURSORCLASS |
If present, the cursor class will be set to the given string. |
API
Classes
- class
flask_mysqldb.MySQL(app=None) -
connection-
Attempts to connect to the MySQL server.
Returns: Bound MySQL connection object if successful or Noneif unsuccessful.
History
Changes:
- 0.2.0: September 5, 2015
- Added option to change the cursor. Thanks to @Sp1tF1r3 on GitHub.
- 0.1.1: February 14, 2015
- Initial Release
[출처] http://flask-mysqldb.readthedocs.io/en/latest/
본 웹사이트는 광고를 포함하고 있습니다.
광고 클릭에서 발생하는 수익금은 모두 웹사이트 서버의 유지 및 관리, 그리고 기술 콘텐츠 향상을 위해 쓰여집니다.
광고 클릭에서 발생하는 수익금은 모두 웹사이트 서버의 유지 및 관리, 그리고 기술 콘텐츠 향상을 위해 쓰여집니다.

