realpython/members

const knex = require('../connection');

function getChapters(callback) {
  return knex('chapters')
  .select('*')
  .orderBy('order_number')
  .then((chapters) => {
    callback(null, chapters);
  })
  .catch((err) => {
    callback(err);
  });
}

function getSingleChapterFromID(chapterID, callback) {
  return knex('chapters')
  .select('*')
  .where('id', parseInt(chapterID))
  .then((chapter) => {
    callback(null, chapter);
  })
  .catch((err) => {
    callback(err);
  });
}

function getSingleChapterFromOrderNum(orderNum, callback) {
  return knex('chapters')
  .select('*')
  .where('order_number', parseInt(orderNum))
  .then((chapter) => {
    callback(null, chapter);
  })
  .catch((err) => {
    callback(err);
  });
}

function getChaptersAndLessons(callback) {
  return knex.select(
    'lessons.id as lessonID',
    'lessons.lesson_order_number as lessonLessonOrder', 'lessons.chapter_order_number as lessonChapterOrder',
    'lessons.name as lessonName',
    'lessons.content as lessonContent',
    'lessons.active as lessonActive',
    'chapters.id as chapterID',
    'chapters.order_number as chapterOrder',
    'chapters.name as chapterName'
  )
  .from('chapters')
  .join('lessons', 'lessons.chapter_id', 'chapters.id')
  .where('lessons.active', true)
  .then((data) => {
    callback(null, data);
  })
  .catch((err) => {
    callback(err);
  });
}

function addChapter(obj, callback) {
  return knex('chapters')
  .insert(obj)
  .returning('*')
  .then((chapter) => {
    callback(null, chapter);
  })
  .catch((err) => {
    callback(err);
  });
}

function deactivateChapter(chapterID, callback) {
  return knex('chapters')
  .update({
    active: false
  })
  .where('id', parseInt(chapterID))
  .returning('*')
  .then((chapter) => {
    callback(null, chapter);
  })
  .catch((err) => {
    callback(err);
  });
}

function updateChapter(chapterID, obj) {
  return knex('chapters')
    .update(obj)
    .where('id', parseInt(chapterID))
    .returning('*');
}

module.exports = {
  getChapters,
  getSingleChapterFromID,
  getSingleChapterFromOrderNum,
  getChaptersAndLessons,
  addChapter,
  deactivateChapter,
  updateChapter: updateChapter
};