ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Couchbase の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにCouchbase から関連するレスポンスデータを返します。
CData Excel Add-In for Couchbase ストアドプロシージャ
Name | Description |
AddDocument | Upsert entire JSON documents to Couchbase as-is. |
CreateBucket | Creates a new bucket in CouchBase. |
CreateCollection | Creates a collection under an existing scope |
CreateSchema | Creates a schema definition of a table in Couchbase. Results may change depending of the value of FlattenObjects, FlattenArrays, and TypeDetectionScheme. |
CreateScope | Creates a scope under an existing bucket |
CreateSearchIndex | Creates a search index with the Search Service API in Couchbase. |
CreateUserTable | An internal operation used when GenerateSchemaFiles=OnCreate |
DeleteBucket | Deletes a bucket (and all its collections and scopes, where supported) |
DeleteCollection | Deletes a collection (Couchbase 7 and up) |
DeleteScope | Deletes a scope and all its collections (Couchbase 7 and up) |
ExecuteSearchIndex | Execute a search on an index using the Search Service API in Couchbase. |
FlushBucket | Removes all documents from a bucket in Couchbase. |
ListIndices | Lists all indices available in Couchbase |
ManageIndices | Creates/Drops an index in a target bucket in Couchbase. |