steps

Table actions

5 rows where job = 27471

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ seq job repo uses name with run env if
136891 1 test 27471 hacker-news-to-sqlite 248903544 actions/checkout@v2          
136892 2 test 27471 hacker-news-to-sqlite 248903544 actions/setup-python@v2 Set up Python ${{ matrix.python-version }} {"python-version": "${{ matrix.python-version }}"}      
136893 3 test 27471 hacker-news-to-sqlite 248903544 actions/cache@v2 Configure pip caching {"path": "~/.cache/pip", "key": "${{ runner.os }}-pip-${{ hashFiles('**/setup.py') }}", "restore-keys": "${{ runner.os }}-pip-\n"}      
136894 4 test 27471 hacker-news-to-sqlite 248903544   Install dependencies   pip install -e '.[test]'    
136895 5 test 27471 hacker-news-to-sqlite 248903544   Run tests   pytest    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [steps] (
   [id] INTEGER PRIMARY KEY,
   [seq] INTEGER,
   [job] INTEGER REFERENCES [jobs]([id]),
   [repo] INTEGER REFERENCES [repos]([id]),
   [uses] TEXT,
   [name] TEXT,
   [with] TEXT,
   [run] TEXT
, [env] TEXT, [if] TEXT);
CREATE INDEX [idx_steps_repo]
    ON [steps] ([repo]);
CREATE INDEX [idx_steps_job]
    ON [steps] ([job]);