\HeaderA{sc.dbsubloc\_dbconn}{Collect information about the package annotation DB}{sc.dbsubloc.Rul.dbconn}
\aliasA{sc.dbsubloc\_dbfile}{sc.dbsubloc\_dbconn}{sc.dbsubloc.Rul.dbfile}
\aliasA{sc.dbsubloc\_dbInfo}{sc.dbsubloc\_dbconn}{sc.dbsubloc.Rul.dbInfo}
\aliasA{sc.dbsubloc\_dbschema}{sc.dbsubloc\_dbconn}{sc.dbsubloc.Rul.dbschema}
\begin{Description}\relax
Some convenience functions for getting a connection object to (or collecting 
information about) the package annotation DB.
\end{Description}
\begin{Usage}
\begin{verbatim}
  sc.dbsubloc_dbconn()
  sc.dbsubloc_dbfile()
  sc.dbsubloc_dbschema(file="", show.indices=FALSE)
  sc.dbsubloc_dbInfo()
\end{verbatim}
\end{Usage}
\begin{Arguments}
\begin{ldescription}
\item[\code{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[\code{show.indices}] The CREATE INDEX statements are not shown by default. Use 
show.indices=TRUE to get them. 
\end{ldescription}
\end{Arguments}
\begin{Details}\relax
\code{sc.dbsubloc\_dbconn} returns a connection object to the package annotation DB. 
IMPORTANT: Don't call \code{\LinkA{dbDisconnect}{dbDisconnect}} on the connection object 
returned by \code{sc.dbsubloc\_dbconn} or you will break all the 
\code{\LinkA{AnnDbObj}{AnnDbObj}} objects defined in this package! 

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

\code{sc.dbsubloc\_dbschema} prints the schema definition of the package annotation
DB. 

\code{sc.dbsubloc\_dbInfo} prints other information about the package annotation
DB.
\end{Details}
\begin{Examples}
\begin{ExampleCode}
  ## Show the first three rows.
  dbGetQuery(sc.dbsubloc_dbconn(), "select * from dbsubloc limit 3")

  ## The connection object returned by sc.dbsubloc_dbconn() was created with:
  dbConnect(SQLite(), dbname=sc.dbsubloc_dbfile(), cache_size=64000, synchronous=0)

  sc.dbsubloc_dbschema()

  sc.dbsubloc_dbInfo()
\end{ExampleCode}
\end{Examples}

