\name{int.intact_dbconn} \alias{int.intact_dbconn} \alias{int.intact_dbfile} \alias{int.intact_dbschema} \alias{int.intact_dbInfo} \title{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{ int.intact_dbconn() int.intact_dbfile() int.intact_dbschema(file="", show.indices=FALSE) int.intact_dbInfo() } \arguments{ \item{file}{A connection, or a character string naming the file to print to (see the file argument of the cat function for the details). } \item{show.indices}{The CREATE INDEX statements are not shown by default. Use show.indices=TRUE to get them. } } \details{ \code{int.intact_dbconn} returns a connection object to the package annotation DB. IMPORTANT: Don't call \code{\link[DBI]{dbDisconnect}} on the connection object returned by \code{int.intact_dbconn} or you will break all the \code{\link[AnnotationDbi]{AnnDbObj}} objects defined in this package! \code{int.intact_dbfile} returns the path (character string) to the package annotation DB (this is an SQLite file). \code{int.intact_dbschema} prints the schema definition of the package annotation DB. \code{int.intact_dbInfo} prints other information about the package annotation DB. } \examples{ ## Show the first three rows. dbGetQuery(int.intact_dbconn(), "select * from intact limit 3") ## The connection object returned by int.intact_dbconn() was created with: dbConnect(SQLite(), dbname=int.intact_dbfile(), cache_size=64000, synchronous=0) int.intact_dbschema() int.intact_dbInfo() }