update move transactionId param #104
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 | |
| on: | |
| push: | |
| branches: | |
| - main # Adjust branch name if necessary | |
| pull_request: | |
| branches: | |
| - main # Adjust branch name if necessary | |
| jobs: | |
| deployment: | |
| name: deploy | |
| runs-on: ubuntu-latest | |
| permissions: write-all | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Install dependencies | |
| run: sudo apt-get update && sudo apt-get install -y build-essential cmake g++ gdb make ninja-build rsync zip | |
| - name: Check CMake version | |
| run: cmake --version | |
| - name: Install Python | |
| uses: actions/setup-python@v2 | |
| with: | |
| python-version: '3.x' | |
| - name: Install Conan | |
| run: | | |
| sudo pip install conan==2.2.2 | |
| sudo conan config install https://bitbucket.org/telkom-workspace/gaboot-backend/downloads/config_linux.zip | |
| - name: Install Package | |
| run: sudo conan install conanfile.py -of=conan/Linux --build=missing | |
| - name: Echo list of files before removal | |
| run: ls | |
| - name: Remove CMakeUserPresets.json | |
| run: sudo rm CMakeUserPresets.json | |
| - name: Echo list of files after removal | |
| run: ls | |
| - name: Configure CMakeList | |
| run: sudo cmake -D CMAKE_BUILD_TYPE=Release -S. -Bbuild -G Ninja | |
| - name: Build 64bit release Executable | |
| run: | | |
| sudo cmake --build ./build --config Release --target Gaboot -- | |
| - name: Check if Executable got built | |
| run: if [ ! -f "build/Gaboot" ]; then exit 1; fi | |
| - name: Move binary to new folder | |
| run: | | |
| sudo mkdir Linux | |
| sudo mkdir Linux/postgres | |
| sudo mkdir Linux/postgres/data | |
| echo "SERVER_KEY=${{ secrets.SERVER_KEY }}" | sudo tee ./Linux/.env | |
| echo "SECRET=${{ secrets.SECRET }}" | sudo tee -a ./Linux/.env | |
| sudo cp -r src/assets Linux/assets | |
| sudo cp config/config.json Linux/config.json | |
| sudo cp config/pg_hba.conf Linux/postgres/data/pg_hba.conf | |
| sudo cp config/supervisord.conf Linux/supervisord.conf | |
| sudo cp Dockerfile Linux/Dockerfile | |
| sudo cp docker-compose.yml Linux/docker-compose.yml | |
| sudo cp build/Gaboot Linux/Gaboot | |
| - name: Zip files | |
| run: sudo zip -r Gaboot.zip Linux/Gaboot Linux/config.json Linux/Dockerfile Linux/docker-compose.yml Linux/supervisord.conf Linux/assets Linux/.env | |
| - name: Upload binary to release | |
| uses: svenstaro/upload-release-action@v2 | |
| with: | |
| repo_token: ${{ secrets.GITHUB_TOKEN }} | |
| file: ./Gaboot.zip | |
| tag: v1.0.0 | |
| asset_name: Gaboot.zip | |
| overwrite: true | |
| body: "Gaboot Release Binary" | |
| repo_name: skript023/Gaboot | |
| - name: Install SSH key | |
| uses: webfactory/ssh-agent@v0.5.3 | |
| with: | |
| ssh-private-key: ${{ secrets.SSH_PRIVATE_KEY }} | |
| - name: Set safe directory | |
| run: ssh -o StrictHostKeyChecking=no ${{ secrets.SERVER_USER }}@${{ secrets.SERVER_IP }} "git config --global --add safe.directory /home/${{ secrets.SERVER_USER }}/gbt-backend/Linux/" | |
| - name: Deploy code | |
| run: | | |
| ssh -o StrictHostKeyChecking=no ${{ secrets.SERVER_USER }}@${{ secrets.SERVER_IP }} "cd /home/${{ secrets.SERVER_USER }}/gbt-backend/ && sudo rm -f Gaboot.zip" | |
| ssh -o StrictHostKeyChecking=no ${{ secrets.SERVER_USER }}@${{ secrets.SERVER_IP }} "cd /home/${{ secrets.SERVER_USER }}/gbt-backend/ && sudo wget https://github.com/skript023/Gaboot/releases/download/v1.0.0/Gaboot.zip" -O Gaboot.zip | |
| ssh -o StrictHostKeyChecking=no ${{ secrets.SERVER_USER }}@${{ secrets.SERVER_IP }} "cd /home/${{ secrets.SERVER_USER }}/gbt-backend/ && sudo rm -r Linux/" | |
| ssh -o StrictHostKeyChecking=no ${{ secrets.SERVER_USER }}@${{ secrets.SERVER_IP }} "cd /home/${{ secrets.SERVER_USER }}/gbt-backend/ && sudo unzip -o Gaboot.zip" | |
| - name: Deploy to docker containers | |
| run: ssh ${{ secrets.SERVER_USER }}@${{ secrets.SERVER_IP }} "cd /home/${{ secrets.SERVER_USER }}/gbt-backend/Linux/ && sudo docker compose up -d --build" | |
| #- name: Build and start Docker containers | |
| # run: | | |
| # ssh ${{ secrets.SERVER_USER }}@${{ secrets.SERVER_IP }} " | |
| # export PGPASSWORD='${{ secrets.DB_PASSWORD }}' | |
| # if sudo docker ps --format '{{.Names}}' | grep -q "gaboot-shop-database"; then | |
| # cd /home/${{ secrets.SERVER_USER }}/gbt-backend/Linux/ && sudo docker compose up -d --build gaboot-api | |
| # cd /home/${{ secrets.SERVER_USER }}/gbt-backend/Linux/ && sudo docker compose restart | |
| # else | |
| # cd /home/${{ secrets.SERVER_USER }}/gbt-backend/Linux/ && sudo docker compose down | |
| # cd /home/${{ secrets.SERVER_USER }}/gbt-backend/Linux/ && sudo docker compose up --build -d | |
| # cd /home/${{ secrets.SERVER_USER }}/gbt-backend/Linux/ && sudo docker cp ../gaboot.sql gaboot-shop-database:/docker-entrypoint-initdb.d/gaboot.sql | |
| # cd /home/${{ secrets.SERVER_USER }}/gbt-backend/Linux/ && sudo docker exec -i gaboot-shop-database psql -U ${{ secrets.DB_USER }} -W ${{ secrets.DB_PASSWORD }} -f docker-entrypoint-initdb.d/gaboot.sql | |
| # fi" | |
| #- name: Connect to PostgreSQL and run SQL query | |
| # run: | | |
| # ssh ${{ secrets.SERVER_USER }}@${{ secrets.SERVER_IP }} export PGPASSWORD="${{ secrets.DB_PASSWORD }}" | |
| # ssh ${{ secrets.SERVER_USER }}@${{ secrets.SERVER_IP }} output=$(sudo psql -h localhost -p 5433 -U ${{ secrets.DB_USER }} -W ${{ secrets.DB_PASSWORD }} -c "SELECT EXISTS (SELECT 1 FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'master_users');") | |
| #- name: Load dump sql | |
| # run: | | |
| # ssh ${{ secrets.SERVER_USER }}@${{ secrets.SERVER_IP }} export PGPASSWORD="${{ secrets.DB_PASSWORD }}" | |
| # ssh ${{ secrets.SERVER_USER }}@${{ secrets.SERVER_IP }} " | |
| # cd /home/${{ secrets.SERVER_USER }}/gbt-backend/Linux/ && | |
| # if [ '$output' == 'f' ]; then | |
| # sudo docker cp ../gaboot.sql gaboot-shop-database:/docker-entrypoint-initdb.d/gaboot.sql | |
| # sudo docker exec -i gaboot-shop-database psql -U ${{ secrets.DB_USER }} -W ${{ secrets.DB_PASSWORD }} -f docker-entrypoint-initdb.d/gaboot.sql | |
| # fi" | |