nim-ladybug/tests/queries/t_can_execute_a_simple_queries.nim

# vim: set et sta sw=4 ts=4 :

import lbug

let db = newLbugDatabase()
let conn = db.connect

var q = conn.query( "CREATE NODE TABLE Doop ( id SERIAL, thing STRING, PRIMARY KEY(id) )" )
assert typeOf( q ) is LbugQueryResult

for thing in @[ "Camel", "Lampshade", "Delicious Cake" ]:
    q = conn.query( "CREATE (d:Doop {thing: '" & thing & "'})" )
    assert typeOf( q ) is LbugQueryResult

q = conn.query( "MATCH (d:Doop) RETURN d.thing" )
assert q.num_columns == 1
assert q.num_tuples == 3
assert q.compile_time > 0
assert q.execution_time > 0