部分一致 Atlas 検索クエリの実行方法
このチュートリアルでは、sample_mflix.movies
コレクションにインデックスを作成し、plot
フィールドに対して部分的な文字列を用いたクエリを実行する方法について説明します。部分的な文字列を用いたクエリに一致するものを返すには、以下の演算子のいずれかを使用します。
オートコンプリート演算子。指定したフィールドから、クエリで指定した文字のシーケンスを含む単語またはフレーズを検索することができます。
フレーズ演算子。指定したフィールドから、単語間の距離を指定してクエリ文字列内の単語を含むドキュメントを検索することができます。
正規表現演算子。正規表現を使用して、指定したフィールドから文字列を検索することができます。
ワイルドカード演算子。クエリ内に特殊文字を使用して、指定したフィールドから任意の文字と一致するものを検索することができます。
部分一致をより細かく制御するには、 テキスト演算子 をカスタムアナライザで使用することもできます。詳細については、「 カスタムアナライザの例 」を参照してください。
このチュートリアルでは、次の手順について説明します。
sample_mflix.movies
コレクションのplot
フィールドに Atlas Search インデックスを設定します。オートコンプリート、フレーズ、正規表現、ワイルドカード演算子を使用して、
sample_mflix.movies
コレクションのplot
フィールドに対して部分的な文字列を用いて Atlas Search クエリを実行します。
開始する前に、Atlas クラスターが前提条件 に記載されている要件を満たしていることを確認してください。
Atlas Search インデックスを作成するには、プロジェクトに対するProject Data Access Admin
以上のアクセス権が必要です。
Atlas Search インデックスの作成
このセクションでは、sample_mflix.movies
コレクションの plot
フィールドに Atlas Search インデックスを作成し、それらのフィールドに対して部分一致クエリを実行します。
Atlas Atlasで、プロジェクトの {0 ページにGoします。GoClusters
まだ表示されていない場合は、希望するプロジェクトを含む組織を選択しますナビゲーション バーのOrganizationsメニュー
まだ表示されていない場合は、ナビゲーション バーのProjectsメニューから目的のプロジェクトを選択します。
まだ表示されていない場合は、サイドバーの [Clusters] をクリックします。
[ クラスター]ページが表示されます。
GoAtlas Searchクラスターの ページに します。
GoAtlas Searchページには、サイドバー、Data Explorer 、またはクラスターの詳細ページから できます。
サイドバーで、 Services見出しの下のAtlas Searchをクリックします。
[ Select data sourceドロップダウンからクラスターを選択し、[ Go to Atlas Search ] をクリックします。
Atlas Searchページが表示されます。
クラスターの [Browse Collections] ボタンをクリックします。
データベースを展開し、コレクションを選択します。
コレクションのSearch Indexesタブをクリックします。
Atlas Searchページが表示されます。
クラスタの名前をクリックします。
[Atlas Search] タブをクリックします。
Atlas Searchページが表示されます。
Index Name を入力し、Database and Collection を設定します。
Index Nameフィールドに
partial-match-tutorial
と入力します。インデックスに
default
と名付けると、 $searchパイプライン ステージでindex
パラメータを指定する必要がなくなります。 インデックスにカスタム名を付ける場合は、index
パラメータでこの名前を指定する必要があります。Database and Collectionセクションで、
sample_mflix
データベースを検索し、movies
コレクションを選択します。
plot
フィールドにインデックスを定義します。
インデックスを作成するには、 インターフェースで または を使用できます。Atlas SearchVisual EditorAtlas SearchJSON EditorAtlas user
[Next] をクリックします。
[Refine Your Index] をクリックします。
Index Configurationsセクションで、Dynamic Mapping を無効に切り替える。
Field Mappingsセクションで、
Add Field Add Field Mapping ウィンドウを表示します。
[Quick Start for Text Fields] をクリックします。
ドロップダウンからSearch-as-you-typeテンプレートを選択し、デフォルト設定を確認します。
これらの設定の詳細については、「オートコンプリートのためのフィールドのインデックス作成方法」を参照してください。
[Quick Start for Text Fields] をクリックします。
ドロップダウンからFull Text Searchテンプレートを選択し、デフォルト設定を確認します。
これらの設定の詳細については、「文字列フィールドのインデックス作成方法」を参照してください。
ドロップダウンから [Customized Configuration] を選択します。
[ Data Type ] ドロップダウンから [ String ] を選択し、ワイルドカード演算子を使用してクエリを実行します。
データタイプのデフォルト設定を次のように変更します。
UI フィールド名構成Index Analyzer
lucene.keyword
Search Analyzer
lucene.keyword
Index Options
offsets
Store
true
Ignore Above
なし
Norms
include
これらの設定の詳細については、「文字列フィールドのインデックス作成方法」を参照してください。
ドロップダウンから [Customized Configuration] を選択します。
[ Data Type ] ドロップダウンから [ String ] を選択し、ワイルドカード演算子を使用してクエリを実行します。
データタイプのデフォルト設定を次のように変更します。
UI フィールド名構成Index Analyzer
lucene.keyword
Search Analyzer
lucene.keyword
Index Options
offsets
Store
true
Ignore Above
なし
Norms
include
これらの設定の詳細については、「文字列フィールドのインデックス作成方法」を参照してください。
Field Nameドロップダウンから
plot
を選択します。Addをクリックすると、 Field Mappingsセクションのリストにフィールドが追加されます。
[Save Changes] をクリックします。
クエリの実行に使用する演算子に対して、デフォルトのインデックス定義を、次の例のインデックス定義に置き換えます。
{ "mappings": { "dynamic": false, "fields": { "plot": [ { "type": "autocomplete", "tokenization": "edgeGram", "minGrams": 2, "maxGrams": 15, "foldDiacritics": true } ] } } } { "mappings": { "fields": { "plot": { "analyzer": "lucene.standard", "type": "string" } } } } { "mappings": { "fields": { "plot": { "analyzer": "lucene.keyword", "type": "string" } } } } { "mappings": { "fields": { "plot": { "analyzer": "lucene.keyword", "type": "string" } } } } [Next] をクリックします。
大文字と小文字を区別する部分一致クエリを実行する
➤ このページの [言語の選択] ドロップダウンメニューを使用して、このセクションの例の言語を設定します。
大文字と小文字を区別する部分一致クエリを実行するには、オートコンプリート、フレーズ、正規表現、およびワイルドカード演算子を使用できます。このチュートリアルでは、これらの演算子を使用して、指定した部分的な文字列がプロットに含まれている映画を検索します。
このセクションでは、Atlas クラスターに接続し、sample_mflix.movies
コレクションの plot
フィールドに対して演算子を使用してサンプル クエリを実行します。
AtlasGoClustersAtlas で、プロジェクトの ページにGoします。
まだ表示されていない場合は、希望するプロジェクトを含む組織を選択しますナビゲーション バーのOrganizationsメニュー
まだ表示されていない場合は、ナビゲーション バーのProjectsメニューから目的のプロジェクトを選択します。
まだ表示されていない場合は、サイドバーの [Clusters] をクリックします。
[ Clusters (クラスター) ] ページが表示されます。
GoAtlas Searchクラスターの ページに します。
GoAtlas Searchページには、サイドバー、Data Explorer 、またはクラスターの詳細ページから できます。
サイドバーで、 Services見出しの下のAtlas Searchをクリックします。
[ Select data sourceドロップダウンからクラスターを選択し、[ Go to Atlas Search ] をクリックします。
Atlas Searchページが表示されます。
クラスターの [Browse Collections] ボタンをクリックします。
データベースを展開し、コレクションを選択します。
コレクションのSearch Indexesタブをクリックします。
Atlas Searchページが表示されます。
クラスタの名前をクリックします。
[Atlas Search] タブをクリックします。
Atlas Searchページが表示されます。
インデックスを作成したオペレーターを使用して、次のAtlas 検索クエリを実行します。
次のクエリは、オペレーターを使用して sample_mflix.movies
コレクションの plot
フィールドをクエリします。
次のクエリをコピーして、 Query Editorに貼り付け、 Query EditorのSearchボタンをクリックします。
このクエリでは、クエリ文字列new
purchase
をフィールド内の単語と照合するために、次の操作が実行されます。
new
とpurchase
という単語をplot
フィールドのどこにでも表示できます。クエリをフィールド内の単語と一致させるためにクエリ文字列に 2 文字のバリエーションを含めることはできますが、クエリ文字列の最初の文字は変更できません。
最大 256 語の類似タームを検討できます。
1 [ 2 { 3 "$search": { 4 "index": "partial-match-tutorial", 5 "autocomplete": { 6 "path": "plot", 7 "query": "new purchase", 8 "tokenOrder": "any", 9 "fuzzy": { 10 "maxEdits": 2, 11 "prefixLength": 1, 12 "maxExpansions": 256 13 } 14 }, 15 "highlight": { 16 "path": "plot" 17 } 18 } 19 } 20 ]
SCORE: 3 _id: "573a13a4f29313caabd112f0" A divorced woman and her diabetic daughter take refuge in their newly-purchased house's safe room, when three men break-in, searching for a missing fortune. Matching fields: plot SCORE: 3 _id: "573a13d1f29313caabd8e209" A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need. Matching fields: plot SCORE: 2 _id: "573a13bef29313caabd5b62d" Set in the near future when artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has purchased. He must Matching fields: plot SCORE: 2 _id: "573a13b3f29313caabd3c91e" He is "purchased" by a wealthy television producer and taken to a desolate island where he must fight to the death against nine other condemned killers from all corners of the world, with freedom going to the sole survivor. Matching fields: plot SCORE: 2 _id: "573a1398f29313caabceb931" A country boy becomes the head of a gang through the purchase of some lucky roses from an old lady. Matching fields: plot, plot SCORE: 1 _id: "573a13a7f29313caabd1b5ab" An illegal Nigerian immigrant discovers the unpalatable side of London life. Matching fields: plot SCORE: 1 _id: "573a13a7f29313caabd1b5c0" A young dropout falls in love with a nightclub dancer... Matching fields: plot SCORE: 1 _id: "573a13a7f29313caabd1b62f" In 1990, to protect his fragile mother from a fatal shock after a long coma, a young man must keep her from learning that her beloved nation of East Germany as she knew it has disappeared. Matching fields: plot SCORE: 1 _id: "573a13a7f29313caabd1b6af" Gadget once again has to fight his arch nemesis, Claw. Matching fields: plot
クエリは new
と purpose
の位置的距離が最大 5
語とする、 new purpose
というクエリ文字列を指定します。
1 [ 2 { 3 "$search": { 4 "index": "partial-match-tutorial", 5 "phrase": { 6 "path": "plot", 7 "query": "new purpose", 8 "slop": 5 9 }, 10 "highlight": { 11 "path": "plot" 12 } 13 } 14 } 15 ]
SCORE: 3.7209534645080566 _id: "573a13b1f29313caabd37ae6" The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities. Matching fields: plot SCORE: 1.1507558822631836 _id: "573a13bdf29313caabd58a26" But without a hero, he loses all purpose and must find new meaning to his life. Matching fields: plot SCORE: 1.0041160583496094 _id: "573a1396f29313caabce5197" An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy New Mexico cattle barons--his sole purpose being to bring down his old friend Billy the Kid. Matching fields: plot
クエリでは (.*)
正規表現を使用して、任意の数の文字を部分クエリ文字列と照合します。
1 [ 2 { 3 "$search": { 4 "index": "partial-match-tutorial", 5 "regex": { 6 "path": "plot", 7 "query": "(.*)new(.*) pur(.*)" 8 } 9 } 10 } 11 ]
SCORE: 1 _id: "573a1397f29313caabce77d9" fullplot: "After the Rebel base on the icy planet Hoth is taken over by the empir…" imdb: Object year: 1980 SCORE: 1 _id: "573a1398f29313caabceb893" plot: "The new owner of the Cleveland Indians puts together a purposely horri…" genres: Array runtime: 107 SCORE: 1 _id: "573a13b1f29313caabd37ae6" plot: "The true story of Richard Pimentel, a brilliant public speaker with a …" genres: Array runtime: 94 SCORE: 1 _id: "573a13d1f29313caabd8e209" fullplot: "Theodore is a lonely man in the final stages of his divorce. When he's…" imdb: Object year: 2013 SCORE: 1 _id: "573a13dcf29313caabdb107a" plot: "An adrenaline junkie walks away from a whirlwind romance and embraces …" genres: Array runtime: 146
クエリは、クエリ文字列の*
を使用して、部分クエリ文字列内の指定された単語の前後の 0
文字以上を照合します。
1 [ 2 { 3 "$search": { 4 "index": "partial-match-tutorial", 5 "wildcard": { 6 "path": "plot", 7 "query": "*new* pur*" 8 } 9 } 10 } 11 ]
SCORE: 1 _id: "573a1397f29313caabce77d9" fullplot: "After the Rebel base on the icy planet Hoth is taken over by the empir…" imdb: Object year: 1980 SCORE: 1 _id: "573a1398f29313caabceb893" plot: "The new owner of the Cleveland Indians puts together a purposely horri…" genres: Array runtime: 107 SCORE: 1 _id: "573a13b1f29313caabd37ae6" plot: "The true story of Richard Pimentel, a brilliant public speaker with a …" genres: Array runtime: 94 SCORE: 1 _id: "573a13d1f29313caabd8e209" fullplot: "Theodore is a lonely man in the final stages of his divorce. When he's…" imdb: Object year: 2013 SCORE: 1 _id: "573a13dcf29313caabdb107a" plot: "An adrenaline junkie walks away from a whirlwind romance and embraces …" genres: Array runtime: 146
クエリ結果を展開します。
Search Testerでは、返されるドキュメント内のすべてのフィールドが表示されない場合があります。 クエリパスで指定したフィールドを含むすべてのフィールドを表示するには、結果内のドキュメントを展開します。
mongosh
内のクラスターに接続します。
ターミナル ウィンドウでmongosh
を開き、クラスターに接続します。 接続の詳細な手順については、「 mongosh
経由での接続 」を参照してください。
sample_mflix
データベースを使用します。
mongosh
プロンプトで次のコマンドを実行します。
use sample_mflix
インデックスを作成したオペレーターを使用して、次のAtlas 検索クエリを実行します。
次のクエリは、オペレーターを使用して sample_mflix.movies
コレクションの plot
フィールドをクエリします。クエリには以下が含まれます。
このクエリでは、クエリ文字列new
purchase
をフィールド内の単語と照合するために、次の操作が実行されます。
new
とpurchase
という単語をplot
フィールドのどこにでも表示できます。クエリをフィールド内の単語と一致させるためにクエリ文字列に 2 文字のバリエーションを含めることはできますが、クエリ文字列の最初の文字は変更できません。
最大 256 語の類似タームを検討できます。
1 db.movies.aggregate([ 2 { 3 "$search": { 4 "index": "partial-match-tutorial", 5 "autocomplete": { 6 "path": "plot", 7 "query": "new purchase", 8 "tokenOrder": "any", 9 "fuzzy": { 10 "maxEdits": 2, 11 "prefixLength": 1, 12 "maxExpansions": 256 13 } 14 }, 15 "highlight": { 16 "path": "plot" 17 } 18 } 19 }, 20 { 21 "$limit": 5 22 }, 23 { 24 "$project": { 25 "_id": 0, 26 "title": 1, 27 "plot": 1, 28 "highlights": { "$meta": "searchHighlights" } 29 } 30 } 31 ])
[ { plot: "A divorced woman and her diabetic daughter take refuge in their newly-purchased house's safe room, when three men break-in, searching for a missing fortune.", title: 'Panic Room', highlights: [ { score: 4.364492893218994, path: 'plot', texts: [ { value: 'A divorced woman and her diabetic daughter take refuge in their ', type: 'text' }, { value: "newly-purchased house's safe", type: 'hit' }, { value: ' room, when three men break-in, searching for a missing fortune.', type: 'text' } ] } ] }, { plot: "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", title: 'Her', highlights: [ { score: 4.198050022125244, path: 'plot', texts: [ { value: 'A lonely writer develops an unlikely relationship with his ', type: 'text' }, { value: 'newly purchased operating system', type: 'hit' }, { value: " that's designed to meet his every ", type: 'text' }, { value: 'need', type: 'hit' }, { value: '.', type: 'text' } ] } ] }, { plot: "Set in the near future when artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has purchased. He must therefore go on the run before said ticker is repossessed.", title: 'Repo Men', highlights: [ { score: 2.6448397636413574, path: 'plot', texts: [ { value: 'Set in the ', type: 'text' }, { value: 'near future when', type: 'hit' }, { value: ' artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has ', type: 'text' }, { value: 'purchased. He must', type: 'hit' } ] } ] }, { plot: 'A psychologically troubled novelty supplier is nudged towards a romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and purchasing stunning amounts of pudding.', title: 'Punch-Drunk Love', highlights: [ { score: 1.2451990842819214, path: 'plot', texts: [ { value: 'A psychologically troubled ', type: 'text' }, { value: 'novelty supplier is', type: 'hit' }, { value: ' ', type: 'text' }, { value: 'nudged towards a', type: 'hit' }, { value: ' romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and ', type: 'text' }, { value: 'purchasing stunning amounts', type: 'hit' }, { value: ' of pudding.', type: 'text' } ] } ] }, { plot: 'Jack Conrad is awaiting the death penalty in a corrupt Central American prison. He is "purchased" by a wealthy television producer and taken to a desolate island where he must fight to the death against nine other condemned killers from all corners of the world, with freedom going to the sole survivor.', title: 'The Condemned', highlights: [ { score: 2.94378924369812, path: 'plot', texts: [ { value: 'He is "', type: 'text' }, { value: 'purchased" by a', type: 'hit' }, { value: ' wealthy television producer and taken to a desolate island where he must fight to the death against ', type: 'text' }, { value: 'nine other condemned', type: 'hit' }, { value: ' killers from all corners of the world, with freedom going to the sole survivor.', type: 'text' } ] } ] } ]
クエリは new
と purpose
の位置的距離が最大 5
語とする、 new purpose
というクエリ文字列を指定します。
1 db.movies.aggregate([ 2 { 3 "$search": { 4 "index": "partial-match-tutorial", 5 "phrase": { 6 "path": "plot", 7 "query": "new purpose", 8 "slop": 5 9 }, 10 "highlight": { 11 "path": "plot" 12 } 13 } 14 }, 15 { 16 "$limit": 5 17 }, 18 { 19 "$project": { 20 "_id": 0, 21 "plot": 1, 22 "title": 1, 23 "highlights": { "$meta": "searchHighlights" } 24 } 25 } 26 ])
[ { plot: 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', title: 'Music Within', highlights: [ { score: 1.9394469261169434, path: 'plot', texts: [ { value: 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a ', type: 'text' }, { value: 'new', type: 'hit' }, { value: ' ', type: 'text' }, { value: 'purpose', type: 'hit' }, { value: ' in his landmark efforts on the behalf of Americans with disabilities.', type: 'text' } ] } ] }, { plot: 'The supervillain Megamind finally defeats his nemesis, the superhero Metro Man. But without a hero, he loses all purpose and must find new meaning to his life.', title: 'Megamind', highlights: [ { score: 2.90376877784729, path: 'plot', texts: [ { value: 'But without a hero, he loses all ', type: 'text' }, { value: 'purpose', type: 'hit' }, { value: ' and must find ', type: 'text' }, { value: 'new', type: 'hit' }, { value: ' meaning to his life.', type: 'text' } ] } ] }, { plot: 'An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy New Mexico cattle barons--his sole purpose being to bring down his old friend Billy the Kid.', title: 'Pat Garrett & Billy the Kid', highlights: [ { score: 2.115748405456543, path: 'plot', texts: [ { value: 'An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy ', type: 'text' }, { value: 'New', type: 'hit' }, { value: ' Mexico cattle barons--his sole ', type: 'text' }, { value: 'purpose', type: 'hit' }, { value: ' being to bring down his old friend Billy the Kid.', type: 'text' } ] } ] } ]
クエリでは (.*)
正規表現を使用して、任意の数の文字を部分クエリ文字列と照合します。
1 db.movies.aggregate([ 2 { 3 "$search": { 4 "index": "partial-match-tutorial", 5 "regex": { 6 "path": "plot", 7 "query": "(.*)new(.*) pur(.*)" 8 } 9 } 10 }, 11 { 12 $limit: 5 13 }, 14 { 15 $project: { 16 "_id": 0, 17 "plot": 1, 18 "title": 1 19 } 20 } 21 ])
[ { plot: 'After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.', title: 'Star Wars: Episode V - The Empire Strikes Back' }, { plot: "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", title: 'Major League' }, { plot: 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', title: 'Music Within' }, { plot: "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", title: 'Her' }, { plot: 'An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.', title: 'Kick' } ]
クエリは、クエリ文字列の*
を使用して、部分クエリ文字列内の指定された単語の前後の 0
文字以上を照合します。
1 db.movies.aggregate([ 2 { 3 "$search": { 4 "index": "partial-match-tutorial", 5 "wildcard": { 6 "path": "plot", 7 "query": "*new* pur*" 8 } 9 } 10 }, 11 { 12 "$limit": 5 13 }, 14 { 15 "$project": { 16 "_id": 0, 17 "plot": 1 18 } 19 } 20 ])
[ { plot: 'After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.', title: 'Star Wars: Episode V - The Empire Strikes Back' }, { plot: "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", title: 'Major League' }, { plot: 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', title: 'Music Within' }, { plot: "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", title: 'Her' }, { plot: 'An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.', title: 'Kick' } ]
MongoDB Compass のクラスターに接続します。
MongoDB Compass を開き、クラスターに接続します。 接続の詳細な手順については、「 Compass 経由での接続 」を参照してください。
インデックスを作成したオペレーターを使用して、次のAtlas 検索クエリを実行します。
次のクエリは、オペレーターを使用して sample_mflix.movies
コレクションの plot
フィールドをクエリします。クエリには以下が含まれます。
MongoDB Compass でこのクエリを実行するには:
[Aggregations] タブをクリックします。
Select...をクリックし、ドロップダウンからステージを選択し、そのステージのクエリを追加して、次の各パイプライン ステージを構成します。 ステージを追加するには、 Add Stageをクリックします。
このクエリでは、クエリ文字列
new purchase
をフィールド内の単語と照合するために、次の操作が実行されます。new
とpurchase
という単語をplot
フィールドのどこにでも表示できます。クエリをフィールド内の単語と一致させるためにクエリ文字列に 2 文字のバリエーションを含めることはできますが、クエリ文字列の最初の文字は変更できません。
最大 256 語の類似タームを検討できます。
パイプラインステージクエリ$search
{ "index": "partial-match-tutorial", "autocomplete": { "path": "plot", "query": "new purchase", "tokenOrder": "any", "fuzzy": { "maxEdits": 2, "prefixLength": 1, "maxExpansions": 256 } }, "highlight": { "path": "plot" } } $limit
5 $project
{ "_id": 0, "title": 1, "plot": 1, "highlights": { "$meta": "searchHighlights" } } クエリは
new
とpurpose
の位置的距離が最大5
語とする、new purpose
というクエリ文字列を指定します。パイプラインステージクエリ$search
{ "index": "partial-match-tutorial", "phrase": { "path": "plot", "query": "new purpose", "slop": 5 }, "highlight": { "path": "plot" } } $limit
5 $project
{ "_id": 0, "title": 1, "plot": 1, "highlights": { "$meta": "searchHighlights" } } クエリでは
(.*)
正規表現を使用して、任意の数の文字を部分クエリ文字列と照合します。パイプラインステージクエリ$search
{ "index": "partial-match-tutorial", "regex": { "path": "plot", "query": "(.*)new(.*) pur(.*)" } } $limit
5 $project
{ "_id": 0, "title": 1, "plot": 1 } クエリは、クエリ文字列の
*
を使用して、部分クエリ文字列内の指定された単語の前後の0
文字以上を照合します。パイプラインステージクエリ$search
{ "index": "partial-match-tutorial", "wildcard": { "path": "plot", "query": "*new* pur*" } } $limit
5 $project
{ "_id": 0, "title": 1, "plot": 1 }
Auto Previewを有効にした場合、MongoDB Compass は$project
パイプライン ステージの横に次のドキュメントを表示します。
1 [ 2 { 3 plot: "A divorced woman and her diabetic daughter take refuge in their newly-purchased house's safe room, when three men break-in, searching for a missing fortune.", 4 title: 'Panic Room', 5 highlights: [ 6 { 7 score: 4.364492893218994, 8 path: 'plot', 9 texts: [ 10 { 11 value: 'A divorced woman and her diabetic daughter take refuge in their ', 12 type: 'text' 13 }, 14 { value: "newly-purchased house's safe", type: 'hit' }, 15 { 16 value: ' room, when three men break-in, searching for a missing fortune.', 17 type: 'text' 18 } 19 ] 20 } 21 ] 22 }, 23 { 24 plot: "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", 25 title: 'Her', 26 highlights: [ 27 { 28 score: 4.198050022125244, 29 path: 'plot', 30 texts: [ 31 { 32 value: 'A lonely writer develops an unlikely relationship with his ', 33 type: 'text' 34 }, 35 { value: 'newly purchased operating system', type: 'hit' }, 36 { 37 value: " that's designed to meet his every ", 38 type: 'text' 39 }, 40 { value: 'need', type: 'hit' }, 41 { value: '.', type: 'text' } 42 ] 43 } 44 ] 45 }, 46 { 47 plot: "Set in the near future when artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has purchased. He must therefore go on the run before said ticker is repossessed.", 48 title: 'Repo Men', 49 highlights: [ 50 { 51 score: 2.6448397636413574, 52 path: 'plot', 53 texts: [ 54 { value: 'Set in the ', type: 'text' }, 55 { value: 'near future when', type: 'hit' }, 56 { value: ' artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has ', type: 'text' }, 57 { value: 'purchased. He must', type: 'hit' } 58 ] 59 } 60 ] 61 }, 62 { 63 plot: 'A psychologically troubled novelty supplier is nudged towards a romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and purchasing stunning amounts of pudding.', 64 title: 'Punch-Drunk Love', 65 highlights: [ 66 { 67 score: 1.2451990842819214, 68 path: 'plot', 69 texts: [ 70 { value: 'A psychologically troubled ', type: 'text' }, 71 { value: 'novelty supplier is', type: 'hit' }, 72 { value: ' ', type: 'text' }, 73 { value: 'nudged towards a', type: 'hit' }, 74 { 75 value: ' romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and ', 76 type: 'text' 77 }, 78 { value: 'purchasing stunning amounts', type: 'hit' }, 79 { value: ' of pudding.', type: 'text' } 80 ] 81 } 82 ] 83 }, 84 { 85 plot: 'Jack Conrad is awaiting the death penalty in a corrupt Central American prison. He is "purchased" by a wealthy television producer and taken to a desolate island where he must fight to the death against nine other condemned killers from all corners of the world, with freedom going to the sole survivor.', 86 title: 'The Condemned', 87 highlights: [ 88 { 89 score: 2.94378924369812, 90 path: 'plot', 91 texts: [ 92 { value: 'He is "', type: 'text' }, 93 { value: 'purchased" by a', type: 'hit' }, 94 { 95 value: ' wealthy television producer and taken to a desolate island where he must fight to the death against ', 96 type: 'text' 97 }, 98 { value: 'nine other condemned', type: 'hit' }, 99 { 100 value: ' killers from all corners of the world, with freedom going to the sole survivor.', 101 type: 'text' 102 } 103 ] 104 } 105 ] 106 } 107 ]
1 [ 2 { 3 plot: 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', 4 title: 'Music Within', 5 highlights: [ 6 { 7 score: 1.9394469261169434, 8 path: 'plot', 9 texts: [ 10 { value: 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a ', type: 'text' }, 11 { value: 'new', type: 'hit' }, 12 { value: ' ', type: 'text' }, 13 { value: 'purpose', type: 'hit' }, 14 { value: ' in his landmark efforts on the behalf of Americans with disabilities.', type: 'text' } 15 ] 16 } 17 ] 18 }, 19 { 20 plot: 'The supervillain Megamind finally defeats his nemesis, the superhero Metro Man. But without a hero, he loses all purpose and must find new meaning to his life.', 21 title: 'Megamind', 22 highlights: [ 23 { 24 score: 2.90376877784729, 25 path: 'plot', 26 texts: [ 27 { value: 'But without a hero, he loses all ', type: 'text' }, 28 { value: 'purpose', type: 'hit' }, 29 { value: ' and must find ', type: 'text' }, 30 { value: 'new', type: 'hit' }, 31 { value: ' meaning to his life.', type: 'text' } 32 ] 33 } 34 ] 35 }, 36 { 37 plot: 'An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy New Mexico cattle barons--his sole purpose being to bring down his old friend Billy the Kid.', 38 title: 'Pat Garrett & Billy the Kid', 39 highlights: [ 40 { 41 score: 2.115748405456543, 42 path: 'plot', 43 texts: [ 44 { value: 'An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy ', type: 'text' }, 45 { value: 'New', type: 'hit' }, 46 { value: ' Mexico cattle barons--his sole ', type: 'text' }, 47 { value: 'purpose', type: 'hit' }, 48 { value: ' being to bring down his old friend Billy the Kid.', type: 'text' } 49 ] 50 } 51 ] 52 } 53 ]
1 [ 2 { 3 plot: 'After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.', 4 title: 'Star Wars: Episode V - The Empire Strikes Back' 5 }, 6 { 7 plot: "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", 8 title: 'Major League' 9 }, 10 { 11 plot: 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', 12 title: 'Music Within' 13 }, 14 { 15 plot: "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", 16 title: 'Her' 17 }, 18 { 19 plot: 'An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.', 20 title: 'Kick' 21 } 22 ]
1 [ 2 { 3 plot: 'After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.', 4 title: 'Star Wars: Episode V - The Empire Strikes Back' 5 }, 6 { 7 plot: "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", 8 title: 'Major League' 9 }, 10 { 11 plot: 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', 12 title: 'Music Within' 13 }, 14 { 15 plot: "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", 16 title: 'Her' 17 }, 18 { 19 plot: 'An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.', 20 title: 'Kick' 21 } 22 ]
Program.cs
ファイルにクエリを作成します。
Program.cs
ファイルの内容を、次のコードで置き換えます。このコード例では、次のタスクを実行します。
mongodb
パッケージと依存関係をインポートします。Atlas クラスターへの接続を確立します。
以下を使用するクエリを実行します。
カーソルを反復処理して、クエリに一致するドキュメントを出力します。
このクエリでは、クエリ文字列
new purchase
をフィールド内の単語と照合するために、次の操作が実行されます。new
とpurchase
という単語をplot
フィールドのどこにでも表示できます。クエリをフィールド内の単語と一致させるためにクエリ文字列に 2 文字のバリエーションを含めることはできますが、クエリ文字列の最初の文字は変更できません。
最大 256 語の類似タームを検討できます。
1 using MongoDB.Bson; 2 using MongoDB.Bson.Serialization.Attributes; 3 using MongoDB.Bson.Serialization.Conventions; 4 using MongoDB.Driver; 5 using MongoDB.Driver.Search; 6 7 public class PartialAutocomplete 8 { 9 private const string MongoConnectionString = "<connection-string>"; 10 11 public static void Main(string[] args) { 12 // allow automapping of the camelCase database fields to our MovieDocument 13 var camelCaseConvention = new ConventionPack { new CamelCaseElementNameConvention() }; 14 ConventionRegistry.Register("CamelCase", camelCaseConvention, type => true); 15 16 // connect to your Atlas cluster 17 var mongoClient = new MongoClient(MongoConnectionString); 18 var mflixDatabase = mongoClient.GetDatabase("sample_mflix"); 19 var moviesCollection = mflixDatabase.GetCollection<MovieDocument>("movies"); 20 21 // define fuzzy options 22 SearchFuzzyOptions fuzzyOptions = new SearchFuzzyOptions() 23 { 24 MaxEdits = 2, 25 PrefixLength = 1, 26 MaxExpansions = 256 27 }; 28 29 // define and run pipeline 30 var results = moviesCollection.Aggregate() 31 .Search(Builders<MovieDocument>.Search.Autocomplete(movie => movie.Plot, "new purchase", SearchAutocompleteTokenOrder.Any, fuzzy: fuzzyOptions), new SearchHighlightOptions<MovieDocument>(movie => movie.Plot), 32 indexName: "partial-match-tutorial") 33 .Project<MovieDocument>(Builders<MovieDocument>.Projection 34 .Include(movie => movie.Plot) 35 .Include(movie => movie.Title) 36 .Exclude(movie => movie.Id) 37 .MetaSearchHighlights("highlights")) 38 .Limit(5) 39 .ToList(); 40 41 // print results 42 foreach (var movie in results) { 43 Console.WriteLine(movie.ToJson()); 44 } 45 } 46 } 47 48 [ ]49 public class MovieDocument { 50 [ ]51 public ObjectId Id { get; set; } 52 public string Plot { get; set; } 53 public string Title { get; set; } 54 [ ]55 public List<SearchHighlight> Highlights { get; set; } 56 } クエリは
new
とpurpose
の位置的距離が最大5
語とする、new purpose
というクエリ文字列を指定します。1 using MongoDB.Bson; 2 using MongoDB.Bson.Serialization.Attributes; 3 using MongoDB.Bson.Serialization.Conventions; 4 using MongoDB.Driver; 5 using MongoDB.Driver.Search; 6 7 public class PartialPhrase 8 { 9 private const string MongoConnectionString = "<connection-string>"; 10 11 public static void Main(string[] args) { 12 // allow automapping of the camelCase database fields to our MovieDocument 13 var camelCaseConvention = new ConventionPack { new CamelCaseElementNameConvention() }; 14 ConventionRegistry.Register("CamelCase", camelCaseConvention, type => true); 15 16 // connect to your Atlas cluster 17 var mongoClient = new MongoClient(MongoConnectionString); 18 var mflixDatabase = mongoClient.GetDatabase("sample_mflix"); 19 var moviesCollection = mflixDatabase.GetCollection<MovieDocument>("movies"); 20 21 // define and run pipeline 22 var results = moviesCollection.Aggregate() 23 .Search(Builders<MovieDocument>.Search.Phrase(movie => movie.Plot, "new purpose", 5), new SearchHighlightOptions<MovieDocument>(movie => movie.Plot), 24 indexName: "partial-match-tutorial") 25 .Project<MovieDocument>(Builders<MovieDocument>.Projection 26 .Include(movie => movie.Plot) 27 .Include(movie => movie.Title) 28 .Exclude(movie => movie.Id) 29 .MetaSearchHighlights("highlights")) 30 .Limit(5) 31 .ToList(); 32 33 // print results 34 foreach (var movie in results) { 35 Console.WriteLine(movie.ToJson()); 36 } 37 } 38 } 39 40 [ ]41 public class MovieDocument { 42 [ ]43 public ObjectId Id { get; set; } 44 public string Plot { get; set; } 45 public string Title { get; set; } 46 [ ]47 public List<SearchHighlight> Highlights { get; set; } 48 } クエリでは
(.*)
正規表現を使用して、任意の数の文字を部分クエリ文字列と照合します。1 using MongoDB.Bson; 2 using MongoDB.Bson.Serialization.Attributes; 3 using MongoDB.Bson.Serialization.Conventions; 4 using MongoDB.Driver; 5 using MongoDB.Driver.Search; 6 7 public class PartialRegex 8 { 9 private const string MongoConnectionString = "<connection-string>"; 10 11 public static void Main(string[] args) { 12 // allow automapping of the camelCase database fields to our MovieDocument 13 var camelCaseConvention = new ConventionPack { new CamelCaseElementNameConvention() }; 14 ConventionRegistry.Register("CamelCase", camelCaseConvention, type => true); 15 16 // connect to your Atlas cluster 17 var mongoClient = new MongoClient(MongoConnectionString); 18 var mflixDatabase = mongoClient.GetDatabase("sample_mflix"); 19 var moviesCollection = mflixDatabase.GetCollection<MovieDocument>("movies"); 20 21 // define and run pipeline 22 var results = moviesCollection.Aggregate() 23 .Search(Builders<MovieDocument>.Search.Regex(movie => movie.Plot, "(.*)new(.*) pur(.*)"), 24 indexName: "partial-match-tutorial") 25 .Project<MovieDocument>(Builders<MovieDocument>.Projection 26 .Include(movie => movie.Plot) 27 .Include(movie => movie.Title) 28 .Exclude(movie => movie.Id)) 29 .Limit(5) 30 .ToList(); 31 32 // print results 33 foreach (var movie in results) { 34 Console.WriteLine(movie.ToJson()); 35 } 36 } 37 } 38 39 [ ]40 public class MovieDocument { 41 [ ]42 public ObjectId Id { get; set; } 43 public string Plot { get; set; } 44 public string Title { get; set; } 45 } クエリは、クエリ文字列の
*
を使用して、部分クエリ文字列内の指定された単語の前後の0
文字以上を照合します。1 using MongoDB.Bson; 2 using MongoDB.Bson.Serialization.Attributes; 3 using MongoDB.Bson.Serialization.Conventions; 4 using MongoDB.Driver; 5 using MongoDB.Driver.Search; 6 7 public class PartialWildcard 8 { 9 private const string MongoConnectionString = "<connection-string>"; 10 11 public static void Main(string[] args) { 12 // allow automapping of the camelCase database fields to our MovieDocument 13 var camelCaseConvention = new ConventionPack { new CamelCaseElementNameConvention() }; 14 ConventionRegistry.Register("CamelCase", camelCaseConvention, type => true); 15 16 // connect to your Atlas cluster 17 var mongoClient = new MongoClient(MongoConnectionString); 18 var mflixDatabase = mongoClient.GetDatabase("sample_mflix"); 19 var moviesCollection = mflixDatabase.GetCollection<MovieDocument>("movies"); 20 21 // define and run pipeline 22 var results = moviesCollection.Aggregate() 23 .Search(Builders<MovieDocument>.Search.Wildcard(movie => movie.Plot, "*new* pur*"), 24 indexName: "partial-match-tutorial") 25 .Project<MovieDocument>(Builders<MovieDocument>.Projection 26 .Include(movie => movie.Plot) 27 .Include(movie => movie.Title) 28 .Exclude(movie => movie.Id)) 29 .Limit(5) 30 .ToList(); 31 32 // print results 33 foreach (var movie in results) { 34 Console.WriteLine(movie.ToJson()); 35 } 36 } 37 } 38 39 [ ]40 public class MovieDocument { 41 [ ]42 public ObjectId Id { get; set; } 43 public string Plot { get; set; } 44 public string Title { get; set; } 45 } サンプルを実行する前に、
<connection-string>
をAtlas接続stringに置き換えます。 接続stringにデータベースユーザーの認証情報が含まれていることを確認します。 詳しくは、「ドライバーによる接続 」を参照してください。
Program.cs
ファイルをコンパイルして実行します。
dotnet run partial-match-example.csproj
{ "plot" : "A divorced woman and her diabetic daughter take refuge in their newly-purchased house's safe room, when three men break-in, searching for a missing fortune.", "title" : "Panic Room", "highlights" : [{ "path" : "plot", "score" : 4.3644928932189941, "texts" : [ { "type" : "Text", "value" : "A divorced woman and her diabetic daughter take refuge in their " }, { "type" : "Hit", "value" : "newly-purchased house's safe" }, { "type" : "Text", "value" : " room, when three men break-in, searching for a missing fortune." }] }] } { "plot" : "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", "title" : "Her", "highlights" : [{ "path" : "plot", "score" : 4.1980500221252441, "texts" : [ { "type" : "Text", "value" : "A lonely writer develops an unlikely relationship with his " }, { "type" : "Hit", "value" : "newly purchased operating system" }, { "type" : "Text", "value" : " that's designed to meet his every " }, { "type" : "Hit", "value" : "need" }, { "type" : "Text", "value" : "." }] }] } { "plot" : "Set in the near future when artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has purchased. He must therefore go on the run before said ticker is repossessed.", "title" : "Repo Men", "highlights" : [{ "path" : "plot", "score" : 2.6448397636413574, "texts" : [ { "type" : "Text", "value" : "Set in the " }, { "type" : "Hit", "value" : "near future when" }, { "type" : "Text", "value" : " artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has " }, { "type" : "Hit", "value" : "purchased. He must" }] }] } { "plot" : "A psychologically troubled novelty supplier is nudged towards a romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and purchasing stunning amounts of pudding.", "title" : "Punch-Drunk Love", "highlights" : [{ "path" : "plot", "score" : 1.2451990842819214, "texts" : [ { "type" : "Text", "value" : "A psychologically troubled " }, { "type" : "Hit", "value" : "novelty supplier is" }, { "type" : "Text", "value" : " " }, { "type" : "Hit", "value" : "nudged towards a" }, { "type" : "Text", "value" : " romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and " }, { "type" : "Hit", "value" : "purchasing stunning amounts" }, { "type" : "Text", "value" : " of pudding." }] }] } { "plot" : "Jack Conrad is awaiting the death penalty in a corrupt Central American prison. He is \"purchased\" by a wealthy television producer and taken to a desolate island where he must fight to the death against nine other condemned killers from all corners of the world, with freedom going to the sole survivor.", "title" : "The Condemned", "highlights" : [{ "path" : "plot", "score" : 2.9437892436981201, "texts" : [ { "type" : "Text", "value" : "He is \"" }, { "type" : "Hit", "value" : "purchased\" by a" }, { "type" : "Text", "value" : " wealthy television producer and taken to a desolate island where he must fight to the death against " }, { "type" : "Hit", "value" : "nine other condemned" }, { "type" : "Text", "value" : " killers from all corners of the world, with freedom going to the sole survivor." }] }] }
dotnet run partial-match-example.csproj
{ "plot" : "The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.", "title" : "Music Within", "highlights" : [{ "path" : "plot", "score" : 1.9394469261169434, "texts" : [ { "type" : "Text", "value" : "The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a " }, { "type" : "Hit", "value" : "new" }, { "type" : "Text", "value" : " " }, { "type" : "Hit", "value" : "purpose" }, { "type" : "Text", "value" : " in his landmark efforts on the behalf of Americans with disabilities." }] }] } { "plot" : "The supervillain Megamind finally defeats his nemesis, the superhero Metro Man. But without a hero, he loses all purpose and must find new meaning to his life.", "title" : "Megamind", "highlights" : [{ "path" : "plot", "score" : 2.90376877784729, "texts" : [ { "type" : "Text", "value" : "But without a hero, he loses all " }, { "type" : "Hit", "value" : "purpose" }, { "type" : "Text", "value" : " and must find " }, { "type" : "Hit", "value" : "new" }, { "type" : "Text", "value" : " meaning to his life." }] }] } { "plot" : "An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy New Mexico cattle barons--his sole purpose being to bring down his old friend Billy the Kid.", "title" : "Pat Garrett & Billy the Kid", "highlights" : [{ "path" : "plot", "score" : 2.115748405456543, "texts" : [ { "type" : "Text", "value" : "An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy " }, { "type" : "Hit", "value" : "New" }, { "type" : "Text", "value" : " Mexico cattle barons--his sole " }, { "type" : "Hit", "value" : "purpose" }, { "type" : "Text", "value" : " being to bring down his old friend Billy the Kid." }] }] }
dotnet run partial-match-example.csproj
{ "plot" : "After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.", "title" : "Star Wars: Episode V - The Empire Strikes Back" } { "plot" : "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", "title" : "Major League" } { "plot" : "The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.", "title" : "Music Within" } { "plot" : "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", "title" : "Her" } { "plot" : "An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.", "title" : "Kick" }
dotnet run partial-match-example.csproj
{ "plot" : "After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.", "title" : "Star Wars: Episode V - The Empire Strikes Back" } { "plot" : "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", "title" : "Major League" } { "plot" : "The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.", "title" : "Music Within" } { "plot" : "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", "title" : "Her" } { "plot" : "An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.", "title" : "Kick" }
インデックスを作成した演算子のコード例をコピーして partial-match-query.go
ファイルに貼り付けます。
次のクエリは、オペレーターを使用して sample_mflix.movies
コレクションの plot
フィールドをクエリします。クエリには以下が含まれます。
このクエリでは、クエリ文字列new
purchase
をフィールド内の単語と照合するために、次の操作が実行されます。
new
とpurchase
という単語をplot
フィールドのどこにでも表示できます。クエリをフィールド内の単語と一致させるためにクエリ文字列に 2 文字のバリエーションを含めることはできますが、クエリ文字列の最初の文字は変更できません。
最大 256 語の類似タームを検討できます。
1 package main 2 3 import ( 4 "context" 5 "fmt" 6 "time" 7 8 "go.mongodb.org/mongo-driver/bson" 9 "go.mongodb.org/mongo-driver/mongo" 10 "go.mongodb.org/mongo-driver/mongo/options" 11 ) 12 13 // define structure of movies collection 14 type MovieCollection struct { 15 title string `bson:"Title,omitempty"` 16 plot string `bson:"Plot,omitempty"` 17 } 18 19 func main() { 20 var err error 21 // connect to the Atlas cluster 22 ctx := context.Background() 23 client, err := mongo.Connect(ctx, options.Client().ApplyURI("<connection-string>")) 24 if err != nil { 25 panic(err) 26 } 27 defer client.Disconnect(ctx) 28 // set namespace 29 collection := client.Database("sample_mflix").Collection("movies") 30 // define pipeline 31 searchStage := bson.D{{"$search", bson.M{ 32 "index": "partial-match-tutorial", 33 "autocomplete": bson.M{ 34 "path": "plot", "query": "new purchase", "tokenOrder": "any", "fuzzy": bson.M{ 35 "maxEdits": 2, "prefixLength": 1, "maxExpansions": 256}, 36 }, 37 "highlight": bson.D{ 38 {"path", "plot"}, 39 }, 40 }}} 41 limitStage := bson.D{{"$limit", 5}} 42 projectStage := bson.D{{"$project", bson.D{{"title", 1}, {"plot", 1}, {"_id", 0}, {"highlights", bson.D{{"$meta", "searchHighlights"}}}}}} 43 // specify the amount of time the operation can run on the server 44 opts := options.Aggregate().SetMaxTime(5 * time.Second) 45 // run pipeline 46 cursor, err := collection.Aggregate(ctx, mongo.Pipeline{searchStage, limitStage, projectStage}, opts) 47 if err != nil { 48 panic(err) 49 } 50 // print results 51 var results []bson.D 52 if err = cursor.All(context.TODO(), &results); err != nil { 53 panic(err) 54 } 55 for _, result := range results { 56 fmt.Println(result) 57 } 58 }
クエリは new
と purpose
の位置的距離が最大 5
語とする、 new purpose
というクエリ文字列を指定します。
1 package main 2 3 import ( 4 "context" 5 "fmt" 6 "time" 7 8 "go.mongodb.org/mongo-driver/bson" 9 "go.mongodb.org/mongo-driver/mongo" 10 "go.mongodb.org/mongo-driver/mongo/options" 11 ) 12 13 // define structure of movies collection 14 type MovieCollection struct { 15 title string `bson:"Title,omitempty"` 16 plot string `bson:"Plot,omitempty"` 17 } 18 19 func main() { 20 var err error 21 // connect to the Atlas cluster 22 ctx := context.Background() 23 client, err := mongo.Connect(ctx, options.Client().ApplyURI("<connection-string>")) 24 if err != nil { 25 panic(err) 26 } 27 defer client.Disconnect(ctx) 28 // set namespace 29 collection := client.Database("sample_mflix").Collection("movies") 30 // define pipeline 31 searchStage := bson.D{{"$search", bson.M{ 32 "index": "partial-match-tutorial", 33 "phrase": bson.D{{"path", "plot"}, {"query", "new purpose"}, {"slop", 5}}, 34 "highlight": bson.D{{"path", "plot"}}, 35 }}} 36 limitStage := bson.D{{"$limit", 5}} 37 projectStage := bson.D{{"$project", bson.D{{"title", 1}, {"plot", 1}, {"_id", 0}, {"highlights", bson.D{{"$meta", "searchHighlights"}}}}}} 38 // specify the amount of time the operation can run on the server 39 opts := options.Aggregate().SetMaxTime(5 * time.Second) 40 // run pipeline 41 cursor, err := collection.Aggregate(ctx, mongo.Pipeline{searchStage, limitStage, projectStage}, opts) 42 if err != nil { 43 panic(err) 44 } 45 // print results 46 var results []bson.D 47 if err = cursor.All(context.TODO(), &results); err != nil { 48 panic(err) 49 } 50 for _, result := range results { 51 fmt.Println(result) 52 } 53 }
クエリでは (.*)
正規表現を使用して、任意の数の文字を部分クエリ文字列と照合します。
1 package main 2 3 import ( 4 "context" 5 "fmt" 6 "time" 7 8 "go.mongodb.org/mongo-driver/bson" 9 "go.mongodb.org/mongo-driver/mongo" 10 "go.mongodb.org/mongo-driver/mongo/options" 11 ) 12 13 // define structure of movies collection 14 type MovieCollection struct { 15 title string `bson:"Title,omitempty"` 16 plot string `bson:"Plot,omitempty"` 17 } 18 19 func main() { 20 var err error 21 // connect to the Atlas cluster 22 ctx := context.Background() 23 client, err := mongo.Connect(ctx, options.Client().ApplyURI("<connection-string>")) 24 if err != nil { 25 panic(err) 26 } 27 defer client.Disconnect(ctx) 28 // set namespace 29 collection := client.Database("sample_mflix").Collection("movies") 30 // define pipeline 31 searchStage := bson.D{{"$search", bson.M{ 32 "index": "partial-match-tutorial", 33 "regex": bson.D{{"path", "plot"}, {"query", "(.*)new(.*) pur(.*)"}}, 34 }}} 35 limitStage := bson.D{{"$limit", 5}} 36 projectStage := bson.D{{"$project", bson.D{{"title", 1}, {"plot", 1}, {"_id", 0}}}} 37 // specify the amount of time the operation can run on the server 38 opts := options.Aggregate().SetMaxTime(5 * time.Second) 39 // run pipeline 40 cursor, err := collection.Aggregate(ctx, mongo.Pipeline{searchStage, limitStage, projectStage}, opts) 41 if err != nil { 42 panic(err) 43 } 44 // print results 45 var results []bson.D 46 if err = cursor.All(context.TODO(), &results); err != nil { 47 panic(err) 48 } 49 for _, result := range results { 50 fmt.Println(result) 51 } 52 }
クエリは、クエリ文字列の*
を使用して、部分クエリ文字列内の指定された単語の前後の 0
文字以上を照合します。
1 package main 2 3 import ( 4 "context" 5 "fmt" 6 "time" 7 8 "go.mongodb.org/mongo-driver/bson" 9 "go.mongodb.org/mongo-driver/mongo" 10 "go.mongodb.org/mongo-driver/mongo/options" 11 ) 12 13 // define structure of movies collection 14 type MovieCollection struct { 15 title string `bson:"Title,omitempty"` 16 plot string `bson:"Plot,omitempty"` 17 } 18 19 func main() { 20 var err error 21 // connect to the Atlas cluster 22 ctx := context.Background() 23 client, err := mongo.Connect(ctx, options.Client().ApplyURI("<connection-string>")) 24 if err != nil { 25 panic(err) 26 } 27 defer client.Disconnect(ctx) 28 // set namespace 29 collection := client.Database("sample_mflix").Collection("movies") 30 // define pipeline 31 searchStage := bson.D{{"$search", bson.M{ 32 "index": "partial-match-tutorial", 33 "wildcard": bson.D{{"path", "plot"}, {"query", "*new* pur*"}}, 34 }}} 35 limitStage := bson.D{{"$limit", 5}} 36 projectStage := bson.D{{"$project", bson.D{{"title", 1}, {"plot", 1}, {"_id", 0}}}} 37 // specify the amount of time the operation can run on the server 38 opts := options.Aggregate().SetMaxTime(5 * time.Second) 39 // run pipeline 40 cursor, err := collection.Aggregate(ctx, mongo.Pipeline{searchStage, limitStage, projectStage}, opts) 41 if err != nil { 42 panic(err) 43 } 44 // print results 45 var results []bson.D 46 if err = cursor.All(context.TODO(), &results); err != nil { 47 panic(err) 48 } 49 for _, result := range results { 50 fmt.Println(result) 51 } 52 }
注意
サンプルを実行する前に、<connection-string>
をAtlas接続stringに置き換えます。 接続stringにデータベースユーザーの認証情報が含まれていることを確認します。 詳しくは、「ドライバーによる接続 」を参照してください。
次のコマンドを実行して、コレクションをクエリします
go run partial-match-query.go
[ {plot A divorced woman and her diabetic daughter take refuge in their newly-purchased house's safe room, when three men break-in, searching for a missing fortune.} {title Panic Room} {highlights [ [ {score 4.364492893218994} {path plot} {texts [ [{value A divorced woman and her diabetic daughter take refuge in their } {type text}] [{value newly-purchased house's safe} {type hit}] [{value room, when three men break-in, searching for a missing fortune.} {type text}] ]} ] ]} ] [ {plot A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.} {title Her} {highlights [ [ {score 4.198050022125244} {path plot} {texts [ [{value A lonely writer develops an unlikely relationship with his } {type text}] [{value newly purchased operating system} {type hit}] [{value that's designed to meet his every } {type text}] [{value need} {type hit}] [{value .} {type text}] ]} ] ]} ] [ {plot Set in the near future when artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has purchased. He must therefore go on the run before said ticker is repossessed.} {title Repo Men} {highlights [ [ {score 2.6448397636413574} {path plot} {texts [ [{value Set in the } {type text}] [{value near future when} {type hit}] [{value artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has } {type text}] [{value purchased. He must} {type hit}] ]} ] ]} ] [ {plot A psychologically troubled novelty supplier is nudged towards a romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and purchasing stunning amounts of pudding.} {title Punch-Drunk Love} {highlights [ [ {score 1.2451990842819214} {path plot} {texts [ [{value A psychologically troubled } {type text}] [{value novelty supplier is} {type hit}] [{value } {type text}] [{value nudged towards a} {type hit}] [{value romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and } {type text}] [{value purchasing stunning amounts} {type hit}] [{value of pudding.} {type text}] ]} ] ]} ] [ {plot Jack Conrad is awaiting the death penalty in a corrupt Central American prison. He is "purchased" by a wealthy television producer and taken to a desolate island where he must fight to the death against nine other condemned killers from all corners of the world, with freedom going to the sole survivor.} {title The Condemned} {highlights [ [ {score 2.94378924369812} {path plot} {texts [ [{value He is "} {type text}] [{value purchased" by a} {type hit}] [{value wealthy television producer and taken to a desolate island where he must fight to the death against } {type text}] [{value nine other condemned} {type hit}] [{value killers from all corners of the world, with freedom going to the sole survivor.} {type text}] ]} ] ]} ]
go run partial-match-query.go
[ {plot The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.} {title Music Within} {highlights [[ {score 1.9394469261169434} {path plot} {texts [ [{value The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a } {type text}] [{value new} {type hit}] [{value } {type text}] [{value purpose} {type hit}] [{value in his landmark efforts on the behalf of Americans with disabilities.} {type text} ] ]} ]]} ] [ {plot The supervillain Megamind finally defeats his nemesis, the superhero Metro Man. But without a hero, he loses all purpose and must find new meaning to his life.} {title Megamind} {highlights [[ {score 2.90376877784729} {path plot} {texts [ [{value But without a hero, he loses all } {type text}] [{value purpose} {type hit}] [{value and must find } {type text}] [{value new} {type hit}] [{value meaning to his life.} {type text}] ]} ]]} ] [ {plot An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy New Mexico cattle barons--his sole purpose being to bring down his old friend Billy the Kid.} {title Pat Garrett & Billy the Kid} {highlights [[ {score 2.115748405456543} {path plot} {texts [ [{value An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy } {type text}] [{value New} {type hit}] [{value Mexico cattle barons--his sole } {type text}] [{value purpose} {type hit}] [{value being to bring down his old friend Billy the Kid.} {type text}] ]} ]]} ]
go run partial-match-query.go
[ {plot After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.} {title Star Wars: Episode V - The Empire Strikes Back} ] [ {plot The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.} {title Major League} ] [ {plot The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.} {title Music Within} ] [ {plot A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.} {title Her} ] [ {plot An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.} {title Kick} ]
go run partial-match-query.go
[ {plot After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.} {title Star Wars: Episode V - The Empire Strikes Back} ] [ {plot The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.} {title Major League} ] [ {plot The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.} {title Music Within} ] [ {plot A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.} {title Her} ] [ {plot An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.} {title Kick} ]
インデックスを作成した演算子のコードをコピーして PartialMatchQuery.java
ファイルに貼り付けます。
このコード例では、次のタスクを実行します。
mongodb
パッケージと依存関係をインポートします。Atlas クラスターへの接続を確立します。
以下を使用するクエリを実行します。
カーソルを反復処理して、クエリに一致するドキュメントを出力します。
このクエリでは、クエリ文字列new
purchase
をフィールド内の単語と照合するために、次の操作が実行されます。
new
とpurchase
という単語をplot
フィールドのどこにでも表示できます。クエリをフィールド内の単語と一致させるためにクエリ文字列に 2 文字のバリエーションを含めることはできますが、クエリ文字列の最初の文字は変更できません。
最大 256 語の類似タームを検討できます。
1 import java.util.Arrays; 2 import static com.mongodb.client.model.Aggregates.limit; 3 import static com.mongodb.client.model.Aggregates.project; 4 import static com.mongodb.client.model.Projections.excludeId; 5 import static com.mongodb.client.model.Projections.fields; 6 import static com.mongodb.client.model.Projections.include; 7 import com.mongodb.client.MongoClient; 8 import com.mongodb.client.MongoClients; 9 import com.mongodb.client.MongoCollection; 10 import com.mongodb.client.MongoDatabase; 11 import org.bson.Document; 12 13 public class PartialMatchQuery { 14 public static void main( String[] args ) { 15 16 // define query 17 Document agg = new Document("$search", 18 new Document ("index", "partial-match-tutorial") 19 .append("autocomplete", 20 new Document("path", "plot") 21 .append("query", "new purchase") 22 .append("tokenOrder", "any") 23 .append("fuzzy", 24 new Document("maxEdits", 2) 25 .append("prefixLength", 1) 26 .append("maxExpansions", 256)))); 27 28 // specify connection 29 String uri = "<connection-string>"; 30 31 // establish connection and set namespace 32 try (MongoClient mongoClient = MongoClients.create(uri)) { 33 MongoDatabase database = mongoClient.getDatabase("sample_mflix"); 34 MongoCollection<Document> collection = database.getCollection("movies"); 35 // run query and print results 36 collection.aggregate(Arrays.asList(agg, 37 limit(5), 38 project(fields(excludeId(), include("title", "plot"))))) 39 .forEach(doc -> System.out.println(doc.toJson())); 40 } 41 } 42 }
クエリは new
と purpose
の位置的距離が最大 5
語とする、 new purpose
というクエリ文字列を指定します。
1 import java.util.Arrays; 2 3 import static com.mongodb.client.model.Aggregates.limit; 4 import static com.mongodb.client.model.Aggregates.project; 5 import static com.mongodb.client.model.Projections.excludeId; 6 import static com.mongodb.client.model.Projections.fields; 7 import static com.mongodb.client.model.Projections.include; 8 import com.mongodb.client.MongoClient; 9 import com.mongodb.client.MongoClients; 10 import com.mongodb.client.MongoCollection; 11 import com.mongodb.client.MongoDatabase; 12 import org.bson.Document; 13 14 public class PartialMatchQuery { 15 public static void main( String[] args ) { 16 // define query 17 Document agg = new Document("$search", 18 new Document("index", "partial-match-tutorial") 19 .append("phrase", 20 new Document("path", "plot") 21 .append("query", "new purpose") 22 .append("slop", 5))); 23 24 // specify connection 25 String uri = "<connection-string>"; 26 27 // establish connection and set namespace 28 try (MongoClient mongoClient = MongoClients.create(uri)) { 29 MongoDatabase database = mongoClient.getDatabase("sample_mflix"); 30 MongoCollection<Document> collection = database.getCollection("movies"); 31 32 // run query and print results 33 collection.aggregate(Arrays.asList(agg, 34 limit(5), 35 project(fields(excludeId(), include("title", "plot"))))) 36 .forEach(doc -> System.out.println(doc.toJson())); 37 } 38 } 39 }
クエリでは (.*)
正規表現を使用して、任意の数の文字を部分クエリ文字列と照合します。
1 import java.util.Arrays; 2 3 import static com.mongodb.client.model.Aggregates.limit; 4 import static com.mongodb.client.model.Aggregates.project; 5 import static com.mongodb.client.model.Projections.excludeId; 6 import static com.mongodb.client.model.Projections.fields; 7 import static com.mongodb.client.model.Projections.include; 8 import com.mongodb.client.MongoClient; 9 import com.mongodb.client.MongoClients; 10 import com.mongodb.client.MongoCollection; 11 import com.mongodb.client.MongoDatabase; 12 import org.bson.Document; 13 14 public class PartialMatchQuery { 15 public static void main( String[] args ) { 16 // define query 17 Document agg = new Document("$search", 18 new Document ("index", "partial-match-tutorial") 19 .append("regex", 20 new Document("path", "plot") 21 .append("query", "(.*)new(.*) pur(.*)"))); 22 // specify connection 23 String uri = "<connection-string>"; 24 // establish connection and set namespace 25 try (MongoClient mongoClient = MongoClients.create(uri)) { 26 MongoDatabase database = mongoClient.getDatabase("sample_mflix"); 27 MongoCollection<Document> collection = database.getCollection("movies"); 28 // run query and print results 29 collection.aggregate(Arrays.asList(agg, 30 limit(5), 31 project(fields(excludeId(), include("title", "plot"))))) 32 .forEach(doc -> System.out.println(doc.toJson())); 33 } 34 } 35 }
クエリは、クエリ文字列の*
を使用して、部分クエリ文字列内の指定された単語の前後の 0
文字以上を照合します。
1 import java.util.Arrays; 2 3 import static com.mongodb.client.model.Aggregates.limit; 4 import static com.mongodb.client.model.Aggregates.project; 5 import static com.mongodb.client.model.Projections.excludeId; 6 import static com.mongodb.client.model.Projections.fields; 7 import static com.mongodb.client.model.Projections.include; 8 import com.mongodb.client.MongoClient; 9 import com.mongodb.client.MongoClients; 10 import com.mongodb.client.MongoCollection; 11 import com.mongodb.client.MongoDatabase; 12 import org.bson.Document; 13 14 public class PartialMatchQuery { 15 public static void main( String[] args ) { 16 // define query 17 Document agg = new Document("$search", 18 new Document ("index", "partial-match-tutorial") 19 .append("wildcard", 20 new Document("path", "plot") 21 .append("query", "*new* pur*"))); 22 // specify connection 23 String uri = "<connection-string>"; 24 // establish connection and set namespace 25 try (MongoClient mongoClient = MongoClients.create(uri)) { 26 MongoDatabase database = mongoClient.getDatabase("sample_mflix"); 27 MongoCollection<Document> collection = database.getCollection("movies"); 28 // run query and print results 29 collection.aggregate(Arrays.asList(agg, 30 limit(5), 31 project(fields(excludeId(), include("title", "plot"))))) 32 .forEach(doc -> System.out.println(doc.toJson())); 33 } 34 } 35 }
注意
Maven 環境でサンプル コードを実行するには、 ファイルのインポート ステートメントの上に以下を追加します。
package com.mongodb.drivers;
サンプルを実行する前に、<connection-string>
をAtlas接続stringに置き換えます。 接続stringにデータベースユーザーの認証情報が含まれていることを確認します。 詳しくは、「ドライバーによる接続 」を参照してください。
PartialMatchQuery.java
ファイルをコンパイルして実行します。
javac PartialMatchQuery.java java PartialMatchQuery
{ "plot": "A divorced woman and her diabetic daughter take refuge in their newly-purchased house's safe room, when three men break-in, searching for a missing fortune.", "title": "Panic Room" } { "plot": "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", "title": "Her" } { "plot": "Set in the near future when artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has purchased. He must therefore go on the run before said ticker is repossessed.", "title": "Repo Men" } { "plot": "A psychologically troubled novelty supplier is nudged towards a romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and purchasing stunning amounts of pudding.", "title": "Punch-Drunk Love" } { "plot": "Jack Conrad is awaiting the death penalty in a corrupt Central American prison. He is \"purchased\" by a wealthy television producer and taken to a desolate island where he must fight to the death against nine other condemned killers from all corners of the world, with freedom going to the sole survivor.", "title": "The Condemned" }
javac PartialMatchQuery.java java PartialMatchQuery
{ "plot": "The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.", "title": "Music Within" } { "plot": "The supervillain Megamind finally defeats his nemesis, the superhero Metro Man. But without a hero, he loses all purpose and must find new meaning to his life.", "title": "Megamind" } { "plot": "An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy New Mexico cattle barons--his sole purpose being to bring down his old friend Billy the Kid.", "title": "Pat Garrett & Billy the Kid" }
javac PartialMatchQuery.java java PartialMatchQuery
{ "plot": "After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.", "title": "Star Wars: Episode V - The Empire Strikes Back" } { "plot": "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", "title": "Major League" } { "plot": "The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.", "title": "Music Within" } { "plot": "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", "title": "Her" } { "plot": "An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.", "title": "Kick" }
javac PartialMatchQuery.java java PartialMatchQuery
{ "plot": "After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.", "title": "Star Wars: Episode V - The Empire Strikes Back" } { "plot": "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", "title": "Major League" } { "plot": "The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.", "title": "Music Within" } { "plot": "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", "title": "Her" } { "plot": "An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.", "title": "Kick" }
インデックスを作成した演算子のコードをコピーして PartialMatchQuery.kt
ファイルに貼り付けます。
このコード例では、次のタスクを実行します。
mongodb
パッケージと依存関係をインポートします。Atlas クラスターへの接続を確立します。
以下を使用するクエリを実行します。
クエリに一致するドキュメントを
AggregateFlow
インスタンスから出力します。
このクエリでは、クエリ文字列new
purchase
をフィールド内の単語と照合するために、次の操作が実行されます。
new
とpurchase
という単語をplot
フィールドのどこにでも表示できます。クエリをフィールド内の単語と一致させるためにクエリ文字列に 2 文字のバリエーションを含めることはできますが、クエリ文字列の最初の文字は変更できません。
最大 256 語の類似タームを検討できます。
1 import com.mongodb.client.model.Aggregates.limit 2 import com.mongodb.client.model.Aggregates.project 3 import com.mongodb.client.model.Projections.* 4 import com.mongodb.kotlin.client.coroutine.MongoClient 5 import kotlinx.coroutines.runBlocking 6 import org.bson.Document 7 8 fun main() { 9 // establish connection and set namespace 10 val uri = "<connection-string>" 11 val mongoClient = MongoClient.create(uri) 12 val database = mongoClient.getDatabase("sample_mflix") 13 val collection = database.getCollection<Document>("movies") 14 15 runBlocking { 16 // define query 17 val agg = Document( 18 "\$search", 19 Document("index", "partial-match-tutorial") 20 .append( 21 "autocomplete", 22 Document("path", "plot") 23 .append("query", "new purchase") 24 .append("tokenOrder", "any") 25 .append( 26 "fuzzy", 27 Document("maxEdits", 2) 28 .append("prefixLength", 1) 29 .append("maxExpansions", 256) 30 ) 31 ) 32 ) 33 34 // run query and print results 35 val resultsFlow = collection.aggregate<Document>( 36 listOf( 37 agg, 38 limit(5), 39 project(fields(excludeId(), include("title", "plot"))) 40 ) 41 ) 42 resultsFlow.collect { println(it) } 43 } 44 mongoClient.close() 45 }
クエリは new
と purpose
の位置的距離が最大 5
語とする、 new purpose
というクエリ文字列を指定します。
1 import com.mongodb.client.model.Aggregates.limit 2 import com.mongodb.client.model.Aggregates.project 3 import com.mongodb.client.model.Projections.* 4 import com.mongodb.kotlin.client.coroutine.MongoClient 5 import kotlinx.coroutines.runBlocking 6 import org.bson.Document 7 8 fun main() { 9 // establish connection and set namespace 10 val uri = "<connection-string>" 11 val mongoClient = MongoClient.create(uri) 12 val database = mongoClient.getDatabase("sample_mflix") 13 val collection = database.getCollection<Document>("movies") 14 15 runBlocking { 16 // define query 17 val agg = Document( 18 "\$search", 19 Document("index", "partial-match-tutorial") 20 .append( 21 "phrase", 22 Document("path", "plot") 23 .append("query", "new purpose") 24 .append("slop", 5) 25 ) 26 ) 27 28 // run query and print results 29 val resultsFlow = collection.aggregate<Document>( 30 listOf( 31 agg, 32 limit(5), 33 project(fields(excludeId(), include("title", "plot"))) 34 ) 35 ) 36 resultsFlow.collect { println(it) } 37 } 38 mongoClient.close() 39 }
クエリでは (.*)
正規表現を使用して、任意の数の文字を部分クエリ文字列と照合します。
1 import com.mongodb.client.model.Aggregates.limit 2 import com.mongodb.client.model.Aggregates.project 3 import com.mongodb.client.model.Projections.* 4 import com.mongodb.kotlin.client.coroutine.MongoClient 5 import kotlinx.coroutines.runBlocking 6 import org.bson.Document 7 8 fun main() { 9 // establish connection and set namespace 10 val uri = "<connection-string>" 11 val mongoClient = MongoClient.create(uri) 12 val database = mongoClient.getDatabase("sample_mflix") 13 val collection = database.getCollection<Document>("movies") 14 15 runBlocking { 16 // define query 17 val agg = Document( 18 "\$search", 19 Document("index", "partial-match-tutorial") 20 .append( 21 "regex", 22 Document("path", "plot") 23 .append("query", "(.*)new(.*) pur(.*)") 24 ) 25 ) 26 27 // run query and print results 28 val resultsFlow = collection.aggregate<Document>( 29 listOf( 30 agg, 31 limit(5), 32 project(fields(excludeId(), include("title", "plot"))) 33 ) 34 ) 35 resultsFlow.collect { println(it) } 36 } 37 mongoClient.close() 38 }
クエリは、クエリ文字列の*
を使用して、部分クエリ文字列内の指定された単語の前後の 0
文字以上を照合します。
1 import com.mongodb.client.model.Aggregates.limit 2 import com.mongodb.client.model.Aggregates.project 3 import com.mongodb.client.model.Projections.* 4 import com.mongodb.kotlin.client.coroutine.MongoClient 5 import kotlinx.coroutines.runBlocking 6 import org.bson.Document 7 8 fun main() { 9 // establish connection and set namespace 10 val uri = "<connection-string>" 11 val mongoClient = MongoClient.create(uri) 12 val database = mongoClient.getDatabase("sample_mflix") 13 val collection = database.getCollection<Document>("movies") 14 15 runBlocking { 16 // define query 17 val agg = Document( 18 "\$search", 19 Document("index", "partial-match-tutorial") 20 .append( 21 "wildcard", 22 Document("path", "plot") 23 .append("query", "*new* pur*") 24 ) 25 ) 26 27 // run query and print results 28 val resultsFlow = collection.aggregate<Document>( 29 listOf( 30 agg, 31 limit(5), 32 project(fields(excludeId(), include("title", "plot"))) 33 ) 34 ) 35 resultsFlow.collect { println(it) } 36 } 37 mongoClient.close() 38 }
サンプルを実行する前に、<connection-string>
をAtlas接続stringに置き換えます。 接続stringにデータベースユーザーの認証情報が含まれていることを確認します。 詳しくは、「ドライバーによる接続 」を参照してください。
PartialMatchQuery.kt
ファイルを実行します。
IDE でPartialMatchQuery.kt
プログラムを実行すると、次のドキュメントが出力されます。
Document{{plot=A divorced woman and her diabetic daughter take refuge in their newly-purchased house's safe room, when three men break-in, searching for a missing fortune., title=Panic Room}} Document{{plot=A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need., title=Her}} Document{{plot=A country boy becomes the head of a gang through the purchase of some lucky roses from an old lady. He and a singer at the gang's nightclub try to do a good deed for the old lady when her daughter comes to visit., title=Miracles - Mr. Canton and Lady Rose}} Document{{plot=A psychologically troubled novelty supplier is nudged towards a romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and purchasing stunning amounts of pudding., title=Punch-Drunk Love}} Document{{plot=Jack Conrad is awaiting the death penalty in a corrupt Central American prison. He is "purchased" by a wealthy television producer and taken to a desolate island where he must fight to the death against nine other condemned killers from all corners of the world, with freedom going to the sole survivor., title=The Condemned}}
Document{{plot=The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities., title=Music Within}} Document{{plot=The supervillain Megamind finally defeats his nemesis, the superhero Metro Man. But without a hero, he loses all purpose and must find new meaning to his life., title=Megamind}} Document{{plot=An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy New Mexico cattle barons--his sole purpose being to bring down his old friend Billy the Kid., title=Pat Garrett & Billy the Kid}}
Document{{plot=After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke., title=Star Wars: Episode V - The Empire Strikes Back}} Document{{plot=The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her., title=Major League}} Document{{plot=The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities., title=Music Within}} Document{{plot=A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need., title=Her}} Document{{plot=An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster., title=Kick}}
Document{{plot=After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke., title=Star Wars: Episode V - The Empire Strikes Back}} Document{{plot=The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her., title=Major League}} Document{{plot=The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities., title=Music Within}} Document{{plot=A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need., title=Her}} Document{{plot=An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster., title=Kick}}
インデックスを作成した演算子のコードをコピーして partial-match-query.js
ファイルに貼り付けます。
このコード例では、次のタスクを実行します。
MongoDB の Node.js ドライバーである
mongodb
をインポートします。Atlas クラスターへの接続を確立するための
MongoClient
クラスのインスタンスを作成します。以下を使用するクエリを実行します。
カーソルを反復処理して、クエリに一致するドキュメントを出力します。
このクエリでは、クエリ文字列new
purchase
をフィールド内の単語と照合するために、次の操作が実行されます。
new
とpurchase
という単語をplot
フィールドのどこにでも表示できます。クエリをフィールド内の単語と一致させるためにクエリ文字列に 2 文字のバリエーションを含めることはできますが、クエリ文字列の最初の文字は変更できません。
最大 256 語の類似タームを検討できます。
1 const MongoClient = require("mongodb").MongoClient; 2 const assert = require("assert"); 3 4 const agg = [ 5 { 6 '$search': { 7 'index': 'partial-match-tutorial', 8 'autocomplete': { 9 'path': 'plot', 10 'query': 'new purchase', 11 'tokenOrder': 'any', 12 'fuzzy': { 13 'maxEdits': 2, 14 'prefixLength': 1, 15 'maxExpansions': 256 16 } 17 }, 18 'highlight': { 19 'path': 'plot' 20 } 21 } 22 }, { 23 '$limit': 5 24 }, { 25 '$project': { 26 '_id': 0, 27 'title': 1, 28 'plot': 1, 29 'highlights': { 30 '$meta': 'searchHighlights' 31 } 32 } 33 } 34 ]; 35 36 MongoClient.connect( 37 "<connection-string>", 38 { useNewUrlParser: true, useUnifiedTopology: true }, 39 async function (connectErr, client) { 40 assert.equal(null, connectErr); 41 const coll = client.db("sample_mflix").collection("movies"); 42 let cursor = await coll.aggregate(agg); 43 await cursor.forEach((doc) => console.log(doc)); 44 client.close(); 45 } 46 );
クエリは new
と purpose
の位置的距離が最大 5
語とする、 new purpose
というクエリ文字列を指定します。
1 const MongoClient = require("mongodb").MongoClient; 2 const assert = require("assert"); 3 4 const agg = [ 5 { 6 '$search': { 7 'index': 'partial-match-tutorial', 8 'phrase': { 9 'path': 'plot', 10 'query': 'new purpose', 11 'slop': 5 12 }, 13 'highlight': { 14 'path': 'plot' 15 } 16 } 17 }, { 18 '$limit': 5 19 }, { 20 '$project': { 21 '_id': 0, 22 'plot': 1, 23 'title': 1, 24 'highlights': { 25 '$meta': 'searchHighlights' 26 } 27 } 28 } 29 ]; 30 31 MongoClient.connect( 32 "<connection-string>", 33 { useNewUrlParser: true, useUnifiedTopology: true }, 34 async function (connectErr, client) { 35 assert.equal(null, connectErr); 36 const coll = client.db("sample_mflix").collection("movies"); 37 let cursor = await coll.aggregate(agg); 38 await cursor.forEach((doc) => console.log(doc)); 39 client.close(); 40 } 41 );
クエリでは (.*)
正規表現を使用して、任意の数の文字を部分クエリ文字列と照合します。
1 const MongoClient = require("mongodb").MongoClient; 2 const assert = require("assert"); 3 4 const agg = [ 5 { 6 '$search': { 7 'index': 'partial-match-tutorial', 8 'regex': { 9 'path': 'plot', 10 'query': '(.*)new(.*) pur(.*)' 11 } 12 } 13 }, { 14 '$limit': 5 15 }, { 16 '$project': { 17 '_id': 0, 18 'plot': 1, 19 'title': 1 20 } 21 } 22 ]; 23 24 MongoClient.connect( 25 "<connection-string>", 26 { useNewUrlParser: true, useUnifiedTopology: true }, 27 async function (connectErr, client) { 28 assert.equal(null, connectErr); 29 const coll = client.db("sample_mflix").collection("movies"); 30 let cursor = await coll.aggregate(agg); 31 await cursor.forEach((doc) => console.log(doc)); 32 client.close(); 33 } 34 );
クエリは、クエリ文字列の*
を使用して、部分クエリ文字列内の指定された単語の前後の 0
文字以上を照合します。
1 const MongoClient = require("mongodb").MongoClient; 2 const assert = require("assert"); 3 4 const agg = [ 5 { 6 '$search': { 7 'index': 'partial-match-tutorial', 8 'wildcard': { 9 'path': 'plot', 10 'query': '*new* pur*' 11 } 12 } 13 }, { 14 '$limit': 5 15 }, { 16 '$project': { 17 '_id': 0, 18 'plot': 1, 19 'title': 1 20 } 21 } 22 ]; 23 24 MongoClient.connect( 25 "<connection-string>", 26 { useNewUrlParser: true, useUnifiedTopology: true }, 27 async function (connectErr, client) { 28 assert.equal(null, connectErr); 29 const coll = client.db("sample_mflix").collection("movies"); 30 let cursor = await coll.aggregate(agg); 31 await cursor.forEach((doc) => console.log(doc)); 32 client.close(); 33 } 34 );
注意
サンプルを実行する前に、<connection-string>
をAtlas接続stringに置き換えます。 接続stringにデータベースユーザーの認証情報が含まれていることを確認します。 詳しくは、「ドライバーによる接続 」を参照してください。
次のコマンドを実行して、コレクションをクエリします。
node partial-match-query.js
{ plot: "A divorced woman and her diabetic daughter take refuge in their newly-purchased house's safe room, when three men break-in, searching for a missing fortune.", title: 'Panic Room', highlights: [ { score: 4.364492893218994, path: 'plot', texts: [Array] } ] } { plot: "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", title: 'Her', highlights: [ { score: 4.198050022125244, path: 'plot', texts: [Array] } ] } { plot: "Set in the near future when artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has purchased. He must therefore go on the run before said ticker is repossessed.", title: 'Repo Men', highlights: [ { score: 2.6448397636413574, path: 'plot', texts: [Array] } ] } { plot: 'A psychologically troubled novelty supplier is nudged towards a romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and purchasing stunning amounts of pudding.', title: 'Punch-Drunk Love', highlights: [ { score: 1.2451990842819214, path: 'plot', texts: [Array] } ] } { plot: 'Jack Conrad is awaiting the death penalty in a corrupt Central American prison. He is "purchased" by a wealthy television producer and taken to a desolate island where he must fight to the death against nine other condemned killers from all corners of the world, with freedom going to the sole survivor.', title: 'The Condemned', highlights: [ { score: 2.94378924369812, path: 'plot', texts: [Array] } ] }
node partial-match-query.js
{ plot: 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', title: 'Music Within', highlights: [ { score: 1.9394469261169434, path: 'plot', texts: [Array] } ] } { plot: 'The supervillain Megamind finally defeats his nemesis, the superhero Metro Man. But without a hero, he loses all purpose and must find new meaning to his life.', title: 'Megamind', highlights: [ { score: 2.90376877784729, path: 'plot', texts: [Array] } ] } { plot: 'An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy New Mexico cattle barons--his sole purpose being to bring down his old friend Billy the Kid.', title: 'Pat Garrett & Billy the Kid', highlights: [ { score: 2.115748405456543, path: 'plot', texts: [Array] } ] }
node partial-match-query.js
{ plot: 'After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.', title: 'Star Wars: Episode V - The Empire Strikes Back' } { plot: "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", title: 'Major League' } { plot: 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', title: 'Music Within' } { plot: "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", title: 'Her' } { plot: 'An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.', title: 'Kick' }
node partial-match-query.js
{ plot: 'After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.', title: 'Star Wars: Episode V - The Empire Strikes Back' } { plot: "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", title: 'Major League' } { plot: 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', title: 'Music Within' } { plot: "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", title: 'Her' } { plot: 'An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.', title: 'Kick' }
インデックスを作成した演算子のコードをコピーして partial-match-query.py
ファイルに貼り付けます。
次のコード例では、次を行います。
pymongo
、MongoDB の Python ドライバー、およびDNSシード リスト接続文字列を使用してpymongo
をAtlas
に接続するために必要なdns
モジュールをインポートします。Atlas クラスターへの接続を確立するための
MongoClient
クラスのインスタンスを作成します。以下を使用するクエリを実行します。
カーソルを反復処理して、クエリに一致するドキュメントを出力します。
このクエリでは、クエリ文字列new
purchase
をフィールド内の単語と照合するために、次の操作が実行されます。
new
とpurchase
という単語をplot
フィールドのどこにでも表示できます。クエリをフィールド内の単語と一致させるためにクエリ文字列に 2 文字のバリエーションを含めることはできますが、クエリ文字列の最初の文字は変更できません。
最大 256 語の類似タームを検討できます。
1 import pymongo 2 import dns 3 4 client = pymongo.MongoClient('<connection-string>') 5 result = client['sample_mflix']['movies'].aggregate([ 6 { 7 '$search': { 8 'index': 'partial-match-tutorial', 9 'autocomplete': { 10 'path': 'plot', 11 'query': 'new purchase', 12 'tokenOrder': 'any', 13 'fuzzy': { 14 'maxEdits': 2, 15 'prefixLength': 1, 16 'maxExpansions': 256 17 } 18 }, 19 'highlight': { 20 'path': 'plot' 21 } 22 } 23 }, { 24 '$limit': 5 25 }, { 26 '$project': { 27 '_id': 0, 28 'title': 1, 29 'plot': 1, 30 'highlights': { 31 '$meta': 'searchHighlights' 32 } 33 } 34 } 35 ]) 36 37 for i in result: 38 print(i)
クエリは new
と purpose
の位置的距離が最大 5
語とする、 new purpose
というクエリ文字列を指定します。
1 import pymongo 2 import dns 3 4 client = pymongo.MongoClient('<connection-string>') 5 result = client['sample_mflix']['movies'].aggregate([ 6 { 7 '$search': { 8 'index': 'partial-match-tutorial', 9 'phrase': { 10 'path': 'plot', 11 'query': 'new purpose', 12 'slop': 5 13 }, 14 'highlight': { 15 'path': 'plot' 16 } 17 } 18 }, { 19 '$limit': 5 20 }, { 21 '$project': { 22 '_id': 0, 23 'plot': 1, 24 'title': 1, 25 'highlights': { 26 '$meta': 'searchHighlights' 27 } 28 } 29 } 30 ]) 31 32 for i in result: 33 print(i)
クエリでは (.*)
正規表現を使用して、任意の数の文字を部分クエリ文字列と照合します。
1 import pymongo 2 import dns 3 4 client = pymongo.MongoClient('<connection-string>') 5 result = client['sample_mflix']['movies'].aggregate([ 6 { 7 '$search': { 8 'index': 'partial-match-tutorial', 9 'regex': { 10 'path': 'plot', 11 'query': '(.*)new(.*) pur(.*)' 12 } 13 } 14 }, { 15 '$limit': 5 16 }, { 17 '$project': { 18 '_id': 0, 19 'plot': 1, 20 'title': 1 21 } 22 } 23 ]) 24 25 for i in result: 26 print(i)
クエリは、クエリ文字列の*
を使用して、部分クエリ文字列内の指定された単語の前後の 0
文字以上を照合します。
1 import pymongo 2 import dns 3 4 client = pymongo.MongoClient('<connection-string>') 5 result = client['sample_mflix']['movies'].aggregate([ 6 { 7 '$search': { 8 'index': 'partial-match-tutorial', 9 'wildcard': { 10 'path': 'plot', 11 'query': '*new* pur*' 12 } 13 } 14 }, { 15 '$limit': 5 16 }, { 17 '$project': { 18 '_id': 0, 19 'plot': 1, 20 'title': 1 21 } 22 } 23 ]) 24 25 for i in result: 26 print(i)
注意
サンプルを実行する前に、<connection-string>
をAtlas接続stringに置き換えます。 接続stringにデータベースユーザーの認証情報が含まれていることを確認します。 詳しくは、「ドライバーによる接続 」を参照してください。
次のコマンドを実行して、コレクションをクエリします。
python partial-match-query.py
{ 'plot': "A divorced woman and her diabetic daughter take refuge in their newly-purchased house's safe room, when three men break-in, searching for a missing fortune.", 'title': 'Panic Room', 'highlights': [{ 'score': 4.364492893218994, 'path': 'plot', 'texts': [ {'value': 'A divorced woman and her diabetic daughter take refuge in their ', 'type': 'text'}, {'value': "newly-purchased house's safe", 'type': 'hit'}, {'value': ' room, when three men break-in, searching for a missing fortune.', 'type': 'text'} ] }] } { 'plot': "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", 'title': 'Her', 'highlights': [{ 'score': 4.198050022125244, 'path': 'plot', 'texts': [ {'value': 'A lonely writer develops an unlikely relationship with his ', 'type': 'text'}, {'value': 'newly purchased operating system', 'type': 'hit'}, {'value': " that's designed to meet his every ", 'type': 'text'}, {'value': 'need', 'type': 'hit'}, {'value': '.', 'type': 'text'} ] }] } { 'plot': "Set in the near future when artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has purchased. He must therefore go on the run before said ticker is repossessed.", 'title': 'Repo Men', 'highlights': [{ 'score': 2.6448397636413574, 'path': 'plot', 'texts': [ {'value': 'Set in the ', 'type': 'text'}, {'value': 'near future when', 'type': 'hit'}, {'value': ' artificial organs can be bought on credit, it revolves around a man who struggles to make the payments on a heart he has ', 'type': 'text'}, {'value': 'purchased. He must', 'type': 'hit'} ] }] } { 'plot': 'A psychologically troubled novelty supplier is nudged towards a romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and purchasing stunning amounts of pudding.', 'title': 'Punch-Drunk Love', 'highlights': [{ 'score': 1.2451990842819214, 'path': 'plot', 'texts': [ {'value': 'A psychologically troubled ', 'type': 'text'}, {'value': 'novelty supplier is', 'type': 'hit'}, {'value': ' ', 'type': 'text'}, {'value': 'nudged towards a', 'type': 'hit'}, {'value': ' romance with an English woman, all the while being extorted by a phone-sex line run by a crooked mattress salesman, and ', 'type': 'text'}, {'value': 'purchasing stunning amounts', 'type': 'hit'}, {'value': ' of pudding.', 'type': 'text'} ] }] } { 'plot': 'Jack Conrad is awaiting the death penalty in a corrupt Central American prison. He is "purchased" by a wealthy television producer and taken to a desolate island where he must fight to the death against nine other condemned killers from all corners of the world, with freedom going to the sole survivor.', 'title': 'The Condemned', 'highlights': [{ 'score': 2.94378924369812, 'path': 'plot', 'texts': [ {'value': 'He is "', 'type': 'text'}, {'value': 'purchased" by a', 'type': 'hit'}, {'value': ' wealthy television producer and taken to a desolate island where he must fight to the death against ', 'type': 'text'}, {'value': 'nine other condemned', 'type': 'hit'}, {'value': ' killers from all corners of the world, with freedom going to the sole survivor.', 'type': 'text'} ] }] }
python partial-match-query.py
{ 'plot': 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', 'title': 'Music Within', 'highlights': [{ 'score': 1.9394469261169434, 'path': 'plot', 'texts': [ {'value': 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a ', 'type': 'text'}, {'value': 'new', 'type': 'hit'}, {'value': ' ', 'type': 'text'}, {'value': 'purpose', 'type': 'hit'}, {'value': ' in his landmark efforts on the behalf of Americans with disabilities.', 'type': 'text'} ] }] } { 'plot': 'The supervillain Megamind finally defeats his nemesis, the superhero Metro Man. But without a hero, he loses all purpose and must find new meaning to his life.', 'title': 'Megamind', 'highlights': [{ 'score': 2.90376877784729, 'path': 'plot', 'texts': [ {'value': 'But without a hero, he loses all ', 'type': 'text'}, {'value': 'purpose', 'type': 'hit'}, {'value': ' and must find ', 'type': 'text'}, {'value': 'new', 'type': 'hit'}, {'value': ' meaning to his life.', 'type': 'text'} ] }] } { 'plot': 'An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy New Mexico cattle barons--his sole purpose being to bring down his old friend Billy the Kid.', 'title': 'Pat Garrett & Billy the Kid', 'highlights': [{ 'score': 2.115748405456543, 'path': 'plot', 'texts': [ {'value': 'An aging Pat Garrett is hired as a lawman on behalf of a group of wealthy ', 'type': 'text'}, {'value': 'New', 'type': 'hit'}, {'value': ' Mexico cattle barons--his sole ', 'type': 'text'}, {'value': 'purpose', 'type': 'hit'}, {'value': ' being to bring down his old friend Billy the Kid.', 'type': 'text'} ] }] }
python partial-match-query.py
{ 'plot': 'After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.', 'title': 'Star Wars: Episode V - The Empire Strikes Back' } { 'plot': "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", 'title': 'Major League' } { 'plot': 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', 'title': 'Music Within' } { 'plot': "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", 'title': 'Her' } { 'plot': 'An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.', 'title': 'Kick' }
python partial-match-query.py
{ 'plot': 'After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke.', 'title': 'Star Wars: Episode V - The Empire Strikes Back' } { 'plot': "The new owner of the Cleveland Indians puts together a purposely horrible team so they'll lose and she can move the team. But when the plot is uncovered, they start winning just to spite her.", 'title': 'Major League' } { 'plot': 'The true story of Richard Pimentel, a brilliant public speaker with a troubled past, who returns from Vietnam severely hearing -impaired and finds a new purpose in his landmark efforts on the behalf of Americans with disabilities.', 'title': 'Music Within' } { 'plot': "A lonely writer develops an unlikely relationship with his newly purchased operating system that's designed to meet his every need.", 'title': 'Her' } { 'plot': 'An adrenaline junkie walks away from a whirlwind romance and embraces a new life as a thief, though he soon finds himself pursued by veteran police officer and engaged in a turf war with a local gangster.', 'title': 'Kick' }