| CREATE OR REPLACE FUNCTION change_trigger() RETURNS trigger AS $$ | |
| BEGIN | |
| IF TG_OP = 'INSERT' | |
| THEN | |
| INSERT INTO history (tabname, schemaname, operation, new_val, item_id) | |
| VALUES (TG_RELNAME, TG_TABLE_SCHEMA, TG_OP, row_to_json(NEW), NEW.id); | |
| RETURN NEW; | |
| ELSIF TG_OP = 'UPDATE' | |
| THEN | |
| INSERT INTO history (tabname, schemaname, operation, new_val, old_val, item_id) |
| package main | |
| import ( | |
| "fmt" | |
| "runtime" | |
| "sync" | |
| "time" | |
| "github.com/tevino/abool" | |
| ) |
| extension String { | |
| func stripComments() -> String { | |
| // ((\s|,)\/\*[\s\S]*?\*\/)|(( |, ")\/\/.*) | |
| return self.replacingOccurrences(of: "((\\s|,)\\/\\*[\\s\\S]*?\\*\\/)|(( |, \\\")\\/\\/.*)", with: "", options: .regularExpression) | |
| } | |
| } |
| { | |
| "BTTPresetName" : "Default", | |
| "BTTPresetUUID" : "4DA9BBE8-9392-4B6C-A22B-AAF8189CE7C1", | |
| "BTTPresetContent" : [ | |
| { | |
| "BTTAppBundleIdentifier" : "BT.G", | |
| "BTTAppName" : "Global", | |
| "BTTAppSpecificSettings" : { | |
| }, |
| CREATE OR REPLACE FUNCTION "json_append"(IN "data" json, IN insert_data json) RETURNS "json" AS $BODY$ | |
| SELECT ('{'||string_agg(to_json(key)||':'||value, ',')||'}')::json | |
| FROM ( | |
| SELECT * FROM json_each(data) | |
| UNION ALL | |
| SELECT * FROM json_each(insert_data) | |
| ) t; | |
| $BODY$ | |
| LANGUAGE sql | |
| COST 100 |
This simple script will take a picture of a whiteboard and use parts of the ImageMagick library with sane defaults to clean it up tremendously.
The script is here:
#!/bin/bash
convert "$1" -morphology Convolve DoG:15,100,0 -negate -normalize -blur 0x1 -channel RBG -level 60%,91%,0.1 "$2"
| #!/bin/bash | |
| # usage: ems.sh <tracking> <sleep_duration> | |
| export SLEEP=60 | |
| export TRACKING="" | |
| if [ $1 ]; then | |
| TRACKING="$1" | |
| else |