null+****@clear*****
null+****@clear*****
2012年 6月 12日 (火) 21:36:47 JST
Kouhei Sutou 2012-06-12 21:36:47 +0900 (Tue, 12 Jun 2012)
New Revision: b9c2bd72bc92181c9365627cc9c81965600b4948
Log:
doc: add examples for query syntax
Added files:
doc/source/example/spec/query_syntax/setup.log
doc/source/example/spec/query_syntax/simple_equal.log
doc/source/example/spec/query_syntax/simple_full_text_search.log
doc/source/example/spec/query_syntax/simple_full_text_search_with_explicit_match_column.log
doc/source/example/spec/query_syntax/simple_greater_than.log
doc/source/example/spec/query_syntax/simple_greater_than_or_equal_to.log
doc/source/example/spec/query_syntax/simple_less_than.log
doc/source/example/spec/query_syntax/simple_less_than_or_equal_to.log
doc/source/example/spec/query_syntax/simple_not_equal.log
doc/source/example/spec/query_syntax/simple_phrase_search.log
doc/source/example/spec/query_syntax/simple_phrase_search_with_explicit_match_column.log
Added: doc/source/example/spec/query_syntax/setup.log (+33 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/spec/query_syntax/setup.log 2012-06-12 21:36:47 +0900 (d0d4b7c)
@@ -0,0 +1,33 @@
+Execution example::
+
+ table_create Entries TABLE_HASH_KEY ShortText
+ column_create Entries content COLUMN_SCALAR Text
+ # [[0, 1337566253.89858, 0.000355720520019531], true]
+ # [[0, 1337566253.89858, 0.000355720520019531], true]
+ column_create Entries n_likes COLUMN_SCALAR UInt32
+ # [[0, 1337566253.89858, 0.000355720520019531], true]
+ table_create Terms TABLE_PAT_KEY|KEY_NORMALIZE ShortText --default_tokenizer TokenBigram
+ # [[0, 1337566253.89858, 0.000355720520019531], true]
+ column_create Terms entries_key_index COLUMN_INDEX|WITH_POSITION Entries _key
+ # [[0, 1337566253.89858, 0.000355720520019531], true]
+ column_create Terms entries_content_index COLUMN_INDEX|WITH_POSITION Entries content
+ # [[0, 1337566253.89858, 0.000355720520019531], true]
+ load --table Entries
+ [
+ {"_key": "The first post!",
+ "content": "Welcome! This is my first post!",
+ "n_likes": 5},
+ {"_key": "Groonga",
+ "content": "I started to use groonga. It's very fast!",
+ "n_likes": 10},
+ {"_key": "Mroonga",
+ "content": "I also started to use mroonga. It's also very fast! Really fast!",
+ "n_likes": 15},
+ {"_key": "Good-bye Senna",
+ "content": "I migrated all Senna system!",
+ "n_likes": 3},
+ {"_key": "Good-bye Tritonn",
+ "content": "I also migrated all Tritonn system!",
+ "n_likes": 3}
+ ]
+ # [[0, 1337566253.89858, 0.000355720520019531], 5]
Added: doc/source/example/spec/query_syntax/simple_equal.log (+41 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/spec/query_syntax/simple_equal.log 2012-06-12 21:36:47 +0900 (0921a77)
@@ -0,0 +1,41 @@
+Execution example::
+
+ select Entries --query _key:Groonga
+ # [
+ # [
+ # 0,
+ # 1337566253.89858,
+ # 0.000355720520019531
+ # ],
+ # [
+ # [
+ # [
+ # 1
+ # ],
+ # [
+ # [
+ # "_id",
+ # "UInt32"
+ # ],
+ # [
+ # "_key",
+ # "ShortText"
+ # ],
+ # [
+ # "content",
+ # "Text"
+ # ],
+ # [
+ # "n_likes",
+ # "UInt32"
+ # ]
+ # ],
+ # [
+ # 2,
+ # "Groonga",
+ # "I started to use groonga. It's very fast!",
+ # 10
+ # ]
+ # ]
+ # ]
+ # ]
Added: doc/source/example/spec/query_syntax/simple_full_text_search.log (+47 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/spec/query_syntax/simple_full_text_search.log 2012-06-12 21:36:47 +0900 (53c3b80)
@@ -0,0 +1,47 @@
+Execution example::
+
+ select Entries --match_columns content --query fast
+ # [
+ # [
+ # 0,
+ # 1337566253.89858,
+ # 0.000355720520019531
+ # ],
+ # [
+ # [
+ # [
+ # 2
+ # ],
+ # [
+ # [
+ # "_id",
+ # "UInt32"
+ # ],
+ # [
+ # "_key",
+ # "ShortText"
+ # ],
+ # [
+ # "content",
+ # "Text"
+ # ],
+ # [
+ # "n_likes",
+ # "UInt32"
+ # ]
+ # ],
+ # [
+ # 2,
+ # "Groonga",
+ # "I started to use groonga. It's very fast!",
+ # 10
+ # ],
+ # [
+ # 3,
+ # "Mroonga",
+ # "I also started to use mroonga. It's also very fast! Really fast!",
+ # 15
+ # ]
+ # ]
+ # ]
+ # ]
Added: doc/source/example/spec/query_syntax/simple_full_text_search_with_explicit_match_column.log (+47 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/spec/query_syntax/simple_full_text_search_with_explicit_match_column.log 2012-06-12 21:36:47 +0900 (a1df267)
@@ -0,0 +1,47 @@
+Execution example::
+
+ select Entries --query content:@fast
+ # [
+ # [
+ # 0,
+ # 1337566253.89858,
+ # 0.000355720520019531
+ # ],
+ # [
+ # [
+ # [
+ # 2
+ # ],
+ # [
+ # [
+ # "_id",
+ # "UInt32"
+ # ],
+ # [
+ # "_key",
+ # "ShortText"
+ # ],
+ # [
+ # "content",
+ # "Text"
+ # ],
+ # [
+ # "n_likes",
+ # "UInt32"
+ # ]
+ # ],
+ # [
+ # 2,
+ # "Groonga",
+ # "I started to use groonga. It's very fast!",
+ # 10
+ # ],
+ # [
+ # 3,
+ # "Mroonga",
+ # "I also started to use mroonga. It's also very fast! Really fast!",
+ # 15
+ # ]
+ # ]
+ # ]
+ # ]
Added: doc/source/example/spec/query_syntax/simple_greater_than.log (+41 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/spec/query_syntax/simple_greater_than.log 2012-06-12 21:36:47 +0900 (11350fa)
@@ -0,0 +1,41 @@
+Execution example::
+
+ select Entries --query n_likes:>10
+ # [
+ # [
+ # 0,
+ # 1337566253.89858,
+ # 0.000355720520019531
+ # ],
+ # [
+ # [
+ # [
+ # 1
+ # ],
+ # [
+ # [
+ # "_id",
+ # "UInt32"
+ # ],
+ # [
+ # "_key",
+ # "ShortText"
+ # ],
+ # [
+ # "content",
+ # "Text"
+ # ],
+ # [
+ # "n_likes",
+ # "UInt32"
+ # ]
+ # ],
+ # [
+ # 3,
+ # "Mroonga",
+ # "I also started to use mroonga. It's also very fast! Really fast!",
+ # 15
+ # ]
+ # ]
+ # ]
+ # ]
Added: doc/source/example/spec/query_syntax/simple_greater_than_or_equal_to.log (+47 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/spec/query_syntax/simple_greater_than_or_equal_to.log 2012-06-12 21:36:47 +0900 (86edfdb)
@@ -0,0 +1,47 @@
+Execution example::
+
+ select Entries --query n_likes:>=10
+ # [
+ # [
+ # 0,
+ # 1337566253.89858,
+ # 0.000355720520019531
+ # ],
+ # [
+ # [
+ # [
+ # 2
+ # ],
+ # [
+ # [
+ # "_id",
+ # "UInt32"
+ # ],
+ # [
+ # "_key",
+ # "ShortText"
+ # ],
+ # [
+ # "content",
+ # "Text"
+ # ],
+ # [
+ # "n_likes",
+ # "UInt32"
+ # ]
+ # ],
+ # [
+ # 2,
+ # "Groonga",
+ # "I started to use groonga. It's very fast!",
+ # 10
+ # ],
+ # [
+ # 3,
+ # "Mroonga",
+ # "I also started to use mroonga. It's also very fast! Really fast!",
+ # 15
+ # ]
+ # ]
+ # ]
+ # ]
Added: doc/source/example/spec/query_syntax/simple_less_than.log (+53 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/spec/query_syntax/simple_less_than.log 2012-06-12 21:36:47 +0900 (90992f86)
@@ -0,0 +1,53 @@
+Execution example::
+
+ select Entries --query n_likes:<10
+ # [
+ # [
+ # 0,
+ # 1337566253.89858,
+ # 0.000355720520019531
+ # ],
+ # [
+ # [
+ # [
+ # 3
+ # ],
+ # [
+ # [
+ # "_id",
+ # "UInt32"
+ # ],
+ # [
+ # "_key",
+ # "ShortText"
+ # ],
+ # [
+ # "content",
+ # "Text"
+ # ],
+ # [
+ # "n_likes",
+ # "UInt32"
+ # ]
+ # ],
+ # [
+ # 1,
+ # "The first post!",
+ # "Welcome! This is my first post!",
+ # 5
+ # ],
+ # [
+ # 4,
+ # "Good-bye Senna",
+ # "I migrated all Senna system!",
+ # 3
+ # ],
+ # [
+ # 5,
+ # "Good-bye Tritonn",
+ # "I also migrated all Tritonn system!",
+ # 3
+ # ]
+ # ]
+ # ]
+ # ]
Added: doc/source/example/spec/query_syntax/simple_less_than_or_equal_to.log (+59 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/spec/query_syntax/simple_less_than_or_equal_to.log 2012-06-12 21:36:47 +0900 (017d566)
@@ -0,0 +1,59 @@
+Execution example::
+
+ select Entries --query n_likes:<=10
+ # [
+ # [
+ # 0,
+ # 1337566253.89858,
+ # 0.000355720520019531
+ # ],
+ # [
+ # [
+ # [
+ # 4
+ # ],
+ # [
+ # [
+ # "_id",
+ # "UInt32"
+ # ],
+ # [
+ # "_key",
+ # "ShortText"
+ # ],
+ # [
+ # "content",
+ # "Text"
+ # ],
+ # [
+ # "n_likes",
+ # "UInt32"
+ # ]
+ # ],
+ # [
+ # 1,
+ # "The first post!",
+ # "Welcome! This is my first post!",
+ # 5
+ # ],
+ # [
+ # 2,
+ # "Groonga",
+ # "I started to use groonga. It's very fast!",
+ # 10
+ # ],
+ # [
+ # 4,
+ # "Good-bye Senna",
+ # "I migrated all Senna system!",
+ # 3
+ # ],
+ # [
+ # 5,
+ # "Good-bye Tritonn",
+ # "I also migrated all Tritonn system!",
+ # 3
+ # ]
+ # ]
+ # ]
+ # ]
Added: doc/source/example/spec/query_syntax/simple_not_equal.log (+59 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/spec/query_syntax/simple_not_equal.log 2012-06-12 21:36:47 +0900 (5370a54)
@@ -0,0 +1,59 @@
+Execution example::
+
+ select Entries --query _key:!Groonga
+ # [
+ # [
+ # 0,
+ # 1337566253.89858,
+ # 0.000355720520019531
+ # ],
+ # [
+ # [
+ # [
+ # 4
+ # ],
+ # [
+ # [
+ # "_id",
+ # "UInt32"
+ # ],
+ # [
+ # "_key",
+ # "ShortText"
+ # ],
+ # [
+ # "content",
+ # "Text"
+ # ],
+ # [
+ # "n_likes",
+ # "UInt32"
+ # ]
+ # ],
+ # [
+ # 1,
+ # "The first post!",
+ # "Welcome! This is my first post!",
+ # 5
+ # ],
+ # [
+ # 3,
+ # "Mroonga",
+ # "I also started to use mroonga. It's also very fast! Really fast!",
+ # 15
+ # ],
+ # [
+ # 4,
+ # "Good-bye Senna",
+ # "I migrated all Senna system!",
+ # 3
+ # ],
+ # [
+ # 5,
+ # "Good-bye Tritonn",
+ # "I also migrated all Tritonn system!",
+ # 3
+ # ]
+ # ]
+ # ]
+ # ]
Added: doc/source/example/spec/query_syntax/simple_phrase_search.log (+41 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/spec/query_syntax/simple_phrase_search.log 2012-06-12 21:36:47 +0900 (a05fcad)
@@ -0,0 +1,41 @@
+Execution example::
+
+ select Entries --match_columns content --query '"I started"'
+ # [
+ # [
+ # 0,
+ # 1337566253.89858,
+ # 0.000355720520019531
+ # ],
+ # [
+ # [
+ # [
+ # 1
+ # ],
+ # [
+ # [
+ # "_id",
+ # "UInt32"
+ # ],
+ # [
+ # "_key",
+ # "ShortText"
+ # ],
+ # [
+ # "content",
+ # "Text"
+ # ],
+ # [
+ # "n_likes",
+ # "UInt32"
+ # ]
+ # ],
+ # [
+ # 2,
+ # "Groonga",
+ # "I started to use groonga. It's very fast!",
+ # 10
+ # ]
+ # ]
+ # ]
+ # ]
Added: doc/source/example/spec/query_syntax/simple_phrase_search_with_explicit_match_column.log (+41 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/spec/query_syntax/simple_phrase_search_with_explicit_match_column.log 2012-06-12 21:36:47 +0900 (5fa796f)
@@ -0,0 +1,41 @@
+Execution example::
+
+ select Entries --query 'content:@"I started"'
+ # [
+ # [
+ # 0,
+ # 1337566253.89858,
+ # 0.000355720520019531
+ # ],
+ # [
+ # [
+ # [
+ # 1
+ # ],
+ # [
+ # [
+ # "_id",
+ # "UInt32"
+ # ],
+ # [
+ # "_key",
+ # "ShortText"
+ # ],
+ # [
+ # "content",
+ # "Text"
+ # ],
+ # [
+ # "n_likes",
+ # "UInt32"
+ # ]
+ # ],
+ # [
+ # 2,
+ # "Groonga",
+ # "I started to use groonga. It's very fast!",
+ # 10
+ # ]
+ # ]
+ # ]
+ # ]