Jinja2 VS flask-sqlalchemy

But, on the other hand, I can read in the jinja repository that there is not the same Switching From Other Template Engines and also exists documentation about Support for templates engines

jinja: Default templating engine for and dependency of flask

or as complex as bringing Jinja into the picture. Some other options include mustache templates, the built in Template class, and some libraries noted here.

Jinja

Hey u/GuzTech , this issue is mostly related to an old version of jinja that you might be using, here is the report: https://github.com/pallets/jinja/issues/1585

Turns out it wasn't how I was getting the variable -- registered from the api call VS lookup('file') -- it was mainly that for some reason, using 'map()' sometimes needs ' | list | to_json ' tacked on to the end to correctly output the results without the "generator object do_map at xxxx" instead (as mentioned here).

- Link: https://github.com/pallets/jinja/blob/master/jinja2/sandbox.py

Cookiecutter is a command-line utility that creates projects from templates. There's a list of templates maintained by the cookiecutter team and plenty of community awesome lists. It's built with python and uses the jinja templating framework (found in python web frameworks like flask). You can use it to make a template for pretty much anything! All you need to get started is pip install cookiecutter.

This major release of Flask is accompanied by major releases of Werkzeug, Jinja2, click, and itsdangerous which we'd also welcome and appreciate testing (their pre releases are installed with the Flask pre release).

You should probably use a database for this, using something like sqlite a single file "database" is probably the quickest way to get started, I recommend you use it with Flask-SQLAlchemy which makes working with the db easy as pie.

Flask-SQLAlchemy: An extension that integrates SQLAlchemy with Flask. You can install it using pip install flask-sqlalchemy.

flask-sqlalchemy: ORM for database access

I've made several runs at stripping the essential paginating functionality of flask-sqlalchemy for use with things like lists. That's where I'd start.

You can either use an ORM, which might be sqlalchemy, possibly wrapped up as a flask plugin https://flask-sqlalchemy.palletsprojects.com/ or more directly: https://www.sqlalchemy.org/

You can learn more about this approach and see an example is this Flask-SQLAlchemy PR.

Flask SQL Alchemy

I used for this project Flask and OpenAI CLIP. For the vector search I used approximate nearest neighbors provided by spotify/annoy. I used Flask-SQLAlchemy with GeoAlchemy2 to query GPS coordinates. The embedding was done using UMAP using the CLIP image vectors.

This appears to be this: https://github.com/pallets/flask-sqlalchemy/issues/910

from sqlalchemy.engine.reflection import Inspector from sqlalchemy.schema import DropConstraint, DropTable, MetaData, Table from extensions import db # from dotmap import DotMap def try_add(object): """ Try to add the column 'object' to its table in the database and return it. """ try: db.session.add(object) db.session.commit() return object except Exception: db.session.rollback() raise def drop_all_cascade(): """(On a live db) drops all foreign key constraints before dropping all tables. Workaround for SQLAlchemy not doing DROP ## CASCADE for drop_all() (https://github.com/pallets/flask-sqlalchemy/issues/722) """ con = db.engine.connect() trans = con.begin() inspector = Inspector.from_engine(db.engine) # We need to re-create a minimal metadata with only the required things to # successfully emit drop constraints and tables commands for postgres # (based on the actual schema of the running instance) meta = MetaData() tables = [] all_fkeys = [] for table_name in inspector.get_table_names(): fkeys = [] for fkey in inspector.get_foreign_keys(table_name): if not fkey["name"]: continue fkeys.append(db.ForeignKeyConstraint((), (), name=fkey["name"])) tables.append(Table(table_name, meta, *fkeys)) all_fkeys.extend(fkeys) for fkey in all_fkeys: con.execute(DropConstraint(fkey)) for table in tables: con.execute(DropTable(table)) trans.commit()