| library("RPostgreSQL") | |
| #Connect to Redshift | |
| redshift.Connection <- dbConnect(dbDriver("PostgreSQL"), host="XXXXXXXXXXXXXXX.redshift.amazonaws.com", dbname="XXXXXXXX", | |
| user="XXXXXXX", password= "XXXXXXXXXX", port=XXXXXXXX) | |
| query_string <- | |
| "select * | |
| from table | |
| where something = 'True';" |
| # Install the Redshift R library: | |
| # https://github.com/pingles/redshift-r | |
| # install.packages("~/Downloads/redshift-r-master", dependencies = T, repos = NULL, type = "source") | |
| library(redshift) | |
| redshift <- redshift.connect("jdbc:postgresql://REDSHIFT_DB:5439/DB_NAME", "LOGIN", "PASSWORD") | |
| # Example Query: | |
| data <- dbGetQuery(redshift, "SELECT COUNT(*) FROM table") |
| library(shiny) | |
| library(ggplot2) | |
| # Download DataTables JS file and TableTools full package from http://datatables.net/download/ | |
| # Change the paths appropriately: | |
| addResourcePath('datatables','/Users/yourusername/Downloads/DataTables-1.9.4/media') | |
| addResourcePath('tabletools','/Users/yourusername/Downloads/TableTools-2.1.5/media') | |
| runApp(list( | |
| ui = basicPage( |
| import requests | |
| import base64 | |
| import json | |
| from simple_salesforce import Salesforce | |
| userName = '' | |
| password = '' | |
| securityToken = '' | |
| instance = '' |
| #!/usr/bin/env python | |
| import os | |
| import sys | |
| from markdown2 import markdown | |
| from xhtml2pdf import pisa | |
| """ | |
| ## Inspired by |
| // Apply the Constraints | |
| CREATE CONSTRAINT ON (s:Student) ASSERT s.pidm IS UNIQUE; | |
| CREATE CONSTRAINT ON (v:Vendor) ASSERT v.name IS UNIQUE; | |
| CREATE CONSTRAINT ON (t:Topic) ASSERT t.name IS UNIQUE; | |
| CREATE CONSTRAINT ON (e:Email) ASSERT e.msgid IS UNIQUE; | |
| CREATE CONSTRAINT ON (a:Ability) ASSERT a.name IS UNIQUE; | |
| CREATE CONSTRAINT ON (c:Contact) ASSERT c.cid IS UNIQUE; | |
| CREATE CONSTRAINT ON (p:Template) ASSERT p.name IS UNIQUE; | |
| CREATE CONSTRAINT ON (v:Version) ASSERT v.version IS UNIQUE; |
| ## a function to import cypher statements into the shell | |
| build_import = function(NEO_SHELL="~/neo4j-community-2.3.1/bin/neo4j-shell", | |
| cypher_file) { | |
| cmd = sprintf("%s -file %s", NEO_SHELL, cypher_file) | |
| system(cmd) | |
| } | |
| ## example | |
| ## import the database from scratch | |
| ## build_import(cypher_file="import-db.cql") |
Whitelist the host for interactive tutorials in neo4j-server.properties file
# Whitelist of hosts for the Neo4j Browser to be allowed to fetch content from.
# Set to '*' to allow all hosts.
dbms.browser.remote_content_hostname_whitelist=http://guides.neo4j.com,https://guides.neo4j.com,http://localhost,https://localhost
Start neo4j server
| # Write R data.frame to a Tableau data extract file (.tde) by building and executing | |
| # a python script which utilizes the Tableau data extract API (a hack, yes). | |
| # | |
| # This, naturally, has a hard dependency on the TDE API, so is only available for | |
| # Windows and Linux systems (unfortunately) | |
| # | |
| # Devin Riley | |
| # October, 2014 |
| # Write R data.frame to a Tableau data extract file (.tde) by building and executing | |
| # a python script which utilizes the Tableau data extract API (a hack, yes). | |
| # | |
| # This, naturally, has a hard dependency on the TDE API, so is only available for | |
| # Windows and Linux systems (unfortunately) | |
| # | |
| # Devin Riley | |
| # October, 2014 |