andrewp-as-is

"""
https://docs.djangoproject.com/en/dev/topics/security/#ssl-https
"""

if '1' in str(os.getenv('SECURE_SSL')):
    SECURE_SSL_REDIRECT = True
    SECURE_PROXY_SSL_HEADER = ('HTTP_X_FORWARDED_PROTO', 'https')

"""".env file:
SECURE_SSL=1

andrewp-as-is

#!/usr/bin/env python
import re

s = 'word1 :blush: word2'
print(re.sub(':[^:]+:', '', s).strip())

andrewp-as-is

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
	<key>URL</key>
	<string>https://discordapp.com/developers/docs/resources/webhook#execute-webhook</string>
</dict>
</plist>

andrewp-as-is

#!/usr/bin/env bash
{ set +x; } 2>/dev/null

set ~/Applications/name.app

/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/LaunchServices.framework/Versions/A/Support/lsregister -f "$@"

andrewp-as-is

#!/usr/bin/env bash


VERSIONER_PERL_PREFER_32_BIT=1 perl -MMac::InternetConfig -le 'print +(GetICHelper "http")[1]'

andrewp-as-is

NODE_PATH:=~/node_modules

sass:
	node-sass --include-path $(NODE_PATH) ./static/src/index.scss ./static/src/index.css

andrewp-as-is

CREATE TABLE IF NOT EXISTS t(
    id serial PRIMARY KEY,
    value text
);
INSERT INTO t(id,value) VALUES (1,'value1'), (2,'value2');

CREATE TABLE t_with_data AS TABLE t;
CREATE TABLE t_without_data AS TABLE t WITH NO DATA;

select COUNT(*) from t_without_data;

andrewp-as-is

andrewp-as-is

1,val"ue

andrewp-as-is

CREATE OR REPLACE FUNCTION basename(path text) RETURNS text AS $$

    SELECT reverse((regexp_split_to_array(reverse($1), '/'))[1])

$$
    LANGUAGE SQL IMMUTABLE;

SELECT basename('/Users/username/git/owner/repo');