Adonis.js search queries

Question

I'm trying to find a way to execute a search query using AdonisJs but I cannot find any way to do this with Lucid ORM...

I'm currently using this, but it's clearly not the right way to make a search query:

let posts = yield Post.query().with('category').where({
   title: request.input('term')
}).forPage(1, 10).fetch()

How can I directly execute postgres SQL queries using adonis.js framework?

SELECT id FROM posts WHERE content LIKE '%searchterm%' OR WHERE tags LIKE '%searchterm%' OR WHERE title LIKE '%searchterm%'

What is the point of using all those fancy ORM-s and to seek raw-query execution at the same time? — vitaly-t, May 25 '17 at 17:21

hailton · Answer 1 · 2017-05-27T02:24:44.880

4

Found the solution to directly execute SQL queries in Adonis with Database.schema.raw(execute queries here), so:

const postQuery = yield Database.schema.raw('SELECT * FROM posts');
const posts = postQuery.rows
console.log(posts);

Edit 1
To perform a search query with Lucid ORM:

const term = request.input('term');
yield Database.select('*').from('posts').where('title', 'LIKE', '%'+term+'%')
console.log(posts);

Edit 2
Even better raw query:

yield Database.select('*').from('posts').whereRaw('title @@ :term OR description @@ :term', {term: '%'+term+'%'})

edited May 27 '17 at 02:24

answered May 26 '17 at 16:01

hailton

score 2 · Answer 2 · answered Mar 05 '19 at 07:25

Assuming you have a Model named Post.You can use the following query.

const term = request.input('term');
const posts = await Post.query().where('title', 'LIKE', '%'+term+'%').fetch()
console.log(posts);

If you want to select all attributes,you don't need to use select() Hope it will help you.

2 Answers2