mkhanal / knex-case-converter-plugin Goto Github PK

const response = await Role.forge({
      title: '12',
      active: 1,
    }).save();


ModelBase {
  attributes: [Object: null prototype] { title: '12', active: 1 },
  _previousAttributes: {},
  changed: [Object: null prototype] {},
  relations: {},
  cid: 'c1',
  _knex: null,
  id: undefined
}

database.raw(`
      SELECT associate.*, market_id
      FROM associate
      JOIN store ON store.id = associate.store_id
      JOIN market ON market.id = store.market_id
      WHERE associate.active = true
      AND market.id = ${marketId}
`);

database('associate')
      .join('store', 'store.id', '=', 'associate.store_id')
      .join('market', 'market.id', '=', 'store.market_id')
      .where('associate.active', '=', active)
      .andWhere('market.id', '=', marketId)
      .select('associate.*', 'market_id');