HypatiaDatabases/.forgejo/workflows/generate_website.yml

name: "Generate Databases and Publish to Website (hypatia.services.yayindasin.org)"
on:
  workflow_dispatch:

jobs:
  build-and-push-prod:
    runs-on: docker
    container:
      image: git.asandikci.com/docker-images/website_builder:latest # actually no need to new image?
    steps:
      - name: Git Clone
        run: |
          git clone https://git.asandikci.com/MaintainTeam/HypatiaDatabases.git
          cd HypatiaDatabases
          ls -la

    #  - name: Generate Databases
    #    run: |
    #      cd scripts
    #      bash generate databases.sh  # 
    # NOTE : I generated database files in docker in my computer locally. (Created a maven project and run Main.java) 
    #        After I completely understand the scripts and generation process I'll add this steps/files to this repo/CI
    #
    # assume this step generates all files to databases/generated/ directory, for now I am using old_generated_files_for_test/ directory, change this later

      - name: Push Databases to "static" branch
        run: |
          mkdir static && cd static
          git clone https://git.asandikci.com/MaintainTeam/HypatiaDatabases.git
          cd HypatiaDatabases
          git checkout static
          rm -rfv ./databases/
          mkdir databases
          cp -rfv ../../HypatiaDatabases/production/* ./databases/
          git config --global user.name "Aliberk Sandıkçı (CI)"
          git config --global user.email git+ci@asandikci.com
          git add -A          
          git commit --all --message "Updated Databases! [CI]"
          git push https://asandikci:${{ secrets.PUSH_KEY }}@git.asandikci.com/MaintainTeam/HypatiaDatabases
          # is it really safe to pushing inside a CI ???
          ### Hey I don't even give PUSH_KEY variable, how does it push lol ?
          ### FIXME: !!!


  publish:
    runs-on: docker
    container:
      image: git.asandikci.com/docker-images/website_builder:latest # actually no need to new image?
    steps:      
      - name: Checkout & Deploy
        run: | 
          git clone https://git.asandikci.com/MaintainTeam/HypatiaDatabases.git
          cd HypatiaDatabases
          git checkout static
          date >> info.txt

          echo '${{ secrets.SFTP_PASSWORD }}' > ~/.passwd
          chmod 0400 ~/.passwd
          sshpass -f ~/.passwd sftp -oBatchMode=no -o StrictHostKeyChecking=accept-new -b - ${{ secrets.SFTP_USERNAME }}@hypatia.services.yayindasin.org << !
            bye
          !
          lftp --user ${{ secrets.SFTP_USERNAME }} --password ${{ secrets.SFTP_PASSWORD }} sftp://hypatia.services.yayindasin.org -e "mirror -R --delete . www/"
          
          ## TODO: see https://git.asandikci.com/asandikci.com/web/issues/10 for ftp related ...
          # CURRENTLY USING PURE STFP FOR AUTH ONLY
          # TODO: CHANGE THIS