[−][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();