// vtest build: !windows
module main

import db.pg
import db.sqlite

fn test_pg_connection_user_aliases() {
    assert pg.Config{
        user: 'alice'
    }.connection_user()! == 'alice'
    assert pg.Config{
        username: 'alice'
    }.connection_user()! == 'alice'
    assert pg.Config{
        user:     'alice'
        username: 'alice'
    }.connection_user()! == 'alice'
    if _ := pg.Config{
        user:     'alice'
        username: 'bob'
    }.connection_user()
    {
        assert false
    } else {
        assert err.msg().contains('must match')
    }
}

fn test_pg_row_value_helpers() {
    mut vals := []?string{}
    vals << none
    vals << 'hello'
    vals << ''
    row := pg.Row{
        vals: vals
    }
    assert row.val(0) == ''
    assert row.val(1) == 'hello'
    assert row.values() == ['', 'hello', '']
    assert row.val_opt(0) == none
    assert row.val_opt(1) or { '' } == 'hello'
}

fn test_sqlite_row_value_helpers() {
    sqlite_row := sqlite.Row{
        vals:  ['hello', '']
        names: ['first', 'second']
    }
    assert sqlite_row.val(0) == 'hello'
    assert sqlite_row.values() == ['hello', '']
}