db_update_where: Update SQL table based on criteria

In ashiklom/dbhelpers: Helper functions for working with database connections

Description

Function to facilitate updating SQL database.

Usage

db_update_where(db, table, criteria, values)

Arguments

db	dplyr src_* object
table	Name of table, as character
criteria	(list of lists) See details.
values	Named list of values. See details

Details

Each item in criteria should be a length 3 list containing: * The column name, as a character * The operator (e.g. '=', '<'), as a string * The value, as the appropriate type

ashiklom/dbhelpers documentation built on May 12, 2019, 4:41 a.m.