\name{scop_dbconn}
\alias{scop_dbconn}
\alias{scop_dbfile}
\alias{scop_dbschema}
\alias{scop_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{
  scop_dbconn()
  scop_dbfile()
  scop_dbschema(file="", show.indices=FALSE)
  scop_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{scop_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{scop_dbconn} or you will break all the 
  \code{\link[AnnotationDbi]{AnnDbObj}} objects defined in this package! 

  \code{scop_dbfile} returns the path (character string) to the package
  annotation DB (this is an SQLite file). 

  \code{scop_dbschema} prints the schema definition of the package annotation
  DB. 

  \code{scop_dbInfo} prints other information about the package annotation
  DB. 
}
\examples{
  ## Show the first three rows.
  dbGetQuery(scop_dbconn(), "select * from des limit 3")

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

  scop_dbschema()

  scop_dbInfo()
}