# diesel_json

Provides a wrapper `diesel_json::Json` type that can be directly used
to wrap serde serializable, deserializable structures and recognize them
as queryable, insertable JsonB fields.

## Getting started

Add diesel_json dependency to Cargo.toml.

* Diesel 2.0 supported: `diesel_json = "0.2"`
* Diesel 1.4 supported: `diesel_json = "0.1"`

Wrap data structures into `diesel_json::Json` type.

```rust
#[derive(Serialize, Deserialize, Debug)]
struct ComplexStruct {
  // ...
}

use diesel_json::Json;

#[derive(Serialize, Deserialize, Queryable, Insertable, AsChangeset, Identifiable)]
struct ExampleTable {
    // ...
    // Field that will be stored in Jsonb format
    jsonb_field: diesel_json::Json<ComplexStruct>,
    // Or simply as 
    jsonb_field2: Json<ComplexStruct>,
    // ...
}
```

`Json` type provides `new` function for object initialization, implements `Deref`,
`DerefMut`, `AsRef`, `AsMut` and other traits that maps data access directly to underlying data.

See `tests/postgresql.rs` for example use.

## Why should I use this library?

Without wrapper type for each unique type you store as JsonB field you
would need to use `serde_json::Value` directly
or implement your own implementation for following traits:
```rust
impl<T> FromSql<sql_types::JsonB, Pg> for Json<T> {}
impl<T> ToSql<sql_types::JsonB, Pg> for Json<T> {}
```

## TODO:

- [ ] Support not only JsonB, but also Json postgres type
- Support more database drivers
    - [x] PostgreSQL
    - [ ] MySql
    - [ ] SQLite
- Improve testing of the library
    - [x] Test insertion and retrieval of nullable/non-nullable JsonB postgresql fields.
    - [ ] Add support and test Json field insertion and retrieval
    - TODO(Expand): Add support for other database driver Json fields