Flask SQLAlchemy query specify column names

Question

How do I specify the column that I want in my query using a model  it selects all columns by default   I know how to do this with the sqlalchmey session  session query self col1   but how do I do it with with models   I can t do SomeModel query    Is there a way

User · Answer

As session query SomeModel col1  returns an array of tuples like this    value 1      value 2     if you want t cast the result to a plain array you can do it by using one of the following statements  values    value 0  for value in session query SomeModel col1   values    model col1 for model in session query SomeModel  options load only  col1      Result     value 1    value 2

User · Answer

You can use Model query  because the Model  or usually its base class  especially in cases where declarative extension is used  is assigned Sesssion query property  In this case the Model query is equivalent to Session query Model    I am not aware of the way to modify the columns returned by the query  except by adding more using add columns     So your best shot is to use the Session query Model col1  Model col2        as already shown by Salil

User · Answer

An example here   movies   Movie query filter Movie rating    0  order by desc Movie rating   all     I query the db for movies with rating  lt   0  and then I order them by rating with the higest rating first   Take a look here  Select  Insert  Delete in Flask-SQLAlchemy

User · Answer

You can use Query values  Query values  session query SomeModel  values  id    user

User · Answer

session query   with entities SomeModel col1    is the same as  session query SomeModel col1    for alias  we can use  label    session query SomeModel col1 label  some alias name

User · Answer

You can use load only function   from sqlalchemy orm import load only  fields     name    addr    phone    url   companies   session query SomeModel  options load only  fields   all

User · Answer

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

[python] Flask SQLAlchemy query, specify column names

Examples related to python

Examples related to sqlalchemy

Examples related to flask-sqlalchemy