Skip to content

Instantly share code, notes, and snippets.

View rngadam's full-sized avatar
💭
coderbunker.ca

Ricky Ng-Adam rngadam

💭
coderbunker.ca
View GitHub Profile
```
*** /Users/rngadam/coderbunker/prj/scryinfo/pgddl/test/expected/init.out 2018-03-26 18:22:55.000000000 +0800
--- /Users/rngadam/coderbunker/prj/scryinfo/pgddl/results/init.out 2018-03-26 18:23:15.000000000 +0800
***************
*** 31,38 ****
pg_ddlx_create_event_trigger(oid) |
pg_ddlx_create_foreign_data_wrapper(oid) |
pg_ddlx_create_function(regproc) |
- pg_ddlx_create_indexes(regclass) |
pg_ddlx_create_index(regclass) |
*** /Users/rngadam/coderbunker/prj/scryinfo/pgddl/test/expected/type.out 2018-03-26 23:41:47.000000000 +0800
--- /Users/rngadam/coderbunker/prj/scryinfo/pgddl/results/type.out 2018-03-27 00:00:25.000000000 +0800
***************
*** 98,104 ****
-- DROP DOMAIN test_collation_d;
CREATE DOMAIN test_collation_d AS text
! COLLATE "en_US.utf8"
DEFAULT '***'::text;
CREATE OR REPLACE function safe_cast(text,anyelement)
returns anyelement
language plpgsql as $$
begin
$0 := $1;
return $0;
exception when others then
return $2;
end; $$;
*** /Users/rngadam/coderbunker/prj/scryinfo/pgddl/test/expected/type.out 2018-03-31 09:38:34.000000000 +0800
--- /Users/rngadam/coderbunker/prj/scryinfo/pgddl/results/type.out 2018-03-31 09:38:44.000000000 +0800
***************
*** 128,134 ****
);
COMMENT ON TYPE integer IS '-2 billion to 2 billion integer, 4-byte storage';
! ALTER TYPE integer OWNER TO postgres;
END;
-- expect this to work but it doesn't...
CREATE OR REPLACE FUNCTION create_update_enum(schemaname TEXT, typname TEXT, enum_values text[]) RETURNS SETOF TEXT AS
$$
DECLARE
has_type BOOLEAN;
label text[];
BEGIN
SELECT count(*) = 1 INTO has_type
FROM pg_type
*** /Users/rngadam/coderbunker/src/pgddl/test/expected/type.out 2018-04-18 10:45:57.000000000 +0800
--- /Users/rngadam/coderbunker/src/pgddl/results/type.out 2018-04-18 10:46:20.000000000 +0800
***************
*** 128,134 ****
);
COMMENT ON TYPE integer IS '-2 billion to 2 billion integer, 4-byte storage';
! ALTER TYPE integer OWNER TO postgres;
END;
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
DROP SCHEMA IF EXISTS design CASCADE;
CREATE SCHEMA IF NOT EXISTS design;
CREATE TABLE IF NOT EXISTS design.event(
id uuid DEFAULT uuid_generate_v4() PRIMARY KEY,
name TEXT
);
# using SendGrid's Python Library
# https://github.com/sendgrid/sendgrid-python
import sendgrid
import os
from sendgrid.helpers.mail import *
import xlrd
def sendEmail(emailAddress):
sg = sendgrid.SendGridAPIClient(apikey=os.environ.get('SENDGRID_API_KEY'))
{
"default_size" : 0.142,
"tags" : [
{
"ID": 0,
"position": [ 1.4, 0, -1 ],
"rotation": [ 0, 5, 0 ],
"size": 0.1
},
{
@rngadam
rngadam / .gitconfig
Created September 7, 2018 03:12
git configuration from rngadam-mac
[user]
name = Ricky Ng-Adam
email = rngadam@gmail.com
[alias]
st = status
ci = commit
co = checkout
br = branch
ss = status -sb
ll = log --oneline --decorate