1. ---
2. title: "R Notebook"
3. output: html_notebook
4. ---
5.  
6.  
7.  
8. ```{r}
9. # 1. Library (must be installed prior to loading
10. library(RMySQL) ### MySQL
11. library(RMariaDB) ### MariaDB
12.  
13. # 2. Settings
14. db_user <- 'admin'
15. db_password <- 'YOUR PASSWORD GOES HERE'
16. db_name <- 'cs5200'
17. db_host <- 'AWS CONNECTION STRING GOES HERE'
18. # db_host:
19. # AWS connection looks like this: myDB-dbs.c07w5c84ka9l.us-east-1.rds.amazonaws.com
20. # db4free: db4free.net
21. # Local: localhost
22. db_port <- 3306 # always this port unless you change it during installation
23.  
24. # 3. Connect to DB
25. mydb <- dbConnect(MySQL(), user = db_user, password = db_password,
26.        dbname = db_name, host = db_host, port = db_port)
27. ```
28.  
29. ```{sql connection=mydb}
30. create table test2 (
31. testpk int primary key,
32. name TEXT
33. );
34. ```
35.  
36. ```{sql connection=mydb}
37. insert into test2 values (1,'one'),(2,'two');
38. ```
39.  
40.  
41. ```{sql connection=mydb}
42. SELECT * FROM test;
43. ```
44.  
45. ```{r}
46. library(RMySQL)
47.  
48. # 2. Settings
49. db_user <- 'admin'
50. db_password <- 'teamjuhi'
51. db_name <- 'practicum1'
52. db_host <- 'practicum1.cxxic7ejczte.us-east-2.rds.amazonaws.com' # AWS Host
53. db_port <- 3306
54.  
55. # 3. Read data from db
56. mydb <-  dbConnect(MySQL(), user = db_user, password = db_password,
57.                  dbname = db_name, host = db_host, port = db_port)
58. ```
59.