pub mod common;

use actualbudget_queries::actualbudget_categories::get_all_actualbudget_categories;
use common::{category_names::CATEGORY_NAMES, db_url::DB_URL};
use diesel::{Connection, SqliteConnection};

#[test]
fn given_test_database_when_get_all_categories_then_return_categories() {
    let connection = &mut SqliteConnection::establish(DB_URL).unwrap();

    let categories = get_all_actualbudget_categories(connection);

    assert!(categories.is_ok());
    let categories = categories.unwrap();
    assert_eq!(CATEGORY_NAMES.len(), categories.len());
    for &category_name in CATEGORY_NAMES {
        assert!(categories.iter().any(|a| a.name.as_str() == category_name));
    }
}