Norikra::Udf::UriParser

This is Norikra UDF.

splituri UDF return value corresponds to specified element in uri string like http://example.com/hoge.

splitquery UDF return value corresponds to target key in query string like hoge=foo.

Installation

Add this line to your application's Gemfile:

gem 'norikra-udf-uri_parser'

And then execute:

$ bundle

Or install it yourself as:

$ gem install norikra-udf-uri_parser

Usage

SELECT
  -- path is like "/hoge?foo=bar"
  splitquery(splituri(path, 'query'), 'foo') AS val
FROM access_log

This query returns below.

{
  "val":"bar"
}

splituri(expression, string)

Second argument accepts scheme,userinfo,host,port,path,opaque,query,fragment.

Example queries:

1. Using path field.

SELECT
  -- path is like "/hoge?foo=bar#top"
  splituri(path, 'scheme')   AS scheme,
  splituri(path, 'userinfo') AS userinfo,
  splituri(path, 'host')     AS host,
  splituri(path, 'port')     AS port,
  splituri(path, 'path')     AS path,
  splituri(path, 'opaque')   AS opaque,
  splituri(path, 'query')    AS query,
  splituri(path, 'fragment') AS fragment
FROM access_log

This query returns below.

{
  "port":"",
  "host":"",
  "scheme":"",
  "query":"foo=bar",
  "opaque":"",
  "path":"/hoge",
  "userinfo":"",
  "fragment":"top"
}

2. Using URL filed.

SELECT
  -- referer is like "http://example.com/hoge?foo=bar#top"
  splituri(referer, 'scheme')   AS scheme,
  splituri(referer, 'userinfo') AS userinfo,
  splituri(referer, 'host')     AS host,
  splituri(referer, 'port')     AS port,
  splituri(referer, 'path')     AS path,
  splituri(referer, 'opaque')   AS opaque,
  splituri(referer, 'query')    AS query,
  splituri(referer, 'fragment') AS fragment
FROM access_log

This query returns below.

{
  "port":"",
  "host":"example.com",
  "scheme":"http",
  "query":"foo=bar",
  "opaque":"",
  "path":"/hoge",
  "userinfo":"",
  "fragment":"top"
}

splitquery(expression, string)

Second argument is the key that you want to get the value.

Example queries:

1. key=value parameter.

SELECT
  -- query is like "foo1=bar1&foo2=bar2&foo3=bar3"
  splitquery(query, 'foo1') AS foo1,
  splitquery(query, 'foo2') AS foo2,
  splitquery(query, 'foo3') AS foo3
FROM access_log

This query returns below.

{
  "foo3":"bar3",
  "foo2":"bar2",
  "foo1":"bar1"
}

2. key[]=values parameter.

SELECT
  -- query is like "foo[]=bar1&foo[]=bar2&foo[]=bar3"
  splitquery(query, 'foo[]') AS foo
FROM access_log

This query returns below.

{
  "foo":[
    "bar1",
    "bar2",
    "bar3"
  ]
}

3. Only key parameter.

SELECT
  -- query is like "test&foo1=bar1&foo2=bar2"
  splitquery(query, 'test') AS test,
  splitquery(query, 'other') AS other
FROM access_log

This query returns below.

{
  "other":null,
  "test":""
}

TODO

Add method returns all query value as hash. (ex. splitquery("foo=bar&buzz=123") return {"foo":"bar","buzz":123})

Contributing

Fork it ( https://github.com/mia-0032/norikra-udf-uri_parser/fork )
Create your feature branch (git checkout -b my-new-feature)
Commit your changes (git commit -am 'Add some feature')
Push to the branch (git push origin my-new-feature)
Create a new Pull Request