自习的范围
测试平台开发前后端
上课形式
方式一： 在课程贴下方截图描述问题
方式二：共享屏幕、开麦描述问题
username = “root”
password = 123456
server = “42.192.73.147:3307”
database = “tpf”
app.config[‘SQLALCHEMY_DATABASE_URI’] = f"mysql+pymysql://{username}:{password}@{server}/{database}?charset=utf8mb4"
app.config[‘SQLALCHEMY_TRACK_MODIFICATIONS’] = True
app.config[“JWT_SECRET_KEY”] = “super-secret”
导入 flask 和 flask_sqlalchemy
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy import *
实例化flask
app = Flask(name)
进行数据库的配置
数据库的用户名
username = “root”
数据库的密码
#password = “1234qwer”
password = “123456”
数据库的ip：数据库端口
#server = “127.0.0.1:3306”
server = “42.192.73.147:3307”
数据库名
#db = “demo”
db = “tpf”
app.config[‘SQLALCHEMY_DATABASE_URI’] =
f"mysql+pymysql://{username}:{password}@{server}/{db}?charset=utf8"
app.config[‘SQLALCHEMY_TRACK_MODIFICATIONS’] = True
SQLAlchemy 绑定app
db = SQLAlchemy(app)
每个类表示一张表
class User0709(db.Model):
id = Column(Integer, primary_key=True)
username = Column(String(80))
if name == ‘main’:
# 创建表
db.create_all()
# 删除表
#db.drop_all()
aniso8601==9.0.1
attrs==22.1.0
certifi==2022.12.7
charset-normalizer==2.1.1
click==8.1.3
colorama==0.4.6
exceptiongroup==1.0.4
Flask==2.1.3
Flask-Cors==3.0.10
Flask-JWT-Extended==4.4.4
flask-restx==0.5.1
Flask-SQLAlchemy==2.5.1
greenlet==2.0.1
idna==3.4
importlib-metadata==5.1.0
importlib-resources==5.10.0
iniconfig==1.1.1
itsdangerous==2.1.2
jenkinsapi==0.3.11
Jinja2==3.1.2
jsonschema==4.17.3
MarkupSafe==2.1.1
packaging==22.0
pkgutil_resolve_name==1.3.10
pluggy==1.0.0
PyJWT==2.6.0
PyMySQL==1.0.2
pyrsistent==0.19.2
pytest==7.2.0
pytz==2022.6
PyYAML==6.0
requests==2.28.1
six==1.16.0
SQLAlchemy==1.4.44
tomli==2.0.1
urllib3==1.26.13
Werkzeug==2.1.0
zipp==3.11.0
/usr/local/bin/python3.10 /Users/renyc/renycHome/projectFlask/flak_sql_alchemy05/demoTest.py
Traceback (most recent call last):
File “/Users/renyc/renycHome/projectFlask/flak_sql_alchemy05/demoTest.py”, line 64, in
db.create_all()
File “/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask_sqlalchemy/extension.py”, line 887, in create_all
self._call_for_binds(bind_key, “create_all”)
File “/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask_sqlalchemy/extension.py”, line 858, in _call_for_binds
engine = self.engines[key]
File “/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask_sqlalchemy/extension.py”, line 639, in engines
app = current_app._get_current_object() # type: ignore[attr-defined]
File “/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/werkzeug/local.py”, line 508, in _get_current_object
raise RuntimeError(unbound_message) from None
RuntimeError: Working outside of application context.
This typically means that you attempted to use functionality that needed
the current application. To solve this, set up an application context
with app.app_context(). See the documentation for more information.
Process finished with exit code 1
python
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///path/to/database.db'
db = SQLAlchemy(app)
# 创建应用程序上下文
with app.app_context():
# 在此处执行需要应用程序上下文的操作
db.create_all()
# 操作完成后，应用程序上下文会自动关闭
# 其他应用程序代码...
