func GetPlayer(id string) (playerObj *player.Player, exists bool, err error) {
command := "SELECT Name, UnionId, ExtraMsg, RegisterTime, LoginTime, IsForbidden, SilentEndTime FROM player WHERE Id = ?;"
var name string
var unionId string
var extraMsg string
var registerTime time.Time
var loginTime time.Time
var isForbidden bool
var silentEndTime time.Time
if err = dal.ChatDB().QueryRow(command, id).Scan(&name, &unionId, &extraMsg, ®isterTime, &loginTime, &isForbidden, &silentEndTime); err != nil {
if err == sql.ErrNoRows {
// 重置err，使其为nil；因为这代表的是没有查找到数据，而不是真正的错误
err = nil
return
} else {
logUtil.Log(fmt.Sprintf("Scan失败，错误信息：%s，command:%s", err, command), logUtil.Error, true)
return
}
}
playerObj = player.NewPlayer(id, name, unionId, extraMsg, registerTime, loginTime, isForbidden, silentEndTime)
exists = true
return
}
func GetAppConfig(appId string) *config.AppConfig {
command := "SELECT AppId, AppName, AppKey, MessageFolder, MaxFileSize FROM appconfig WHERE AppId = ?;"
var appName string
var appKey string
var messageFolder string
var maxFileSize int64
if err := dal.ChatDB().QueryRow(command, appId).Scan(&appId, &appName, &appKey, &messageFolder, &maxFileSize); err != nil {
if err == sql.ErrNoRows {
panic(errors.New("未找到appconfig配置内容"))
} else {
panic(errors.New(fmt.Sprintf("QueryRow失败，错误信息：%s，command:%s", err, command)))
}
}
return config.NewAppConfig(appId, appName, appKey, messageFolder, maxFileSize)
}
func UpdateForbiddenStatus(player *player.Player) error {
command := "UPDATE player SET IsForbidden = ? WHERE Id = ?"
stmt, err := dal.ChatDB().Prepare(command)
if err != nil {
logUtil.Log(fmt.Sprintf("Prepare失败，错误信息：%s，command:%s", err, command), logUtil.Error, true)
return err
}
// 最后关闭
defer stmt.Close()
if _, err = stmt.Exec(player.IsForbidden, player.Id); err != nil {
logUtil.Log(fmt.Sprintf("Exec失败，错误信息：%s，command:%s", err, command), logUtil.Error, true)
return err
}
return nil
}
func UpdateInfo(player *player.Player) error {
command := "UPDATE player SET Name = ?, UnionId = ?, ExtraMsg = ? WHERE Id = ?"
stmt, err := dal.ChatDB().Prepare(command)
if err != nil {
logUtil.Log(fmt.Sprintf("Prepare失败，错误信息：%s，command:%s", err, command), logUtil.Error, true)
return err
}
// 最后关闭
defer stmt.Close()
if _, err = stmt.Exec(player.Name, player.UnionId, player.ExtraMsg, player.Id); err != nil {
logUtil.Log(fmt.Sprintf("Exec失败，错误信息：%s，command:%s", err, command), logUtil.Error, true)
return err
}
return nil
}
func Insert(apiName, content string) error {
command := "INSERT INTO request_log(APIName, ServerGroupId, Content, Crdate) VALUES(?, ?, ?, ?);"
stmt, err := dal.ChatDB().Prepare(command)
if err != nil {
logUtil.Log(fmt.Sprintf("Prepare失败，错误信息：%s，command:%s", err, command), logUtil.Error, true)
return err
}
// 最后关闭
defer stmt.Close()
if _, err = stmt.Exec(apiName, dal.ServerGroupId, content, time.Now()); err != nil {
logUtil.Log(fmt.Sprintf("Exec失败，错误信息：%s，command:%s", err, command), logUtil.Error, true)
return err
}
return nil
}
func Insert(player *player.Player) error {
command := `INSERT INTO
player(Id, Name, UnionId, ExtraMsg, RegisterTime, LoginTime, IsForbidden, SilentEndTime)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?);
`
stmt, err := dal.ChatDB().Prepare(command)
if err != nil {
logUtil.Log(fmt.Sprintf("Prepare失败，错误信息：%s，command:%s", err, command), logUtil.Error, true)
return err
}
// 最后关闭
defer stmt.Close()
if _, err = stmt.Exec(player.Id, player.Name, player.UnionId, player.ExtraMsg, player.RegisterTime, player.LoginTime, player.IsForbidden, player.SilentEndTime); err != nil {
logUtil.Log(fmt.Sprintf("Exec失败，错误信息：%s，command:%s", err, command), logUtil.Error, true)
return err
}
return nil
}