org.Sc.sgd_dbconn {org.Sc.sgd.db} | R Documentation |
Some convenience functions for getting a connection object to (or collecting information about) the package annotation DB.
org.Sc.sgd_dbconn() org.Sc.sgd_dbfile() org.Sc.sgd_dbschema(file="", show.indices=FALSE) org.Sc.sgd_dbInfo()
file |
A connection, or a character string naming the file to print to (see
the |
show.indices |
The CREATE INDEX statements are not shown by default.
Use |
org.Sc.sgd_dbconn
returns a connection object to the
package annotation DB. IMPORTANT: Don't call
dbDisconnect
on the connection object
returned by org.Sc.sgd_dbconn
or you will break all the
AnnDbObj
objects defined
in this package!
org.Sc.sgd_dbfile
returns the path (character string) to the
package annotation DB (this is an SQLite file).
org.Sc.sgd_dbschema
prints the schema definition of the
package annotation DB.
org.Sc.sgd_dbInfo
prints other information about the package
annotation DB.
org.Sc.sgd_dbconn
: a DBIConnection object representing an
open connection to the package annotation DB.
org.Sc.sgd_dbfile
: a character string with the path to the
package annotation DB.
org.Sc.sgd_dbschema
: none (invisible NULL
).
org.Sc.sgd_dbInfo
: none (invisible NULL
).
dbGetQuery
,
dbConnect
,
dbconn
,
dbfile
,
dbschema
,
dbInfo
## Count the number of rows in the "sgd" table: dbGetQuery(org.Sc.sgd_dbconn(), "SELECT COUNT(*) FROM sgd") ## The connection object returned by org.Sc.sgd_dbconn() was ## created with: dbConnect(SQLite(), dbname=org.Sc.sgd_dbfile(), cache_size=64000, synchronous=0) org.Sc.sgd_dbschema() org.Sc.sgd_dbInfo()