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


client.flushdb();

// CREATE TABLE worker (id int primary key, division int, health int, salary TEXT, name TEXT)
client.create("TABLE", "worker", "(id", "int,", "division", "int,", "health", "int,", "salary", "TEXT,", "name", "TEXT)", redis.print);
client.create("INDEX", "worker:division:index", "ON", "worker", "(division)", redis.print);
client.create("INDEX", "worker:health:index", "ON", "worker", "(health)", redis.print);

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

client.scanselect("*", "FROM", "worker", redis.print);
client.select("*", "FROM", "worker", "WHERE", "id", "=", "1", redis.print);
client.update("worker", "SET", "name=JIM", "WHERE", "id", "=", "1", redis.print);
client.select("*", "FROM", "worker", "WHERE", "id", "=", "1", redis.print);
client.delete("FROM", "worker", "WHERE", "id", "=", "1", redis.print);
client.scanselect("*", "FROM", "worker", redis.print);
client.desc("worker", redis.print);
client.dump("worker", function (err, res) {
    console.log("last response: " + res.toString());
    client.quit();
});