mysql_model

package
v0.0.0-...-59da782 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Jul 30, 2020 License: GPL-3.0 Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func AcceptFriend

func AcceptFriend(userId, friendId, source string, addTime int64) error

func AcceptFriendApply

func AcceptFriendApply(userId, friendId string) (int64, error)

func ActiveAd

func ActiveAd(id string, isActive int) error

func AddMember

func AddMember(tx types.Tx, userId, roomId string, memberLevel int, createTime int64, source string) (int64, error)

func AddMemberReceiveLog

func AddMemberReceiveLog(logId, receiver string, state int) (int64, error)

添加群成员消息接收日志

func AddMutedMember

func AddMutedMember(tx types.Tx, roomId, userId string, mutedType int, deadline int64) (int64, error)

func AddPrivateChatLog

func AddPrivateChatLog(senderId, receiveId, msgId string, msgType, status, isSnap int, content, ext string, time int64) (int64, int64, error)

func AddToken

func AddToken(userid, token string, createTime int64) (int64, error)

func AddUser

func AddUser(markId, uid, appId, username, phone, userLevel, device, version string, createTime int64) (int64, error)

func AddVerifyApply

func AddVerifyApply(val *types.VerifyApply) (int64, error)

func AdminCheckLogin

func AdminCheckLogin(appId, account string) (*types.Admin, error)

func AlertRoomRevStateByRevId

func AlertRoomRevStateByRevId(revId string, state int) error

func AppendApplyLog

func AppendApplyLog(targetId, userId, applyReason, source, remark string, state, tp int, datetime int64) (int64, error)

添加入群申请记录

func AppendRoomChatLog

func AppendRoomChatLog(userId, roomId, msgId string, msgType, isSnap int, content, ext string, time int64) (int64, int64, error)

func ApproveChangeStateStep

func ApproveChangeStateStep(tx types.Tx, logId int64, status int) (bool, error)

func ApproveInsertMemberStep

func ApproveInsertMemberStep(tx types.Tx, roomId, userId, source string) (bool, int64, error)

func CheckIsFriend

func CheckIsFriend(userId, friendId string, isDel int) (bool, error)

func CheckRoomMarkIdExist

func CheckRoomMarkIdExist(randomId string) (bool, error)

func ClearMutedList

func ClearMutedList(tx types.Tx, roomId string) error

func ClearUserDeviceToken

func ClearUserDeviceToken(userId string) (string, error)

func CloseRoom

func CloseRoom(tx types.Tx, roomId string, closeUntil int64) error

func CloseUser

func CloseUser(tx types.Tx, userId string, closeUntil int64) error

func CreateNewRoom

func CreateNewRoom(creater, roomName, roomAvatar string, encrypt, canAddFriend, joinPermission, recordPermission, adminMuted, masterMuted int, members []string, randomRoomId string, createTime int64) (int64, error)

func CreateNewRoomV2

func CreateNewRoomV2(tx types.Tx, creater, roomName, roomAvatar string, encrypt, canAddFriend, joinPermission, recordPermission, adminMuted, masterMuted int, randomRoomId string, createTime int64) (int64, error)

func DelMemberMuted

func DelMemberMuted(tx types.Tx, roomId, userId string) error

func DelPrivateChatLog

func DelPrivateChatLog(logId string) (int, error)

func DelRoomChatLogById

func DelRoomChatLogById(logId string) (int, error)

func DeleteAd

func DeleteAd(id string) error

func DeleteFriend

func DeleteFriend(userId, friendId string, alterTime int64) error

func DeletePraise

func DeletePraise(id string) error

func DeleteRoomById

func DeleteRoomById(roomId string) (bool, error)

func DeleteRoomMemberById

func DeleteRoomMemberById(userId, roomId string, time int64) (bool, error)

func FindAddFriendConfByUserId

func FindAddFriendConfByUserId(userId string) (*types.AddFriendConf, error)

func FindAdminById

func FindAdminById(id string) (*types.Admin, error)

获取管理员信息 根据id

func FindAdminOperateLog

func FindAdminOperateLog(appId, query string, optType *int, startId int64, number int) (int64, []*types.AdminOptLogView, error)

查询操作日志列表

func FindAdminOperateLogByOptType

func FindAdminOperateLogByOptType(appId string, optType int, startId int64, number int) ([]*types.AdminOptLog, error)

查询操作日志列表,根据操作类型

func FindAllPrivateLogs

func FindAllPrivateLogs() ([]*types.PrivateLog, error)

func FindAllRecommendRooms

func FindAllRecommendRooms(appId string) ([]*types.Room, error)

func FindApplyLogById

func FindApplyLogById(logId int64) (*types.Apply, error)

func FindApplyLogByUserAndTarget

func FindApplyLogByUserAndTarget(userId, targetId string, tp int) (*types.Apply, error)

func FindApplyLogs

func FindApplyLogs(userId string, id int64, number int) (int64, []*types.Apply, error)

func FindBlockedFriends

func FindBlockedFriends(userId string) ([]*types.FriendJoinUser, error)

func FindCreateRoomNumbers

func FindCreateRoomNumbers(masterId string) (int, error)

创建群个数 未解散

func FindFirstPrivateMsg

func FindFirstPrivateMsg(userId, friendId string) (*types.PrivateLog, error)

func FindFriendApplyCount

func FindFriendApplyCount(userId, friendId string) (int32, error)

func FindFriendById

func FindFriendById(userID, friendID string) (*types.FriendJoinUser, error)

func FindFriendsAfterTime

func FindFriendsAfterTime(userId string, commonUse int, time int64) ([]*types.FriendJoinUser, error)

func FindFriendsById

func FindFriendsById(userId string, commonUse, isDel int) ([]*types.FriendJoinUser, error)

func FindFriendsId

func FindFriendsId(userId string) ([]string, error)

func FindJoinedRooms

func FindJoinedRooms(userId string) ([]*types.RoomMember, error)

func FindLastCatLogId

func FindLastCatLogId(userId, friendId string) (int64, error)

func FindNotBurnedLogsAfter

func FindNotBurnedLogsAfter(userId string, isDel int, time int64) ([]*types.PrivateLogJoinUser, error)

func FindNotBurnedLogsBetween

func FindNotBurnedLogsBetween(userId string, isDel int, begin, end int64) ([]*types.PrivateLogJoinUser, error)

func FindPrivateChatLogById

func FindPrivateChatLogById(id string) (*types.PrivateLogJoinUser, error)

func FindPrivateChatLogByMsgId

func FindPrivateChatLogByMsgId(senderId, msgId string) (*types.PrivateLogJoinUser, error)

func FindPrivateChatLogs

func FindPrivateChatLogs(userId, friendId string, start int64, number int) (int64, []*types.PrivateLogJoinUser, error)

func FindPrivateChatLogsNumberBetween

func FindPrivateChatLogsNumberBetween(userId string, isDel int, begin, end int64) (int64, error)

func FindReceiveLogById

func FindReceiveLogById(logId, userId string) (*types.RoomMsgReceive, error)

func FindRoomBanTimes

func FindRoomBanTimes(roomId string) (int, error)

群被封群次数

func FindRoomChatLogByContentId

func FindRoomChatLogByContentId(logId string) (*types.RoomLogJoinUser, error)

func FindRoomChatLogByMsgId

func FindRoomChatLogByMsgId(senderId, msgId string) (*types.RoomLogJoinUser, error)

func FindRoomChatLogsAfterTime

func FindRoomChatLogsAfterTime(rooms []string, time int64) ([]*types.RoomLogJoinUser, error)

func FindRoomChatLogsBetweenTime

func FindRoomChatLogsBetweenTime(rooms []string, begin, end int64) ([]*types.RoomLogJoinUser, error)

func FindRoomChatLogsNumberBetween

func FindRoomChatLogsNumberBetween(rooms []string, begin, end int64) (int64, error)

func FindRoomLogs

func FindRoomLogs(roomId string, startId, joinTime int64, number int) (int64, []*types.RoomLogJoinUser, error)

func FindRoomLogsById

func FindRoomLogsById(roomId, owner string, startId, joinTime int64, number int, queryType []string) (int64, []*types.RoomLogJoinUser, error)

func FindRoomMemberById

func FindRoomMemberById(roomId, userId string, isDel int) (*types.MemberJoinUser, error)

func FindRoomMemberByName

func FindRoomMemberByName(roomId, name string) ([]*types.MemberJoinUser, error)

func FindRoomMembers

func FindRoomMembers(roomId string, searchNumber int) ([]*types.MemberJoinUser, error)

func FindRoomsInAppClosed

func FindRoomsInAppClosed(appId string) ([]*types.RoomJoinUser, error)

查找某个app所有下封禁群

func FindRoomsInAppQueryMarkId

func FindRoomsInAppQueryMarkId(appId, query string) ([]*types.RoomJoinUser, error)

查询某个app的所有群,模糊查询 markId 群名

func FindRoomsInAppRecommend

func FindRoomsInAppRecommend(appId string) ([]*types.RoomJoinUser, error)

查找某个app所有下推荐群(带 群主、人数、封群次数等信息)

func FindRoomsInAppUnClose

func FindRoomsInAppUnClose(appId string) ([]*types.RoomJoinUser, error)

查找某个app所有下未封禁群

func FindSessionKeyAlert

func FindSessionKeyAlert(userId string, endTime int64) ([]*types.PrivateLogJoinUser, error)

func FindSetNoDisturbingMembers

func FindSetNoDisturbingMembers(roomId string) ([]*types.RoomMember, error)

func FindSystemMsg

func FindSystemMsg(roomId string, startId int64, number int) (int64, []*types.RoomLog, error)

func FindToken

func FindToken(userid string) (map[string]string, error)

func FindTypicalPrivateChatLogs

func FindTypicalPrivateChatLogs(userId, friendId, owner string, startId int64, number int, queryType []string) (int64, []*types.PrivateLogJoinUser, error)

func FindUserBanTimes

func FindUserBanTimes(userId string) (int, error)

用户被封号次数

func FindUserCreateRoomsNumber

func FindUserCreateRoomsNumber(userId string) (int, error)

func FindUserIdByDeviceToken

func FindUserIdByDeviceToken(deviceToken string) (string, *string, error)

func FindVerifyApplyById

func FindVerifyApplyById(id string) (*types.VerifyApply, error)

func FindVerifyApplyByState

func FindVerifyApplyByState(tp int, targetId string, state int) ([]*types.VerifyApply, error)

func GetActiveNumber

func GetActiveNumber(appId string, startTime, endTime int64) (int64, error)

活跃用户统计

func GetActiveNumberAsPlatform

func GetActiveNumberAsPlatform(appId string, startTime, endTime int64, device string) (int64, error)

活跃用户统计

func GetActiveNumberAsVersion

func GetActiveNumberAsVersion(appId string, startTime, endTime int64, version string) (int64, error)

活跃用户统计

func GetActiveNumberAsVersionAndPlatform

func GetActiveNumberAsVersionAndPlatform(appId string, startTime, endTime int64, version, platform string) (int64, error)

活跃用户统计 根据版本和平台

func GetActiveUsersInfoAsVersion

func GetActiveUsersInfoAsVersion(appId string, startTime, endTime int64, version string) ([]*types.ActiveUsersView, error)

活跃用户统计信息

func GetActiveUsersInfoAsVersionAndPlatform

func GetActiveUsersInfoAsVersionAndPlatform(appId string, startTime, endTime int64, version, platform string) ([]*types.ActiveUsersView, error)

活跃用户统计信息 根据版本和平台

func GetAdNumbers

func GetAdNumbers(appId string) (int64, error)

func GetAddFriendApplyLog

func GetAddFriendApplyLog(userId, friendId string) (*types.Apply, error)

func GetAllAd

func GetAllAd(appId string) ([]*types.Advertisement, error)

func GetApplyListNumber

func GetApplyListNumber(id string) (int, error)

func GetCloseRoomCountInApp

func GetCloseRoomCountInApp(appId string) (int64, error)

func GetCloseUserCountInApp

func GetCloseUserCountInApp(appId string) (int64, error)

func GetCreateRoomsLimit

func GetCreateRoomsLimit(appId string, level int) (int, error)

获取用户创建群个数上限

func GetEnableRoomsId

func GetEnableRoomsId() ([]string, error)

获取所有群

func GetIsChain

func GetIsChain(userId string) (int64, error)

func GetJoinedRoom

func GetJoinedRoom(userId string, Type int) ([]*types.MemberJoinRoom, error)

func GetLastUserLoginLog

func GetLastUserLoginLog(userId string, device []string) (*types.LoginLog, error)

func GetMemberApplyInfo

func GetMemberApplyInfo(roomId, userId string) (*types.Apply, error)

func GetMemberNumber

func GetMemberNumber(roomId string) (int64, error)

func GetMutedListByType

func GetMutedListByType(roomId string, mutedType int) ([]*types.RoomUserMuted, error)

获取群的某种禁言信息列表

func GetOpenNumber

func GetOpenNumber(appId string, startTime, endTime int64) (int64, error)

打开应用统计

func GetOpenNumberAsPlatform

func GetOpenNumberAsPlatform(appId string, startTime, endTime int64, device string) (int64, error)

打开应用统计 筛选平台

func GetOpenNumberAsVersion

func GetOpenNumberAsVersion(appId string, startTime, endTime int64, version string) (int64, error)

打开应用统计 筛选平台

func GetOpenNumberAsVersionAndPlatform

func GetOpenNumberAsVersionAndPlatform(appId string, startTime, endTime int64, version, platform string) (int64, error)

打开应用统计 筛选版本和平台

func GetPraiseByLogId

func GetPraiseByLogId(channelType int, logId string) ([]*types.Praise, error)

func GetPraiseByLogIdAndOptId

func GetPraiseByLogIdAndOptId(channelType int, logId, optId string) ([]*types.Praise, error)

func GetPraiseByLogIdLimit

func GetPraiseByLogIdLimit(channelType int, logId string, startId int64, number int) ([]*types.Praise, int64, error)

func GetPraiseListByTarget

func GetPraiseListByTarget(msgSenderId string, channelType int, targetId string, startId int64, number int) ([]*types.Praise, int64, error)

func GetPraiseStaticAsLike

func GetPraiseStaticAsLike(startTime, endTime int64) ([]map[string]string, error)

func GetPraiseStaticAsReward

func GetPraiseStaticAsReward(startTime, endTime int64) ([]map[string]string, error)

func GetPraiseTodayLimit

func GetPraiseTodayLimit(optId string) ([]map[string]string, error)

func GetRedPacketInfo

func GetRedPacketInfo(packetId string) (*types.RedPacketLog, error)

func GetRoomCountInApp

func GetRoomCountInApp(appId string) (int64, error)

根据appId获取应用的所有未解散的群聊,包括被封群

func GetRoomManagerAndMaster

func GetRoomManagerAndMaster(roomId string) ([]*types.MemberJoinUser, error)

获取群中所有管理员 返回:key 用户ID value level

func GetRoomMemberName

func GetRoomMemberName(roomId, userId string) (string, error)

返回群中名称

func GetRoomMemberNumberByLevel

func GetRoomMemberNumberByLevel(roomId string, level int) (int64, error)

func GetRoomMembersLimit

func GetRoomMembersLimit(appId string, level int) (int, error)

获取群的成员数上限

func GetRoomMsgBurntNumber

func GetRoomMsgBurntNumber(logId string) (int, error)

func GetRoomMutedNumber

func GetRoomMutedNumber(roomId string) (int64, error)

获取群禁言数量

func GetRoomMutedNumberTx

func GetRoomMutedNumberTx(tx types.Tx, roomId string) (int64, error)

获取群禁言数量 事务

func GetRoomMutedType

func GetRoomMutedType(roomId string) (int, error)

获取群禁言类型

func GetRoomUserLevel

func GetRoomUserLevel(roomId, userId string, isDel int) (int, error)

获取群成员身份等级(普通用户 管理员 群主)

func GetRoomUserMuted

func GetRoomUserMuted(roomId, userId string) (mutedType int, deadline int64, err error)

获取群中成员禁言详情

func GetSystemMsgNumber

func GetSystemMsgNumber(roomId string) (int64, error)

func GetTx

func GetTx() (*mysql.MysqlTx, error)

func GetUnReadNumber

func GetUnReadNumber(userId, friendId string) (int32, error)

func GetUnreadApplyNumber

func GetUnreadApplyNumber(userId string) (int, error)

func GetUserInfoByAccount

func GetUserInfoByAccount(appId, account string) (*types.User, error)

func GetUserInfoById

func GetUserInfoById(id string) (*types.User, error)

func GetUserInfoByMarkId

func GetUserInfoByMarkId(appId, markId string) (*types.User, error)

func GetUserInfoByPhone

func GetUserInfoByPhone(appId, phone string) (*types.User, error)

func GetUserInfoByToken

func GetUserInfoByToken(appId, token string) (*types.User, error)

func GetUserInfoByUid

func GetUserInfoByUid(appId, uid string) (*types.User, error)

func GetUserJoinedRooms

func GetUserJoinedRooms(userId string) ([]string, error)

获取用户加入的所有群id

func GetUsers

func GetUsers() ([]string, error)

func GetUsersInAppClosed

func GetUsersInAppClosed(appId string) ([]*types.User, error)

查找某个app下所有封禁用户

func GetUsersInAppQueryUid

func GetUsersInAppQueryUid(appId, query string) ([]*types.User, error)

查找所有app下用户信息,包括被封用户,模糊查询 uid account

func GetUsersInAppUnClose

func GetUsersInAppUnClose(appId string) ([]*types.User, error)

查找某个app下所有未封禁用户

func GetVersionList

func GetVersionList(appId string) ([]string, error)

func GrandTotalUsers

func GrandTotalUsers(appId string, time int64) (int64, error)

func GrandTotalUsersAsPlatform

func GrandTotalUsersAsPlatform(appId string, time int64, device string) (int64, error)

func GrandTotalUsersAsVersion

func GrandTotalUsersAsVersion(appId string, time int64, version string) (int64, error)

func IncreaseUsers

func IncreaseUsers(appId string, startTime, endTime int64) (int64, error)

func IncreaseUsersAsPlatform

func IncreaseUsersAsPlatform(appId string, startTime, endTime int64, device string) (int64, error)

func IncreaseUsersAsVersion

func IncreaseUsersAsVersion(appId string, startTime, endTime int64, version string) (int64, error)

func IncreaseUsersAsVersionAndPlatform

func IncreaseUsersAsVersionAndPlatform(appId string, startTime, endTime int64, version, platform string) (int64, error)

func IncreaseUsersInfoAsVersion

func IncreaseUsersInfoAsVersion(appId string, startTime, endTime int64, version string) ([]*types.User, error)

func IncreaseUsersInfoAsVersionAndPlatform

func IncreaseUsersInfoAsVersionAndPlatform(appId string, startTime, endTime int64, version, platform string) ([]*types.User, error)

func InsertAd

func InsertAd(appId, name, url string, duration int, link string, isActive int) (int64, error)

func InsertAdminOperateLog

func InsertAdminOperateLog(tx types.Tx, admin, target string, targetType, optType int, reason string, createTime, effectiveTime int64) error

func InsertFriend

func InsertFriend(userID, friendID, remark, extRemark string, dnd, top int, addTime int64) error

func InsertLoginLog

func InsertLoginLog(userID, deviceType, deviceName, loginType, uuid, version string, loginTime int64) (int64, error)

func InsertOpenLog

func InsertOpenLog(userId, appId, device, version string, createTime int64) error

func InsertPacketInfo

func InsertPacketInfo(packetID, userID, toID, tType, size, amount, remark string, cType, coin int, time int64) error

func InsertPraise

func InsertPraise(val *types.Praise) error

func InsertPraiseUser

func InsertPraiseUser(val *types.PraiseUser) error

func InsertUser

func InsertUser(markId, uid, appId, username, account, email, area, phone, userLevel, verified, avatar, depositAddress, device, version string, createTime int64) (int64, error)

func IsNeedConfirm

func IsNeedConfirm(userId string, state int) error

func LikeOrRewardCount

func LikeOrRewardCount(channelType int, logId string, tp int) (int, error)

func PersonalVerifyList

func PersonalVerifyList(appId string, search *string, start, end int64, state *int) (int64, []*types.VerifyApplyJoinUser, error)

func RoomInviteConfirm

func RoomInviteConfirm(userId string) (*types.InviteRoomConf, error)

设置邀请入群是否需要验证

func RoomVerifyList

func RoomVerifyList(appId string, search *string, start, end int64, state *int) (int64, []*types.VerifyApplyJoinRoomAndUser, error)

func RoomsOrderActiveMember

func RoomsOrderActiveMember(appId string, datetime int64) ([]*types.Room, error)

根据群的发言人数递减排序

func RoomsOrderActiveMsg

func RoomsOrderActiveMsg(appId string, datetime int64) ([]*types.Room, error)

根据群的发言条数递减排序

func SearchRoomInfo

func SearchRoomInfo(id string, isDel int) (*types.Room, error)

func SearchRoomInfoByMarkId

func SearchRoomInfoByMarkId(markId string, isDel int) (*types.Room, error)

func SetAdName

func SetAdName(id, name string) error

设置广告名称

func SetAvatar

func SetAvatar(roomId, avatar string) (bool, error)

func SetCanAddFriendPermission

func SetCanAddFriendPermission(roomId string, permisson int) error

func SetCreateRoomsLimit

func SetCreateRoomsLimit(appId string, level, limit int) error

设置用户创建群个数上限

func SetFriendDND

func SetFriendDND(userId, friendId string, DND int) error

func SetFriendExtRemark

func SetFriendExtRemark(userId, friendId, remark string) error

func SetFriendIsBlock

func SetFriendIsBlock(userId, friendId string, state int, alterTime int64) error

func SetFriendIsTop

func SetFriendIsTop(userId, friendId string, isTop int) error

func SetFriendRemark

func SetFriendRemark(userId, friendId, remark string) error

func SetJoinPermission

func SetJoinPermission(roomId string, permisson int) error

func SetMemberLevel

func SetMemberLevel(userId, roomId string, level int) error

func SetMemberNickname

func SetMemberNickname(userId, roomId string, nickname string) error

func SetNeedAnswer

func SetNeedAnswer(userId, question, answer string) error

func SetNewMaster

func SetNewMaster(master, userId, roomId string, level int) error

func SetNoDisturbing

func SetNoDisturbing(userId, roomId string, noDisturbing int) error

func SetNotNeedAnswer

func SetNotNeedAnswer(userId string) error

func SetOnTop

func SetOnTop(userId, roomId string, onTop int) error

func SetQuestionandAnswer

func SetQuestionandAnswer(userId, question, answer string) error

func SetRecordPermission

func SetRecordPermission(roomId string, permisson int) error

func SetRoomInviteConfirm

func SetRoomInviteConfirm(userId string, needConfirm int) error

设置邀请入群是否需要验证

func SetRoomMembersLimit

func SetRoomMembersLimit(appId string, level, limit int) error

设置群的成员数上限

func SetRoomMutedType

func SetRoomMutedType(tx types.Tx, roomId string, mutedType int) error

设置群禁言类型

func SetRoomName

func SetRoomName(roomId, name string) (bool, error)

func SetUserVerifyed

func SetUserVerifyed(tx types.Tx, userId, vInfo string) error

func UpdateApply

func UpdateApply(applyUser, target string, tp int, reason, remark, source string, state int) (int64, error)

func UpdateDepositAddress

func UpdateDepositAddress(userId, address string) error

func UpdateDeviceToken

func UpdateDeviceToken(userId, deviceToken, deviceType string) error

func UpdateEmail

func UpdateEmail(userId, email string) error

func UpdateInviteCode

func UpdateInviteCode(userId, code string) error

func UpdateIsChain

func UpdateIsChain(userId string, ischain int) error

func UpdateNowVersion

func UpdateNowVersion(userId, version string) error

func UpdatePhone

func UpdatePhone(userId, phone string) error

func UpdatePrivateLogContentById

func UpdatePrivateLogContentById(logId, content string) error

func UpdatePrivateLogStateById

func UpdatePrivateLogStateById(revId string, state int) error

func UpdatePublicKey

func UpdatePublicKey(userId, publicKey, privateKey string) error

func UpdateToken

func UpdateToken(userId, token string, createTime int64) error

func UpdateUid

func UpdateUid(markId, userId, uid string) error

func UpdateUserAvatar

func UpdateUserAvatar(userId, avatar string) error

func UpdateUsername

func UpdateUsername(userId, username string) error

func UpdateVersionUsersNumber

func UpdateVersionUsersNumber(appId, nowVersion string) (int64, error)

Types

This section is empty.

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL