Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
DIW 2016: Github Project Scaffolding with Googl...
Search
dirtystylus
November 15, 2016
Technology
0
240
DIW 2016: Github Project Scaffolding with Google Sheets and Zenhub
Talk given at Delaware Innovation Week. November 15, 2016
dirtystylus
November 15, 2016
Tweet
Share
More Decks by dirtystylus
See All by dirtystylus
Rapid Data APIs using GraphQL and Drupal
mllobrera
0
64
Decoupled Drupal Days 2018: Drupal Unhitched
mllobrera
0
330
Drupaldelphia 2018: Drupal Unhitched: The CMS in Decoupled Architectures
mllobrera
0
270
Drupalcon 2017: Pattern Language: Pattern Libraries in the Wild
mllobrera
0
470
Philly Tech Week 2016: Decoupled Development: Feeding Your Application with Off-the-Shelf Tools
mllobrera
0
160
Drupal Beyond the Browser: Using Drupal to Power Apps and Touchscreens
mllobrera
0
360
Decoupled Development with WordPress JSON APIs
mllobrera
0
730
Drupaldelphia 2014: Progressive Enhancement in Drupal 7, Using Ajax-Include Patterns
mllobrera
0
170
Drupaldelphia 2013 - Tyler School of Art: A Case Study in User-Centered Decision-Making
mllobrera
0
1k
Other Decks in Technology
See All in Technology
物体検出モデルでシイタケの収穫時期を自動判定してみた。 #devio2025
lamaglama39
0
110
ユーザーの声とAI検証で進める、プロダクトディスカバリー
sansantech
PRO
1
140
【Kaigi on Rails 事後勉強会LT】MeはどうしてGirlsに? 私とRubyを繋いだRail(s)
joyfrommasara
0
270
PHPからはじめるコンピュータアーキテクチャ / From Scripts to Silicon: A Journey Through the Layers of Computing Hiroshima 2025 Edition
tomzoh
0
140
新規事業におけるGORM+SQLx併用アーキテクチャ
hacomono
PRO
0
290
Claude Code Subagents 再入門 ~cc-sddの実装で学んだこと~
gotalab555
6
9.6k
[Keynote] What do you need to know about DevEx in 2025
salaboy
0
170
AI Agent Dojo #2 watsonx Orchestrateフローの作成
oniak3ibm
PRO
0
120
「使い方教えて」「事例教えて」じゃもう遅い! Microsoft 365 Copilot を触り倒そう!
taichinakamura
0
390
Introduction to Sansan for Engineers / エンジニア向け会社紹介
sansan33
PRO
5
43k
アイテムレビュー機能導入からの学びと改善
zozotech
PRO
0
170
大規模サーバーレスAPIの堅牢性・信頼性設計 〜AWSのベストプラクティスから始まる現実的制約との向き合い方〜
maimyyym
10
4.8k
Featured
See All Featured
We Have a Design System, Now What?
morganepeng
53
7.8k
The Art of Programming - Codeland 2020
erikaheidi
56
14k
Imperfection Machines: The Place of Print at Facebook
scottboms
269
13k
Product Roadmaps are Hard
iamctodd
PRO
54
11k
The Invisible Side of Design
smashingmag
302
51k
Rails Girls Zürich Keynote
gr2m
95
14k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
33
2.5k
A better future with KSS
kneath
239
18k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
45
2.5k
Why You Should Never Use an ORM
jnunemaker
PRO
59
9.6k
Large-scale JavaScript Application Architecture
addyosmani
514
110k
The Cult of Friendly URLs
andyhume
79
6.6k
Transcript
Github Project Scaffolding with Google Sheets and Zenhub Delaware Innovation
Week November 15, 2016
Hi. I’m Mark. Director of Technology, Bluecadet @dirtystylus
Let’s talk about workflow. Beginnings, and endings.
Clues from cooking • Recipes—what is the base set of
things you repeat for success? • Tasks for setting up a project • Tasks for launching a project • Manual entry = time
Interlude: Bench Time @ Bluecadet • List of pre-approved internal
agency projects • Folks can chip away at things they’re excited about • Some examples: Electron for web-based apps. Unity 3D in Oculus Rift.
Addressing the pain points at the start and end.
Ingredients • Listening • Empathy • Github API • Python
• PyGithub (https://github.com/PyGithub/PyGithub)
Automation to reduce friction.
Step One: Create an Issue
#!/usr/bin/python import sys sys.path.append("./PyGithub"); from github import Github import getpass
# Authenticate to github.com and create PyGithub "Github" object username
= raw_input("Github username: ") pw = getpass.getpass() g = Github(username, pw) repository = "dirtystylus/pygithub-sandbox" repo = g.get_repo(repository) issue = repo.create_issue("Test issue", "This is a test issue.")
Step Two: Labels and Milestones
Prerequisites • Create Labels and Milestones first • Label is
String • Milestone is Integer • ¯\_(ツ)_/¯
username = raw_input("Github username: ") pw = getpass.getpass() g =
Github(username, pw) user = g.get_user(username) repository = "dirtystylus/pygithub-sandbox" repo = g.get_repo(repository) milestone = repo.get_milestone(1) labels = ["Launch Checklist"] issue = repo.create_issue("Test issue", "This is a test issue.", user, milestone, labels)
Step Three: CSV
Prerequisites • CSV file with a column of Issue names
• csv, time libraries
username = raw_input("Github username: ") pw = getpass.getpass() g =
Github(username, pw) user = g.get_user(username) repository = "dirtystylus/pygithub-sandbox" repo = g.get_repo(repository) milestone = repo.get_milestone(1) labels = ["Launch Checklist"] csv_file = "launch-checklist.csv"
with open(csv_file, 'rb') as f: reader = csv.reader(f) for row
in reader: issue = repo.create_issue("Launch Checklist: " + row[0], row[0], user, milestone, labels) print "Created issue Launch Checklist: " + row[0] time.sleep(2)
Step Four: Google Sheet
Living Documents • Launch Checklist Template item examples: ◦ Enable
caching ◦ Performance Tests (Webpagetest) ◦ Test 404 page ◦ Test 301 redirects
Prerequisites • Google Quick Start: https://developers.google.com/sheets/quickstart/python • client_secret.json • google-api-python-client
library
None
None
def get_credentials(): # Google OAuth stuff here def main(): #
Pretty much the same as before, except now we’re pulling in the spreadsheet from Google’s Sheets API and then looping through it
Example Time
None
None
None
None
None
None
Sudden-death overtime
Github + Zenhub • Zenhub (https://www.zenhub.com) • Lightweight kanban-style project
boards • Estimates, burndowns
Zenhub Board Setup • Backlog (sometimes we set up future
pipelines to reduce volume) • Ready • In Progress • Blocked • Done
None
Thank you. Mark Llobrera (@dirtystylus) Slides: https://speakerdeck.com/mllobrera/diw-2016-github-project-scaffolding-with-google-sheets-and-zenh ub Repo: https://github.com/dirtystylus/diw-2016