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
200
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
58
Decoupled Drupal Days 2018: Drupal Unhitched
mllobrera
0
290
Drupaldelphia 2018: Drupal Unhitched: The CMS in Decoupled Architectures
mllobrera
0
240
Drupalcon 2017: Pattern Language: Pattern Libraries in the Wild
mllobrera
0
440
Philly Tech Week 2016: Decoupled Development: Feeding Your Application with Off-the-Shelf Tools
mllobrera
0
120
Drupal Beyond the Browser: Using Drupal to Power Apps and Touchscreens
mllobrera
0
320
Decoupled Development with WordPress JSON APIs
mllobrera
0
640
Drupaldelphia 2014: Progressive Enhancement in Drupal 7, Using Ajax-Include Patterns
mllobrera
0
130
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
地方拠点で エンジニアリングマネージャーってできるの? 〜地方という制約を楽しむオーナーシップとコミュニティ作り〜
1coin
1
130
技術負債の「予兆検知」と「状況異変」のススメ / Technology Dept
i35_267
1
1k
ビジネスと現場活動をつなぐソフトウェアエンジニアリング~とあるスタートアッププロダクトの成長記録より~
mizunori
0
210
自動テストの世界に、この5年間で起きたこと
autifyhq
10
7.1k
MC906491 を見据えた Microsoft Entra Connect アップグレード対応
tamaiyutaro
1
480
RSNA2024振り返り
nanachi
0
500
Ask! NIKKEIの運用基盤と改善に向けた取り組み / NIKKEI TECH TALK #30
kaitomajima
1
450
エンジニアの育成を支える爆速フィードバック文化
sansantech
PRO
3
660
Building Products in the LLM Era
ymatsuwitter
10
4.4k
依存関係があるコンポーネントは Barrel ファイルでまとめよう
azukiazusa1
3
530
Classmethod AI Talks(CATs) #15 司会進行スライド(2025.02.06) / classmethod-ai-talks-aka-cats_moderator-slides_vol15_2025-02-06
shinyaa31
0
170
Moved to https://speakerdeck.com/toshihue/presales-engineer-career-bridging-tech-biz-ja
toshihue
2
550
Featured
See All Featured
The Invisible Side of Design
smashingmag
299
50k
The World Runs on Bad Software
bkeepers
PRO
67
11k
jQuery: Nuts, Bolts and Bling
dougneiner
63
7.6k
Code Review Best Practice
trishagee
66
17k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
59k
Designing on Purpose - Digital PM Summit 2013
jponch
117
7.1k
The Art of Delivering Value - GDevCon NA Keynote
reverentgeek
10
1.3k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
29
4.6k
Java REST API Framework Comparison - PWX 2021
mraible
28
8.4k
Testing 201, or: Great Expectations
jmmastey
41
7.2k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
47
5.2k
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
7
630
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