How to use AdonisJS v6 Repl to read data

[wswawan]

In another version adonisjs to read data in Repl I can use query() why in v6 I can't use the query builder like below this

await loadModels()
await models.user.query().select()

but for create method it works

with adonisjs v6 Repl to read data I want to be able to use query builders like all(), find(), findBy() and others

[Julien-R44]

not sure if i understand your problem. the REPL code you just posted works fine. what's the error or issue you are facing?

await loadModels()
const user = await models.user.query().select().first()
user.name // will print the user name in the repl

[wswawan]

I want to read all values in table users, like using sql query SELECT * FROM users; or using limit SELECT * FROM users limit 2;, first() method works fine.

[Julien-R44]

well, can you show the code that is not working? because, this will be the same thing :

await loadModels()
const users = await models.user.query().select()
const usersLimit = await models.user.query().select().limit(2)

i think, you are probably missing an await before your call

[wswawan]

this is the capture of my results

if using variable db from await loadDb() it works fine

[Julien-R44]

yeah that's normal. in the first case, it returns instances of User. in the second case, it's just standard json, plain POJOs

read this

in your first screenshot, if you write users[0].id you'll get the id displayed in the REPL

[wswawan]

thank you