mysql_write: Wrapper for writing to the R&D MySQL instances

In wikimedia-research/WMUtils: Utilities for Wikimedia staffers

Description

mysql_write is a simple wrapper around RMySQL that allows a useR to write to the dbs on analytics-store.eqiad.wmnet.

Usage

mysql_write(x, db, table_name, ...)

Arguments

x	a data.frame to insert into the table
db	the name of the database you want to write to. This is usually going to be "staging"
table_name	the name you want given to the resulting table.
...	further arguments to pass to dbWriteTable. See ?dbWriteTable for more details.

Value

A TRUE or FALSE confirming whether the write succeeded.

Author(s)

Oliver Keyes <[e-mail]>

See Also

mysql_query for reading from the same range of databases, mysql_delete for removing rows from a table that match a set of conditions, or mysql_exists for checking the existence of a table.

wikimedia-research/WMUtils documentation built on May 4, 2019, 5:23 a.m.