Skip to content

Instantly share code, notes, and snippets.

@cvengros
cvengros / download.rb
Created February 13, 2015 22:45
sharepoint downloader
require 'csv'
require_relative 'sharepoint_downloader'
# variables
client_id = ENV['CLIENT_ID']
client_secret = ENV['CLIENT_SECRET']
refresh_token = ENV['REFRESH_TOKEN']
@cvengros
cvengros / gist:32ad1a518b3956617522
Created November 26, 2014 23:35
Export table to CSV
require 'rubygems'
require 'jdbc/dss'
require 'sequel'
require 'csv'
Jdbc::DSS.load_driver
FILENAME = ''
USERNAME = ''
PASSWORD = ''
@cvengros
cvengros / gist:b2a7e82f66519d423b6f
Created November 15, 2014 01:30
Download directory from GitHub through API
class GitHub
class << self
def download_file_to_string(github_token, setup={}, raw=true, link=nil)
if link
url = link
else
sql_repo_name = setup['repo_name']
sql_repo_owner = setup['repo_owner']
# URI join won't make it:
@cvengros
cvengros / degeminator.rb
Created October 10, 2014 23:52
Change references from gems to local libraries
require 'fileutils'
require 'json'
# change require 'library' to require_relative 'path'
# path will be dynamic depending on the current file path
# I don't deal with libraries I don't know
LIBS_DIR = 'libs'
def generate_require_relative(file_path, require_path)
@cvengros
cvengros / params.json
Created June 19, 2014 21:02
Typical setup for the salesapp_dss_to_gdc brick
{
"dss_jdbc_url": "jdbc:dss://secure.gooddata.com/gdc/dss/instances/something",
"GDC_USERNAME": "you@gooddata.com",
"GDC_PASSWORD": "yourpassword",
"dss_GDC_USERNAME": "you+dss@gooddata.com",
"dss_GDC_PASSWORD": "yourotherpassword",
"dss_name_prefix": "sfdc",
"gooddata_model_url": "https://gist.githubusercontent.com/cvengros/a85874dd8f8da034c70d/raw/2441035702459d210b9013b6d1bfe21be3d90de7/salesapp_model.json",
"dataset_mapping": {
@cvengros
cvengros / params.json
Last active August 29, 2015 14:02
Typical setup for the salesapp_sfdc_to_dss brick
{
"salesforce_username": "customer@theircompany.com",
"salesforce_password": "theirpassword",
"salesforce_token": "theirtoken",
"salesforce_client_id": "sfdc oauth app id",
"salesforce_client_secret": "sfdc oauth app secret",
"dss_jdbc_url": "jdbc:dss://secure.gooddata.com/gdc/dss/instances/something",
"dss_GDC_USERNAME": "you@gooddata.com",
"dss_GDC_PASSWORD": "yourpassword",
@cvengros
cvengros / salesapp_model.json
Last active August 29, 2015 14:00
Data model for salesapp
{
"title": "salesapp",
"datasets": [
{
"name":"account",
"columns":[
{
"name":"id",
"type":"anchor"
},
@cvengros
cvengros / add_licenses.rb
Last active August 29, 2015 13:55
Add license to all sources
#!/usr/bin/env ruby
LICENSE_TEXT = "%s Copyright (C) 2007-2014 My Cool license text %s"
SKIP_PATTERN = /.*Copyright\(C\)*/
# rb, js, hbs, css
FILE_TYPES = {
:rb => {
:pattern => '**/*.rb',