survey (version 3.29-4)

open.DBIsvydesign: Open and close DBI connections

Description

A database-backed survey design object contains a connection to a database. This connection will be broken if the object is saved and reloaded, and the connection should ideally be closed with close before quitting R (although it doesn't matter for SQLite connections). The connection can be reopened with open.

Usage

## S3 method for class 'DBIsvydesign':
open(con, ...)
## S3 method for class 'DBIsvydesign':
close(con, ...)
## S3 method for class 'ODBCsvydesign':
open(con, ...)
## S3 method for class 'ODBCsvydesign':
close(con, ...)

Arguments

con

Object of class DBIsvydesign or ODBCsvydesign

...

Other options, to be passed to dbConnect or dbDisconnect, or odbcReConnect or odbcDisconnect

Value

• The same survey design object with the connection opened or closed.

See Also

svydesign

DBI package

Examples

library(RSQLite)
dbclus1<-svydesign(id=~dnum, weights=~pw, fpc=~fpc,
data="apiclus1",dbtype="SQLite",
dbname=system.file("api.db",package="survey"))

dbclus1
close(dbclus1)
dbclus1
try(svymean(~api00, dbclus1))

dbclus1<-open(dbclus1)
open(dbclus1)
svymean(~api00, dbclus1)