Subbu Allamaraju s3u

A table in the tables dir

create table parse.response
    on select get from 'http://maps.googleapis.com/maps/api/geocode/json?sensor=true&address={^address}'
        using patch 'parse-response.js'

Patch in the same dir

// args.body would be an array of buffers

exports['parse response'] = function(args) {

create table foo 
    on insert post to 'uri'
          using bodyTemplate... type ...
          with part ... 

insert into foo (...) values (...)
   with part "{req.part[0]}";
update bar ...
   with part "{req.part[0]}";

insert into foo values "{req.body}";

User Defined Functions

A user-defined function is a Javascript function that can be used in where clauses and columns clauses.

UDFs in the Where Clause

When specified in the where clause, a UDF can apply custom logic to filter out or re-shape a row from a data set.

	var http = require('http'),
	EventEmitter = require('events').EventEmitter;

	var emitter = new EventEmitter();

	var server = http.createServer(function (req, res, proxy) {
	emitter.on('done', function (e) {
	if(e) {
	res.writeHead(502);
	res.end();

	a1 = [{
	"name": "Brand-A",
	"ns": "df",
	"aspectValue" : [{ "name": "Gap"},
	{"name": "Addidas"},
	{"name": "Gravati"}]
	},
	{
	"name": "Brand-B",
	"ns": "df",

	var cluster = require('cluster');
	var http = require('http');
	var numCPUs = require('os').cpus().length;
	var numReqs = 0;

	if(cluster.isMaster) {
	// Fork workers.
	for(var i = 0; i < numCPUs; i++) {
	var worker = cluster.fork();
	worker.on('message', function (msg) {

	~> siege -c 100 -t 2m http://localhost:3030
	** SIEGE 2.70
	** Preparing 100 concurrent users for battle.
	The server is now under siege...
	Lifting the server siege... done.
	Transactions: 4366377 hits
	Availability: 100.00 %
	Elapsed time: 119.26 secs
	Data transferred: 49.97 MB
	Response time: 0.00 secs

	~> siege -c 100 -t 2m http://localhost:3030
	** SIEGE 2.70
	** Preparing 100 concurrent users for battle.
	The server is now under siege...
	Lifting the server siege... done.
	Transactions: 3407277 hits
	Availability: 100.00 %
	Elapsed time: 119.73 secs
	Data transferred: 38.99 MB
	Response time: 0.00 secs

	HTTP/1.1 200 OK
	Server: nginx
	Date: Thu, 22 Mar 2012 13:28:14 GMT
	Content-Type: application/json
	Transfer-Encoding: chunked
	Connection: keep-alive
	Keep-Alive: timeout=20
	X-Powered-By: ql.io/node.js v0.6.8
	vary: accept-encoding
	Transfer-Encoding: chunked