MySQLBind

const (
	InsertOneNewUserSQL = `` /* 133-byte string literal not displayed */

	DeleteOneUserRealSQL = `DELETE FROM tb_user_basic WHERE id = ?`
)

const (
	SelectUserBaseSQL = `SELECT id, email, name, password,mobile, gender, avatar, qr_code, is_delete FROM tb_user_basic`

	SelectOneUserByIdSQL            = SelectUserBaseSQL + ` WHERE id = ? AND is_delete = ?`
	SelectOneUserByEmailSQL         = SelectUserBaseSQL + ` WHERE email = ? AND is_delete = ?`
	SelectManyUserByNameSQL         = SelectUserBaseSQL + ` WHERE name = ? AND is_delete = ?`
	SelectOneUserPasswordByIdSQL    = `SELECT password FROM tb_user_basic WHERE id = ?`
	SelectOneUserPasswordByEmailSQL = `SELECT password FROM tb_user_basic WHERE email = ?`
)

const (
	UpdateOneUserProfileSQL  = `UPDATE tb_user_basic SET name = ?, mobile = ?, gender = ? WHERE id = ?`
	UpdateOneUserAvatarSQL   = `UPDATE tb_user_basic SET avatar = ? WHERE id = ?`
	UpdateOneUserQrCodeSQL   = `UPDATE tb_user_basic SET qr_code = ? WHERE id = ?`
	UpdateOneUserPasswordSQL = `UPDATE tb_user_basic SET password = ? WHERE id = ?`
	UpdateOneUserIsDeleteSQL = `UPDATE tb_user_basic SET is_delete = ?  WHERE id = ?`
)

const (
	InsertOneNewFriendSQL = `` /* 173-byte string literal not displayed */

	DeleteOneFriendshipRealSQL = `DELETE FROM tb_friendship WHERE self_id = ? AND friend_id = ?`
)

const (
	SelectFriendshipBaseSQL = `SELECT self_id, friend_id, friend_note, is_accept, is_black, is_delete FROM
tb_friendship`

	SelectOneFriendshipSQL = SelectFriendshipBaseSQL + ` WHERE self_id= ? AND friend_id= ?`

	SelectFriendsIdByOptionsSQL = `SELECT friend_id FROM tb_friendship WHERE self_id= ? AND is_accept= ? AND 
is_black= ? AND is_delete= ?`
)

const (
	UpdateOneFriendNoteSQL = `UPDATE tb_friendship SET friend_note= ? WHERE self_id= ? AND friend_id= ?`

	UpdateOneFriendIsAcceptSQL = `INSERT INTO tb_friendship (self_id, friend_id, is_accept) VALUES (?, ?, ?) 
ON DUPLICATE KEY UPDATE is_accept= ?`

	UpdateOneFriendIsBlackSQL = `INSERT INTO tb_friendship (self_id, friend_id, is_black) VALUES (?, ?, ?) 
ON DUPLICATE KEY UPDATE is_black= ?`

	UpdateOneFriendIsDeleteSQL = `UPDATE tb_friendship SET is_delete= ? WHERE self_id=? AND friend_id= ?`
)

const (
	InsertOneNewGroupChatSQL = `` /* 148-byte string literal not displayed */

	DeleteOneGroupChatRealSQL = `DELETE FROM tb_group_chat WHERE id = ?`
)

const (
	SelectGroupChatBaseSQL             = `SELECT id, name, manager_id, avatar, qr_code, is_delete FROM tb_group_chat`
	SelectGroupChatByIdSQL             = SelectGroupChatBaseSQL + ` WHERE id= ? AND is_delete= ?`
	SelectGroupChatsByNameSQL          = SelectGroupChatBaseSQL + ` WHERE name= ? AND is_delete= ?`
	SelectGroupChatsByManagerIdSQl     = SelectGroupChatBaseSQL + ` WHERE manager_id=? AND is_delete= ?`
	SelectGroupChatByNameAndManagerSQL = SelectGroupChatBaseSQL + ` WHERE name= ? AND manager_id= ? AND is_delete= False`
)

const (
	UpdateOneGroupChatNameByIdSQL     = `UPDATE tb_group_chat SET name = ? WHERE id = ?`
	UpdateOneGroupChatManagerByIdSQL  = `UPDATE tb_group_chat SET manager_id = ? WHERE id = ?`
	UpdateOneGroupChatAvatarByIdSQL   = `UPDATE tb_group_chat SET avatar = ? WHERE id = ?`
	UpdateOneGroupChatQrCodeByIdSQL   = `UPDATE tb_group_chat SET qr_code = ? WHERE id = ?`
	UpdateOneGroupChatIsDeleteByIdSQL = `UPDATE tb_group_chat SET is_delete = ? WHERE id = ?`
)

const (
	InsertOneNewUserGroupChatSQL = `` /* 132-byte string literal not displayed */

	DeleteOneUserGroupChatRealSQL = `DELETE FROM tb_user_group_chat WHERE group_id= ? AND user_id= ?`
)

const (
	SelectUserGroupChatBaseSQL = `SELECT group_id, user_id, user_note, is_delete FROM tb_user_group_chat`

	SelectOneUserGroupChatByGIDAndUIDSQL = SelectUserGroupChatBaseSQL + ` WHERE group_id= ? AND user_id= ?`
	SelectManyUserGroupChatByGroupIdSQL  = SelectUserGroupChatBaseSQL + ` WHERE group_id= ? AND is_delete= ?`
	SelectManyUserGroupChatByUserIdSQL   = SelectUserGroupChatBaseSQL + ` WHERE user_id= ? AND is_delete= ?`

	SelectUsersIdOfGroupChatSQL = `SELECT user_id FROM tb_user_group_chat WHERE group_id= ? AND is_delete= ?`

	SelectGroupChatsIdOfUserSQL = `SELECT group_id FROM tb_user_group_chat WHERE user_id= ? AND is_delete= ?`
)

const (
	UpdateOneUserGroupChatNoteSQL     = `UPDATE tb_user_group_chat SET user_note= ? WHERE group_id= ? AND user_id= ?`
	UpdateOneUserGroupChatIsDeleteSQL = `UPDATE tb_user_group_chat SET is_delete= ? WHERE group_id= ? AND user_id= ?`
)

const (
	InsertOneNewSubscriptionSQL = `INSERT INTO tb_subscription(id, name, manager_id, intro, avatar, qr_code) 
VALUES(?, ?, ?, ?, ?, ?)`

	DeleteOneSubscriptionRealSQL = `DELETE FROM tb_subscription WHERE id= ?`
)

const (
	SelectSubscriptionBaseSQL = `SELECT id,name,manager_id,intro,avatar,qr_code,is_delete FROM tb_subscription`

	SelectOneSubscriptionByIdSQL         = SelectSubscriptionBaseSQL + ` WHERE id= ? AND is_delete= ?`
	SelectOneSubscriptionByNameSQL       = SelectSubscriptionBaseSQL + ` WHERE name= ? AND is_delete= ?`
	SelectManySubscriptionByManagerIdSQL = SelectSubscriptionBaseSQL + ` WHERE manager_id= ? AND is_delete= ?`
)

const (
	UpdateOneSubscriptionNameByIdSQL      = `UPDATE tb_subscription SET name= ? WHERE id=?`
	UpdateOneSubscriptionManagerByIdSQL   = `UPDATE tb_subscription SET manager_id= ? WHERE id=?`
	UpdateOneSubscriptionIntroduceByIdSQL = `UPDATE tb_subscription SET intro= ? WHERE id=?`
	UpdateOneSubscriptionAvatarByIdSQL    = `UPDATE tb_subscription SET avatar= ? WHERE id= ?`
	UpdateOneSubscriptionQrCodeByIdSQL    = `UPDATE tb_subscription SET qr_code= ? WHERE id= ?`
	UpdateOneSubscriptionIsDeleteByIdSQL  = `UPDATE tb_subscription SET is_delete= ? WHERE id= ?`
)

const (
	InsertOneNewUserSubscriptionSQL = `INSERT INTO tb_user_subscription(subs_id, user_id) VALUES(?, ?)`

	DeleteOneUserSubscriptionRealSQL = `DELETE FROM tb_user_subscription WHERE subs_id= ? AND user_id= ?`
)

const (
	SelectUserSubscriptionBaseSQL = `SELECT subs_id, user_id, is_delete FROM tb_user_subscription`

	SelectOneUserSubscriptionByIdsSQL = SelectUserSubscriptionBaseSQL + ` WHERE subs_id= ? AND user_id= ?`

	SelectManyUserSubscriptionBySubsIdSQL = SelectUserSubscriptionBaseSQL + ` WHERE subs_id= ? AND is_delete= ?`
	SelectManyUserSubscriptionByUserIdSQL = SelectUserSubscriptionBaseSQL + ` WHERE user_id= ? AND is_delete= ?`

	SelectUsersIdOfSubscriptionSQL = `SELECT user_id FROM tb_user_subscription WHERE subs_id= ? AND is_delete= ?`

	SelectSubscriptionsIdOfUserSQL = `SELECT subs_id FROM tb_user_subscription WHERE user_id= ? AND is_delete= ?`
)

const (
	SelectOneFriendIsBlackSQL  = `SELECT is_black FROM tb_friendship WHERE self_id= ? AND friend_id= ?`
	SelectOneFriendIsAcceptSQL = `SELECT is_accept FROM tb_friendship WHERE self_id= ? AND friend_id= ?`
)

const (
	SelectAllFriendsInfoPlusSQL = `` /* 293-byte string literal not displayed */

	SelectEffectiveFriendsInfoPlusSQL = `` /* 340-byte string literal not displayed */

	SelectBlacklistFriendsInfoPlusSQL = `` /* 311-byte string literal not displayed */

	SelectEffectiveFriendsIdPlusSQL = `SELECT friend_id FROM tb_friendship WHERE self_id = ? AND is_accept = TRUE 
AND is_black = FALSE  AND is_delete = FALSE`

	SelectBlacklistFriendsIdPlusSQL = `SELECT friend_id FROM tb_friendship WHERE self_id = ? AND is_black = TRUE 
AND is_delete = FALSE`
)

const (
	SelectOneGroupChatIsDeleteById = `SELECT is_delete FROM tb_group_chat WHERE id= ?`

	SelectGroupChatUsersInfoPlusSQL = `` /* 280-byte string literal not displayed */

)

const (
	SelectOneUserIsDeleteById = `SELECT is_delete FROM tb_user_basic WHERE id= ?`

	SelectUserGroupChatsInfoPlusSQL = `` /* 248-byte string literal not displayed */

)

const (
	SelectSubscriptionsOfUserPlusSQL = `` /* 268-byte string literal not displayed */

	SelectUsersOfSubscriptionPlusSQL = `` /* 254-byte string literal not displayed */

)

const (
	UpdateOneUserSubscriptionIsDeleteSQL = `UPDATE tb_user_subscription SET is_delete= ? WHERE subs_id= ? AND user_id= ?`
)