dataFrameDao: A Data Access Object (DAO) that stores the data in the...

In beerda/crudtable: A Shiny toolkit for Create-Read-Update-Delete Operations on Data

Description

DAO is a list that provides basic backend CRUD functionality to the crudTableServer. This DAO stores internally the data into a data frame, that is, the data are NOT stored on the disk in any way.

Usage

dataFrameDao(d)

Arguments

d	A data frame to create DAO object for

Value

An S3 object of class dao, which is a list having as elements the functions described above

Generally about DAO objects

Generally, all DAO objects have to provide the following functions:

• getAttributes() – get the list of attribute definitions. Names of the list correspond to names of attributes. Each element of that list contains a list with character element 'type' that specifies the data type (factor, character, numeric, logical). Factors have also a character vector levels with level names;

• getData() – get the data frame with all data. The data frame contain all columns as indicated in the getAttributes() function plus the "id" column with numeric row identifier;

• getRecord(id) – get the record of given ID, as a list;

• insert(record) – store the new record, the ID attribute of the record must not be set, it is determined automatically by the DAO object;

• update(id, record) – update the stored record of given ID by data given in the list record;

• delete(id) – delete the record of given ID.

See Also

sqlDao, is.dao

Examples

d <- CO2[1:5, ]
dao <- dataFrameDao(d)
str(dao$getAttributes())
print(dao$getData())
dao$insert(list(Plant='Qn1', Type='Quebec', Treatment='chilled', conc=1000, uptake=2000))
dao$delete(1)
print(dao$getData)

beerda/crudtable documentation built on July 13, 2020, 2:16 p.m.