I am trying to access my User objection.js model from getStaticProps and getStaticPaths. However, I need to run import Knex from "knex"; import knexfile from "./knexfile"; impor...

Model.knex(knex); const app = express(); app.use(bodyParser.urlencoded({ extended: false })); app.use(bodyParser.json()); app.use(i18nextMiddleware); I want to test method getUsers of users co...

My project consists of node (express), knex, objectionjs with graphql. We are using Jest to test calls to graphql which behind the scenes uses objectionjs+knex to perform updates on Postgres db. A...

I have two models in Objection - "brands" and "offers". Brand: const { Model } = require('objection') class Brand extends Model { static get tableName() { return 'brands' } ...

I have an array newData = [{ sId: 'XXXXXX', itemlName: 'LSｽﾄﾚｯ', iCode: 'XXXXXX', iType: '', skus: 'XXXXXXX', iLevel: 'L2', cCode: '88', cName: 'Other', sCode: '999', sName: 'No Control', pLengthC...

I'm looking for a way to capture the raw SQL for all the queries that the Objection.js library executes with the bindings interpolated into the SQL string. I realize that there's a Knex event handl...

I'd like to query for all records less than 48 hours of age using a created_at column. In PostgreSQL you can do something like: SELECT * from "media" WHERE updated_at >= now() - '48 hour'::INT...