1 coursesRouter.get('/:id',expressAsyncHandler(async(req,res)=>{
2 const pageSize = 1;
3 const page = Number(req.query.pageNumber) || 1;
4 const courseId = req.params.id;
5 const course = await db('id').from('courses').where('id','=',courseId)
6 const courseName = course[0].name
7 const sections = await db('course_name').from('sections').where('course_name','=',courseName).limit(pageSize).offset(pageSize * (page - 1))
8 const count = await db('course_name').from('sections').count('sections')
9 console.log( Math.ceil( count[0]/pageSize));
10 res.send({sections , page, pages: Math.ceil( count[0]/pageSize)})
11}))
1 coursesRouter.get('/:id',expressAsyncHandler(async(req,res)=>{
2 const pageSize = 1;
3 const page = Number(req.query.pageNumber) || 1;
4 const courseId = req.params.id;
5 const course = await db('id').from('courses').where('id','=',courseId)
6 const courseName = course[0].name
7 const sections = await db('course_name').from('sections').where('course_name','=',courseName).limit(pageSize)
8 .offset(pageSize * (page - 1))
9 const count = await db('course_name').from('sections').count('sections')
10 console.log( Math.ceil( count[0]/pageSize));
11 res.send({sections , page, pages: Math.ceil( count[0]/pageSize)})
12}))