You can do it by using either the lower or upper functions in your filter: from sqlalchemy import func user = models.User.query.filter(func.lower(User.username) == func.lower(“GaNyE”)).first() Another option is to do searching using ilike instead of like: .query.filter(Model.column.ilike(“ganye”))
Edit If you’re experiencing this, upgrading Flask-SQLAlchemy to >= 2.5 should resolve the issue per https://github.com/pallets/flask-sqlalchemy/issues/910#issuecomment-802098285. Pinning SQLAlchemy to ~1.3 should no longer be necessary. I ran into this issue a little earlier, but think I’ve figured out what’s going on. SQLAlchemy is automatically installed as a dependency for Flask-SQLAlchemy and its latest release (1.4.0) … Read more
The flask_sqlalchemy module does not have to be initialized with the app right away – you can do this instead: # apps.members.models from flask_sqlalchemy import SQLAlchemy db = SQLAlchemy() class Member(db.Model): # fields here pass And then in your application setup you can call init_app: # apps.application.py from flask import Flask from apps.members.models import db … Read more
Below should work in most cases: df = pd.read_sql(query.statement, query.session.bind) See pandas.read_sql documentation for more information on the parameters.
You can use the with_entities() method to restrict which columns you’d like to return in the result. (documentation) result = SomeModel.query.with_entities(SomeModel.col1, SomeModel.col2) Depending on your requirements, you may also find deferreds useful. They allow you to return the full object but restrict the columns that come over the wire.
It seems that you actually haven’t executed your query. Try following: return jsonify(json_list = qryresult.all()) [Edit]: Problem with jsonify is, that usually the objects cannot be jsonified automatically. Even Python’s datetime fails 😉 What I have done in the past, is adding an extra property (like serialize) to classes that need to be serialized. def … Read more
Have you tried: result = db.engine.execute(“<sql here>”) or: from sqlalchemy import text sql = text(‘select name from penguins’) result = db.engine.execute(sql) names = [row[0] for row in result] print names Note that db.engine.execute() is “connectionless”, which is deprecated in SQLAlchemy 2.0.