Guest User

Untitled

a guest
Oct 30th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. conn <- dbConnect(MySQL(), user=conf$user, password=conf$passws, host=conf$host, dbname=conf$db)
  2.  
  3. conf$conn <- dbConnect(MySQL(), user=conf$user, password=conf$passws, host=conf$host, dbname=conf$db)
  4.  
  5. library(pool)
  6. library(RPostgreSQL)
  7.  
  8. connect <- function(cfg) {
  9. config <- config::get(config = cfg)
  10. dbPool(
  11. drv = dbDriver("PostgreSQL", max.con = 100),
  12. dbname = config$dbname,
  13. host = config$host,
  14. port = config$port,
  15. user = config$user,
  16. password = config$password
  17. )
  18. }
  19. conn <- lapply(c("db1", "db2"), connect)
Add Comment
Please, Sign In to add comment