Hello friends :wave: Anyone know whether it's poss...
# orm-helpk
Kent C. Dodds
11/17/2021, 7:20 PMHello friends 👋 Anyone know whether it's possible to get a random row in the db via the query without pulling everything and grabbing a random one in the client/node?
j
Joonatan
11/17/2021, 7:26 PMI think you could for example generate random integer before querying the table. If you have an integer id column in the table you can just then query prisma.mytable.findOne({where: {id: randomId}}})
Of course in this case you would have to first find the max id the table contains.
k
Kent C. Dodds
11/17/2021, 7:30 PMThanks for the idea, but I'd rather not use integers and query for the max id 😅
p
Pierre Ortega
11/17/2021, 10:33 PMYou can get the count of the table, get a random number between 0 and the number of rows, then do a select with`LIMIT 1 OFFSET $RANDOMNUMBER` . I’m sure you can add these parameters to a query, just not sure what is the equivalent in prisma API
Pierre Ortega
11/17/2021, 10:36 PMI believe this should work:
Copy code
const count = await prisma.table.count();
const randomRowNumber = Math.floor(Math.random() * count);
const randomRow = await prisma.table.findMany({ take: 1, skip: randomRowNumber });k
Kent C. Dodds
11/17/2021, 10:36 PMWas hoping I could do this in one query, but that definitely is better! Thanks @Pierre Ortega!
p
Pierre Ortega
11/17/2021, 10:38 PMYeah… I don’t see a way of doing in one query without writing the SQL query ourselves and using
queryRawk
Kent C. Dodds
11/17/2021, 10:39 PMThat's ok, this will work great. Thank you!
🙌 1
3 Views