pg-related usage

pg-related-use.js

import 'dotenv/config'
import knex from 'pg-related'

const sql = knex({
    client: 'pg',
    connection: process.env.PG_CONNECTION,
    serarchpath: ['public']
})
;(async () => {
    const out =
        // base query
        await sql('cart')
            .select('cart.*')
            .join('cart_row', 'cart.id', 'cart_row.cart_id')
            .limit(10)
            // say that we want eager loading of data relate to cart
            // c is alials for the base query
            // cart is the type of base query relation
            .relation({ c: 'cart' })
            // list relations
            // for each realation we set:
            // cu: alias for the relation
            // customer: relation type, many relations can reference the same type
            // query snippet: the query to load relate data, usually a join or a later/subquery
            .relate({ cu: 'customer' }, q =>
                q.join({ cu: 'customer' }, 'cu.id', 'c.customer_id')
            )
            .relate({ cr: 'cart_row' }, q =>
                q.join({ cr: 'cart_row' }, 'cr.cart_id', 'c.id')
            )
    console.log(JSON.stringify(out, null, ' '))
})().finally(() => sql.destroy())