Skip to content

Instantly share code, notes, and snippets.

View deinspanjer's full-sized avatar

Daniel Einspanjer deinspanjer

22 followers · 4 following
View GitHub Profile
@deinspanjer
deinspanjer / keybase.md
Created September 23, 2014 18:10

Keybase proof

I hereby claim:

  • I am deinspanjer on github.
  • I am deinspanjer (https://keybase.io/deinspanjer) on keybase.
  • I have a public key whose fingerprint is 1080 6154 9E69 6FA5 D351 A532 9001 A7B5 6F57 1C60

To claim this, I am signing this object:

@deinspanjer
deinspanjer / gist:9d173ea339667f2bdd72
Last active August 29, 2015 14:22
---
build_version : '5.4.0.0'
build_arch : 'x64'
build_exe : 'bin'
build_name : 'pentaho-business-analytics'
ci_base_url : 'http://build/hosted'
ci_index_page : "%{hiera('ci_base_url')}/%{hiera('build_version')}/index.html"
build_number : "%{most_recent_build_number('%{hiera("ci_index_page")}')}"
@deinspanjer
deinspanjer / gist:251c8319302bbd1ae9ec
Created May 29, 2015 16:03
class install_nightly {
$ci_base_url = hiera("ci_base_url")
$ci_index_page = hiera("ci_index_page")
$download_path = hiera("download_path")
$build_version = hiera("build_version")
$build_arch = hiera("build_arch")
$build_exe = hiera("build_exe")
$build_name = hiera("build_name")
@deinspanjer
deinspanjer / date_and_time_dimensions.sql
Created June 29, 2016 20:08
Magic Date and Time dimensions in PostgreSQL for a data warehouse
BEGIN;
CREATE TABLE dwh.d_date
(
date_key CHAR(10) PRIMARY KEY NOT NULL,
full_date DATE NOT NULL
);
CREATE UNIQUE INDEX d_date_full_date_uindex ON dwh.d_date (full_date);
INSERT INTO dwh.d_date
@deinspanjer
deinspanjer / pg_deploy_create_table.tmpl
Last active October 9, 2016 13:02
Sqitch create table templates for pg engine
-- Deploy [% project %]:[% change %] to [% engine %]
[% FOREACH item IN requires -%]
-- requires: [% item %]
[% END -%]
[% FOREACH item IN conflicts -%]
-- conflicts: [% item %]
[% END -%]
BEGIN;
@deinspanjer
deinspanjer / pg_deploy_create_view.tmpl
Last active October 9, 2016 13:52
Sqitch create view templates for pg engine
-- Deploy [% project %]:[% change %] to [% engine %]
[% FOREACH item IN requires -%]
-- requires: [% item %]
[% END -%]
[% FOREACH item IN conflicts -%]
-- conflicts: [% item %]
[% END -%]
BEGIN;
@deinspanjer
deinspanjer / pg_deploy_create_type.tmpl
Last active October 9, 2016 13:50
Sqitch create type templates for pg engine
-- Deploy [% project %]:[% change %] to [% engine %]
[% FOREACH item IN requires -%]
-- requires: [% item %]
[% END -%]
[% FOREACH item IN conflicts -%]
-- conflicts: [% item %]
[% END -%]
BEGIN;
@deinspanjer
deinspanjer / pg_deploy_create_enum.tmpl
Last active October 9, 2016 13:44
Sqitch create enum templates for pg engine
-- Deploy [% project %]:[% change %] to [% engine %]
[% FOREACH item IN requires -%]
-- requires: [% item %]
[% END -%]
[% FOREACH item IN conflicts -%]
-- conflicts: [% item %]
[% END -%]
BEGIN;
@deinspanjer
deinspanjer / pg_deploy_create_schema.tmpl
Last active October 9, 2016 13:43
Sqitch create schema templates for pg engine
-- Deploy [% project %]:[% change %] to [% engine %]
[% FOREACH item IN requires -%]
-- requires: [% item %]
[% END -%]
[% FOREACH item IN conflicts -%]
-- conflicts: [% item %]
[% END -%]
BEGIN;
@deinspanjer
deinspanjer / pg_deploy_create_function.tmpl
Last active October 9, 2016 13:41
Sqitch create function templates for pg engine
-- Deploy [% project %]:[% change %] to [% engine %]
[% FOREACH item IN requires -%]
-- requires: [% item %]
[% END -%]
[% FOREACH item IN conflicts -%]
-- conflicts: [% item %]
[% END -%]
BEGIN;