sc.dbsubloc_dbconn {sc.dbsubloc.db} | R Documentation

## Collect information about the package annotation DB

### Description

Some convenience functions for getting a connection object to (or collecting information about) the package annotation DB.

### Usage

      sc.dbsubloc_dbconn()
      sc.dbsubloc_dbfile()
      sc.dbsubloc_dbschema(file="", show.indices=FALSE)
      sc.dbsubloc_dbInfo()

### Arguments

`file` | A connection, or a character string naming the file to print to (see the file argument of the cat function for the details).
`show.indices` | The CREATE INDEX statements are not shown by default. Use show.indices=TRUE to get them.

### Details

`sc.dbsubloc_dbconn` returns a connection object to the package annotation DB. IMPORTANT: Don't call `dbDisconnect` on the connection object returned by `sc.dbsubloc_dbconn` or you will break all the `AnnDbObj` objects defined in this package!

`sc.dbsubloc_dbfile` returns the path (character string) to the package annotation DB (this is an SQLite file).

`sc.dbsubloc_dbschema` prints the schema definition of the package annotation DB.

`sc.dbsubloc_dbInfo` prints other information about the package annotation DB.

### Examples

      ## Show the first three rows.
      dbGetQuery(sc.dbsubloc_dbconn(), "select * from dbsubloc limit 3")

      ## The connection object returned by sc.dbsubloc_dbconn() was created with:
      dbConnect(SQLite(), dbname=sc.dbsubloc_dbfile(), cache_size=64000, synchronous=0)

      sc.dbsubloc_dbschema()

      sc.dbsubloc_dbInfo()

[Package sc.dbsubloc.db version 1.1.0 Index]