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