Query With Option Parameters

[Dawson-Jones]

I have some parameters now

like: ?username=ast&user_type=admin&status=active&expiration=2024-08

Every parameter can exist or not, if not, ignore it as a filter

So in this situation, what my code should be written.

I've tried like

async fn sqlx_query(
    db: &PgPool,
    params: &Params,
) -> sqlx::Result<Vec<UserOut>> {
    let mut query_str = String::from(
        r#"
            SELECT 
                user_id, 
                username, 
                user_type as "user_type:_",
                status as "status:_",
                vip_expired
            FROM users
            WHERE 1 = 1
        "#,
    );


    // let mut bindings: Vec<Box<dyn sqlx::encode::Encode<sqlx::Postgres> + Send>> = vec![];
    let mut param_count = 1;
    let mut bindings:Vec<Box<(dyn sqlx::encode::Encode<sqlx::Postgres> + Send)>> = vec![];

    if let Some(username) = params.username {
        query_str.push_str(&format!("AND username like '%${}%'", param_count));
        bindings.push(Box::new(username));
        param_count += 1;
    }

    // ---------- parameters else ignore

    let mut query = sqlx::query_as::<_, UserOut>(&query_str);
    for binding in bindings {
        query = query.bind(*binding);
    }

    query.fetch_all(db).await
}

Obviously, It does not work...

I want to know how to make it in those situations