ONT_dbconn: Collect information about the package annotation DB

Description Usage Details Value See Also Examples

View source: R/zzz.R

Description

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

Usage

1
2
3
4
5

Details

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

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

ONT_dbschema prints the schema definition of the package annotation DB.

ONT_dbInfo prints other information about the package annotation DB.

Value

ONT_dbconn: a DBIConnection object representing an open connection to the package annotation DB.

ONT_dbfile: a character string with the path to the package annotation DB.

ONT_dbschema: none (invisible NULL).

ONT_dbInfo: none (invisible NULL).

See Also

dbGetQuery, dbConnect, dbconn, dbfile, dbschema, dbInfo

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
  ## Count the number of rows in the "term" table:
  dbGetQuery(ONT_dbconn(), "SELECT COUNT(*) FROM term")

  ## The connection object returned by ONT_dbconn() was
  ## created with:
  dbConnect(SQLite(), dbname=ONT_dbfile(), cache_size=64000,
  synchronous='off')

  #ONT_dbschema()

#  ONT_dbInfo()

hxin/topOnto.HDO.db documentation built on May 17, 2017, 12:07 a.m.