How to get all the values in a column sequentially using SqlAlchemy?

user_13476133 0
Viewed 41

I have a Profile named School

Table is :

   id[pk]     name    division
   ------     ----    --------
 1  100       John      2
 2  102       Maria     5
 3  108       Hooper    4

PK Column Type: 'Numeric'.

How do get all the id values sequentially from the very first to the last using python?

sqlalchemy python-3.x python
1 Answers

Here:

for row in dbsession.query(School.id).order_by(School.id):
    print(row[0])
user_3151680
Related