Yuya TAMANO
null+****@clear*****
Sun Apr 19 11:40:45 JST 2015
Yuya TAMANO 2015-04-19 11:40:45 +0900 (Sun, 19 Apr 2015) New Revision: 680a231b26893d939af32674b9a750d29e08c681 https://github.com/groonga/meetup/commit/680a231b26893d939af32674b9a750d29e08c681 Message: Migrate files from groonga/groonga-document-read-ja Added files: document-read-ja/LICENSE.md document-read-ja/README.md document-read-ja/data/2014-08-25.grn document-read-ja/data/2014-10-27.grn Added: document-read-ja/LICENSE.md (+118 -0) 100755 =================================================================== --- /dev/null +++ document-read-ja/LICENSE.md 2015-04-19 11:40:45 +0900 (6be26be) @@ -0,0 +1,118 @@ +```text +CC0 1.0 Universal + +Statement of Purpose + +The laws of most jurisdictions throughout the world automatically confer +exclusive Copyright and Related Rights (defined below) upon the creator and +subsequent owner(s) (each and all, an "owner") of an original work of +authorship and/or a database (each, a "Work"). + +Certain owners wish to permanently relinquish those rights to a Work for the +purpose of contributing to a commons of creative, cultural and scientific +works ("Commons") that the public can reliably and without fear of later +claims of infringement build upon, modify, incorporate in other works, reuse +and redistribute as freely as possible in any form whatsoever and for any +purposes, including without limitation commercial purposes. These owners may +contribute to the Commons to promote the ideal of a free culture and the +further production of creative, cultural and scientific works, or to gain +reputation or greater distribution for their Work in part through the use and +efforts of others. + +For these and/or other purposes and motivations, and without any expectation +of additional consideration or compensation, the person associating CC0 with a +Work (the "Affirmer"), to the extent that he or she is an owner of Copyright +and Related Rights in the Work, voluntarily elects to apply CC0 to the Work +and publicly distribute the Work under its terms, with knowledge of his or her +Copyright and Related Rights in the Work and the meaning and intended legal +effect of CC0 on those rights. + +1. Copyright and Related Rights. A Work made available under CC0 may be +protected by copyright and related or neighboring rights ("Copyright and +Related Rights"). Copyright and Related Rights include, but are not limited +to, the following: + + i. the right to reproduce, adapt, distribute, perform, display, communicate, + and translate a Work; + + ii. moral rights retained by the original author(s) and/or performer(s); + + iii. publicity and privacy rights pertaining to a person's image or likeness + depicted in a Work; + + iv. rights protecting against unfair competition in regards to a Work, + subject to the limitations in paragraph 4(a), below; + + v. rights protecting the extraction, dissemination, use and reuse of data in + a Work; + + vi. database rights (such as those arising under Directive 96/9/EC of the + European Parliament and of the Council of 11 March 1996 on the legal + protection of databases, and under any national implementation thereof, + including any amended or successor version of such directive); and + + vii. other similar, equivalent or corresponding rights throughout the world + based on applicable law or treaty, and any national implementations thereof. + +2. Waiver. To the greatest extent permitted by, but not in contravention of, +applicable law, Affirmer hereby overtly, fully, permanently, irrevocably and +unconditionally waives, abandons, and surrenders all of Affirmer's Copyright +and Related Rights and associated claims and causes of action, whether now +known or unknown (including existing as well as future claims and causes of +action), in the Work (i) in all territories worldwide, (ii) for the maximum +duration provided by applicable law or treaty (including future time +extensions), (iii) in any current or future medium and for any number of +copies, and (iv) for any purpose whatsoever, including without limitation +commercial, advertising or promotional purposes (the "Waiver"). Affirmer makes +the Waiver for the benefit of each member of the public at large and to the +detriment of Affirmer's heirs and successors, fully intending that such Waiver +shall not be subject to revocation, rescission, cancellation, termination, or +any other legal or equitable action to disrupt the quiet enjoyment of the Work +by the public as contemplated by Affirmer's express Statement of Purpose. + +3. Public License Fallback. Should any part of the Waiver for any reason be +judged legally invalid or ineffective under applicable law, then the Waiver +shall be preserved to the maximum extent permitted taking into account +Affirmer's express Statement of Purpose. In addition, to the extent the Waiver +is so judged Affirmer hereby grants to each affected person a royalty-free, +non transferable, non sublicensable, non exclusive, irrevocable and +unconditional license to exercise Affirmer's Copyright and Related Rights in +the Work (i) in all territories worldwide, (ii) for the maximum duration +provided by applicable law or treaty (including future time extensions), (iii) +in any current or future medium and for any number of copies, and (iv) for any +purpose whatsoever, including without limitation commercial, advertising or +promotional purposes (the "License"). The License shall be deemed effective as +of the date CC0 was applied by Affirmer to the Work. Should any part of the +License for any reason be judged legally invalid or ineffective under +applicable law, such partial invalidity or ineffectiveness shall not +invalidate the remainder of the License, and in such case Affirmer hereby +affirms that he or she will not (i) exercise any of his or her remaining +Copyright and Related Rights in the Work or (ii) assert any associated claims +and causes of action with respect to the Work, in either case contrary to +Affirmer's express Statement of Purpose. + +4. Limitations and Disclaimers. + + a. No trademark or patent rights held by Affirmer are waived, abandoned, + surrendered, licensed or otherwise affected by this document. + + b. Affirmer offers the Work as-is and makes no representations or warranties + of any kind concerning the Work, express, implied, statutory or otherwise, + including without limitation warranties of title, merchantability, fitness + for a particular purpose, non infringement, or the absence of latent or + other defects, accuracy, or the present or absence of errors, whether or not + discoverable, all to the greatest extent permissible under applicable law. + + c. Affirmer disclaims responsibility for clearing rights of other persons + that may apply to the Work or any use thereof, including without limitation + any person's Copyright and Related Rights in the Work. Further, Affirmer + disclaims responsibility for obtaining any necessary consents, permissions + or other rights required for any use of the Work. + + d. Affirmer understands and acknowledges that Creative Commons is not a + party to this document and has no duty or obligation with respect to this + CC0 or use of the Work. + +For more information, please see +<http://creativecommons.org/publicdomain/zero/1.0/> +``` Added: document-read-ja/README.md (+22 -0) 100755 =================================================================== --- /dev/null +++ document-read-ja/README.md 2015-04-19 11:40:45 +0900 (486625d) @@ -0,0 +1,22 @@ +# Groongaドキュメント読書会 + +「Groongaドキュメント読書会」とは[Groongaのドキュメント](http://groonga.org/ja/docs/)を先頭から順に読んでGroongaについて理解していくイベントです。このリポジトリーはそのイベントで使うデータや情報を共有するためのリポジトリーです。 + +## 現在共有している情報 + + * 次はどこから読むか + * [4.7.2. インデックス名を指定した全文検索](http://groonga.org/ja/docs/tutorial/match_columns.html#full-text-search-with-specific-index-name) + * 次回、再開するためにデータベースに読み込むデータ + * [data/2014-10-27.grn](data/2014-10-27.grn) + +## ライセンス + +このリポジトリーにあるデータや情報のライセンスは[CC0 1.0 Universal](http://creativecommons.org/publicdomain/zero/1.0/deed.ja)（いわゆるパブリックドメイン）とします。つまり、だれでもこのリポジトリーにある情報を利用したり、コピーしたり、変更したり、再配布したりといったことができます。詳細はライセンス文を確認してください。 + +## 過去のGroongaドキュメント読書会 + + * [Groongaドキュメント読書会5](http://groonga.doorkeeper.jp/events/16395) - 2014-10-27（月） 19:30-21:30 + * [Groongaドキュメント読書会4](http://groonga.doorkeeper.jp/events/14275) - 2014-08-25（月） 19:30-21:30 + * [Groongaドキュメント読書会3](http://groonga.doorkeeper.jp/events/13039) - 2014-07-23（水） 20:00-22:00 + * [Groongaドキュメント読書会2](http://groonga.doorkeeper.jp/events/11834) - 2014-06-03（火） 20:00-22:00 + * [Groongaドキュメント読書会1](http://groonga.doorkeeper.jp/events/11169) - 2014-05-15（木） 20:00-22:00 Added: document-read-ja/data/2014-08-25.grn (+134 -0) 100755 =================================================================== --- /dev/null +++ document-read-ja/data/2014-08-25.grn 2015-04-19 11:40:45 +0900 (5609e59) @@ -0,0 +1,134 @@ +# 4.1でのスキーマ定義とデータ + +table_create --name Site --flags TABLE_HASH_KEY --key_type ShortText + +column_create --table Site --name title --type ShortText + +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."} +] + +table_create --name Terms --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram + +column_create --table Terms --name blog_title --flags COLUMN_INDEX|WITH_POSITION --type Site --source title + +# 4.3でのスキーマ定義とデータ + +table_create --name ToyBox --flags TABLE_HASH_KEY --key_type ShortText + +column_create --table ToyBox --name is_animal --type Bool + +load --table ToyBox +[ +{"_key":"Monkey","is_animal":true}, +{"_key":"Flower","is_animal":false} +{"_key":"Block"} +] + +column_create --table ToyBox --name price --type Int8 + +column_create --table ToyBox --name weight --type Float + +load --table ToyBox +[ +{"_key":"Monkey","price":15.9}, +{"_key":"Flower","price":200,"weight":0.13}, +{"_key":"Block","weight":25.7} +] + +column_create --table ToyBox --name name --type ShortText + +load --table ToyBox +[ +{"_key":"Monkey","name":"Grease"}, +{"_key":"Flower","name":"Rose"} +] + +column_create --table ToyBox --name time --type Time + +load --table ToyBox +[ +{"_key":"Flower","time":1234567890.1234569999}, +{"_key":"Block","time":-1234567890} +] + +column_create --table ToyBox --name location --type WGS84GeoPoint + +load --table ToyBox +[ +{"_key":"Monkey","location":"128452975x503157902"}, +{"_key":"Block","location":"35.6813819x139.7660839"} +] + +column_create --table Site --name link --type Site + +load --table Site +[ +{"_key":"http://example.org/","link":"http://example.net/"} +] + +column_create --table Site --name links --flags COLUMN_VECTOR --type Site + +load --table Site +[ +{"_key":"http://example.org/","links":["http://example.net/","http://example.org/","http://example.com/"]} +] + +# 4.4でのスキーマ定義とデータ + +column_create --table Site --name location --type WGS84GeoPoint + +load --table Site +[ + {"_key":"http://example.org/","location":"128452975x503157902"} + {"_key":"http://example.net/","location":"128487316x502920929"}, +] + +# 4.5でのスキーマ定義とデータ + +table_create --name SiteDomain --flags TABLE_HASH_KEY --key_type ShortText +table_create --name SiteCountry --flags TABLE_HASH_KEY --key_type ShortText +column_create --table Site --name domain --flags COLUMN_SCALAR --type SiteDomain +column_create --table Site --name country --flags COLUMN_SCALAR --type SiteCountry + +load --table Site +[ +{"_key":"http://example.org/","domain":".org","country":"japan"}, +{"_key":"http://example.net/","domain":".net","country":"brazil"}, +{"_key":"http://example.com/","domain":".com","country":"japan"}, +{"_key":"http://example.net/afr","domain":".net","country":"usa"}, +{"_key":"http://example.org/aba","domain":".org","country":"korea"}, +{"_key":"http://example.com/rab","domain":".com","country":"china"}, +{"_key":"http://example.net/atv","domain":".net","country":"china"}, +{"_key":"http://example.org/gat","domain":".org","country":"usa"}, +{"_key":"http://example.com/vdw","domain":".com","country":"japan"} +] + +# 4.6.1までのスキーマ定義とデータ + +table_create --name Video --flags TABLE_HASH_KEY --key_type UInt32 +table_create --name Tag --flags TABLE_HASH_KEY --key_type ShortText +column_create --table Video --name title --flags COLUMN_SCALAR --type ShortText +column_create --table Video --name tags --flags COLUMN_VECTOR --type Tag +column_create --table Tag --name index_tags --flags COLUMN_INDEX --type Video --source tags + +load --table Video +[ +{"_key":1,"title":"Soccer 2010","tags":["Sports","Soccer"]}, +{"_key":2,"title":"Zenigata Kinjirou","tags":["Variety","Money"]}, +{"_key":3,"title":"groonga Demo","tags":["IT","Server","groonga"]}, +{"_key":4,"title":"Moero!! Ultra Baseball","tags":["Sports","Baseball"]}, +{"_key":5,"title":"Hex Gone!","tags":["Variety","Quiz"]}, +{"_key":6,"title":"Pikonyan 1","tags":["Animation","Pikonyan"]}, +{"_key":7,"title":"Draw 8 Month","tags":["Animation","Raccoon"]}, +{"_key":8,"title":"K.O.","tags":["Animation","Music"]} +] Added: document-read-ja/data/2014-10-27.grn (+210 -0) 100755 =================================================================== --- /dev/null +++ document-read-ja/data/2014-10-27.grn 2015-04-19 11:40:45 +0900 (41ebd3f) @@ -0,0 +1,210 @@ +# 4.1. 基本的な操作 +# 4.1.5. テーブルの作成 + +table_create --name Site --flags TABLE_HASH_KEY --key_type ShortText + +# 4.1.7. カラムの作成 + +column_create --table Site --name title --flags COLUMN_SCALAR --type ShortText + +# 4.1.8. データのロード + +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."} +] + +# 4.1.10. 全文検索用の語彙表の作成 + +table_create --name Terms --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram + +column_create --table Terms --name blog_title --flags COLUMN_INDEX|WITH_POSITION --type Site --source title + +# 4.3. いろいろなデータの保存 + +table_create --name ToyBox --flags TABLE_HASH_KEY --key_type ShortText + +# 4.3.2. 真偽値 + +column_create --table ToyBox --name is_animal --flags COLUMN_SCALAR --type Bool + +load --table ToyBox +[ +{"_key":"Monkey","is_animal":true}, +{"_key":"Flower","is_animal":false} +{"_key":"Block"} +] + +# 4.3.3. 数値 + +column_create --table ToyBox --name price --flags COLUMN_SCALAR --type Int8 + +column_create --table ToyBox --name weight --flags COLUMN_SCALAR --type Float + +load --table ToyBox +[ +{"_key":"Monkey","price":15.9}, +{"_key":"Flower","price":200,"weight":0.13}, +{"_key":"Block","weight":25.7} +] + +# 4.3.4. 文字列 + +column_create --table ToyBox --name name --flags COLUMN_SCALAR --type ShortText + +load --table ToyBox +[ +{"_key":"Monkey","name":"Grease"}, +{"_key":"Flower","name":"Rose"} +] + +# 4.3.5. 日時 + +column_create --table ToyBox --name time --flags COLUMN_SCALAR --type Time + +load --table ToyBox +[ +{"_key":"Flower","time":1234567890.1234569999}, +{"_key":"Block","time":-1234567890} +] + +# 4.3.6. 経緯度 + +column_create --table ToyBox --name location --flags COLUMN_SCALAR --type WGS84GeoPoint + +load --table ToyBox +[ +{"_key":"Monkey","location":"128452975x503157902"}, +{"_key":"Block","location":"35.6813819x139.7660839"} +] + +# 4.3.7. テーブル参照 + +column_create --table Site --name link --flags COLUMN_SCALAR --type Site + +load --table Site +[ +{"_key":"http://example.org/","link":"http://example.net/"} +] + +# 4.3.8. ベクターカラム + +column_create --table Site --name links --flags COLUMN_VECTOR --type Site + +load --table Site +[ +{"_key":"http://example.org/","links":["http://example.net/","http://example.org/","http://example.com/"]} +] + +# 4.4. さまざまな検索条件 +# 4.4.3. 位置情報を用いた絞込・ソート + +column_create --table Site --name location --flags COLUMN_SCALAR --type WGS84GeoPoint + +load --table Site +[ +{"_key":"http://example.org/","location":"128452975x503157902"}, +{"_key":"http://example.net/","location":"128487316x502920929"} +] + +# 4.5. ドリルダウン + +table_create --name SiteDomain --flags TABLE_HASH_KEY --key_type ShortText +table_create --name SiteCountry --flags TABLE_HASH_KEY --key_type ShortText + +column_create --table Site --name domain --flags COLUMN_SCALAR --type SiteDomain +column_create --table Site --name country --flags COLUMN_SCALAR --type SiteCountry + +load --table Site +[ +{"_key":"http://example.org/","domain":".org","country":"japan"}, +{"_key":"http://example.net/","domain":".net","country":"brazil"}, +{"_key":"http://example.com/","domain":".com","country":"japan"}, +{"_key":"http://example.net/afr","domain":".net","country":"usa"}, +{"_key":"http://example.org/aba","domain":".org","country":"korea"}, +{"_key":"http://example.com/rab","domain":".com","country":"china"}, +{"_key":"http://example.net/atv","domain":".net","country":"china"}, +{"_key":"http://example.org/gat","domain":".org","country":"usa"}, +{"_key":"http://example.com/vdw","domain":".com","country":"japan"} +] + +# 4.6. タグ検索・参照関係の逆引き +# 4.6.1. タグ検索 + +table_create --name Video --flags TABLE_HASH_KEY --key_type UInt32 +table_create --name Tag --flags TABLE_HASH_KEY --key_type ShortText + +column_create --table Video --name title --flags COLUMN_SCALAR --type ShortText +column_create --table Video --name tags --flags COLUMN_VECTOR --type Tag +column_create --table Tag --name index_tags --flags COLUMN_INDEX --type Video --source tags + +load --table Video +[ +{"_key":1,"title":"Soccer 2010","tags":["Sports","Soccer"]}, +{"_key":2,"title":"Zenigata Kinjirou","tags":["Variety","Money"]}, +{"_key":3,"title":"groonga Demo","tags":["IT","Server","groonga"]}, +{"_key":4,"title":"Moero!! Ultra Baseball","tags":["Sports","Baseball"]}, +{"_key":5,"title":"Hex Gone!","tags":["Variety","Quiz"]}, +{"_key":6,"title":"Pikonyan 1","tags":["Animation","Pikonyan"]}, +{"_key":7,"title":"Draw 8 Month","tags":["Animation","Raccoon"]}, +{"_key":8,"title":"K.O.","tags":["Animation","Music"]} +] + +# 4.6.2. 参照関係の逆引き + +table_create --name User --flags TABLE_HASH_KEY --key_type ShortText + +column_create --table User --name username --flags COLUMN_SCALAR --type ShortText +column_create --table User --name friends --flags COLUMN_VECTOR --type User +column_create --table User --name index_friends --flags COLUMN_INDEX --type User --source friends + +load --table User +[ +{"_key":"ken","username":"健作","friends":["taro","jiro","tomo","moritapo"]}, +{"_key":"moritapo","username":"森田","friends":["ken","tomo"]}, +{"_key":"taro","username":"ぐるんが太郎","friends":["jiro","tomo"]}, +{"_key":"jiro","username":"ぐるんが次郎","friends":["taro","tomo"]}, +{"_key":"tomo","username":"トモちゃん","friends":["ken","hana"]}, +{"_key":"hana","username":"花子","friends":["ken","taro","jiro","moritapo","tomo"]} +] + +# 4.6.3. インデックス付きジオサーチ + +table_create --name GeoIndex --flags TABLE_PAT_KEY --key_type WGS84GeoPoint + +column_create --table GeoIndex --name index_point --type Site --flags COLUMN_INDEX --source location + +load --table Site +[ + {"_key":"http://example.org/","location":"128452975x503157902"}, + {"_key":"http://example.net/","location":"128487316x502920929"} +] + +# 4.7. match_columnsパラメータ +# 4.7.1.1. カラムごとにインデックスを付与する場合 + +table_create --name Blog1 --flags TABLE_HASH_KEY --key_type ShortText + +column_create --table Blog1 --name title --flags COLUMN_SCALAR --type ShortText +column_create --table Blog1 --name message --flags COLUMN_SCALAR --type ShortText + +table_create --name IndexBlog1 --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram + +column_create --table IndexBlog1 --name index_title --flags COLUMN_INDEX|WITH_POSITION --type Blog1 --source title +column_create --table IndexBlog1 --name index_message --flags COLUMN_INDEX|WITH_POSITION --type Blog1 --source message + +load --table Blog1 +[ +{"_key":"grn1","title":"groonga test","message":"groonga message"}, +{"_key":"grn2","title":"baseball result","message":"rakutan eggs 4 - 4 groonga moritars"}, +{"_key":"grn3","title":"groonga message","message":"none"} +] + -------------- next part -------------- HTML����������������������������...Download