-use crate::{newtypes::LanguageId, source::language::Language};
-use diesel::{result::Error, PgConnection, RunQueryDsl, *};
+use crate::{
+ diesel::ExpressionMethods,
+ newtypes::LanguageId,
+ schema::language::dsl::{code, id, language},
+ source::language::Language,
+ utils::{get_conn, DbPool},
+};
+use diesel::{result::Error, QueryDsl};
+use diesel_async::RunQueryDsl;
impl Language {
- pub fn read_all(conn: &PgConnection) -> Result<Vec<Language>, Error> {
- use crate::schema::language::dsl::*;
- language.load::<Self>(conn)
+ pub async fn read_all(pool: &mut DbPool<'_>) -> Result<Vec<Language>, Error> {
+ let conn = &mut get_conn(pool).await?;
+ language.load::<Self>(conn).await
}
- pub fn read_from_id(conn: &PgConnection, id_: LanguageId) -> Result<Language, Error> {
- use crate::schema::language::dsl::*;
- language.filter(id.eq(id_)).first::<Self>(conn)
+ pub async fn read_from_id(pool: &mut DbPool<'_>, id_: LanguageId) -> Result<Language, Error> {
+ let conn = &mut get_conn(pool).await?;
+ language.filter(id.eq(id_)).first::<Self>(conn).await
}
- pub fn read_id_from_code(conn: &PgConnection, code_: &str) -> Result<LanguageId, Error> {
- use crate::schema::language::dsl::*;
- Ok(language.filter(code.eq(code_)).first::<Self>(conn)?.id)
- }
-
- pub fn read_id_from_code_opt(
- conn: &PgConnection,
+ /// Attempts to find the given language code and return its ID. If not found, returns none.
+ pub async fn read_id_from_code(
+ pool: &mut DbPool<'_>,
code_: Option<&str>,
) -> Result<Option<LanguageId>, Error> {
if let Some(code_) = code_ {
- Ok(Some(Language::read_id_from_code(conn, code_)?))
+ let conn = &mut get_conn(pool).await?;
+ Ok(
+ language
+ .filter(code.eq(code_))
+ .first::<Self>(conn)
+ .await
+ .map(|l| l.id)
+ .ok(),
+ )
} else {
Ok(None)
}
}
-
- pub fn read_undetermined(conn: &PgConnection) -> Result<LanguageId, Error> {
- use crate::schema::language::dsl::*;
- Ok(language.filter(code.eq("und")).first::<Self>(conn)?.id)
- }
}
#[cfg(test)]
mod tests {
- use crate::{source::language::Language, utils::establish_unpooled_connection};
+ use crate::{source::language::Language, utils::build_db_pool_for_tests};
use serial_test::serial;
- #[test]
+ #[tokio::test]
#[serial]
- fn test_languages() {
- let conn = establish_unpooled_connection();
+ async fn test_languages() {
+ let pool = &build_db_pool_for_tests().await;
+ let pool = &mut pool.into();
- let all = Language::read_all(&conn).unwrap();
+ let all = Language::read_all(pool).await.unwrap();
assert_eq!(184, all.len());
assert_eq!("ak", all[5].code);