jonhilgart22

--ltv for users to call
with most_recent_subscription as (
	select
		user_id,
		max(created_at) as created_at
	from subscriptions s
	group by 1
),
weekly_minutes as (

jonhilgart22

with most_recent_subscription as (
	select
		user_id,
		max(created_at) as created_at
	from subscriptions s
	group by 1
),
weekly_minutes as (
	select
		date_trunc('month', subscription_started_at) as sub_start_month,

jonhilgart22

--waitlist
select
	distinct
	us.name,
	us.email,
	c.code as pricing_plan,
	c.amount,
	u.created_at::date as entered_credit_card_at
from user_events u
join coupons c

jonhilgart22

with most_recent_subscription as (
  select
    user_id,
    max(id) as subscription_id
  from alooma.subscriptions
  group by 1
),
weekly_minutes as (
  select
    a.user_id,

jonhilgart22

pyenv virtualenv 2.7.10 my-virtual-env-2.7.10

Need to run - pyenv install 3.6.5 if the python version is not installed

jonhilgart22

ls -F |grep -v / | wc -l

jonhilgart22

sudo du -hsx /* | sort -rh | head -n 40

jonhilgart22

# create
python -m venv .

# activate
source /bin/activate

jonhilgart22

.git/hooks/pre-push
^new file

chmod +x pre-push

#!/bin/bash

protected_branch='master'
current_branch=$(git symbolic-ref HEAD | sed -e 's,.*/\(.*\),\1,')

jonhilgart22

 python -m ipykernel install --user --name=jupyter2 
 
 replace jupyter2 with the pyenv name