/**
 * 
 * 专门用来处理hero表的操作
 */

const connection = require('./conn')

module.exports = {
    getHeroList(callback) {
        // 真正的和数据库打交道
        const sql = `select * from heros  where isDelete = 0 ORDER BY id desc`
        connection.query(sql, (err, data) => {
            if (err) {
                callback(err)
            } else {
                callback(null, data)
            }
        })
    },
    addHero(obj, callback) {
        const sql = 'insert into heros set ?'
        connection.query(sql, obj, (err, data) => {
            if (err) {
                callback(err)
            } else {
                callback(null)
            }
        })
    },
    getHeroById(id, callback) {
        const sql = `select id, name, gender, img from heros where id = ${id}`
        connection.query(sql, (err, data) => {
            if (err) {
                callback(err)
            } else {
                callback(null, data[0])
            }
        })
    },
    editHero(obj, callback) {
        const sql = 'update heros set ? where id = ?'
        connection.query(sql, [obj, obj.id], (err, data) => {
            if (err) {
                callback(err)
            } else {
                callback(null)
            }
        })
    },
    delHeroById(id, callback) {
        // 软删除
        // const sql = 'delete from users where id = ?'
        const sql = 'update heros set isDelete = 1 where id = ?'
        connection.query(sql, [id], (err) => {
            if (err) {
                callback(err)
            } else {
                callback(null)
            }
        })
    },
    doLogin(userName, callback) {
        const sqlStr = `select * from users where userName = ?`
        connection.query(sqlStr, [userName], (err, results) => {
            if (err) {
                callback(err)
            } else {
                callback(null, results[0])
            }
        })
    }
}