steps

Table actions

41 rows where repo = 140912432

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: seq, job, uses, name, with, run, if

id ▼ seq job repo uses name with run env if
137033 1 Analyze 27502 sqlite-utils 140912432 actions/checkout@v2 Checkout repository {"fetch-depth": 2}      
137034 2 Analyze 27502 sqlite-utils 140912432       git checkout HEAD^2   ${{ github.event_name == 'pull_request' }}
137035 3 Analyze 27502 sqlite-utils 140912432 github/codeql-action/init@v1 Initialize CodeQL {"languages": "${{ matrix.language }}"}      
137036 4 Analyze 27502 sqlite-utils 140912432 github/codeql-action/autobuild@v1 Autobuild        
137037 5 Analyze 27502 sqlite-utils 140912432 github/codeql-action/analyze@v1 Perform CodeQL Analysis        
137038 1 documentation-links 27503 sqlite-utils 140912432 readthedocs/actions/preview@v1   {"project-slug": "sqlite-utils"}      
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    
137044 1 deploy 27505 sqlite-utils 140912432 actions/checkout@v3          
137045 2 deploy 27505 sqlite-utils 140912432 actions/setup-python@v4 Set up Python {"python-version": "3.11"}      
137046 3 deploy 27505 sqlite-utils 140912432 actions/cache@v3 Configure pip caching {"path": "~/.cache/pip", "key": "${{ runner.os }}-publish-pip-${{ hashFiles('**/setup.py') }}", "restore-keys": "${{ runner.os }}-publish-pip-\n"}      
137047 4 deploy 27505 sqlite-utils 140912432   Install dependencies   pip install setuptools wheel twine    
137048 5 deploy 27505 sqlite-utils 140912432   Publish   python setup.py sdist bdist_wheel twine upload dist/* {"TWINE_USERNAME": "__token__", "TWINE_PASSWORD": "${{ secrets.PYPI_TOKEN }}"}  
137049 1 spellcheck 27506 sqlite-utils 140912432 actions/checkout@v2          
137050 2 spellcheck 27506 sqlite-utils 140912432 actions/setup-python@v2 Set up Python ${{ matrix.python-version }} {"python-version": 3.9}      
137051 3 spellcheck 27506 sqlite-utils 140912432 actions/cache@v2 Configure pip caching {"path": "~/.cache/pip", "key": "${{ runner.os }}-pip-${{ hashFiles('**/setup.py') }}", "restore-keys": "${{ runner.os }}-pip-\n"}      
137052 4 spellcheck 27506 sqlite-utils 140912432   Install dependencies   pip install -e '.[docs]'    
137053 5 spellcheck 27506 sqlite-utils 140912432   Check spelling   codespell docs/*.rst --ignore-words docs/codespell-ignore-words.txt codespell sqlite_utils --ignore-words docs/codespell-ignore-words.txt    
137054 1 test 27507 sqlite-utils 140912432 actions/checkout@v2 Check out repo        
137055 2 test 27507 sqlite-utils 140912432 actions/setup-python@v2 Set up Python {"python-version": 3.9}      
137056 3 test 27507 sqlite-utils 140912432 actions/cache@v2 Configure pip caching {"path": "~/.cache/pip", "key": "${{ runner.os }}-pip-${{ hashFiles('**/setup.py') }}", "restore-keys": "${{ runner.os }}-pip-\n"}      
137057 4 test 27507 sqlite-utils 140912432   Install SpatiaLite   sudo apt-get install libsqlite3-mod-spatialite    
137058 5 test 27507 sqlite-utils 140912432   Install Python dependencies   python -m pip install --upgrade pip python -m pip install -e .[test] python -m pip install pytest-cov    
137059 6 test 27507 sqlite-utils 140912432   Run tests   ls -lah pytest --cov=sqlite_utils --cov-report xml:coverage.xml --cov-report term ls -lah    
137060 7 test 27507 sqlite-utils 140912432 codecov/codecov-action@v1 Upload coverage report {"token": "${{ secrets.CODECOV_TOKEN }}", "file": "coverage.xml"}      
137061 1 test 27508 sqlite-utils 140912432 actions/checkout@v3          
137062 2 test 27508 sqlite-utils 140912432 actions/setup-python@v4 Set up Python ${{ matrix.python-version }} {"python-version": "${{ matrix.python-version }}"}      
137063 3 test 27508 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"}      
137064 4 test 27508 sqlite-utils 140912432   Install dependencies   pip install -e '.[test,mypy,flake8,tui]'    
137065 5 test 27508 sqlite-utils 140912432   Optionally install numpy   pip install numpy   matrix.numpy == 1
137066 6 test 27508 sqlite-utils 140912432   Install SpatiaLite   sudo apt-get install libsqlite3-mod-spatialite   matrix.os == 'ubuntu-latest'
137067 7 test 27508 sqlite-utils 140912432   On macOS with Python 3.10 test with sqlean.py   pip install sqlean.py sqlite-dump   matrix.os == 'macos-latest' && matrix.python-version == '3.10'
137068 8 test 27508 sqlite-utils 140912432   Build extension for --load-extension test   (cd tests && gcc ext.c -fPIC -shared -o ext.so && ls -lah)   matrix.os == 'ubuntu-latest'
137069 9 test 27508 sqlite-utils 140912432   Run tests   pytest -v    
137070 10 test 27508 sqlite-utils 140912432   run mypy   mypy sqlite_utils tests    
137071 11 test 27508 sqlite-utils 140912432   run flake8 if Python 3.8 or higher   flake8   matrix.python-version >= 3.8
137072 12 test 27508 sqlite-utils 140912432   Check formatting   black . --check    
137073 13 test 27508 sqlite-utils 140912432   Check if cog needs to be run   cog --check README.md docs/*.rst    

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]);