const db = require('../config/mysqlConfig')
const crypto = require('crypto')
const moment = require('moment')
const UserEntity = require('../entity/UserEntity')

let UserDao = {
    selectById: UserID => {
        let sql = `SELECT * from user where user_id = '` + UserID + `'`
        return db.query(sql)
    },
    selectByName: UserName => {
        let sql = `SELECT * from user where user_name = '` + UserName + `'`
        return db.query(sql)
    },
    update: User => {
        let sql = `UPDATE user SET `;
        if (User.Password !== undefined && User.Password !== ''){
            sql += `password = '` + User.Password + `'`
        }
        if (User.avatarUrl !== undefined && User.avatarUrl !== ''){
            sql += `avatar = '` + User.avatarUrl + `'`
        }
        if (User.description !== undefined && User.description !== ''){
            sql += `description = '` + user.description + `'`
        }
        sql += ` WHERE user_id = '` + User.userID + `'`
        return db.query(sql)
    },
    insert: User => {
        let password = crypto.createHash('md5').update(User.password).digest('hex')
        let createdAt = moment(Date.now()).format('YYYY-MM-DD HH:mm:ss')
        let sql = `insert into user(user_name, password, avatar, description, create_time) values('${User.userName}', '${password}', '${User.avatarUrl}', '${User.description}', '${createdAt}')`
        db.query(sql)
    }
}

module.exports = UserDao