Skip to content

Instantly share code, notes, and snippets.

View daviddahl's full-sized avatar
💭
burning the midnight oil

David Dahl daviddahl

💭
burning the midnight oil
118 followers · 116 following
View GitHub Profile
@daviddahl
daviddahl / scema.diff
Created November 11, 2015 19:11
Diff from HEAD to the current production database
diff --git a/928a5500234abb5db508ba07b1d2f6c385fe8d19:server/lib/stores/postgres/sql/setup.sql b/HEAD:server/lib/stores/postgres/sql/setup.sql
index ed69e77..1091725 100644
--- a/928a5500234abb5db508ba07b1d2f6c385fe8d19:server/lib/stores/postgres/sql/setup.sql
+++ b/HEAD:server/lib/stores/postgres/sql/setup.sql
@@ -620,4 +620,165 @@ create unique index transaction_delete_message_msg_id_idx
on transaction_delete_message
(transaction_id, message_id);
+
+create table item (
@daviddahl
daviddahl / migrate_items.sql
Created November 20, 2015 22:00
begin;
create table item (
item_id int8 not null primary key default nextval('version_identifier'),
account_id int8 not null references account,
name_hmac bytea not null unique,
creation_time timestamp not null default current_timestamp,
modified_time timestamp not null default current_timestamp,
deletion_time timestamp,
value bytea,
@daviddahl
daviddahl / configuration.js
Created April 9, 2016 20:10
configuration.js
function () {
/*
* Write Configuration Properties Here:
*/
var PROTO = 'https://';
var HOST = 'dev.nulltxt.se';
var PORT = null;
var API_PATH = 'api/v1/';
@daviddahl
daviddahl / simplified-test-case-slider.html
Created April 22, 2016 13:16
SImlified Test Case, slider
<html>
<head>
<style>
.slide{
-webkit-transition:all .2s linear;
-webkit-transform: translate3d(0,0,0);
-moz-transition:all .2s linear;
-moz-transform: translate3d(0,0,0);
transform: translate3d(0,0,0);
}
@daviddahl
daviddahl / sliding-menu-diagnosis.md
Last active April 24, 2016 04:11
Sliding Menu Diagnosis

Sliding Menu Diagnosis

Examination

  • Watched the console for clues, none forthcoming
  • Examined the CSS and click event handler for obvious coding issues, initially looks good
  • Tinkered with the css a bit based on some related issues found in stackoverflow having to do with display:block in LI and A nodes - was a red herring
  • Created a simpler test case, see: https://gist.github.com/daviddahl/a6740c9310d15452b28fac79cbc93b6a
@daviddahl
daviddahl / page-reloading-diagnosis.md
Last active April 22, 2016 16:00
Page reloading Diagnosis

Page Reloading Diagnosis

Examination

  • Watched the console for clues, but found the console constantly re-loading and nearly useless
  • First gut feeling this has something to do with window.location
  • Grabbed all uglified JS files and beuatified them
  • Searched each file for location
@daviddahl
daviddahl / calc-1.sql
Last active May 9, 2016 22:50
sample calc
case
when {{action}} like 'T_%'
then 'Processing...' -- <-- 1st test
when {{listing_location_id}} <> '{{profile.default_participant.location.id}}' -- <-- 2nd test
then 'N/A'
when {{pre_delivery_verify}} = 'Confirm' and {{action}} <> 'Received' <-- 3rd test
then 'Assured'
when {{actor}} = 'Seller' <-- 4th test
then
case
@daviddahl
daviddahl / css-transform-research.md
Last active May 18, 2016 20:50
CSS transform research

CSS transform research

Find, in the relevant standard(s), why the following works in Gecko:

  • elem.style.WebKitTransform

A:

It is difficult to tell from reading the spec why the browser implementations behave the way the do. Outside of the standards process, human decisions around not supporting unstandardized browser functionality and behavior drove the usage of -webkit-* and -moz-*. digging through the mailing lists will no doubt turn up the exact reasons.

For now, the techical reasons are found in code.

@daviddahl
daviddahl / plv8-modules.sh
Last active June 22, 2017 02:52
plv8-modules
#! /bin/bash
sudo apt-get install npm
cd /var/django
npm install moment moment-timezone
sudo -u postgres psql -d template1 -c "create extension plv8;"
sudo -u postgres psql -d template1 << EOF
@daviddahl
daviddahl / last_update.sql
Last active September 22, 2016 17:35
CREATE OR REPLACE VIEW pds_retailer_inventory_latest_vu AS
SELECT a.id,
a.created,
a.updated,
greatest(a.created, a.updated) as last_updated,
(SELECT a.updated WHERE a.retailer_inventory_location_id = l.id ORDER BY a.updated DESC LIMIT 1) as last_inventory_run,
a.sku,
a.available_qty,
a.retailer_inventory_location_id,
l.locator_id,