2024-08-07 13:52:34 +08:00
package v2
2024-07-23 14:48:37 +08:00
import (
"context"
"encoding/base64"
2024-08-07 13:52:34 +08:00
"github.com/1Panel-dev/1Panel/agent/app/api/v2/helper"
2024-07-23 14:48:37 +08:00
"github.com/1Panel-dev/1Panel/agent/app/dto"
"github.com/gin-gonic/gin"
)
// @Tags Database Mysql
// @Summary Create mysql database
// @Accept json
// @Param request body dto.MysqlDBCreate true "request"
// @Success 200
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases [post]
// @x-panel-log {"bodyKeys":["name"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"创建 mysql 数据库 [name]","formatEN":"create mysql database [name]"}
func ( b * BaseApi ) CreateMysql ( c * gin . Context ) {
var req dto . MysqlDBCreate
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if len ( req . Password ) != 0 {
password , err := base64 . StdEncoding . DecodeString ( req . Password )
if err != nil {
2024-10-29 18:42:12 +08:00
helper . BadRequest ( c , err )
2024-07-23 14:48:37 +08:00
return
}
req . Password = string ( password )
}
if _ , err := mysqlService . Create ( context . Background (), req ); err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
2025-04-18 15:44:28 +08:00
helper . Success ( c )
2024-07-23 14:48:37 +08:00
}
// @Tags Database Mysql
2026-07-16 14:24:38 +08:00
// @Summary List mysql users
2024-07-23 14:48:37 +08:00
// @Accept json
2026-07-16 14:24:38 +08:00
// @Param request body dto.MysqlUserSearch true "request"
// @Success 200 {array} dto.MysqlUser
2024-07-23 14:48:37 +08:00
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2026-07-16 14:24:38 +08:00
// @Router /databases/users/search [post]
func ( b * BaseApi ) ListMysqlUsers ( c * gin . Context ) {
var req dto . MysqlUserSearch
2024-07-23 14:48:37 +08:00
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
2026-07-16 14:24:38 +08:00
data , err := mysqlService . ListUsers ( req )
if err != nil {
helper . InternalServer ( c , err )
return
}
helper . SuccessWithData ( c , data )
}
2024-07-23 14:48:37 +08:00
2026-07-16 14:24:38 +08:00
// @Tags Database Mysql
// @Summary Create mysql user
// @Accept json
// @Param request body dto.MysqlUserCreate true "request"
// @Success 200
// @Security ApiKeyAuth
// @Security Timestamp
// @Router /databases/users [post]
// @x-panel-log {"bodyKeys":["database","username","host"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"创建 mysql 数据库 [database] 用户 [username]@[host]","formatEN":"create mysql database [database] user [username]@[host]"}
func ( b * BaseApi ) CreateMysqlUser ( c * gin . Context ) {
var req dto . MysqlUserCreate
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
2024-07-23 14:48:37 +08:00
if len ( req . Password ) != 0 {
password , err := base64 . StdEncoding . DecodeString ( req . Password )
if err != nil {
2024-10-29 18:42:12 +08:00
helper . BadRequest ( c , err )
2024-07-23 14:48:37 +08:00
return
}
req . Password = string ( password )
}
2026-07-16 14:24:38 +08:00
if err := mysqlService . CreateUser ( req ); err != nil {
helper . InternalServer ( c , err )
return
}
helper . Success ( c )
}
2024-07-23 14:48:37 +08:00
2026-07-16 14:24:38 +08:00
// @Tags Database Mysql
// @Summary Delete mysql user
// @Accept json
// @Param request body dto.MysqlUserDelete true "request"
// @Success 200
// @Security ApiKeyAuth
// @Security Timestamp
// @Router /databases/users/del [post]
// @x-panel-log {"bodyKeys":["database","username","host"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"删除 mysql 数据库 [database] 用户 [username]@[host]","formatEN":"delete mysql database [database] user [username]@[host]"}
func ( b * BaseApi ) DeleteMysqlUser ( c * gin . Context ) {
var req dto . MysqlUserDelete
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if err := mysqlService . DeleteUser ( req ); err != nil {
helper . InternalServer ( c , err )
return
}
helper . Success ( c )
}
// @Tags Database Mysql
// @Summary Update mysql user
// @Accept json
// @Param request body dto.MysqlUserUpdate true "request"
// @Success 200
// @Security ApiKeyAuth
// @Security Timestamp
// @Router /databases/users/update [post]
// @x-panel-log {"bodyKeys":["database","username","host","newHost","description"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"更新 mysql 数据库 [database] 用户 [username] 访问权限 [host] => [newHost] 描述 [description]","formatEN":"update mysql database [database] user [username] access [host] => [newHost] description [description]"}
func ( b * BaseApi ) UpdateMysqlUser ( c * gin . Context ) {
var req dto . MysqlUserUpdate
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if err := mysqlService . UpdateUser ( req ); err != nil {
helper . InternalServer ( c , err )
return
}
helper . Success ( c )
}
// @Tags Database Mysql
// @Summary Change mysql user password
// @Accept json
// @Param request body dto.MysqlUserPassword true "request"
// @Success 200
// @Security ApiKeyAuth
// @Security Timestamp
// @Router /databases/users/password [post]
// @x-panel-log {"bodyKeys":["database","username","host"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"更新 mysql 数据库 [database] 用户 [username]@[host] 密码","formatEN":"update mysql database [database] user [username]@[host] password"}
func ( b * BaseApi ) ChangeMysqlUserPassword ( c * gin . Context ) {
var req dto . MysqlUserPassword
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if len ( req . Password ) != 0 {
password , err := base64 . StdEncoding . DecodeString ( req . Password )
if err != nil {
helper . BadRequest ( c , err )
return
}
req . Password = string ( password )
}
if err := mysqlService . ChangeUserPassword ( req ); err != nil {
helper . InternalServer ( c , err )
return
}
helper . Success ( c )
}
2026-07-21 19:08:09 +08:00
// @Tags Database Mysql
// @Summary Save mysql user password locally
// @Accept json
// @Param request body dto.MysqlUserPassword true "request"
// @Success 200
// @Security ApiKeyAuth
// @Security Timestamp
// @Router /databases/users/password/save [post]
// @x-panel-log {"bodyKeys":["database","username","host"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"补充 mysql 数据库 [database] 用户 [username]@[host] 密码","formatEN":"save mysql database [database] user [username]@[host] password locally"}
func ( b * BaseApi ) SaveMysqlUserPassword ( c * gin . Context ) {
var req dto . MysqlUserPassword
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if len ( req . Password ) != 0 {
password , err := base64 . StdEncoding . DecodeString ( req . Password )
if err != nil {
helper . BadRequest ( c , err )
return
}
req . Password = string ( password )
}
if err := mysqlService . SaveUserPassword ( req ); err != nil {
helper . InternalServer ( c , err )
return
}
helper . Success ( c )
}
2026-07-16 14:24:38 +08:00
// @Tags Database Mysql
// @Summary List mysql grants
// @Accept json
// @Param request body dto.MysqlUserSearch true "request"
// @Success 200 {array} dto.MysqlGrant
// @Security ApiKeyAuth
// @Security Timestamp
// @Router /databases/grants/search [post]
func ( b * BaseApi ) ListMysqlGrants ( c * gin . Context ) {
var req dto . MysqlUserSearch
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
data , err := mysqlService . ListGrants ( req )
if err != nil {
helper . InternalServer ( c , err )
return
}
helper . SuccessWithData ( c , data )
}
// @Tags Database Mysql
// @Summary List mysql grant summary
// @Accept json
// @Param request body dto.MysqlGrantSummarySearch true "request"
// @Success 200 {object} map[string][]dto.MysqlUser
// @Security ApiKeyAuth
// @Security Timestamp
// @Router /databases/grants/summary [post]
func ( b * BaseApi ) ListMysqlGrantSummary ( c * gin . Context ) {
var req dto . MysqlGrantSummarySearch
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
data , err := mysqlService . ListGrantSummary ( req )
if err != nil {
helper . InternalServer ( c , err )
return
}
helper . SuccessWithData ( c , data )
}
// @Tags Database Mysql
// @Summary Grant mysql user
// @Accept json
// @Param request body dto.MysqlGrantCreate true "request"
// @Success 200
// @Security ApiKeyAuth
// @Security Timestamp
// @Router /databases/grants [post]
// @x-panel-log {"bodyKeys":["database","db","username","host"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"授权 mysql 数据库 [database] 用户 [username]@[host] 访问 [db]","formatEN":"grant mysql database [database] user [username]@[host] access to [db]"}
func ( b * BaseApi ) GrantMysqlUser ( c * gin . Context ) {
var req dto . MysqlGrantCreate
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if err := mysqlService . GrantUser ( req ); err != nil {
helper . InternalServer ( c , err )
return
}
helper . Success ( c )
}
// @Tags Database Mysql
// @Summary Revoke mysql grant
// @Accept json
// @Param request body dto.MysqlGrantDelete true "request"
// @Success 200
// @Security ApiKeyAuth
// @Security Timestamp
// @Router /databases/grants/del [post]
// @x-panel-log {"bodyKeys":["database","db","username","host"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"取消 mysql 数据库 [database] 用户 [username]@[host] 对 [db] 的授权","formatEN":"revoke mysql database [database] user [username]@[host] access to [db]"}
func ( b * BaseApi ) RevokeMysqlGrant ( c * gin . Context ) {
var req dto . MysqlGrantDelete
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if err := mysqlService . RevokeGrant ( req ); err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
2025-04-18 15:44:28 +08:00
helper . Success ( c )
2024-07-23 14:48:37 +08:00
}
// @Tags Database Mysql
// @Summary Update mysql database description
// @Accept json
// @Param request body dto.UpdateDescription true "request"
// @Success 200
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases/description/update [post]
// @x-panel-log {"bodyKeys":["id","description"],"paramKeys":[],"BeforeFunctions":[{"input_column":"id","input_value":"id","isList":false,"db":"database_mysqls","output_column":"name","output_value":"name"}],"formatZH":"mysql 数据库 [name] 描述信息修改 [description]","formatEN":"The description of the mysql database [name] is modified => [description]"}
func ( b * BaseApi ) UpdateMysqlDescription ( c * gin . Context ) {
var req dto . UpdateDescription
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if err := mysqlService . UpdateDescription ( req ); err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
2025-04-18 15:44:28 +08:00
helper . Success ( c )
2024-07-23 14:48:37 +08:00
}
// @Tags Database Mysql
2026-07-16 14:24:38 +08:00
// @Summary Change mysql root password
2024-07-23 14:48:37 +08:00
// @Accept json
// @Param request body dto.ChangeDBInfo true "request"
// @Success 200
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases/change/password [post]
2026-07-16 14:24:38 +08:00
// @x-panel-log {"bodyKeys":["database"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"更新数据库 [database] root 密码","formatEN":"Update database [database] root password"}
2024-07-23 14:48:37 +08:00
func ( b * BaseApi ) ChangeMysqlPassword ( c * gin . Context ) {
var req dto . ChangeDBInfo
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if len ( req . Value ) != 0 {
value , err := base64 . StdEncoding . DecodeString ( req . Value )
if err != nil {
2024-10-29 18:42:12 +08:00
helper . BadRequest ( c , err )
2024-07-23 14:48:37 +08:00
return
}
req . Value = string ( value )
}
if err := mysqlService . ChangePassword ( req ); err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
2025-04-18 15:44:28 +08:00
helper . Success ( c )
2024-07-23 14:48:37 +08:00
}
// @Tags Database Mysql
2026-07-16 14:24:38 +08:00
// @Summary Change mysql root access
2024-07-23 14:48:37 +08:00
// @Accept json
// @Param request body dto.ChangeDBInfo true "request"
// @Success 200
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases/change/access [post]
2026-07-16 14:24:38 +08:00
// @x-panel-log {"bodyKeys":["database"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"更新数据库 [database] root 访问权限","formatEN":"Update database [database] root access"}
2024-07-23 14:48:37 +08:00
func ( b * BaseApi ) ChangeMysqlAccess ( c * gin . Context ) {
var req dto . ChangeDBInfo
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if err := mysqlService . ChangeAccess ( req ); err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
2025-04-18 15:44:28 +08:00
helper . Success ( c )
2024-07-23 14:48:37 +08:00
}
// @Tags Database Mysql
// @Summary Update mysql variables
// @Accept json
// @Param request body dto.MysqlVariablesUpdate true "request"
// @Success 200
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases/variables/update [post]
// @x-panel-log {"bodyKeys":[],"paramKeys":[],"BeforeFunctions":[],"formatZH":"调整 mysql 数据库性能参数","formatEN":"adjust mysql database performance parameters"}
func ( b * BaseApi ) UpdateMysqlVariables ( c * gin . Context ) {
var req dto . MysqlVariablesUpdate
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if err := mysqlService . UpdateVariables ( req ); err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
2025-04-18 15:44:28 +08:00
helper . Success ( c )
2024-07-23 14:48:37 +08:00
}
// @Tags Database Mysql
// @Summary Page mysql databases
// @Accept json
// @Param request body dto.MysqlDBSearch true "request"
// @Success 200 {object} dto.PageResult
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases/search [post]
func ( b * BaseApi ) SearchMysql ( c * gin . Context ) {
var req dto . MysqlDBSearch
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
total , list , err := mysqlService . SearchWithPage ( req )
if err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
helper . SuccessWithData ( c , dto . PageResult {
Items : list ,
Total : total ,
})
}
2025-11-24 16:07:14 +08:00
// @Tags Database Mysql
// @Summary List mysql database format collation options
// @Accept json
// @Param request body dto.OperationWithName true "request"
// @Success 200 {array} dto.MysqlFormatCollationOption
// @Security ApiKeyAuth
// @Security Timestamp
// @Router /databases/format/options [post]
func ( b * BaseApi ) ListDBFormatCollationOptions ( c * gin . Context ) {
var req dto . OperationWithName
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
helper . SuccessWithData ( c , mysqlService . LoadFormatOption ( req ))
}
2024-07-23 14:48:37 +08:00
// @Tags Database Mysql
// @Summary Load mysql database from remote
// @Accept json
// @Param request body dto.MysqlLoadDB true "request"
2025-12-08 17:34:24 +08:00
// @Success 200
2024-07-23 14:48:37 +08:00
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases/load [post]
func ( b * BaseApi ) LoadDBFromRemote ( c * gin . Context ) {
var req dto . MysqlLoadDB
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
if err := mysqlService . LoadFromRemote ( req ); err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
2025-04-18 15:44:28 +08:00
helper . Success ( c )
2024-07-23 14:48:37 +08:00
}
// @Tags Database Mysql
// @Summary Check before delete mysql database
// @Accept json
// @Param request body dto.MysqlDBDeleteCheck true "request"
// @Success 200 {array} string
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases/del/check [post]
func ( b * BaseApi ) DeleteCheckMysql ( c * gin . Context ) {
var req dto . MysqlDBDeleteCheck
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
apps , err := mysqlService . DeleteCheck ( req )
if err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
helper . SuccessWithData ( c , apps )
}
// @Tags Database Mysql
// @Summary Delete mysql database
// @Accept json
// @Param request body dto.MysqlDBDelete true "request"
// @Success 200
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases/del [post]
// @x-panel-log {"bodyKeys":["id"],"paramKeys":[],"BeforeFunctions":[{"input_column":"id","input_value":"id","isList":false,"db":"database_mysqls","output_column":"name","output_value":"name"}],"formatZH":"删除 mysql 数据库 [name]","formatEN":"delete mysql database [name]"}
func ( b * BaseApi ) DeleteMysql ( c * gin . Context ) {
var req dto . MysqlDBDelete
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
tx , ctx := helper . GetTxAndContext ()
if err := mysqlService . Delete ( ctx , req ); err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
tx . Rollback ()
return
}
tx . Commit ()
2025-04-18 15:44:28 +08:00
helper . Success ( c )
2024-07-23 14:48:37 +08:00
}
// @Tags Database Mysql
// @Summary Load mysql remote access
// @Accept json
// @Param request body dto.OperationWithNameAndType true "request"
// @Success 200 {boolean} isRemote
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases/remote [post]
func ( b * BaseApi ) LoadRemoteAccess ( c * gin . Context ) {
var req dto . OperationWithNameAndType
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
isRemote , err := mysqlService . LoadRemoteAccess ( req )
if err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
helper . SuccessWithData ( c , isRemote )
}
// @Tags Database Mysql
// @Summary Load mysql status info
// @Accept json
// @Param request body dto.OperationWithNameAndType true "request"
// @Success 200 {object} dto.MysqlStatus
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases/status [post]
func ( b * BaseApi ) LoadStatus ( c * gin . Context ) {
var req dto . OperationWithNameAndType
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
data , err := mysqlService . LoadStatus ( req )
if err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
helper . SuccessWithData ( c , data )
}
// @Tags Database Mysql
// @Summary Load mysql variables info
// @Accept json
// @Param request body dto.OperationWithNameAndType true "request"
// @Success 200 {object} dto.MysqlVariables
// @Security ApiKeyAuth
2025-01-21 18:32:14 +08:00
// @Security Timestamp
2024-07-23 14:48:37 +08:00
// @Router /databases/variables [post]
func ( b * BaseApi ) LoadVariables ( c * gin . Context ) {
var req dto . OperationWithNameAndType
if err := helper . CheckBindAndValidate ( & req , c ); err != nil {
return
}
data , err := mysqlService . LoadVariables ( req )
if err != nil {
2024-10-29 18:42:12 +08:00
helper . InternalServer ( c , err )
2024-07-23 14:48:37 +08:00
return
}
helper . SuccessWithData ( c , data )
}