Database with node drills

gistfile1.txt

require('dotenv').config();
const knex = require('knex');


const knexInstance = knex({
    client: 'pg',
    connection: process.env.DB_URL
})

function searchName(searchTerm) {
    knexInstance
        .select('id', 'name', 'price', 'category')
        .from('shopping_list')
        .where('name', 'ILIKE', `%${searchTerm}%`)
        .then(result => {
            console.log(result)
        })
}

searchName('fried')

function paginateProducts(page) {
    const productsPerPage = 6;
    const offset = productsPerPage * (page -1);
    knexInstance    
        .select('id', 'name', 'price', 'category')
        .from('shopping_list')
        .limit(productsPerPage)
        .offset(offset)
        .then(result => {
            console.log(result);
        })
}
paginateProducts(2);

function mostPopularVideosForDays(days) {
    knexInstance
      .select('name', 'date_added')
      .where(
        'date_added',
        '>',
        knexInstance.raw(`now() - '?? days'::INTERVAL`, days)
      )
      .from('shopping_list')
      .orderBy([
        { column: 'date_added', order: 'ASC' },
      ])
      .then(result => {
        console.log(result)
      })
  }
  
  mostPopularVideosForDays(30)

  function costPerCategory() {
    knexInstance
      .select('category')
      .sum('price as total')
      .from('shopping_list')
      .groupBy('category')
      .then(result => {
        console.log('COST PER CATEGORY')
        console.log(result)
      })
  }
  
  costPerCategory()