import * as uuid from 'uuid'
import { Students } from './../sqlz/models/students'
import { where, Op } from 'sequelize/types'
import { Request, Response } from 'express'

export function create(students: any): Promise<any> {
  return Students.create({
    id: uuid.v1(),
    code: students.code,
    firstname: students.firstname,
    lastname: students.lastname,
    email: students.email,
    sdt: students.sdt
  })
}
export function findAll(): Promise<any> {
  return Students.findAll()

}

export function findStudentPagination(page: any, pagesize: any): Promise<any> {
  return Students.findAndCountAll({
    offset: (page - 1) * pagesize,
    limit: pagesize
    //offset: 1,
    //limit: 2
  })

}

export function deleteUser(code: any): Promise<any> {
  return Students.destroy({
    where: { code }
  })
}

export function updateUser(code: any, students: any): Promise<any> {
  return Students.findOne({
    where: { code }
  }).then(function(student) {
    if (student) {
      student.update({
        firstname: students.firstname,
        lastname: students.lastname,
        email: students.email,
        sdt: students.sdt
      })
    }
  })
}