Skip to content

Bump dotenv from 16.4.1 to 16.4.2 #943

Bump dotenv from 16.4.1 to 16.4.2

Bump dotenv from 16.4.1 to 16.4.2 #943

Workflow file for this run

name: SQLite Dump
on:
workflow_dispatch:
push:
jobs:
sqlitedump:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v3
- name: Dump the SQLite to a SQL File
run: for i in ./db/*.db; do sqlite3 $i .dump > $i.sql; done
- name: Dump the SQLite to CSV
run: for i in ./db/*.db; do sqlite3 -header -csv $i "select * from Quotes order by id Asc;" > $i.csv; done
- name: Count the quotes and write it to a YAML file
run: |
cd ./db; COUNT=$(sqlite3 quotes.db "Select Count(*) from Quotes"); echo "count: $COUNT" > quotes.count.yml
- name: Commit the SQLite dumps
uses: stefanzweifel/git-auto-commit-action@1f4914882d31162256a5dd23dd006bf97be303a2
with:
commit_message: SQLite database dump
file_pattern: db/*.db.* db/*.yml
- name: Notify if the code is broken
uses: sarisia/actions-status-discord@v1
if: failure()
with:
webhook: ${{ secrets.DISCORD_WEBHOOK }}