Skip to content

Instantly share code, notes, and snippets.

View EyePulp's full-sized avatar

EyePulp EyePulp

7 followers · 0 following
View GitHub Profile
@EyePulp
EyePulp / create_table_query_from_redshift_table.sql
Last active August 29, 2016 23:17
Create a viable copy of a table schema for moving redshift table data between DB's -- doesn't copy secondary index details (would be nice to get it improved to do that though) Edit the "source_table_name" string at the bottom to the table you want the structure for. This script DOES NOT create the table - merely creates the SQL statement necessa…
select pk.pkey, tm.schemaname||'.'||tm.tablename, 'create table '||tm.schemaname||'.'||tm.tablename
||' ('
||cp.coldef
-- primary key
||decode(pk.pkey,null,'',pk.pkey)
-- diststyle and dist key
||decode(d.distkey,null,')\n diststyle '||dist_style||' ',d.distkey)
--sort key
|| (select decode(skey,null,'',skey) from (select
@EyePulp
EyePulp / autossh.yaml
Created November 8, 2013 22:31
Wondering about variable scopes -- If I include the same playbook (autossh.yaml, as seen below) twice, what is the scope of the variables defined with each call? Would the second include call continue to have all the values defined from the first call? e.g. would the second include in playbook.yaml have a defined or undefined value for AUTOSSH_P…
---
# set up an ssh tunnel
# using the following variables
# {{AUTOSSH_PUBLIC_KEY_SRC}}
# {{AUTOSSH_PUBLIC_KEY_DEST}}
# {{AUTOSSH_PRIVATE_KEY_SRC}}
# {{AUTOSSH_PRIVATE_KEY_DEST}}
# {{AUTOSSH_UPSTART_SRC}}
# {{AUTOSSH_UPSTART_DEST}}
# {{AUTOSSH_UPSTART_SERVICE}}
@EyePulp
EyePulp / Vagrantfile
Created September 20, 2013 16:12
Vagrantfile error
Vagrant.configure("2") do |config|
config.vm.synced_folder File.dirname(__FILE__)+'/../', "/vagrant-project/"
config.vm.define "project_foo" do |app|
app.vm.box = "precise64"
app.vm.box_url = "http://files.vagrantup.com/precise64.box"
@EyePulp
EyePulp / main.js
Created August 21, 2013 00:27
require.js module example
require(['some_module'], // import your module
function(mm){ // give it a local reference
var MyInstance = new mm({'yo':'ho ho'}); // instantiate it with a value
MyInstance.bar(); // run some functions off of it
}
);
@EyePulp
EyePulp / ko.binding.js
Created August 20, 2013 20:06
Simple KO binding for getting context data from within a VM
ko.bindingHandlers.console = {
init: function (element, valueAccessor,allBindingsAccessor) {
console.info('ko.console:',valueAccessor());
},
update: function (element, valueAccessor, allBindingsAccessor) {
console.info('ko.console:',valueAccessor());
}
};
@EyePulp
EyePulp / gist:5815203
Created June 19, 2013 15:26
Basic attempt @ using knockback to read from a tastypie resource and add to a collection. Wondering how to properly and most succinctly create a new Payment instance on the client side and have it show up in its finished, saved incarnation via the observableCollection. Wondering if there's any two-way binding between the collection and the colle…
var Payment = kb.Model.extend({
urlRoot: '/api/v1/payment_backbone/'
});
var PaymentCollection = kb.Collection.extend({
model: Payment
// Constructor method
, initialize: function(data, options) {
this.limit = options.limit || 20;
@EyePulp
EyePulp / example.js
Last active December 18, 2015 04:28
knockout.js, jquery, and tastypie: Automattically perform a "PUT" to your model's resource_uri when certain observables change value
// usage inside a vm:
var fooVM = function(){
var self = this;
var resource_uri = ko.observable('/api/v1/foo/');
var bar = ko.observable(1);
var baz = ko.observable(1);
ko.saveOnChange(self,['bar']);
}
var f = new fooVM();
f.bar(2); // causes a PUT to /api/v1/foo/
@EyePulp
EyePulp / dashboard.js
Created March 1, 2013 17:44
define(['ko','ko.mapping','underscore','moment'],
function(ko,mapping,_,moment) {
console.log('dashboard VM loaded:',arguments);
return function(){
var self = this;
};
});
@EyePulp
EyePulp / gist:5027698
Last active December 14, 2015 04:19
#!/usr/bin/python
# don't forget each model needs
# class Meta:
# app_label = 'app_name' # or whatever the app name is
PACKAGE = 'project_name.app_name.models' # <--- SET YOUR PACKAGE NAME
import os
@EyePulp
EyePulp / gist:4962327
Last active December 13, 2015 19:28
django templated e-mail using markdown/html -- supports attaching files or streaming file attachments
from django.conf import settings
def email_template(
template_name = None,
template_context = None,
subject = '',
recipients = None,
sender = settings.DEFAULT_FROM_EMAIL,
fail_silently = False,
use_markdown = False,