Deploy demo #645
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Deploy demo | |
| on: | |
| workflow_dispatch: | |
| schedule: | |
| - cron: '27 3 * * *' | |
| jobs: | |
| build: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Check out repo | |
| uses: actions/checkout@v3 | |
| - name: Set up Python | |
| uses: actions/setup-python@v4 | |
| with: | |
| python-version: '3.8' | |
| cache: pip | |
| cache-dependency-path: setup.py | |
| - name: Install Python dependencies | |
| run: | | |
| pip install github-to-sqlite | |
| # Need latest datasette for --apt-get-install option | |
| pip install https://github.com/simonw/datasette/archive/main.zip | |
| - name: Fetch list of my repos | |
| run: github-to-sqlite repos repos.db simonw dogsheep | |
| - name: Filter to just the repos I want in the demo | |
| run: sqlite-utils repos.db " | |
| delete from repos where full_name not in ( | |
| select full_name from repos | |
| where ( | |
| full_name like 'simonw/datasette%' | |
| or full_name like 'simonw/%-datasette' | |
| or full_name like 'simonw/sqlite-%' | |
| or full_name like '%-to-sqlite' | |
| or full_name like '%/dogsheep%' | |
| or full_name in ('simonw/museums', 'simonw/til', 'simonw/django-sql-dashboard') | |
| ) and full_name not like '%-support' and fork = 0 | |
| )" | |
| - name: Git clone my datasette* repos | |
| run: |- | |
| mkdir all | |
| cd all | |
| for line in $( | |
| sqlite-utils ../repos.db "select full_name from repos" --csv --no-headers | |
| ) | |
| do | |
| git clone https://github.com/$line --depth 1 | |
| done | |
| find . | |
| pwd | |
| cd .. | |
| - name: Create metadata.yml | |
| run: | | |
| echo ' | |
| title: datasette-ripgrep demo | |
| about: simonw/datasette-ripgrep | |
| about_url: https://github.com/simonw/datasette-ripgrep | |
| description_html: |- | |
| <style> | |
| form.ripgrep label { | |
| font-weight: normal; | |
| display: inline; | |
| } | |
| </style> | |
| <form class="ripgrep" action="/-/ripgrep" method="get"> | |
| <p> | |
| <input type="search" name="pattern" value=""> | |
| <input type="submit" value="Search"> | |
| </p> | |
| <p><strong>Options:</strong> <label><input type="checkbox" name="literal"> Literal search (not regex)</label> <label><input type="checkbox" name="ignore"> Ignore case</label></p> | |
| <p> | |
| <label><strong>File pattern</strong>: <input type="text" style="max-width: 20em" name="glob" value=""></label> | |
| </p> | |
| <p class="glob-examples">For example <code>*.py</code> or <code>**/templates/**/*.html</code> or <code>datasette/**</code> or </code><code>!setup.py</code> | |
| </p> | |
| </form> | |
| plugins: | |
| datasette-ripgrep: | |
| path: /app/all | |
| time_limit: 5.0 | |
| ' > metadata.yml | |
| - name: Set up Cloud Run | |
| uses: google-github-actions/setup-gcloud@v0 | |
| with: | |
| version: '318.0.0' | |
| service_account_email: ${{ secrets.GCP_SA_EMAIL }} | |
| service_account_key: ${{ secrets.GCP_SA_KEY }} | |
| - name: Deploy demo using Google Cloud Run | |
| run: |- | |
| gcloud config set run/region us-central1 | |
| gcloud config set project datasette-222320 | |
| datasette publish cloudrun repos.db \ | |
| --metadata metadata.yml \ | |
| --static all:all \ | |
| --install=https://github.com/simonw/datasette-ripgrep/archive/main.zip \ | |
| --service datasette-ripgrep \ | |
| --apt-get-install ripgrep |