Skip to content

Instantly share code, notes, and snippets.

@smeghead
Created March 11, 2011 02:14
Show Gist options
  • Save smeghead/865347 to your computer and use it in GitHub Desktop.
Save smeghead/865347 to your computer and use it in GitHub Desktop.
checking groonga filter.
% groonga -n tutorial.db
> status
[[0,1299809390.33857,0.000201772],{"alloc_count":141,"starttime":1299809383,"uptime":7,"version":"1.0.8","n_queries":0,"cache_hit_rate":0.0,"command_version":1,"default_command_version":1,"max_command_version":2}]
> table_create --name Site --flags TABLE_HASH_KEY --key_type ShortText
[[0,1299809412.44953,0.035176607],true]
> column_create --table Site --name title --flags COLUMN_SCALAR --type ShortText
[[0,1299809426.68955,0.03979605],true]
> table_create --name Terms --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram
[[0,1299809437.91029,0.026471031],true]
> column_create --table Terms --name blog_title --flags COLUMN_INDEX|WITH_POSITION --type Site --source title
[[0,1299809450.90833,0.098852366],true]
> load --table Site
> [
{"_key":"http://example.org/","title":"This is test record 1!"},
{"_key":"http://example.net/","title":"test record 2."},
{"_key":"http://example.com/","title":"test test record three."},
{"_key":"http://example.net/afr","title":"test record four."},
{"_key":"http://example.org/aba","title":"test test test record five."},
{"_key":"http://example.com/rab","title":"test test test test record six."},
{"_key":"http://example.net/atv","title":"test test test record seven."},
{"_key":"http://example.org/gat","title":"test test record eight."},
{"_key":"http://example.com/vdw","title":"test test record nine."},
]
> > > > > > > > > > [[0,1299809483.9183,1.847447931],9]
> select --table Site --filter "_id > 5"
[[0,1299809540.60952,0.023556556],[[[4],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[6,"http://example.com/rab","test test test test record six."],[7,"http://example.net/atv","test test test record seven."],[8,"http://example.org/gat","test test record eight."],[9,"http://example.com/vdw","test test record nine."]]]]
>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment