data.db fixed 2024.3.6 #38
Workflow file for this run
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: pr-awesome-main | |
| on: | |
| pull_request: | |
| branches: | |
| - main | |
| paths: | |
| - 'awesome/database/data.db' | |
| jobs: | |
| compare-dbs: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Checkout code | |
| uses: actions/checkout@v2 | |
| - name: Set up SQLite | |
| run: sudo apt-get install sqlite3 | |
| - name: Install sqldiff tool | |
| run: | | |
| wget https://www.sqlite.org/2023/sqlite-tools-linux-x86-3420000.zip | |
| unzip sqlite-tools-linux-x86-3420000.zip | |
| - name: Get target branch database | |
| run: | | |
| wget -O target_data.db https://raw.githubusercontent.com/${{ github.repository }}/main/awesome/database/data.db | |
| - name: Show database schema differences | |
| run: ./sqlite-tools-linux-x86-3420000/sqldiff --schema target_data.db awesome/database/data.db | |
| - name: Show substantial tables differences | |
| run: | | |
| ./sqlite-tools-linux-x86-3420000/sqldiff --primarykey --table Course target_data.db awesome/database/data.db | |
| ./sqlite-tools-linux-x86-3420000/sqldiff --primarykey --table Organization target_data.db awesome/database/data.db | |
| ./sqlite-tools-linux-x86-3420000/sqldiff --primarykey --table User target_data.db awesome/database/data.db | |
| ./sqlite-tools-linux-x86-3420000/sqldiff --primarykey --table Tag target_data.db awesome/database/data.db | |
| ./sqlite-tools-linux-x86-3420000/sqldiff --primarykey --table CourseTags target_data.db awesome/database/data.db | |
| ./sqlite-tools-linux-x86-3420000/sqldiff --primarykey --table CourseOrganizations target_data.db awesome/database/data.db | |
| ./sqlite-tools-linux-x86-3420000/sqldiff --primarykey --table UserCourses target_data.db awesome/database/data.db | |
| ./sqlite-tools-linux-x86-3420000/sqldiff --primarykey --table Tutorial target_data.db awesome/database/data.db | |
| ./sqlite-tools-linux-x86-3420000/sqldiff --primarykey --table TutorialTags target_data.db awesome/database/data.db | |
| ./sqlite-tools-linux-x86-3420000/sqldiff --primarykey --table UserTutorials target_data.db awesome/database/data.db | |
| - name: Show all differences in database | |
| run: ./sqlite-tools-linux-x86-3420000/sqldiff --primarykey target_data.db awesome/database/data.db |