mysql: Work with MySQL databases

In Ironholds/olivr: Oliver's personal R package

Description

Read from, write to, and check data from the MySQL databases and tables in the Wikimedia cluster. Assumes the presence of a validly formatted configuration file.

Usage

mysql_connect(database)

mysql_read(query, database, con = NULL)

mysql_exists(database, table_name, con = NULL)

mysql_write(x, database, table_name, con = NULL, ...)

mysql_close(con)

mysql_disconnect(con)

Arguments

database	The name of the database to query.
query	A SQL query.
con	A MySQL connection returned by mysql_connect. Optional – if not provided, a temporary connection will be opened up.
...	Further arguments to pass to dbWriteTable. See ?dbWriteTable for more details.
table	The name of a table to check for the existence of or create, depending on the function.

See Also

hive_query or global_query

Ironholds/olivr documentation built on May 7, 2019, 6:40 a.m.