| hgu133plus2_dbconn {hgu133plus2.db} | R Documentation |
Some convenience functions for getting a connection object to (or collecting information about) the package annotation DB.
hgu133plus2_dbconn() hgu133plus2_dbfile() hgu133plus2_dbschema(file="", show.indices=FALSE) hgu133plus2_dbInfo()
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.
|
hgu133plus2_dbconn returns a connection object to the package
annotation DB.
IMPORTANT: Don't call dbDisconnect on the connection
object returned by hgu133plus2_dbconn or you will
break all the AnnDbObj objects defined in this package!
hgu133plus2_dbfile returns the path (character string) to the
package annotation DB (this is an SQLite file).
hgu133plus2_dbschema prints the schema definition of the
package annotation DB.
hgu133plus2_dbInfo prints other information about the package
annotation DB.
hgu133plus2_dbconn: a DBIConnection object representing an open
connection to the package annotation DB.
hgu133plus2_dbfile: a character string with the path to the
package annotation DB.
hgu133plus2_dbschema: none (invisible NULL).
hgu133plus2_dbInfo: none (invisible NULL).
dbGetQuery,
dbConnect,
dbconn,
dbfile,
dbschema,
dbInfo
## Count the number of rows in the "probes" table: dbGetQuery(hgu133plus2_dbconn(), "SELECT COUNT(*) FROM probes") ## The connection object returned by hgu133plus2_dbconn() was created with: dbConnect(SQLite(), dbname=hgu133plus2_dbfile(), cache_size=64000, synchronous=0) hgu133plus2_dbschema() hgu133plus2_dbInfo()