Derive Macro sqlxinsert::SqliteInsert

source ·
#[derive(SqliteInsert)]
Expand description

Create method for inserting struts into Sqlite database

#[derive(Default, Debug, sqlx::FromRow, sqlxinsert::SqliteInsert)]
struct Car {
    pub car_id: i32,
    pub car_name: String,
}

let car = Car {
    car_id: 33,
    car_name: "Skoda".to_string(),
};

let url = "sqlite::memory:";
let pool = sqlx::sqlite::SqlitePoolOptions::new().connect(url).await.unwrap();

let create_table = "create table cars ( car_id INTEGER PRIMARY KEY, car_name TEXT NOT NULL )";
sqlx::query(create_table).execute(&pool).await.expect("Not possible to execute");

let res = car.insert_raw(&pool, "cars").await.unwrap(); // returning id