// vtest build: started_postgres?
module main

import db.pg

@[table: 'demo']
struct Demo {
    id      int @[primary; sql: serial]
    number  f64
    number2 f32
}

fn test_float_field() {
    $if !network ? {
        eprintln('> Skipping test ${@FN}, since `-d network` is not passed.')
        eprintln('> This test requires a working postgres server running on localhost.')
        return
    }
    conn := 'host=localhost user=postgres password=12345678' // insert own connection string
    mut db := pg.connect_with_conninfo(conn)!
    defer {
        db.close() or {}
    }

    sql db {
        create table Demo
    }!

    demo := Demo{0, 9.58815, 9.58815}
    sql db {
        insert demo into Demo
    }!
    rows := sql db {
        select from Demo
    }!

    assert rows[0].number == 9.58815
    assert rows[0].number2 == 9.58815

    sql db {
        drop table Demo
    }!

    println(rows)
}