Add this to your Cargo.toml:
[dependencies]
serde_rusqlite = "0.10"
This crate provides convenience functions to bridge serde and rusqlite. With their help
you can "deserialize" rusqlite Row's into serde Deserialize types and "serialize" types
implementing Serialize into bound query arguments (positional or named) that rusqlite expects.
Serialization of named bound arguments is only supported from structs and maps because other
serde types lack column name information. Likewise, serialization of positional bound arguments
is only supported from tuples, sequences and primitive non-iterable types. In the latter case
the result will be single-element vector. Each serialized field or element must implement
rusqlite::types::ToSql.
SQLite only supports 5 types: NULL (None), INTEGER (i64), REAL (f64), TEXT (String)
and BLOB (Vec<u8>). Corresponding rust types are inside brackets.
Some types employ non-trivial handling, these are described below:
* Serialization of u64 will fail if it can't be represented by i64 due to sqlite limitations.
* Simple enums will be serialized as strings so:
enum Gender {
M,
F,
}
will have two possible TEXT options in the database "M" and "F". Deserialization into enum
from TEXT is also supported.
* bools are serialized as INTEGERs 0 or 1, can be deserialized from INTEGER and REAL where
0 and 0.0 are false, anything else is true.
* f64 and f32 values of NaN are serialized as NULLs. When deserializing such value Option<f64>
will have value of None and f64 will have value of NaN. The same applies to f32.
* Bytes, ByteBuf from serde_bytes are supported as optimized way of handling BLOBs.
* unit serializes to NULL.
* Only sequences of u8 are serialized and deserialized, BLOB database type is used. It's
more optimal though to use Bytes and ByteBuf from serde_bytes for such fields.
* unit_struct serializes to struct name as TEXT, when deserializing the check is made to ensure
that struct name coincides with the string in the database.
```rust extern crate rusqlite;
extern crate serdederive; extern crate serderusqlite;
struct Example { id: i64, name: String, }
fn main() { let connection = rusqlite::Connection::openinmemory().unwrap(); connection.execute("CREATE TABLE example (id INT, name TEXT)", &[]).unwrap();
let row1 = Example{ id: 1, name: "first name".into() }; connection.executenamed("INSERT INTO example (id, name) VALUES (:id, :name)", &serderusqlite::toparamsnamed(&row1).unwrap().to_slice()).unwrap();
let row2 = (2, "second name"); connection.execute("INSERT INTO example (id, name) VALUES (?, ?)", &serderusqlite::toparams(&row2).unwrap().to_slice()).unwrap();
let mut statement = connection.prepare("SELECT * FROM example").unwrap();
let columns = serderusqlite::columnsfromstatement(&statement);
let mut rows = statement.querymap(&[], |row| serderusqlite::fromrow::