---
title: "R Notebook"
output: html_notebook
---



```{r}
# 1. Library (must be installed prior to loading
library(RMySQL) ### MySQL
library(RMariaDB) ### MariaDB

# 2. Settings
db_user <- 'admin'
db_password <- 'YOUR PASSWORD GOES HERE'
db_name <- 'cs5200'
db_host <- 'AWS CONNECTION STRING GOES HERE'
# db_host:
# AWS connection looks like this: myDB-dbs.c07w5c84ka9l.us-east-1.rds.amazonaws.com
# db4free: db4free.net
# Local: localhost
db_port <- 3306 # always this port unless you change it during installation

# 3. Connect to DB
mydb <- dbConnect(MySQL(), user = db_user, password = db_password,
       dbname = db_name, host = db_host, port = db_port)
```

```{sql connection=mydb}
create table test2 (
testpk int primary key,
name TEXT
);
```

```{sql connection=mydb}
insert into test2 values (1,'one'),(2,'two');
```


```{sql connection=mydb}
SELECT * FROM test;
```

```{r}
library(RMySQL)

# 2. Settings
db_user <- 'admin'
db_password <- 'teamjuhi'
db_name <- 'practicum1'
db_host <- 'practicum1.cxxic7ejczte.us-east-2.rds.amazonaws.com' # AWS Host
db_port <- 3306

# 3. Read data from db
mydb <-  dbConnect(MySQL(), user = db_user, password = db_password,
                 dbname = db_name, host = db_host, port = db_port)
```