steps

Table actions

5 rows where job = 27504

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ seq job repo uses name with run env if
137039 1 test 27504 sqlite-utils 140912432 actions/checkout@v3          
137040 2 test 27504 sqlite-utils 140912432 actions/setup-python@v4 Set up Python ${{ matrix.python-version }} {"python-version": "${{ matrix.python-version }}"}      
137041 3 test 27504 sqlite-utils 140912432 actions/cache@v3 Configure pip caching {"path": "~/.cache/pip", "key": "${{ runner.os }}-pip-${{ hashFiles('**/setup.py') }}", "restore-keys": "${{ runner.os }}-pip-\n"}      
137042 4 test 27504 sqlite-utils 140912432   Install dependencies   pip install -e '.[test,tui]'    
137043 5 test 27504 sqlite-utils 140912432   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]);