Skip to content

Instantly share code, notes, and snippets.

@gwak
gwak / pg_upsert_9.5.sql
Created July 26, 2017 09:06
UPSERT script in PostgreSQL 9.5+
insert into my_table (id, desc, updated_at)
values (
1,
'text',
clock_timestamp()
)
on conflict (id) -- Must be unique
do update set (desc, updated_at) = ('text', clock_timestamp())
where my_table.id = 1;
@gwak
gwak / tooltip.js
Created July 26, 2017 09:01 — forked from monzou/tooltip.js
GuidelineLayer + Tooltip w/ Plottable.js
import d3 from 'd3/d3'
import Plottable from './plottable'
const findDOMNode = (node, tag) => {
tag = tag.toUpperCase()
while (node.parentNode) {
node = node.parentNode
if (node.tagName.toUpperCase().trim() === tag) {
return node
}
@gwak
gwak / pg_update_returning_old_values.sql
Created July 26, 2017 09:00
SQL update script that returns old and new values
UPDATE tbl x
SET tbl_id = 24
, name = 'New Gal'
FROM (SELECT tbl_id, name FROM tbl WHERE tbl_id = 4 FOR UPDATE) y
WHERE x.tbl_id = y.tbl_id
RETURNING y.tbl_id AS old_id, y.name AS old_name, x.tbl_id, x.name;
@gwak
gwak / BaseModel
Last active August 29, 2015 14:15
Slick Models and Repos
package models
import org.joda.time.DateTime
/**
* Base model abstract class
* @param id Model identifier
* @param createdAt Model created date
* @param updatedAt Model updated date
*/