r2d2-aykroyd
============

[Documentation](https://docs.rs/r2d2-aykroyd)

[aykroyd](https://crates.io/crates/aykroyd) support library for the [r2d2](https://crates.io/crates/r2d2) connection pool.

Examples
--------

An example of the `postgres` client.

```rust
use std::thread;
use postgres::NoTls;
use r2d2_aykroyd::postgres::AykroydConnectionManager;

#[derive(aykroyd::QueryOne)]
#[query(row(Row), text = "SELECT 1 + $1")]
struct AddOneTo(i32);

#[derive(aykroyd::FromRow)]
struct Row(i32);

fn main() {
    let manager = AykroydConnectionManager::new(
        "host=localhost user=postgres".parse().unwrap(),
        NoTls,
    );
    let pool = r2d2::Pool::new(manager).unwrap();

    for i in 0..10i32 {
        let pool = pool.clone();
        thread::spawn(move || {
            let mut client = pool.get().unwrap();
            let row = client.query_one(&AddOneTo(i)).unwrap();
            let value = row.0;
            assert_eq!(value, i + 1);
        });
    }
}
```

An example of the `mysql` client.

```rust
use std::thread;
use r2d2_aykroyd::mysql::AykroydConnectionManager;

#[derive(aykroyd::QueryOne)]
#[query(row(Row), text = "SELECT 1 + ?")]
struct AddOneTo(i32);

#[derive(aykroyd::FromRow)]
struct Row(i32);

fn main() {
    let opts = mysqsl::Opts::from_url(
        "mysql://user:password@locahost:3307/db_name",
    );
    let builder = mysql::OptsBuilder::from_opts(opts);
    let manager = AykroydConnectionManager::new(builder);
    let pool = r2d2::Pool::new(manager).unwrap();

    for i in 0..10i32 {
        let pool = pool.clone();
        thread::spawn(move || {
            let mut client = pool.get().unwrap();
            let row = client.query_one(&AddOneTo(i)).unwrap();
            let value = row.0;
            assert_eq!(value, i + 1);
        });
    }
}
```