motus.org

Description Usage Arguments Details Value Author(s)

create a view of a table where timestamps are displayed in human-readable form.

1 2	dbHumanizeTimestamps(dbcon, table, newtable = paste0("_", table), tsRegex = "^ts.*", temporary = FALSE)

`dbcon`	connection to a MySQL/MariaDB server or sqlite database
`table`	name of existing table
`newtable`	name of new view; default: `paste0('_', table)`
`tsRegex`	regular expression that matches names of columns holding numeric timestamps. Default: '^ts.*'
`temporary`	should view be temporary? default:FALSE

Creates a view of a table where any numeric 'timestamp' field is replaced by a human readble version. The view will have the given new name, 'timestamp' is judged by having a name matching the timestamp regex. If the view already exists, this function does nothing.

TRUE on success; FALSE otherwise.

John Brzustowski jbrzusto@REMOVE_THIS_PART_fastmail.fm

jbrzusto/motusServer documentation built on May 19, 2019, 8:19 a.m.