go train delay rust api sqlx get all

go_train_delay_rust_api_sqlx_get_all.rs

let q = format!(
        "select 
            date, 
            departure, 
            depart_scheduled, 
            destination, 
            arrival_scheduled, 
            delay, 
            created_at,
            count(*) OVER() AS total_count
        from delays 
        ORDER BY created_at DESC 
        LIMIT {} 
        OFFSET {}",
        &limit, &offset
    );

    let delays = sqlx::query_as::<_, Delay>(&q).fetch_all(&state.db).await?;

    if delays.is_empty() {
        return Ok(HttpResponse::InternalServerError().json(AppError{
            message: Some("no record found".to_string()),
            cause: Some("out of record range".to_string()),
            error_type: AppErrorType::DbError,
        }));
}