\HeaderA{sysptm\_dbconn}{Collect information about the package annotation DB}{sysptm.Rul.dbconn}
\aliasA{sysptm\_dbfile}{sysptm\_dbconn}{sysptm.Rul.dbfile}
\aliasA{sysptm\_dbInfo}{sysptm\_dbconn}{sysptm.Rul.dbInfo}
\aliasA{sysptm\_dbschema}{sysptm\_dbconn}{sysptm.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}
  sysptm_dbconn()
  sysptm_dbfile()
  sysptm_dbschema(file="", show.indices=FALSE)
  sysptm_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{sysptm\_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{sysptm\_dbconn} or you will break all the 
\code{\LinkA{AnnDbObj}{AnnDbObj}} objects defined in this package! 

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

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

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

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

  sysptm_dbschema()

  sysptm_dbInfo()
\end{ExampleCode}
\end{Examples}

