use chrono::{DateTime, Utc};
use serde::{Deserialize, Serialize};
use sqlx::FromRow;
use uuid::Uuid;
#[derive(Debug, Clone, FromRow, Serialize, Deserialize)]
pub struct CloudFixture {
pub id: Uuid,
pub org_id: Uuid,
pub workspace_id: Option<Uuid>,
pub name: String,
pub description: String,
pub path: String,
pub method: String,
pub content: Option<serde_json::Value>,
pub tags: serde_json::Value,
pub route_path: Option<String>,
pub protocol: Option<String>,
pub created_by: Uuid,
pub created_at: DateTime<Utc>,
pub updated_at: DateTime<Utc>,
}
#[cfg(feature = "postgres")]
impl CloudFixture {
#[allow(clippy::too_many_arguments)]
pub async fn create(
pool: &sqlx::PgPool,
org_id: Uuid,
created_by: Uuid,
name: &str,
description: &str,
path: &str,
method: &str,
content: Option<&serde_json::Value>,
protocol: Option<&str>,
tags: Option<&serde_json::Value>,
) -> sqlx::Result<Self> {
let tags_value = tags.cloned().unwrap_or_else(|| serde_json::Value::Array(Vec::new()));
sqlx::query_as::<_, Self>(
r#"
INSERT INTO fixtures (org_id, name, description, path, method, content, protocol, tags, created_by)
VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)
RETURNING *
"#,
)
.bind(org_id)
.bind(name)
.bind(description)
.bind(path)
.bind(method)
.bind(content)
.bind(protocol)
.bind(tags_value)
.bind(created_by)
.fetch_one(pool)
.await
}
pub async fn find_by_id(pool: &sqlx::PgPool, id: Uuid) -> sqlx::Result<Option<Self>> {
sqlx::query_as::<_, Self>("SELECT * FROM fixtures WHERE id = $1")
.bind(id)
.fetch_optional(pool)
.await
}
pub async fn find_by_org(pool: &sqlx::PgPool, org_id: Uuid) -> sqlx::Result<Vec<Self>> {
sqlx::query_as::<_, Self>(
"SELECT * FROM fixtures WHERE org_id = $1 ORDER BY created_at DESC",
)
.bind(org_id)
.fetch_all(pool)
.await
}
#[allow(clippy::too_many_arguments)]
pub async fn update(
pool: &sqlx::PgPool,
id: Uuid,
name: Option<&str>,
description: Option<&str>,
path: Option<&str>,
method: Option<&str>,
content: Option<&serde_json::Value>,
tags: Option<&serde_json::Value>,
) -> sqlx::Result<Option<Self>> {
sqlx::query_as::<_, Self>(
r#"
UPDATE fixtures
SET
name = COALESCE($2, name),
description = COALESCE($3, description),
path = COALESCE($4, path),
method = COALESCE($5, method),
content = COALESCE($6, content),
tags = COALESCE($7, tags),
updated_at = NOW()
WHERE id = $1
RETURNING *
"#,
)
.bind(id)
.bind(name)
.bind(description)
.bind(path)
.bind(method)
.bind(content)
.bind(tags)
.fetch_optional(pool)
.await
}
pub async fn delete(pool: &sqlx::PgPool, id: Uuid) -> sqlx::Result<()> {
sqlx::query("DELETE FROM fixtures WHERE id = $1").bind(id).execute(pool).await?;
Ok(())
}
}