illuminaHumanDASLBeadID_dbconn {illuminaHumanDASLBeadID.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

      illuminaHumanDASLBeadID_dbconn()
      illuminaHumanDASLBeadID_dbfile()
      illuminaHumanDASLBeadID_dbschema(file="", show.indices=FALSE)
      illuminaHumanDASLBeadID_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

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

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

`illuminaHumanDASLBeadID_dbschema` prints the schema definition of the package annotation DB.

`illuminaHumanDASLBeadID_dbInfo` prints other information about the package annotation DB.

### Value

`illuminaHumanDASLBeadID_dbconn`: a DBIConnection object representing an open connection to the package annotation DB.
`illuminaHumanDASLBeadID_dbfile`: a character string with the path to the package annotation DB.
`illuminaHumanDASLBeadID_dbschema`: none (invisible `NULL`).
`illuminaHumanDASLBeadID_dbInfo`: none (invisible `NULL`).

### See Also

`dbGetQuery`, `dbConnect`, `dbconn`, `dbfile`, `dbschema`, `dbInfo`

### Examples

      ## Count the number of rows in the "probes" table:
      dbGetQuery(illuminaHumanDASLBeadID_dbconn(), "SELECT COUNT(*) FROM probes")

      ## The connection object returned by illuminaHumanDASLBeadID_dbconn() was created with:
      dbConnect(SQLite(), dbname=illuminaHumanDASLBeadID_dbfile(), cache_size=64000, synchronous=0)

      illuminaHumanDASLBeadID_dbschema()

      illuminaHumanDASLBeadID_dbInfo()

[Package illuminaHumanDASLBeadID.db version 1.2.0 Index]