var redis  = require("./redisql"),
    sys    = require('sys'),
    client = redis.createClient();

function last_command(err, res) {
    console.log("Last result: " + res.toString());
    client.quit();
}

client.flushdb(redis.print);

client.create("TABLE", "worker", "id int,division int,health int,salary TEXT, name TEXT", redis.print);

client.create("INDEX", "worker:division:index", "worker", "division", redis.print);
client.create("INDEX", "worker:health:index", "worker", "health", redis.print);

client.insert("worker", "(1,11,2,60000.66,jim)", redis.print);
client.insert("worker", "(2,22,1,30000.33,jack)", redis.print);
client.insert("worker", "(3,33,4,90000.99,bob)", redis.print);
client.insert("worker", "(4,44,3,70000.77,bill)", redis.print);
client.insert("worker", "(6,66,1,12000.99,jan)", redis.print);
client.insert("worker", "(7,66,1,11000.99,beth)", redis.print);
client.insert("worker", "(8,11,2,68888.99,mac)", redis.print);
client.insert("worker", "(9,22,1,31111.99,ken)", redis.print);
client.insert("worker", "(10,33,4,111111.99,seth)", redis.print);

client.scanselect("*", "worker", redis.print);
client.scanselect("*", "worker", "name=bill", redis.print);

client.select("*", "worker", "id=1", redis.print);
client.update("worker", "name=JIM", "id = 1", redis.print);
client.select("*", "worker", "id = 1", redis.print);

client.delete("worker", "id = 2", redis.print);
client.select("*", "worker", "id = 2", redis.print);

client.desc("worker", redis.print);
client.dump("worker",  redis.print);

client.drop("index", "worker:health:index",  redis.print);

client.drop("table", "worker", last_command);