Learn R Programming

datamart (version 0.3.2)

dbWriteTable: dbWriteTable method with update and conversion options.

Description

The method is almost identical with its ancestor. The only difference is that supports updates instead of appends/replacements. It also provides a conversion mechanism for temporal attributes.

Arguments

conn
an SQLiteDataStore object
name
the name of the data table to create
value
the data object
savemode
optional write mode "u" for update (default), "w" for replacement of the table
uniq
optional - column names that must be unique combinations. Used in "u" savemode.
dates
optional - column names that are to interpreted as dates. Converts them back and forth.
timestamps
optional - column names that are intepreted as timestamps. Converts them back and forth.
field.types
optional - class list of fields. See RSQLite package.
verbose
optional - print diagnostic messages