use deuterium::*;

#[test]
fn select() {

    let jedi_table = TableDef::new("jedi");
    let name = NamedField::<String>::field_of("name", &jedi_table);
    let side = NamedField::<bool>::field_of("side", &jedi_table);
    
    // Type is here only for sure it is right, it can be ommited in real code
    let query: SelectQuery<(), LimitMany, ()> = jedi_table.select_all();
    assert_sql!(query, "SELECT * FROM jedi;");

    let query: SelectQuery<(String,), LimitMany, ()> = jedi_table.select_1(&name);
    assert_sql!(query, "SELECT name FROM jedi;");

    let query: SelectQuery<(String,), LimitMany, ()> = jedi_table.alias("j").select_1(&name);
    assert_sql!(query, "SELECT name FROM jedi AS j;");

    let query: SelectQuery<(String, bool), LimitMany, ()> = jedi_table.select_2(&name, &side);
    assert_sql!(query, "SELECT name, side FROM jedi;");
}

#[test]
fn select_from_select() {

    let jedi_table = TableDef::new("jedi");
    
    let query = jedi_table.select_all().from_as("j").select_all();
    assert_sql!(query, "SELECT * FROM (SELECT * FROM jedi) as j;");
}

#[test]
fn select_distinct() {

    let jedi_table = TableDef::new("jedi");
    let name = NamedField::<String>::field_of("name", &jedi_table);

    let query = jedi_table.select_all().distinct();
    assert_sql!(query, "SELECT DISTINCT * FROM jedi;");    

    let query = jedi_table.select_all().distinct_on(&[&name]);
    assert_sql!(query, "SELECT DISTINCT ON (name) * FROM jedi;");
}

#[test]
fn select_for() {

    let jedi_table = TableDef::new("jedi");
    
    let query = jedi_table.select_all().for_update();
    assert_sql!(query, "SELECT * FROM jedi FOR UPDATE;"); 

    let query = jedi_table.select_all().for_share();
    assert_sql!(query, "SELECT * FROM jedi FOR SHARE;");     

    let query = jedi_table.select_all().for_update_nowait();
    assert_sql!(query, "SELECT * FROM jedi FOR UPDATE NOWAIT;");      

    let query = jedi_table.select_all().for_share_nowait();
    assert_sql!(query, "SELECT * FROM jedi FOR SHARE NOWAIT;");    
}


#[test]
fn select_exists() {

    let jedi_table = TableDef::new("jedi");
    let name = NamedField::<String>::field_of("name", &jedi_table);
    
    let query = jedi_table.exists().where_(name.is("Luke".to_string()));
    assert_sql!(query, "SELECT 1 FROM jedi WHERE name = $1;");    
}