use crate::{
models::{CreateDatabase, Database, DbPrivilege},
CpanelClient, CpanelError,
};
impl CpanelClient {
pub async fn list_databases(&self, user: &str) -> Result<Vec<Database>, CpanelError> {
let result: Vec<Database> = self.uapi("Mysql", "list_dbs", &[("user", user)]).await?;
Ok(result)
}
pub async fn create_database(
&self,
user: &str,
create: &CreateDatabase,
) -> Result<(), CpanelError> {
let mut params: Vec<(&str, &str)> = vec![("user", user), ("name", &create.name)];
if let Some(charset) = &create.charset {
params.push(("charset", charset.as_str()));
}
let _: () = self.uapi("Mysql", "create_db", ¶ms).await?;
Ok(())
}
pub async fn delete_database(&self, user: &str, name: &str) -> Result<(), CpanelError> {
let _: () = self
.uapi("Mysql", "drop_db", &[("user", user), ("name", name)])
.await?;
Ok(())
}
pub async fn create_db_user(
&self,
user: &str,
db_user: &str,
password: &str,
) -> Result<(), CpanelError> {
let _: () = self
.uapi(
"Mysql",
"add_user",
&[("user", user), ("name", db_user), ("password", password)],
)
.await?;
Ok(())
}
pub async fn grant_privileges(
&self,
user: &str,
db_user: &str,
database: &str,
table: &str,
privilege: &str,
) -> Result<(), CpanelError> {
let _: () = self
.uapi(
"Mysql",
"set_user_privileges",
&[
("user", user),
("dbuser", db_user),
("dbname", database),
("table", table),
("privilege", privilege),
],
)
.await?;
Ok(())
}
pub async fn revoke_privileges(
&self,
user: &str,
db_user: &str,
database: &str,
table: &str,
privilege: &str,
) -> Result<(), CpanelError> {
let _: () = self
.uapi(
"Mysql",
"set_user_privileges",
&[
("user", user),
("dbuser", db_user),
("dbname", database),
("table", table),
("privilege", privilege),
("revoke", "1"),
],
)
.await?;
Ok(())
}
pub async fn list_db_user_privileges(
&self,
user: &str,
db_user: &str,
) -> Result<Vec<DbPrivilege>, CpanelError> {
let result: Vec<DbPrivilege> = self
.uapi(
"Mysql",
"list_user_privileges",
&[("user", user), ("dbuser", db_user)],
)
.await?;
Ok(result)
}
pub async fn drop_db_user(&self, user: &str, db_user: &str) -> Result<(), CpanelError> {
let _: () = self
.uapi("Mysql", "drop_user", &[("user", user), ("name", db_user)])
.await?;
Ok(())
}
}