soloman1124’s gists

soloman1124 / entrypoint.sh

Created April 17, 2021 12:32

entrypoint.sh for docker secret

	#!/usr/bin/env sh

	: ${ENV_SECRET_DIR:=/run/secrets}

	beginswith() { case $2 in "$1") true;; ) false;; esac; }

	dksec_expand() {
	for env_var in $(printenv)
	do
	value=$(echo $env_var \| cut -d"=" -f2)

soloman1124 / test.txt

Last active January 1, 2020 23:14

assessment

	spuqmrxnyvotlwz
	wnoqzxyurmlpsvt
	wrnupvltozxsmqy
	nwqzotsrxypmvlu
	nlpymquvrtzsxow
	uzomtvspqylnrxw
	utsylmxrwqnopvz
	tsoyxwqrmzuvnpl
	suvzmowrpnlxytq
	mtwnxqsrluzopvy

soloman1124 / whalebrew-vscode.sh

Last active December 16, 2018 03:07

Support whalebrew command with vscode

	#!/usr/bin/env bash

	comandline=$@
	workdir=$(pwd)/
	command="${comandline/$workdir/}"

	exec whalebrew run /usr/local/bin/yapf $command

soloman1124 / creating_a_date_dimension_table_in_postgresql.sql

Created May 15, 2017 12:11 — forked from duffn/creating_a_date_dimension_table_in_postgresql.sql

Creating a date dimension table in PostgreSQL

	DROP TABLE if exists d_date;

	CREATE TABLE d_date
	(
	date_dim_id INT NOT NULL,
	date_actual DATE NOT NULL,
	epoch BIGINT NOT NULL,
	day_suffix VARCHAR(4) NOT NULL,
	day_name VARCHAR(9) NOT NULL,
	day_of_week INT NOT NULL,

soloman1124 / data.json

Created November 18, 2015 02:09

	{
	"data": [
	{
	"date": "2015-04-30",
	"marketing_blog_views": 0.0,
	"marketing_content_downloads": 0.0,
	"marketing_edms_clicked": 0.0,
	"marketing_edms_opened": 0.0,
	"marketing_edms_sent": 0.0,
	"marketing_form_submissions": 0.0,

soloman1124 / anonymousId_dist

Created June 1, 2015 04:44

distribution of clicked_give_now_cta grouped by anonymousId

	["9a2ce82f-30ca-45e2-b94d-23e6ad9d9855", 1]
	["51efb7b1-1f09-4c1f-b1cf-ce459697747f", 1]
	["a96b24b7-27e3-4701-91d2-4630e778d3c5", 1]
	["81e27beb-5baa-45dc-aaf7-7fa5f7d63712", 1]
	["cf51d21a-8fea-45b9-a03f-84447f1e9eb3", 1]
	["523746f9-e818-4a7d-8c84-3873bcf70814", 1]
	["c1dc3f74-3c9e-4804-b231-2358cfffbfc9", 1]
	["2db9cc4c-83e9-4c9b-85eb-b33c9c1b76b8", 1]
	["721344d1-eac7-4df4-9ce2-82a26ddef869", 1]
	["2e796be2-106a-459c-a4ad-b461848ddd17", 1]

soloman1124 / 2015-05-03

Created June 1, 2015 04:39

multiple clicked_give_now_cta from same anonymousId (2)

{"timestamp"=>"2015-05-03T03:41:03.858Z", "sentAt"=>"2015-05-03T03:41:05.336Z", "anonymousId"=>"4b9b26aa-939b-464b-aaf4-fc169f6eebab", "receivedAt"=>"2015-05-03T03:41:03.859Z", "event"=>"Clicked Give Now CTA", "context"=>{"userAgent"=>"Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36", "page"=>{"title"=>"everydayhero: Spartan 2015", "referrer"=>"https://www.facebook.com/", "path"=>"/us/marta-melody-race-for-nepal", "url"=>"https://spartan-2015.everydayhero.com/us/marta-melody-race-for-nepal"}, "library"=>{"name"=>"analytics.js", "version"=>"2.8.17"}, "ip"=>"80.169.112.194"}, "originalTimestamp"=>"2015-05-03T03:41:05.335Z", "properties"=>{"category"=>"Donations", "userAgent"=>"Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36", "action"=>"Donate", "label"=>"Clicked Give Now CTA", "url"=>"https://spartan-2015.everydayhero.com/us/marta-melody-race-for-nepal", "mobile"=>false}, "projectId"=>"y8

soloman1124 / 2015-05-11

Created June 1, 2015 04:37

multiple clicked_give_now_cta from same anonymousId (1)

This file has been truncated, but you can view the full file.

{"timestamp"=>"2015-05-11T16:44:49.932Z", "sentAt"=>"2015-05-11T16:44:49.610Z", "anonymousId"=>"63abd5e4-10c9-4839-952d-8d68e75dcba7", "receivedAt"=>"2015-05-11T16:44:49.933Z", "event"=>"Clicked Give Now CTA", "context"=>{"userAgent"=>"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36", "page"=>{"title"=>"everydayhero: Honor Ride New Hampshire in Memory of Jack Nash", "referrer"=>"https://us-mg5.mail.yahoo.com/neo/launch?.partner=vz-acs&.rand=did681cdaasdo", "path"=>"/us/david-4", "url"=>"https://honor-ride-new-hampshire-2015.everydayhero.com/us/david-4"}, "library"=>{"name"=>"analytics.js", "version"=>"2.8.17"}, "ip"=>"155.39.88.241"}, "originalTimestamp"=>"2015-05-11T16:44:49.609Z", "properties"=>{"category"=>"Donations", "userAgent"=>"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36", "action"=>"Donate", "label"=>"Clicked Give Now CTA", "url"=>"https://honor-ride-new-hampshire-2015.every

soloman1124 / topdonor.json

Last active August 29, 2015 14:16

Top Donor API

	http://heroix-staging.herokuapp.com/api/v1/stats/top_donors?beneficiary_uuid=<beneficiary_uuid>&limit=7&start_time=1426044611&end_time=1426044612

	{
	"top_donors":[
	{
	"name":"Person0",
	"funds_raised":45563,
	"avatar_url":"http://lorempixel.com/100/100/people/0/"
	},
	{

soloman1124 / events_distribution.rb

Created March 3, 2015 00:26

Generate CSV for the events distribution over past few days

	require 'aws-sdk'
	require 'active_support/all'
	require 'csv'

	EVENTS_FROM = 2.day.ago
	EVENT_TYPES = %w(
	page_view user_identify clicked_give_now_cta page_received_donation_-_supporter
	post_created_-_supporter page_shared_-_supporter viewed_supporter_page viewed_sign_up_page
	commented_on_online_donation_-_supporter joined_team_-_supporter
	user_signed_in page_updated_-_supporter user_alias page_created_-_supporter

Soloman Weng soloman1124