helloflask

helloflask copied to clipboard

SQLAlchemy + SQLite3 设置的字符长度限制不会生效

1

- 页数：258 - 如标题所示。 ```python class Book(db.model): name = db.Column(db.String(20)) # 字符数限制不会生效 ```

turtlekey

由于 flask 从 pocoo 转到由 pallets projects 进行维护，书中的多数链接需要进行更新，可以考虑在第二版中统一处理。

yuxiaoy1

Albumy 探索 报错 AttributeError: 'WhoosheeQuery' object has no attribute '_join_entities'

5

当我点击搜索按钮的时候，显示错误 Traceback (most recent call last): File "C:\Users\Slian\.virtualenvs\albumy-ABVUmZFk\Lib\site-packages\flask\app.py", line 2309, in __call__ return self.wsgi_app(environ, start_response) File "C:\Users\Slian\.virtualenvs\albumy-ABVUmZFk\Lib\site-packages\flask\app.py", line 2295, in wsgi_app response = self.handle_exception(e) File "C:\Users\Slian\.virtualenvs\albumy-ABVUmZFk\Lib\site-packages\flask\app.py", line 1741, in handle_exception...

Slian22

models模块中是否适合提交数据库会话

2

参考[Four SQLAlchemy Tips](https://www.youtube.com/watch?v=5-4W3m5gRAs)，Miguel建议不要在models模块中使用db.session.commit()，而应该在更高层的业务逻辑代码中去使用它（比如视图函数中），理由是可能会出现不符合预期的结果。 想了解下辉哥你对于这个问题的看法是什么，因为目前狼书里相关项目的models模块是包含db.session.commit()的，想问下根据你的经验，这种写法有出现过问题吗？

yuxiaoy1

这条SQL语句是不是有问题呀, photo没有tag_id字段, 是不是因该改成SELECT tag.* FROM tag JOIN tagging ON tag.id = tagging.tag_id JOIN photo ON photo.id=tagging.photo_id. 还有一点想问如果我把tagging修改为关联模型, 我是不是可以直接从tagging查找热们标签.而不是用join.大概就是Tagging.query.group_by(tagging.tag_id).order_by(func.count(tagging.photo_id).desc()).limet(10) 之后对查询出来的tagging在模板中分别使用tag关联属性(在建立模型的时候添加relationship)是不是也能实现相同的功能.

guoxy2016

Bump mako from 1.1.2 to 1.2.2

1

Bumps [mako](https://github.com/sqlalchemy/mako) from 1.1.2 to 1.2.2. Release notes Sourced from mako's releases. 1.2.2 Released: Mon Aug 29 2022 bug [bug] [lexer] Fixed issue in lexer where the regexp used to...

dependabot[bot]

Flask-SQLAlchemy would automatically import `db` instance and Model class in `flask shell` since version 3.0.0

yuxiaoy1

yuxiaoy1

Bump urllib3 from 2.2.1 to 2.2.2 in /requirements

1

Bumps [urllib3](https://github.com/urllib3/urllib3) from 2.2.1 to 2.2.2. Release notes Sourced from urllib3's releases. 2.2.2 🚀 urllib3 is fundraising for HTTP/2 support urllib3 is raising ~$40,000 USD to release HTTP/2 support and...

dependabot[bot]

Bumps [werkzeug](https://github.com/pallets/werkzeug) from 1.0.1 to 3.0.6. Release notes Sourced from werkzeug's releases. 3.0.6 This is the Werkzeug 3.0.6 security fix release, which fixes security issues but does not otherwise change...

dependabot[bot]