listing_search.js

require('dotenv').config()
const { Pool } = require('pg')

const pool = new Pool({
  connectionString: process.env.DATABASE_URL,
  ssl: true,
  pool: 1
})

pool.connect()

const query = `
SELECT
       ts_rank_cd(search_vector, plainto_tsquery('english', $1)) rank,
       l.updated_at,
       l.stock_number,
       l.updated_at,
       l.description,
       l.photos
FROM vw_listing_search search
    JOIN listings l ON search.stock_number = l.stock_number
    WHERE search.search_vector @@ plainto_tsquery('english', $1)
    ORDER BY 1;
`
module.exports = async (req, res) => {
  try {
    const term = req.query.q
    const { rows: data } = await pool.query(query, [term])
    const meta = { term, result_count: data.length }

    res.json({ meta, data })
  } catch (error) {
    res
      .status(500)
      .json({ error: 'There was a problem processing your request' })
  }
}