look into sqlx

[jrheard]

figuring out how to do simple stuff in diesel is giving me a lot of trouble. here's my first attempt at splitting out a portion of a WHERE clause so that it can be reused:

pub fn alive_tasks<'a>() -> Box<dyn BoxableExpression<task::table, Pg, SqlType = Bool> + 'a> {
    Box::new(task::mode.eq(any(vec![MODE_PENDING.0, MODE_ACTIVE.0])))
}

absolutely hideous.

also, afaict i can't do this:

    let query = task::table.find(task_id);
    if !include_deleted {
        query = query.filter(task::mode.ne(MODE_DELETED.0));
    }

because the second query value has a different type from the first.

hopefully i'm just doing stuff wrong and diesel is actually great! but comradeblue in irc uses https://github.com/launchbadge/sqlx , so i should do some research on that someday. low-priority.

[jrheard]

got help from the diesel maintainer via gitter, he suggested using a typedef for the first one and .into_boxed() for the second. ended up with this:

pub fn alive_tasks<'a>() -> SqlExpr<'a, task::table, Bool> {
    Box::new(task::mode.eq(any(vec![MODE_PENDING.0, MODE_ACTIVE.0])))
}

and

let mut query = task::table.find(task_id).into_boxed();
if !include_deleted {
    query = query.filter(task::mode.ne(MODE_DELETED.0));
}

which seems p reasonable! so this sqlx investigation ticket is super non-urgent / low-priority