/*
 * Copyright (c) 2017-2018 Boucher, Antoni <bouanto@zoho.com>
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy of
 * this software and associated documentation files (the "Software"), to deal in
 * the Software without restriction, including without limitation the rights to
 * use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of
 * the Software, and to permit persons to whom the Software is furnished to do so,
 * subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS
 * FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR
 * COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER
 * IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN
 * CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 */

#![feature(proc_macro)]

extern crate chrono;
extern crate tql;
#[macro_use]
extern crate tql_macros;

#[macro_use]
mod connection;
mod teardown;

backend_extern_crate!();

use chrono::DateTime;
use chrono::naive::{NaiveDate, NaiveDateTime, NaiveTime};
use chrono::offset::{Local, Utc};
use tql::{ForeignKey, PrimaryKey};
use tql_macros::sql;

use connection::get_connection;
use teardown::TearDown;

#[derive(SqlTable)]
#[allow(dead_code)]
struct SqlTable {
    id: PrimaryKey,
    field1: String,
    field2: i32,
    field3: Option<i32>,
    related_field: ForeignKey<RelatedTable>,
}

#[derive(SqlTable)]
#[allow(dead_code)]
struct RelatedTable {
    id: PrimaryKey,
    field1: String,
}

#[derive(SqlTable)]
#[allow(dead_code)]
struct Dates {
    pk: PrimaryKey,
    date1: NaiveDateTime,
    date2: DateTime<Utc>,
    date3: DateTime<Local>,
    date4: NaiveDate,
    date5: NaiveTime,
}

#[cfg(feature = "postgres")]
#[derive(SqlTable)]
#[allow(dead_code)]
struct OtherTypes {
    pk: PrimaryKey,
    boolean: bool,
    bytestring: Vec<u8>,
    //character: char, // FIXME: does not work.
    float32: f32,
    float64: f64,
    int8: i8,
    int16: i16,
    int32: i32,
    int64: i64,
}

#[cfg(feature = "sqlite")]
#[derive(SqlTable)]
#[allow(dead_code)]
struct OtherTypes {
    pk: PrimaryKey,
    boolean: bool,
    bytestring: Vec<u8>,
    //character: char, // FIXME: does not work.
    float64: f64,
    int8: i8,
    int16: i16,
    int32: i32,
    int64: i64,
}

#[test]
fn test_create() {
    let connection = get_connection();

    let _teardown = TearDown::new(|| {
        let _ = sql!(SqlTable.drop());
        let _ = sql!(RelatedTable.drop());
        let _ = sql!(Dates.drop());
        let _ = sql!(OtherTypes.drop());
    });

    assert!(sql!(RelatedTable.create()).is_ok());

    assert!(sql!(SqlTable.create()).is_ok());

    assert!(sql!(Dates.create()).is_ok());
    assert!(sql!(Dates.drop()).is_ok());

    assert!(sql!(OtherTypes.create()).is_ok());
    assert!(sql!(OtherTypes.drop()).is_ok());

    assert!(sql!(SqlTable.drop()).is_ok());
    assert!(sql!(RelatedTable.drop()).is_ok());
}