ONT_dbconn: Collect information about the package annotation DB

In hxin/topOnto.HDO.db: TopOnto ontology db package

Description

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

Usage

  ONT_dbconn()
  ONT_dbfile()

  ONT_dbschema()
  ONT_dbInfo()

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

  ## 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, 2019, 9:15 p.m.