Function main

example-postgres/src/main.rs:12–79

()

#[tokio::main]
async fn main() -> anyhow::Result<()> {
    dotenv::dotenv().ok();
    env_logger::builder()
        .filter_level(LevelFilter::Debug)
        .init();

    let db = PgPool::connect(&dotenv::var("DATABASE_URL")?).await?;

    log::info!("insert a few new rows into the database");
    let mut new = InsertUser {
        user_id: 1,
        first_name: "Moritz".to_owned(),
        last_name: "Bischof".to_owned(),
        email: "moritz.bischof1@gmail.com".to_owned(),
        disabled: None,
        role: Role::User,
        ty: Some(AccountType::Normal),
    }
    .insert(&db)
    .await?;
    InsertUser {
        user_id: 2,
        first_name: "Dylan".to_owned(),
        last_name: "Thomas".to_owned(),
        email: "dylan.thomas@gmail.com".to_owned(),
        disabled: Some("email not verified".to_owned()),
        role: Role::Admin,
        ty: None,
    }
    .insert(&db)
    .await?;

    log::info!("update a single field");
    new.set_last_login(&db, Some(Utc::now().naive_utc()))
        .await?;

    log::info!("update all fields at once");
    new.email = "asdf".to_owned();
    new.update(&db).await?;

    log::info!("apply a patch to the user");
    new.patch(
        &db,
        UpdateUser {
            first_name: "NewFirstName".to_owned(),
            last_name: "NewLastName".to_owned(),
            disabled: Some("Reason".to_owned()),
            role: Role::Admin,
        },
    )
    .await?;

    log::info!("reload the user, in case it has been modified");
    new.reload(&db).await?;

    log::info!("use the improved query macro for searching users");
    let search_result = query2::query_users(&db, Some("NewFirstName"), None).await?;
    log::info!("search result: {:?}", search_result);