/**
 * Created by doan_du on 20/11/2018.
 */


module.exports = {
    tableName: 'Students',
    user: { model: 'Student' },
    primaryKey: 'id',
    attributes: {
        id: {  type: 'number', required: true  },
        class_id: { type: 'string' },
        createdAt: false,
        updatedAt: false
    },

    getAllStudents : async function(isDeleted, keyword, classId){


        var condition = {
            sort : '',
            where : {full_name : keyword}
        };


        //check if exist isDeleted,keyword(search by name, phone),classId

        // if(isDeleted) condition.isDeleted = parseInt(isDeleted);
        // if(keyword.phone) condition.phone = 'LIKE %' +  


        
        



        //query and catch error : err - variable error, res - variable result

        var result = {};

        var ListStudent = await Student.find();

        for( i in ListStudent){
            result[ListStudent[i].id] = ListStudent[i];
        }

        return result;


        

    }


    // createItem : async function(data_create) {
    //     var created = await Student.create(data_create).fetch();

    //     return created ? true : false;
    // },

    // updateItem : async function(condition, data_update) {

    //     var updated = await Student.update(condition).set(data_update).fetch();

    //     return updated ? true : false;
    // },

    // getListItems : async function (args) {
    //     var query = 'SELECT Students.*, Users.full_name, Users.email, Users.phone, Users.address, Users.active ';
    //     query += 'FROM Students ';
    //     query += 'JOIN Users ON Students.id = Users.id ';
    //     query += 'LIMIT $1 OFFSET $2';
    //     return await Student.query(query, [args.limit, args.offset] , function(err, rawResult) {
    //         if (err || !rawResult) {
    //             console.log(err);
    //             return false;
    //         }
    //         return rawResult.rows;
    //     });
    // },




}