1 use crate::{newtypes::LanguageId, source::language::Language};
2 use diesel::{result::Error, PgConnection, RunQueryDsl, *};
5 pub fn read_all(conn: &PgConnection) -> Result<Vec<Language>, Error> {
6 use crate::schema::language::dsl::*;
7 language.load::<Self>(conn)
10 pub fn read_from_id(conn: &PgConnection, id_: LanguageId) -> Result<Language, Error> {
11 use crate::schema::language::dsl::*;
12 language.filter(id.eq(id_)).first::<Self>(conn)
15 pub fn read_id_from_code(conn: &PgConnection, code_: &str) -> Result<LanguageId, Error> {
16 use crate::schema::language::dsl::*;
17 Ok(language.filter(code.eq(code_)).first::<Self>(conn)?.id)
20 pub fn read_id_from_code_opt(
23 ) -> Result<Option<LanguageId>, Error> {
24 if let Some(code_) = code_ {
25 Ok(Some(Language::read_id_from_code(conn, code_)?))
31 pub fn read_undetermined(conn: &PgConnection) -> Result<LanguageId, Error> {
32 use crate::schema::language::dsl::*;
33 Ok(language.filter(code.eq("und")).first::<Self>(conn)?.id)
39 use crate::{source::language::Language, utils::establish_unpooled_connection};
40 use serial_test::serial;
45 let conn = establish_unpooled_connection();
47 let all = Language::read_all(&conn).unwrap();
49 assert_eq!(184, all.len());
50 assert_eq!("ak", all[5].code);
51 assert_eq!("lv", all[99].code);
52 assert_eq!("yi", all[179].code);