In EuropeanForestInstitute/tradeflows: Process forest products trade flow data from COMTRADE and COMEXT

knitr::opts_chunk$set(echo = TRUE)

Replace RMySQL with RMariaDB

Bash command to replace all RMySQL:: function calls to RMariaDB::.

# Replace the special function
git grep -lz 'RMySQL::mysqlHasDefault'| xargs -0 perl -i'' -pE "s/RMySQL::mysqlHasDefault/RMariaDB::mariadbHasDefault/g"

# Replace all other functions
git grep -lz 'RMySQL::'| xargs -0 perl -i'' -pE "s/RMySQL::/RMariaDB::/g"

# Replace the mistaken dbconnect statement
# R> con <- RMySQL::dbConnect(RMySQL::MySQL(), dbname = "test")
# has now become
# R> con <- RMariaDB::dbConnect(RMariaDB::MySQL(), dbname = "test")
# The driver should be RMariaDB::MariaDB()
git grep -lz '::MySQL'| xargs -0 perl -i'' -pE "s/::MySQL/::MariaDB/g"

# Replace the connection parameter
git grep -lz 'RMySQLcon'| xargs -0 perl -i'' -pE "s/RMySQLcon/RMariaDBcon/g"

EuropeanForestInstitute/tradeflows documentation built on Oct. 7, 2019, 10:57 a.m.