extern crate mysql;
extern crate ini;

use mysql as my;
use ini::Ini;

struct BinData {
    id: i32,
    bin: i32,
    country: String,
    bank: String
}

fn main() {

    let mysql_options = Ini::load_from_file("./conf.cnf").unwrap();

    let sect = mysql_options.section(Some("client"));

    let params = sect.unwrap();
    let user = params.get("user").unwrap().as_str();
    let host = params.get("host").unwrap().as_str();
    let password = params.get("password").unwrap().as_str();
    let database = params.get("database").unwrap().as_str();
    let port = "3306";


    let mut connection_string = String::new();
    let ss = format!("mysql://{}:{}@{}:{}/{}", user, password, host,  port, database);
    connection_string.push_str(&ss[..]);


    let pool = my::Pool::new(connection_string).unwrap();

    let bins: Vec<BinData> = pool.prep_exec("SELECT id, bin, country, bank from binData limit 10", ())
        .map(|result| {
            result.map(|x| x.unwrap()).map(|row| {
                let (id, bin, country, bank) = my::from_row(row);
                BinData {
                    id: id,
                    bin: bin,
                    country: country,
                    bank: bank
                }
            }).collect()
        }).unwrap();

    for bn in &bins {
        println!("{} {} {} {}", bn.id, bn.bin,bn.country,bn.bank);
    }
}