should = (require \chai).should!

expect = (require \chai).expect
var plx, conString
describe 'db', -> ``it``
  .. 'loaded successfully.', (done) ->
    # Load home page
    conString := process.env.TESTDB ? "tcp://localhost/#{ process.env.TESTDBNAME }"
    plv8x = require \..
    _plx <- plv8x.new conString
    plx := _plx
    plx.should.be.ok
    done!
  .. 'javascript |>', (done) ->
    rows <- plx.query "select |> '1' as ret"
    expect JSON.parse rows.0.ret .to.equal(1)
    done!
  .. 'javascript |> return', (done) ->
    rows <- plx.query "select |> 'if (true) { return 21.5; }' as ret"
    expect JSON.parse rows.0.ret .to.equal(21.5)
    done!
  .. 'javascript |> function', (done) ->
    rows <- plx.query "select |> 'function() { return 42; }' as ret"
    expect JSON.parse rows.0.ret .to.equal(42)
    done!
  .. 'javascript data |> expression', (done) ->
    rows <- plx.query "select $1 |> $2 as ret", [ JSON.stringify({ hello: [2, 3, 4] }), 'this.hello[1]' ]
    expect JSON.parse rows.0.ret .to.equal(3)
    done!
  .. 'livescript |> ~>', (done) ->
    <- plx.import-bundle \LiveScript './node_modules/LiveScript/package.json'
    rows <- plx.query "select |> $1 as ret" ['~> plv8x.require "LiveScript" .VERSION']
    console.log rows
    expect rows.0.ret .to.equal \1.2.0
    done!
  .. 'livescript data |> ->', (done) ->
    rows <- plx.query "select $1 |> $2 as ret", [ JSON.stringify({ hello: [2, 3, 4] }), '-> @hello.1' ]
    expect rows.0.ret .to.equal(3)
    done!
  .. 'livescript data |> expression', (done) ->
    rows <- plx.query "select $1 |> $2 as ret", [ JSON.stringify({ hello: [2, 3, 4] }), '@hello.1' ]
    expect JSON.parse rows.0.ret .to.equal(3)
    done!
  .. 'livescript ~>', (done) ->
    <- plx.import-bundle \LiveScript './node_modules/LiveScript/package.json'
    rows <- plx.query "select ~> $1 as ret" ['plv8x.require "LiveScript" .VERSION']
    console.log rows
    expect rows.0.ret .to.equal \1.2.0
    done!
  .. 'livescript data ~>', (done) ->
    rows <- plx.query "select $1 ~> $2 as ret", [ JSON.stringify({ hello: [2, 3, 4] }), '-@hello.1' ]
    expect rows.0.ret .to.equal(-3)
    done!
  .. 'livescript <~ data', (done) ->
    rows <- plx.query "select $2 <~ $1 as ret", [ JSON.stringify({ hello: [2, 3, 4] }), '-@hello.1' ]
    expect rows.0.ret .to.equal(-3)
    done!
# Currently Borked -- pullreqs welcome
/*
  .. 'coffeescript |> =>', (done) ->
    <- plx.import-bundle \coffee-script './node_modules/coffee-script/package.json'
    rows <- plx.query "select |> $1 as ret" ['=> "1.6.2"']
    console.log rows
    expect rows.0.ret .to.equal \1.6.2
    done!
  .. 'coffeescript data |> =>', (done) ->
    rows <- plx.query "select $1 |> $2 as ret", [ JSON.stringify({ hello: [2, 3, 4] }), '=> @hello[1]' ]
    expect rows.0.ret .to.equal(3)
    done!
  */