howTo translate Web2Py SQL Code with ROW_NUM, LIMIT into DAL?

Question

How is this (SQLite Code), working:

csv_rt_bat_c_x = db.executesql('select * from csv_rt_bat_c LIMIT 100')

converted into Web2Py DAL?

Thats working:

csv_rt_bat_c_x = db().select(db.csv_rt_bat_c.ALL)

But how to add the 100 LIMIT (to speed it up for development) ?

score 0 · Accepted Answer · answered Sep 02 '19 at 16:56

0

Use the limitby argument:

csv_rt_bat_c_x = db().select(db.csv_rt_bat_c.ALL, limitby=(0, 100))

answered Sep 02 '19 at 16:56

Anthony

As workaround I found: csv_rt_bat_c_x = db.executesql('select * from csv_rt_bat_c LIMIT 100') Yours is much better. It allows to speed up when testing on large tables and is acroding to the standard. – klausz Sep 02 '19 at 23:15

1 Answers1