steps
3 rows where seq = 9
This data as json, CSV (advanced)
with 1 ✖
id ▼ | seq | job | repo | uses | name | with | run | env | if |
---|---|---|---|---|---|---|---|---|---|
136870 | 9 | scheduled 27466 | github-to-sqlite 207052882 | actions/upload-artifact@v2 | {"path": "github.db"} | ||||
136975 | 9 | deploy 27488 | datasette 107914493 | Make some modifications to metadata.json | cat fixtures.json | \ jq '.databases |= . + {"ephemeral": {"allow": {"id": "*"}}}' | \ jq '.plugins |= . + {"datasette-ephemeral-tables": {"table_ttl": 900}}' \ > metadata.json cat metadata.json | ||||
137069 | 9 | test 27508 | sqlite-utils 140912432 | Run tests | pytest -v |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);