vindeolal

CREATE OR REPLACE VIEW virtual_catchment_address_mapping_table AS (
    select row_number() OVER ()  AS id,
           cam.catchment_id::int AS catchment_id,
           al.id                 AS addresslevel_id
    from address_level al
             left outer join regexp_split_to_table((al.lineage)::text, '[.]'::text) WITH ORDINALITY lineage(point_id, level)
                             ON (true)
             left outer join catchment_address_mapping cam on cam.addresslevel_id = point_id::int
    where catchment_id notnull
    group by 2, 3

vindeolal

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

vindeolal

const AWS = require('aws-sdk');

const auth = {
    region: process.argv[2],
    accessKeyId: process.argv[3],
    secretAccessKey: process.argv[4],
};

var cognitoidentityserviceprovider = new AWS.CognitoIdentityServiceProvider(auth);

vindeolal

var fs = require('fs');

var rootDir = process.argv[2];
//map of old and new uuids {olduuid: newuuid}
const oldNewUUIDMap = JSON.parse(process.argv[3]);

String.prototype.replaceAll = function (search, replace) {
    return this.replace(new RegExp(search, 'g'), replace)
};

vindeolal

create table deps_saved_ddl
(
  deps_id serial primary key, 
  deps_view_schema varchar(255), 
  deps_view_name varchar(255), 
  deps_ddl_to_run text
);

create or replace function deps_save_and_drop_dependencies(p_view_schema varchar, p_view_name varchar) returns void as
$$