org.Zmays.eg_dbconn: Collect information about the package annotation DB
In bakuhatsu/zmaysGeneTools: Genome wide annotation for Zea mays

Description Usage Arguments Details Value See Also Examples

Some convenience functions for getting a connection object to (or collecting information about) the package annotation DB.

  org.Zmays.eg_dbconn()
  org.Zmays.eg_dbfile()
  org.Zmays.eg_dbschema(file="", show.indices=FALSE)
  org.Zmays.eg_dbInfo()

`file`	A connection, or a character string naming the file to print to (see the `file` argument of the `cat` function for the details).
`show.indices`	The CREATE INDEX statements are not shown by default. Use `show.indices=TRUE` to get them.

org.Zmays.eg_dbconn returns a connection object to the package annotation DB. IMPORTANT: Don't call dbDisconnect on the connection object returned by org.Zmays.eg_dbconn or you will break all the AnnDbObj objects defined in this package!

org.Zmays.eg_dbfile returns the path (character string) to the package annotation DB (this is an SQLite file).

org.Zmays.eg_dbschema prints the schema definition of the package annotation DB.

org.Zmays.eg_dbInfo prints other information about the package annotation DB.

org.Zmays.eg_dbconn: a DBIConnection object representing an open connection to the package annotation DB.

org.Zmays.eg_dbfile: a character string with the path to the package annotation DB.

org.Zmays.eg_dbschema: none (invisible NULL).

org.Zmays.eg_dbInfo: none (invisible NULL).

dbGetQuery, dbConnect, dbconn, dbfile, dbschema, dbInfo

  library(DBI)
  ## Count the number of rows in the "genes" table:
  dbGetQuery(org.Zmays.eg_dbconn(), "SELECT COUNT(*) FROM genes")

  org.Zmays.eg_dbschema()

  org.Zmays.eg_dbInfo()