#sqlite #traits #derive

macro derive-sql-sqlite

Accompany the derive-sql crate. Implements the DeriveSqlite procedural macro to implement trait for SQLite

13 releases (7 breaking)

0.12.1 Aug 26, 2024
0.11.3 Jul 22, 2024
0.8.1 Mar 18, 2024
0.6.0 Nov 11, 2023

#483 in #sqlite

50 downloads per month
Used in 4 crates (via derive-sql)

MIT license

24KB
409 lines

Procedural macro to automatically generate an Sqlable trait for the provided struct that is compatible with an SQLite database.

How to use

You write:

#[derive(DeriveSqlite)]
pub struct Person {
  name: String,
  age: u32,
}

And you can use:


let connection = rusqlite::Connection::open_in_memory().unwrap();
let mut db: PersonSqlite<_> = connection.into();

// initialise
db.create_table().unwrap();

// Insert entries
db.insert(Person {name: "Abi".to_string(), age: 31 }).unwrap();
db.insert(Person {name: "Bert".to_string(), age: 32 }).unwrap();
db.insert(Person {name: "Charlie".to_string(), age: 33 }).unwrap();

// Query
let persons: Vec<Person> = db.select(Box::new(SimpleFilter::try_from(("age", 32)).unwrap())).unwrap();
assert!(persons[0].name.eq("Bert"));

// Update
db.update(Box::new(SimpleFilter::try_from(("name", "Abi")).unwrap()), Person { name: "Abi".to_string(), age: 32 }).unwrap();

// Delete
db.delete(Box::new(SimpleFilter::try_from(("name", "Abi")).unwrap())).unwrap();

// Clear the table
db.delete_table().unwrap();

Container attributes:

  • #[derive_sqlite(ident = ...)] overwrite the name of the rusqlite wrapper from {class}Sqlite;
  • #[derive_sqlite(table_name = "...")] specify the name of the table (default to the container name in lower case);

Field attributes:

  • #[derive_sqlite(is_primary_key = true)] nominate that one of the field is a primary key. Only one primary key can be specified. primary key fields are unique in the table.
  • #[derive_sqlite(on_insert = ...)] nominate a function of the type fn() -> {type} with {type} corresponding to the type of the field. The function is called when the item is inserted and the value returned by the function is assigned to the field before the item is inserted. Typical use is to assign a creation date.
  • #[derive_sqlite(on_update = ...)] nominate a function of the type fn() -> {type} with {type} corresponding to the type of the field. The function is called when the item is updated and the value returned by the function is assigned to the field before the item is updated. Typical use is to assign a last modified date.

Dependencies

~0.7–1.2MB
~24K SLoC