How to use the queryBuilder function from knex

media-controller.js

GitHub: mirfishe/PKD-and-Me-Server-V2

198
199
200
201
202
203
204
205
206
207
// const createMedia = {
//     media:      request.body.recordObject.media,
//     sortID:     newSortID
//   };

db.queryBuilder()
  .from(tableName)
  .max("sortID")
  .first() // * Add this to get an object. -- 05/06/2021 MF
  .then((maxSortID) => {

0

0

0

statisticsDb.js

GitHub: math-learning/exercises-service

46
47
48
49
50
51
52
53
54
55
/**
 * Get error count of exercise
 *
 */
const getExercisesErrorCount = async ({ courseId }) => (
  knex.queryBuilder()
    .select(knex.raw('eec.exercise_id, eec.guide_id, eec.course_id, eec.user_id, ex.name, sum(error_count)::integer as count'))
    .from('exercise_errors_count as eec')
    .innerJoin('exercises as ex', function innerJoinFn() {
      this.on('eec.exercise_id', 'ex.exercise_id');

0

0

3

+ 7 other calls in file