# 9.15. ODPI-C SODA Collection Functions

SODA collection handles are used to represent SODA collections in the database. They are created by calling one of the functions `dpiSodaDb_createCollection()`, `dpiSodaDb_openCollection()` or `dpiSodaCollCursor_getNext()` and are destroyed when the last reference is released by calling the function `dpiSodaColl_release()`.

See this tracking issue for known issues with SODA.

int dpiSodaColl_addRef(dpiSodaColl *coll)

  Adds a reference to the SODA collection. This is intended for situations where a reference to the collection needs to be maintained independently of the reference returned when the collection was created.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection to which a reference is to be added. If the reference is NULL or invalid, an error is returned.

int dpiSodaColl_createIndex(dpiSodaColl *coll, const char *indexSpec, uint32_t indexSpecLength, uint32_t flags)

  Create an index on the collection, which can improve the performance of SODA query-by-examples (QBE). An index is defined by a specification, which is a JSON-encoded string that specifies how particular QBE patterns are to be indexed for quicker matching. See Overview of SODA indexing.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection on which the index is to be created. If the reference is NULL or invalid, an error is returned.
  `indexSpec` | IN | The JSON specification of the index as a byte string in the encoding used for CHAR data.
  `indexSpecLength` | IN | The length of the specification of the index, in bytes.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.

int dpiSodaColl_drop(dpiSodaColl *coll, uint32_t flags, int *isDropped)

  Drops a SODA collection from the database.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection which is to be dropped. If the reference is NULL or invalid, an error is returned.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `isDropped` | OUT | A pointer to a boolean which indicates whether the collection was dropped (1) or not (0). If this information is not needed, NULL can also be passed.

int dpiSodaColl_dropIndex(dpiSodaColl *coll, const char *name, uint32_t nameLength, uint32_t flags, int *isDropped)

  Drop an index on the collection.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection on which the index is to be dropped. If the reference is NULL or invalid, an error is returned.
  `name` | IN | The name of the index that is to be dropped as a byte string in the encoding used for CHAR data.
  `nameLength` | IN | The length of the index name, in bytes.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `isDropped` | OUT | A pointer to a boolean which indicates whether the specified index was dropped (1) or not (0). If this information is not needed, NULL can also be passed.

int dpiSodaColl_find(dpiSodaColl *coll, const dpiSodaOperOptions *options, uint32_t flags, dpiSodaDocCursor **cursor)

  Finds all of the documents in the collection that match the specified options.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection which is to be searched. If the reference is NULL or invalid, an error is returned.
  `options` | IN | A pointer to a structure of type dpiSodaOperOptions which specifies options for restricting the number of documents returned. This value can also be NULL which will result in all documents in the collection being returned.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `cursor` | OUT | A pointer to a reference to the cursor that is populated if the function completes successfully. The reference that is returned should be released using `dpiSodaDocCursor_release()` when it is no longer needed.

int dpiSodaColl_findOne(dpiSodaColl *coll, const dpiSodaOperOptions *options, uint32_t flags, dpiSodaDoc **doc)

  Finds a single document in the collection that matches the specified options.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection which is to be searched. If the reference is NULL or invalid, an error is returned.
  `options` | IN | A pointer to a structure of type dpiSodaOperOptions which specifies options for restricting the document that is returned. This value can also be NULL which will result in the first document in the collection being returned.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `doc` | OUT | A pointer to a reference to the document that is populated if the function completes successfully. The reference that is returned should be released using `dpiSodaDoc_release()` when it is no longer needed. If no document matches the specified options, the value NULL is returned instead.

int dpiSodaColl_getDataGuide(dpiSodaColl *coll, uint32_t flags, dpiSodaDoc **doc)

  Returns a document containing the data guide for the collection. See JSON Data Guide.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection from which the data guide is to be retrieved. If the reference is NULL or invalid, an error is returned.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `doc` | OUT | A pointer to a reference to the document that is populated if the function completes successfully. The document reference that is returned should be released using `dpiSodaDoc_release()` when it is no longer needed. If no data guide is available because the collection contains no documents, then a NULL reference is returned.

int dpiSodaColl_getDocCount(dpiSodaColl *coll, const dpiSodaOperOptions *options, uint32_t flags, uint64_t *count)

  Returns the number of documents in the collection that match the specified options.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection which is to be searched. If the reference is NULL or invalid, an error is returned.
  `options` | IN | A pointer to a structure of type dpiSodaOperOptions which specifies options for restricting the number of documents found. This value can also be NULL which will result in all of the documents in the collection being counted.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `count` | OUT | A pointer to a count of the number of documents found that is populated if the function completes successfully.

int dpiSodaColl_getMetadata(dpiSodaColl *coll, const char **value, uint32_t *valueLength)

  Returns the metadata for the collection.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection from which the metadata is to be retrieved. If the reference is NULL or invalid, an error is returned.
  `value` | IN | A pointer to the collection metadata, as a byte string in the encoding used for CHAR data, which will be populated upon successful completion of this function. The string returned will remain valid as long as a reference to the collection is held.
  `valueLength` | OUT | A pointer to the length of the collection metadata, in bytes, which will be populated upon successful completion of this function.

int dpiSodaColl_getName(dpiSodaColl *coll, const char **value, uint32_t *valueLength)

  Returns the name of the collection.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection from which the name is to be retrieved. If the reference is NULL or invalid, an error is returned.
  `value` | IN | A pointer to the collection name, as a byte string in the encoding used for CHAR data, which will be populated upon successful completion of this function. The string returned will remain valid as long as a reference to the collection is held.
  `valueLength` | OUT | A pointer to the length of the collection name, in bytes, which will be populated upon successful completion of this function.

int dpiSodaColl_insertMany(dpiSodaColl *coll, uint32_t numDocs, dpiSodaDoc **docs, uint32_t flags, dpiSodaDoc **insertedDocs)

  Inserts multiple documents into the collection and optionally returns result documents containing information about the newly inserted documents.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure. On failure the offset attribute in the dpiErrorInfo structure will contain the index into the SODA document handles array where the error took place.

  NOTE: this function requires Oracle Client 18.5 or higher in addition to the usual SODA requirements and is currently available only as a preview.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection into which the documents are to be inserted. If the reference is NULL or invalid, an error is returned.
  `numDocs` | IN | The length of the arrays passed for the docs and insertedDocs parameters.
  `docs` | IN | An array of SODA document handles which will be inserted into the collection. The length of the array is determined by the numDocs parameter.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.

  `insertedDocs`

  OUT

  A pointer to an array of document references that will be populated upon successful completion of this function. The length of the array is determined by the numDocs parameter. Call the function `dpiSodaDoc_release()` for each of the elements of this array when the references contained in the array are no longer needed. This parameter can also be NULL if this information is not required.

int dpiSodaColl_insertManyWithOptions(dpiSodaColl *coll, uint32_t numDocs, dpiSodaDoc **docs, dpiSodaOperOptions *options, uint32_t flags, dpiSodaDoc **insertedDocs)

  Inserts multiple documents into the collection and optionally returns result documents containing information about the newly inserted documents. In addition, options can be supplied to modify how the documents are inserted or returned.

  This function requires Oracle Client 21.3 or higher to be used in addition to the normal SODA requirements (also available in Oracle Client 19 from 19.11).

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure. On failure the offset attribute in the dpiErrorInfo structure will contain the index into the SODA document handles array where the error took place.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection into which the documents are to be inserted. If the reference is NULL or invalid, an error is returned.
  `numDocs` | IN | The length of the arrays passed for the docs and insertedDocs parameters.
  `docs` | IN | An array of SODA document handles which will be inserted into the collection. The length of the array is determined by the numDocs parameter.
  `options` | IN | A pointer to a dpiSodaOperOptions structure containing any desired options, or NULL. If the value is NULL, this function behaves identically to `dpiSodaColl_insertMany()`. Options can only be specified with Oracle Client 21.3 or higher (also available in Oracle Client 19 from 19.11).
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.

  `insertedDocs`

  OUT

  A pointer to an array of document references that will be populated upon successful completion of this function. The length of the array is determined by the numDocs parameter. Call the function `dpiSodaDoc_release()` for each of the elements of this array when the references contained in the array are no longer needed. This parameter can also be NULL if this information is not required.

int dpiSodaColl_insertOne(dpiSodaColl *coll, dpiSodaDoc *doc, uint32_t flags, dpiSodaDoc **insertedDoc)

  Inserts a document into the collection and optionally returns it.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection into which the document is to be inserted. If the reference is NULL or invalid, an error is returned.
  `doc` | IN | A reference to the document which is to be inserted into the collection. If the reference is NULL or invalid, an error is returned.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `insertedDoc` | OUT | A pointer to a document reference that will be populated upon successful completion of this function. Call the function `dpiSodaDoc_release()` when it is no longer needed. This parameter can also be NULL if this information is not required.

int dpiSodaColl_insertOneWithOptions(dpiSodaColl *coll, dpiSodaDoc *doc, dpiSodaOperOptions *options, uint32_t flags, dpiSodaDoc **insertedDoc)

  Inserts a document into the collection and optionally returns it. In addition, options can be supplied to modify how the document is inserted or returned.

  This method requires Oracle Client 21.3 or higher to be used in addition to the normal SODA requirements (also available in Oracle Client 19 from 19.11).

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection into which the document is to be inserted. If the reference is NULL or invalid, an error is returned.
  `doc` | IN | A reference to the document which is to be inserted into the collection. If the reference is NULL or invalid, an error is returned.
  `options` | IN | A pointer to a dpiSodaOperOptions structure containing any desired options, or NULL. If the value is NULL, this function behaves identically to `dpiSodaColl_insertOne()`. Options can only be specified with Oracle Client 21.3 or higher (also available in Oracle Client 19 from 19.11).
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `insertedDoc` | OUT | A pointer to a document reference that will be populated upon successful completion of this function. Call the function `dpiSodaDoc_release()` when it is no longer needed. This parameter can also be NULL if this information is not required.

int dpiSodaColl_listIndexes(dpiSodaColl *coll, uint32_t flags, dpiStringList *list)

  Returns a list of indexes associated with the collection.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection from which the list of indexes is to be retrieved. If the reference is NULL or invalid, an error is returned.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `list` | OUT | A pointer to a structure of type dpiStringList which is populated if the function completes successfully. The memory associated with this list should be freed by calling `dpiContext_freeStringList()` when it is no longer needed.

int dpiSodaColl_release(dpiSodaColl *coll)

  Releases a reference to the SODA collection. A count of the references to the collection is maintained and when this count reaches zero, the memory associated with the collection is freed.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection from which a reference is to be released. If the reference is NULL or invalid, an error is returned.

int dpiSodaColl_remove(dpiSodaColl *coll, const dpiSodaOperOptions *options, uint32_t flags, uint64_t *count)

  Removes all of the documents in the collection that match the specified options.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection from which documents are to be removed. If the reference is NULL or invalid, an error is returned.
  `options` | IN | A pointer to a structure of type dpiSodaOperOptions which specifies options for restricting the number of documents removed. This value can also be NULL which will result in all documents in the collection being removed.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `count` | OUT | A pointer to a count of the number of documents removed that is populated if the function completes successfully.

int dpiSodaColl_replaceOne(dpiSodaColl *coll, const dpiSodaOperOptions *options, dpiSodaDoc *doc, uint32_t flags, int *replaced, dpiSodaDoc **replacedDoc)

  Replaces the single document in the collection matching the given options with the new document.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection in which the document is to be replaced. If the reference is NULL or invalid, an error is returned.
  `options` | IN | A pointer to a structure of type dpiSodaOperOptions which identifies options for specifying the document which is to be replaced. Currently at least the `dpiSodaOperOptions.key` member must be specified or the error “ORA-40734: key for the document to replace must be specified using the key attribute” will be raised.
  `doc` | IN | A reference to the document which is to replace the document in the collection found using the provided options. If the reference is NULL or invalid, an error is returned.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `replaced` | OUT | A pointer to a boolean value indicating if the document was replaced (1) or not (0). This parameter may also be NULL if this information is not required.
  `replacedDoc` | OUT | A pointer to a document reference which will be populated when this function returns successfully. Call the function `dpiSodaDoc_release()` when the reference is no longer needed. This parameter can also be NULL if this information is not required.

int dpiSodaColl_save(dpiSodaColl *coll, dpiSodaDoc *doc, uint32_t flags, dpiSodaDoc **savedDoc)

  Saves a document into the collection. This method is equivalent to `dpiSodaColl_insertOne()` except that if client-assigned keys are used, and the document with the specified key already exists in the collection, it will be replaced with the input document.

  This method requires Oracle Client 19.9 or higher to be used in addition to the normal SODA requirements.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection in which the document is to be saved. If the reference is NULL or invalid, an error is returned.
  `doc` | IN | A reference to the document which is to be saved into the collection. If the reference is NULL or invalid, an error is returned.
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `savedDoc` | OUT | A pointer to a document reference which will be populated when this function returns successfully. Call the function `dpiSodaDoc_release()` when the reference is no longer needed. This parameter can also be NULL if this information is not required.

int dpiSodaColl_saveWithOptions(dpiSodaColl *coll, dpiSodaDoc *doc, dpiSodaOperOptions *options, uint32_t flags, dpiSodaDoc **savedDoc)

  Saves a document into the collection. This method is equivalent to `dpiSodaColl_insertOneWithOptions()` except that if client-assigned keys are used, and the document with the specified key already exists in the collection, it will be replaced with the input document.

  This method requires Oracle Client 21.3 or higher to be used in addition to the normal SODA requirements (also available in Oracle Client 19 from 19.11).

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection in which the document is to be saved. If the reference is NULL or invalid, an error is returned.
  `doc` | IN | A reference to the document which is to be saved into the collection. If the reference is NULL or invalid, an error is returned.
  `options` | IN | A pointer to a dpiSodaOperOptions structure containing any desired options, or NULL. If the value is NULL, this function behaves identically to `dpiSodaColl_save()`. Options can only be specified with Oracle Client 21.3 or higher (also available in Oracle Client 19 from 19.11).
  `flags` | IN | One or more of the values from the enumeration dpiSodaFlags, OR’ed together.
  `savedDoc` | OUT | A pointer to a document reference which will be populated when this function returns successfully. Call the function `dpiSodaDoc_release()` when the reference is no longer needed. This parameter can also be NULL if this information is not required.

int dpiSodaColl_truncate(dpiSodaColl *coll)

  Removes all of the documents in a SODA collection in a similar manner to a TRUNCATE TABLE statement.

  The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.

  Parameter | Mode | Description
  --- | --- | ---
  `coll` | IN | A reference to the collection in which all of the documents are to be removed. If the reference is NULL or invalid, an error is returned.