.. -*- rst -*- .. highlightlang:: none .. groonga-command .. database: tutorial-patricia-trie ãããªã·ã¢æ¨ã«ããåæ¹ä¸è´æ¤ç´¢ ============================== groongaã®ãã¼ãã«ã¯ããã¼ãã«ä½ææã«ãããªã·ã¢æ¨ãªãã·ã§ã³ãæå®ããã¨ãåæ¹ä¸è´æ¤ç´¢ãè¡ããã¨ãã§ãã¾ããã¾ãã追å ã®ãªãã·ã§ã³ãæå®ãããã¨ã«ããã主ãã¼ã®å¾æ¹ä¸è´æ¤ç´¢ããè¡ããã¨ãã§ãã¾ãã 主ãã¼ã«ããåæ¹ä¸è´æ¤ç´¢ ------------------------ table_createã³ãã³ãã®flagsãªãã·ã§ã³ã«TABLE_PAT_KEYãæå®ãããã¨ã§ã主ãã¼ã«ããåæ¹ä¸è´æ¤ç´¢ãã§ããããã«ãªãã¾ãã .. groonga-command .. include:: ../example/tutorial/patricia_trie-1.log .. .. table_create --name PatPrefix --flags TABLE_PAT_KEY --key_type ShortText .. load --table PatPrefix .. [ .. {"_key":"ã²ããã"}, .. {"_key":"ã¾ããã"}, .. {"_key":"ã²ããã"}, .. {"_key":"ããã²ã"} .. ] .. select --table PatPrefix --query _key:^ã²ã 主ãã¼ã«ããå¾æ¹ä¸è´æ¤ç´¢ ------------------------ table_createã³ãã³ãã®flagsãªãã·ã§ã³ã«TABLE_PAT_KEYã¨KEY_WITH_SISãæå®ãããã¨ã§ã主ãã¼ã«ããåæ¹ä¸è´æ¤ç´¢ã»å¾æ¹ä¸è´æ¤ç´¢ã®ä¸¡æ¹ãå¯è½ã¨ãªãã¾ãã KEY_WITH_SISãã©ã°ãä»ä¸ããã¨ããã¼ã¿ã追å ããéã«å¾æ¹ä¸è´ç¨ã®ã¬ã³ã¼ãã追å ããã¦ãã¾ãã¾ãããã®ãããåç´ã«æ¤ç´¢ããã¨ãå ã®ã¬ã³ã¼ãã«å ãã¦èªåçã«è¿½å ãããã¬ã³ã¼ãã¾ã§ããããã¦ãã¾ãã¾ããå ã®ã¬ã³ã¼ãã®ã¿æ¤ç´¢ããããã«ãä¸å·¥å¤«å¿ è¦ã«ãªãã¾ãã ä¾ãã°ãå ã®ã¬ã³ã¼ãã¨èªåçã«è¿½å ãããã¬ã³ã¼ãã¨ã®åºå¥ãã¤ããããã«ãå ã®ã¬ã³ã¼ãã§ãããã¨ã示ãoriginalã«ã©ã ã追å ãã¦ãæ¤ç´¢æã«ã¯originalã«ã©ã ã ``true`` ãæ¤ç´¢æ¡ä»¶ã«å ãã¾ãã ``--query`` ãªãã·ã§ã³ã§ã¯ ``Bool`` åã®å¤ãç´æçã«æå®ãããã¨ãã§ããªãã®ã§ ``--filter`` ãªãã·ã§ã³ã使ã£ã¦ãããã¨ã«æ³¨æãã¦ãã ããã .. groonga-command .. include:: ../example/tutorial/patricia_trie-2.log .. .. table_create --name PatSuffix --flags TABLE_PAT_KEY|KEY_WITH_SIS --key_type ShortText .. column_create --table PatSuffix --name original --type Bool .. load --table PatSuffix .. [ .. {"_key":"ã²ããã","original":true}, .. {"_key":"ã¾ããã","original":true}, .. {"_key":"ã²ããã","original":true}, .. {"_key":"ããã²ã","original":true} .. ] .. select --table PatSuffix --query _key:$ãã .. select --table PatSuffix --filter '_key @$ "ãã" && original == true'