leapingfrogs

-- From Pairing with Renee
select users.id, count(*)
from users
join courses on users.id = courses.user_id
join guided_drafts on courses.id = guided_drafts.course_id
join guided_draft_student_states on guided_drafts.id = guided_draft_student_states.guided_draft_id
where users.school_id in (79158, 79118, 78188, 78241, 78636, 78196, 78814, 79172, 162744, 78424, 78510, 165141, 79173, 169401, 78441, 165142, 78794, 78784, 165139, 136536, 78797, 78082, 78035, 78190, 78238, 159049, 165140, 169378, 78483, 78582, 165144, 78692, 78933, 79026, 165145, 79077, 79082)
and guided_draft_student_states.state in ("submitted", "graded")
and guided_draft_student_states.submitted_at > '2019/01/01' and guided_draft_student_states.submitted_at < '2019/05/01'
group by users.id

leapingfrogs

#!/usr/bin/env bash
set -euo pipefail

# This script requires:
# jq (brew install jq)
# pivotal tracker token (See API Token on https://www.pivotaltracker.com/profile while logged in)

promptValue() {
	read -rp "$1"": " val
	echo "${val}"

leapingfrogs

Keybase proof

I hereby claim:

• I am leapingfrogs on github.
• I am leapingfrogs (https://keybase.io/leapingfrogs) on keybase.
• I have a public key ASA5ud-mfMA2AG5Xw7FyftDnb_4dwI6Mu8RSyLBPWQx8Bwo

To claim this, I am signing this object:

leapingfrogs

//        final Client jerseyClient = Client.create();
        JerseyClient jerseyClient = new JerseyClientFactory(new JerseyClientConfiguration()).build(new Environment(new Configuration(), new AbstractService<Configuration>("Blah") {
            @Override
            protected void subclassServiceInsteadOfThis() {
            }

            @Override
            protected void initialize(Configuration configuration, Environment environment) throws Exception {
            }