const mysql = require('../utils/mysql_db')
const dbhandle = require('../utils/handle_db')
const uuid = require('node-uuid')

module.exports = {
  /**
   * 更新验证码
   */
  async updateVerification(params) {
    let sql = `UPDATE SYS_USER SET verification_code = '${params.code}' WHERE tel = '${params.phone}'`
    return await mysql.query(sql)
  },

  /**
   * 验证码登录
   */
  async getUser(params) {
    let sql = `SELECT * FROM SYS_USER WHERE TEL = '${params.phone}' AND verification_code = '${params.code}'`
    return await mysql.query(sql)
  }
}