\HeaderA{hom.Sc.inp\_dbconn}{Collect information about the package annotation DB}{hom.Sc.inp.Rul.dbconn}
\aliasA{hom.Sc.inp\_dbfile}{hom.Sc.inp\_dbconn}{hom.Sc.inp.Rul.dbfile}
\aliasA{hom.Sc.inp\_dbInfo}{hom.Sc.inp\_dbconn}{hom.Sc.inp.Rul.dbInfo}
\aliasA{hom.Sc.inp\_dbschema}{hom.Sc.inp\_dbconn}{hom.Sc.inp.Rul.dbschema}
\keyword{utilities}{hom.Sc.inp\_dbconn}
\keyword{datasets}{hom.Sc.inp\_dbconn}
\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}
  hom.Sc.inp_dbconn()
  hom.Sc.inp_dbfile()
  hom.Sc.inp_dbschema(file="", show.indices=FALSE)
  hom.Sc.inp_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 \code{file} argument of the \code{\LinkA{cat}{cat}} function for
the details).

\item[\code{show.indices}] The CREATE INDEX statements are not shown by default.
Use \code{show.indices=TRUE} to get them.

\end{ldescription}
\end{Arguments}
\begin{Details}\relax
\code{hom.Sc.inp\_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{hom.Sc.inp\_dbconn} or you will
break all the \code{\LinkA{AnnDbObj}{AnnDbObj}} objects defined in this package!

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

\code{hom.Sc.inp\_dbschema} prints the schema definition of the
package annotation DB.

\code{hom.Sc.inp\_dbInfo} prints other information about the package
annotation DB.
\end{Details}
\begin{Value}
\code{hom.Sc.inp\_dbconn}: a DBIConnection object representing an open
connection to the package annotation DB.

\code{hom.Sc.inp\_dbfile}: a character string with the path to the
package annotation DB.

\code{hom.Sc.inp\_dbschema}: none (invisible \code{NULL}).

\code{hom.Sc.inp\_dbInfo}: none (invisible \code{NULL}).
\end{Value}
\begin{SeeAlso}\relax
\code{\LinkA{dbGetQuery}{dbGetQuery}},
\code{\LinkA{dbConnect}{dbConnect}},
\code{\LinkA{dbconn}{dbconn}},
\code{\LinkA{dbfile}{dbfile}},
\code{\LinkA{dbschema}{dbschema}},
\code{\LinkA{dbInfo}{dbInfo}}
\end{SeeAlso}
\begin{Examples}
\begin{ExampleCode}
  ## Count the number of rows in the "metadata" table:
  dbGetQuery(hom.Sc.inp_dbconn(), "SELECT COUNT(*) FROM metadata")

  ## The connection object returned by hom.Sc.inp_dbconn() was created with:
  dbConnect(SQLite(), dbname=hom.Sc.inp_dbfile(), cache_size=64000, synchronous=0)

  hom.Sc.inp_dbschema()

  hom.Sc.inp_dbInfo()
\end{ExampleCode}
\end{Examples}

