package v2 import ( "context" "encoding/base64" "github.com/1Panel-dev/1Panel/agent/app/api/v2/helper" "github.com/1Panel-dev/1Panel/agent/app/dto" "github.com/gin-gonic/gin" ) // @Tags Database PostgreSQL // @Summary Create postgresql database // @Accept json // @Param request body dto.PostgresqlDBCreate true "request" // @Success 200 // @Security ApiKeyAuth // @Security Timestamp // @Router /databases/pg [post] // @x-panel-log {"bodyKeys":["name"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"创建 postgresql 数据库 [name]","formatEN":"create postgresql database [name]"} func (b *BaseApi) CreatePostgresql(c *gin.Context) { var req dto.PostgresqlDBCreate 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 := postgresqlService.Create(context.Background(), req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Tags Database PostgreSQL // @Summary Bind postgresql user // @Accept json // @Param request body dto.PostgresqlBindUser true "request" // @Success 200 // @Security ApiKeyAuth // @Security Timestamp // @Router /databases/pg/bind [post] // @x-panel-log {"bodyKeys":["name", "username"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"绑定 postgresql 数据库 [name] 用户 [username]","formatEN":"bind postgresql database [name] user [username]"} func (b *BaseApi) BindPostgresqlUser(c *gin.Context) { var req dto.PostgresqlBindUser if err := helper.CheckBindAndValidate(&req, c); err != nil { return } if err := postgresqlService.BindUser(req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Tags Database PostgreSQL // @Summary Update postgresql database description // @Accept json // @Param request body dto.UpdateDescription true "request" // @Success 200 // @Security ApiKeyAuth // @Security Timestamp // @Router /databases/pg/description [post] // @x-panel-log {"bodyKeys":["id","description"],"paramKeys":[],"BeforeFunctions":[{"input_column":"id","input_value":"id","isList":false,"db":"database_postgresqls","output_column":"name","output_value":"name"}],"formatZH":"postgresql 数据库 [name] 描述信息修改 [description]","formatEN":"The description of the postgresql database [name] is modified => [description]"} func (b *BaseApi) UpdatePostgresqlDescription(c *gin.Context) { var req dto.UpdateDescription if err := helper.CheckBindAndValidate(&req, c); err != nil { return } if err := postgresqlService.UpdateDescription(req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Tags Database PostgreSQL // @Summary Change postgresql privileges // @Accept json // @Param request body dto.ChangeDBInfo true "request" // @Success 200 // @Security ApiKeyAuth // @Security Timestamp // @Router /databases/pg/privileges [post] // @x-panel-log {"bodyKeys":["database", "username"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"更新数据库 [database] 用户 [username] 权限","formatEN":"Update [username] privileges of database [database]"} func (b *BaseApi) ChangePostgresqlPrivileges(c *gin.Context) { var req dto.PostgresqlPrivileges if err := helper.CheckBindAndValidate(&req, c); err != nil { return } if err := postgresqlService.ChangePrivileges(req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Tags Database PostgreSQL // @Summary Change postgresql password // @Accept json // @Param request body dto.ChangeDBInfo true "request" // @Success 200 // @Security ApiKeyAuth // @Security Timestamp // @Router /databases/pg/password [post] // @x-panel-log {"bodyKeys":["id"],"paramKeys":[],"BeforeFunctions":[{"input_column":"id","input_value":"id","isList":false,"db":"database_postgresqls","output_column":"name","output_value":"name"}],"formatZH":"更新数据库 [name] 密码","formatEN":"Update database [name] password"} func (b *BaseApi) ChangePostgresqlPassword(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 { helper.BadRequest(c, err) return } req.Value = string(value) } if err := postgresqlService.ChangePassword(req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Tags Database PostgreSQL // @Summary Page postgresql databases // @Accept json // @Param request body dto.PostgresqlDBSearch true "request" // @Success 200 {object} dto.PageResult // @Security ApiKeyAuth // @Security Timestamp // @Router /databases/pg/search [post] func (b *BaseApi) SearchPostgresql(c *gin.Context) { var req dto.PostgresqlDBSearch if err := helper.CheckBindAndValidate(&req, c); err != nil { return } total, list, err := postgresqlService.SearchWithPage(req) if err != nil { helper.InternalServer(c, err) return } helper.SuccessWithData(c, dto.PageResult{ Items: list, Total: total, }) } // @Tags Database PostgreSQL // @Summary Load postgresql database from remote // @Accept json // @Param request body dto.PostgresqlLoadDB true "request" // @Success 200 // @Security ApiKeyAuth // @Security Timestamp // @Param database path string true "database" // @Router /databases/pg/:database/load [post] func (b *BaseApi) LoadPostgresqlDBFromRemote(c *gin.Context) { database, err := helper.GetStrParamByKey(c, "database") if err != nil { helper.BadRequest(c, err) return } if err := postgresqlService.LoadFromRemote(database); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Tags Database PostgreSQL // @Summary Check before delete postgresql database // @Accept json // @Param request body dto.PostgresqlDBDeleteCheck true "request" // @Success 200 {array} string // @Security ApiKeyAuth // @Security Timestamp // @Router /databases/pg/del/check [post] func (b *BaseApi) DeleteCheckPostgresql(c *gin.Context) { var req dto.PostgresqlDBDeleteCheck if err := helper.CheckBindAndValidate(&req, c); err != nil { return } apps, err := postgresqlService.DeleteCheck(req) if err != nil { helper.InternalServer(c, err) return } helper.SuccessWithData(c, apps) } // @Tags Database PostgreSQL // @Summary Delete postgresql database // @Accept json // @Param request body dto.PostgresqlDBDelete true "request" // @Success 200 // @Security ApiKeyAuth // @Security Timestamp // @Router /databases/pg/del [post] // @x-panel-log {"bodyKeys":["id"],"paramKeys":[],"BeforeFunctions":[{"input_column":"id","input_value":"id","isList":false,"db":"database_postgresqls","output_column":"name","output_value":"name"}],"formatZH":"删除 postgresql 数据库 [name]","formatEN":"delete postgresql database [name]"} func (b *BaseApi) DeletePostgresql(c *gin.Context) { var req dto.PostgresqlDBDelete if err := helper.CheckBindAndValidate(&req, c); err != nil { return } tx, ctx := helper.GetTxAndContext() if err := postgresqlService.Delete(ctx, req); err != nil { helper.InternalServer(c, err) tx.Rollback() return } tx.Commit() helper.Success(c) } func (b *BaseApi) ListPostgresqlUsers(c *gin.Context) { var req dto.PostgresqlUserSearch if err := helper.CheckBindAndValidate(&req, c); err != nil { return } result, err := postgresqlService.ListUsers(req) if err != nil { helper.InternalServer(c, err) return } helper.SuccessWithData(c, result) } // @Router /databases/pg/users [post] // @x-panel-log {"bodyKeys":["database","username"],"paramKeys":[],"formatZH":"创建 PostgreSQL 实例 [database] 用户 [username]","formatEN":"create PostgreSQL instance [database] user [username]","BeforeFunctions":[]} func (b *BaseApi) CreatePostgresqlUser(c *gin.Context) { var req dto.PostgresqlUserCreate if err := helper.CheckBindAndValidate(&req, c); err != nil { return } password, err := base64.StdEncoding.DecodeString(req.Password) if err != nil { helper.BadRequest(c, err) return } req.Password = string(password) if err := postgresqlService.CreateUser(req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Router /databases/pg/users/update [post] // @x-panel-log {"bodyKeys":["database","username"],"paramKeys":[],"formatZH":"修改 PostgreSQL 实例 [database] 用户 [username]","formatEN":"update PostgreSQL instance [database] user [username]","BeforeFunctions":[]} func (b *BaseApi) UpdatePostgresqlUser(c *gin.Context) { var req dto.PostgresqlUserUpdate if err := helper.CheckBindAndValidate(&req, c); err != nil { return } if err := postgresqlService.UpdateUser(req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Router /databases/pg/users/password [post] // @x-panel-log {"bodyKeys":["database","username"],"paramKeys":[],"formatZH":"修改 PostgreSQL 实例 [database] 用户 [username] 密码","formatEN":"change PostgreSQL instance [database] user [username] password","BeforeFunctions":[]} func (b *BaseApi) ChangePostgresqlUserPassword(c *gin.Context) { var req dto.PostgresqlUserPassword if err := helper.CheckBindAndValidate(&req, c); err != nil { return } password, err := base64.StdEncoding.DecodeString(req.Password) if err != nil { helper.BadRequest(c, err) return } req.Password = string(password) if err := postgresqlService.ChangeUserPassword(req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Tags Database PostgreSQL // @Summary Save postgresql user password locally // @Accept json // @Param request body dto.PostgresqlUserPassword true "request" // @Success 200 // @Security ApiKeyAuth // @Security Timestamp // @Router /databases/pg/users/password/save [post] // @x-panel-log {"bodyKeys":["database","username"],"paramKeys":[],"BeforeFunctions":[],"formatZH":"补充 PostgreSQL 实例 [database] 用户 [username] 密码","formatEN":"save PostgreSQL instance [database] user [username] password locally"} func (b *BaseApi) SavePostgresqlUserPassword(c *gin.Context) { var req dto.PostgresqlUserPassword if err := helper.CheckBindAndValidate(&req, c); err != nil { return } password, err := base64.StdEncoding.DecodeString(req.Password) if err != nil { helper.BadRequest(c, err) return } req.Password = string(password) if err := postgresqlService.SaveUserPassword(req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Router /databases/pg/users/del [post] // @x-panel-log {"bodyKeys":["database","username"],"paramKeys":[],"formatZH":"删除 PostgreSQL 实例 [database] 用户 [username]","formatEN":"delete PostgreSQL instance [database] user [username]","BeforeFunctions":[]} func (b *BaseApi) DeletePostgresqlUser(c *gin.Context) { var req dto.PostgresqlUserDelete if err := helper.CheckBindAndValidate(&req, c); err != nil { return } if err := postgresqlService.DeleteUser(req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Router /databases/pg/grants [post] // @x-panel-log {"bodyKeys":["database","username","name"],"paramKeys":[],"formatZH":"绑定 PostgreSQL 实例 [database] 数据库 [name] 用户 [username]","formatEN":"bind PostgreSQL instance [database] database [name] user [username]","BeforeFunctions":[]} func (b *BaseApi) GrantPostgresqlUser(c *gin.Context) { var req dto.PostgresqlUserGrant if err := helper.CheckBindAndValidate(&req, c); err != nil { return } if err := postgresqlService.GrantUser(req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) } // @Router /databases/pg/grants/del [post] // @x-panel-log {"bodyKeys":["database","username","name"],"paramKeys":[],"formatZH":"撤销 PostgreSQL 实例 [database] 数据库 [name] 用户 [username] 绑定","formatEN":"revoke PostgreSQL instance [database] database [name] user [username] binding","BeforeFunctions":[]} func (b *BaseApi) RevokePostgresqlUser(c *gin.Context) { var req dto.PostgresqlUserGrant if err := helper.CheckBindAndValidate(&req, c); err != nil { return } if err := postgresqlService.RevokeUser(req); err != nil { helper.InternalServer(c, err) return } helper.Success(c) }