use crate::domain::models::crawl_model::ACTIVE_CRAWL_STATUSES;
use crate::infrastructure::database::entities::crawl;
use dbnexus::sea_orm::{sea_query::Expr, ColumnTrait, Condition, ExprTrait};
pub(crate) fn non_terminal_condition() -> Condition {
Condition::all().add(crawl::Column::Status.is_in(ACTIVE_CRAWL_STATUSES))
}
pub(crate) fn terminal_eligible_condition() -> Condition {
non_terminal_condition()
.add(crawl::Column::TotalTasks.gt(0))
.add(
Expr::col(crawl::Column::CompletedTasks)
.add(Expr::col(crawl::Column::FailedTasks))
.eq(Expr::col(crawl::Column::TotalTasks)),
)
}
pub(crate) fn terminal_status_case() -> Expr {
Expr::cust("CASE WHEN completed_tasks = 0 THEN 'failed' ELSE 'completed' END")
}