buckmaxwell

import csv
import requests
import glob
import time
import os
import hashlib
from urllib.request import urlretrieve
from PyPDF2 import PdfReader
from PyPDF2.errors import PdfReadError

buckmaxwell

-- users in city without complete profile
with city as (
select poly from sitter_area area where area.name = 'Cincinnati'
)

select u.id, u.first_name, u.last_name from sitter_user u
join sitter_babysitter b on b.user_id = u.id
join sitter_babysittersuccessprogress bsp on bsp.babysitter_id = b.id
join sitter_address a on a.user_id = u.id and ST_WITHIN(a.point, (select poly from city))
where bsp.completed_profile is null

buckmaxwell

python-dispatch==0.2.0
python-rtmidi==1.4.9
websocket-client==1.3.3; python_version >= "3.7"

buckmaxwell

terraform {
  required_providers {
    aws = {
      source  = "hashicorp/aws"
      version = "~> 3.0"
    }
  }
}

provider "aws" {

buckmaxwell

/* My db is clean -- all the messages just say 'Test', this is my starting point */
select * from sitter_message;

-- Threads longer than 1 message
select thread_id, l from (
select message_thread.thread_id, jsonb_agg(message_thread.added_at order by message_thread.added_at) l from
		(
		with sitter_ids as (select user_id id from sitter_babysitter),
		messages_w_context as (
			select m.*, (case when sender_id in (select id from sitter_ids) then true else false end) sender_is_sitter 

buckmaxwell

SELECT
    l
FROM (
    SELECT
        jsonb_agg(score ORDER BY added_at) l
    FROM
        sitter_jobscorehistory
    GROUP BY
        ongoing_request_id) tab1
WHERE

buckmaxwell

# Given an array of people objects (where each person has a name and a number
# of pizza slices they're hungry for) and a number for the number of slices
# that the pizza can be sliced into, return the number of pizzas you need to
# buy.

import math


def gimme_pizza(people, slices_per_pie):
    if people and slices_per_pie > 0:

buckmaxwell

# Given an array of integers representing asteroids in a row, for each
# asteroid, the absolute value represents its size, and the sign represents its
# direction (positive = right, negative = left). Return the state of the
# asteroids after all collisions (assuming they are moving at the same speed).
# If two asteroids meet, the smaller one will explode. When they are the same
# size, they both explode. Asteroids moving in the same direction will never
# meet.


def asteroids(a):

buckmaxwell

#!/usr/bin/env python3


def stock_buy_sell(tst):
    """Given an array of numbers that represent stock prices (where each
    number is the price for a certain day), find 2 days when you should buy
    and sell your stock for the highest profit."""

    i = len(tst) - 1
    high_idx, low_idx = i, i

buckmaxwell

set nocompatible              " be iMproved, required
filetype off                  " required

" set the runtime path to include Vundle and initialize
set rtp+=~/.vim/bundle/Vundle.vim
call vundle#begin()
" alternatively, pass a path where Vundle should install plugins
"call vundle#begin('~/some/path/here')

" let Vundle manage Vundle, required