SqliteConn-class {biodb} | R Documentation

## SQLite connector class.

### Description

This is the abstract connector class for all SQLite databases.

### Methods

`getEntryContentFromDb(entry.id)`

  :

  Get the contents of entries directly from the database. A direct request or an access to the database will be made in order to retrieve the contents. No access to the biodb cache system will be made.

  entry.id: A character vector with the IDs of entries to retrieve.

  Returned value: A character vector, the same size of entry.id, with contents of the requested entries. An NA value will be set for the content of each entry for which the retrieval failed.

`isSearchableByField(field)`

  :

  Tests if a field can be used to search entries when using methods searchByName() and searchCompound().

  field: The name of the field.

  Returned value: Returns TRUE if the database is searchable using the specified field, FALSE otherwise.

### See Also

Super classes `BiodbConn`, `BiodbWritable`, `BiodbEditable`, and sub-classes `CompSqliteConn`, and `MassSqliteConn`.

### Examples

    # Create an instance with default settings:
    mybiodb <- biodb::newInst()

    # Get a connector that inherits from SqliteConn:
    chebi_file <- system.file("extdata", "chebi_extract.sqlite", package="biodb")
    conn <- mybiodb$getFactory()$createConn('comp.sqlite', url=chebi_file)

    # Get an entry
    e <- conn$getEntry('1018')

    # Terminate instance.
    mybiodb$terminate()

[Package biodb version 1.0.4 Index]