[][src]Derive Macro sqlxinsert::SqliteInsert

#[derive(SqliteInsert)]

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:%3Amemory:";
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(&pool, "cars").await.unwrap();