use crate::{
    models::budget_update::BudgetUpdate,
    schema::budget_updates::{
        self as budget_updates_schema, dsl::budget_updates as budget_updates_table,
    },
};
use diesel::{
    result::Error, ExpressionMethods, QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection,
};

pub fn get_first_budget_update_with_date(
    date: &str,
    connection: &mut SqliteConnection,
) -> Result<BudgetUpdate, Error> {
    budget_updates_table
        .select(BudgetUpdate::as_select())
        .filter(budget_updates_schema::date.eq(date))
        .first(connection)
}