hrishikeshrt / flask-bootstrap-anywhere

Quickly set up a web-based application using Flask styled with Bootstrap and deploy on PythonAnywhere

GitHub Stats	Streak Stats

• 🔭 Interests: Sanskrit, Natural Language Processing, Computational Linguistics, Information Retrieval, Software, Knowledge Graphs, Databases
• ⚡ I use (and recommend) Conventional Commit Messages for all commits.

flask-bootstrap-anywhere's Issues

old dependencies and potential security issues

1. "flask-restx 1.2.0 requires Flask!=2.0.0,<3.0.0,>=0.8, but you have flask 3.0.0 which is incompatible."

2/. "cannot import name 'url_decode' from 'werkzeug.urls'", which fixed to downgrade:

pip uninstall werkzeug
pip install werkzeug==2.3.0

[Suggestion] Make this repo a "template"

Why?
So others can generate new repositories with the same directory structure, branches, and files as this repo.

Some references 👇

• Creating a template repository
• Creating a repository from a template

Database error after trying to use (Query-invoked autoflush)

1. Use this repo to create another repo, clone it, etc.
2. Create a venv: python3 -m venv venv
3. Activate the venv
4. Install requirements from the requirements.txt file (which result in much newer requirements being installed): pip install -r requirements.txt
5. Export the env from the README.
6. Run flask db init and flask db migrate and flask db upgrade.
7. Run flask run.
8. Load the homepage.
9. Observe the following error:

sqlalchemy.exc.InterfaceError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(sqlite3.InterfaceError) Error binding parameter 3 - probably unsupported type.
[SQL: INSERT INTO role (name, description, level, permissions) VALUES (?, ?, ?, ?)]
[parameters: ('owner', 'Owner', 1000, ['view_acp', 'remove_admin'])]
(Background on this error at: https://sqlalche.me/e/14/rvf5)

This is the pip freeze output:

alembic==1.8.1
Babel==2.11.0
blinker==1.5
certifi==2022.9.24
charset-normalizer==2.1.1
click==8.1.3
colorama==0.4.6
dnspython==2.2.1
email-validator==1.3.0
Flask==2.2.2
Flask-BabelEx==0.9.4
Flask-Login==0.6.2
Flask-Mail==0.9.1
Flask-Migrate==4.0.0
Flask-Principal==0.4.0
Flask-Security-Too==5.0.2
Flask-SQLAlchemy==3.0.2
Flask-WTF==1.0.1
gitdb==4.0.9
GitPython==3.1.29
greenlet==2.0.1
idna==3.4
importlib-metadata==5.0.0
importlib-resources==5.10.0
itsdangerous==2.1.2
Jinja2==3.1.2
Mako==1.2.4
MarkupSafe==2.1.1
passlib==1.7.4
pytz==2022.6
requests==2.28.1
smmap==5.0.0
speaklater==1.3
SQLAlchemy==1.4.44
urllib3==1.26.12
Werkzeug==2.2.2
WTForms==3.0.1
zipp==3.10.0

• Using SQLite

Add `Flask-Migrate` to `requirements.txt`

Flask-security-too 5.x compatibility.

There are a bunch of breaking changes.
Check and update the ones that need fixing.

Reference: https://flask-security-too.readthedocs.io/en/stable/changelog.html#version-5-0-0