I'm using SQLALchemy and Postgresql.
Imagine I have a SQLAlchemy class Items
,
There are 100 items in this table, I want to get for example 200 random rows(expected rows are not unique indeed).
for getting less than 100 easily I do:
items = session.query(Items)\
.order_by(func.random())\
.limit(80)\
.all()
But how can I get more than 100 rows if only I have 100?
Aucun commentaire:
Enregistrer un commentaire