IPython Notebook for BAIT Group Project

db_connect.json

{
   "host": "localhost",
   "port": 5432,
   "database": "yourdatabase",
   "user": "postgres",
   "password": "postgres"
}

template_doc.ipynb

template_doc.Rmd

---
title: "Project Report"
output: html_document
---

```{r setup, include=FALSE}
knitr::opts_chunk$set(echo = TRUE)
```

## About the Data

We obtained the data from this resource.  This is what it represents, these are the basic features.  

## Data Model

The data is modeled in this way.  This is how elements relate to one another generally.  This is the justification.

### Table Descriptions

#### Table One

The table contains these features, this is what each one of them means.

```SQL
CREATE TABLE thetablename(id SERIAL,
                          firstthing CHARACTER VARYING)
```

#### Table Two

The table contains these features, this is what each one of them means.

```SQL
CREATE TABLE thetablename(id SERIAL,
                          firstthing CHARACTER VARYING)
```

## Key Report Elements

Given the data models, these are the things we want to know, this is how we want to do it.

### Setting up the Database Link

Now we set things up.

```{r}
library(RPostgreSQL)
library(jsonlite)

dbcon <- fromJSON(txt = 'dbconnect.json', flatten = TRUE)

# Connect to a database:
con <- dbConnect(drv = "PostgreSQL",
                 user = dbcon$user,
                 password = dbcon$password,
                 host = dbcon$host,
                 port = dbcon$port,
                 dbname = dbcon$database)

```

### Defining Each Report Element

Here is the first thing that we're going to look at, this is why it's important and what it all means.

```{r}
RPostgreSQL::dbGetQuery(con, 
                        "SELECT values FROM table WHERE thing = 'something'")
```

Stuff.