How to use Flask SQLALCHEMY to operate on MySQL database under Python3

1. Use. 1) Use the init db function to create a database:

from import init_db>> init_db()

2) Example of inserting entries in the database:

from import db_session>> from import user

u = user('admin', 'admin@localhost')

db_ db_

3) Inquiry: >>

== 'admin').first()二Introduction。 sqlalchemy is a popular database abstraction layer and requires some configuration to use, which can be extended from pypi**flask-sqlalchemy.

The claims extension in SQL Alchemy is the latest way to use SQL Alchemy, like Django, to define tables and models in one place and then use them everywhere.

1 All Quick Start - flask-sqlalchemy documentation

Configuration - flask-sqlalchemy documentation

pip install pymysql

After that, the database connection is made up of:

mysql://username:password@server/db

Instead. mysql+pymysql://username:password@server/db

That's it.

I created this users table manually in the database, so I forgot to set the id as the primary key. If you use the ORM's create all() method to create the correct table, you can create the correct table.

python3 hasn't been used, because the mac comes with it or you said python2 can't be used, you can use the following demo to run down:

cfrs2005 flask blog · github Secondly, pay attention to install mysql and pip install mysql-python related support libraries.