feat: update dbgate-query-splitter tp 4.11.3

feat: sqlite triggers tests
fix: prevent testing empty parameters
2025-01-07 09:20:59 +01:00 · 2025-01-02 11:47:07 +01:00 · 2025-01-02 11:41:00 +01:00 · 2025-01-02 11:26:40 +01:00 · 2025-01-02 11:26:40 +01:00 · 2025-01-02 10:59:22 +01:00
67 changed files with 3159 additions and 2148 deletions
@@ -1,83 +1,86 @@
+# --------------------------------------------------------------------------------------------
+# This file is generated. Do not edit manually
+# --------------------------------------------------------------------------------------------
 name: Electron app BETA
-
-on:
+'on':
  push:
    tags:
      - 'v[0-9]+.[0-9]+.[0-9]+-beta.[0-9]+'
-
 jobs:
  build:
-    runs-on: ${{ matrix.os }}
-
+    runs-on: '${{ matrix.os }}'
    strategy:
      fail-fast: false
      matrix:
-        os: [macos-14, windows-2022, ubuntu-22.04]
-        # os: [macOS-10.15]
-
+        os:
+          - macos-14
+          - windows-2022
+          - ubuntu-22.04
    steps:
+      - name: Install python 3.11 (MacOS)
+        if: matrix.os == 'macos-14'
+        run: |
+          brew install python@3.11
+          echo "PYTHON=/opt/homebrew/bin/python3.11" >> $GITHUB_ENV
      - name: Context
        env:
-          GITHUB_CONTEXT: ${{ toJson(github) }}
+          GITHUB_CONTEXT: '${{ toJson(github) }}'
        run: echo "$GITHUB_CONTEXT"
      - uses: actions/checkout@v2
        with:
          fetch-depth: 1
-      - name: Use Node.js 18.x
+      - name: Use Node.js 22.x
        uses: actions/setup-node@v1
        with:
-          node-version: 18.x
-      - name: yarn adjustPackageJson
+          node-version: 22.x
+      - name: adjustPackageJson
        run: |
-          yarn adjustPackageJson
+
+          node adjustPackageJson --community
      - name: setUpdaterChannel beta
        run: |
+
          node setUpdaterChannel beta
      - name: yarn set timeout
        run: |
+
          yarn config set network-timeout 100000
      - name: yarn install
        run: |
+
          yarn install
      - name: setCurrentVersion
        run: |
+
          yarn setCurrentVersion
      - name: printSecrets
        run: |
-            yarn printSecrets
+
+          yarn printSecrets
        env:
-          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
+          GIST_UPLOAD_SECRET: '${{secrets.GIST_UPLOAD_SECRET}}'
      - name: fillPackagedPlugins
        run: |
+
          yarn fillPackagedPlugins
      - name: Install Snapcraft
        if: matrix.os == 'ubuntu-22.04'
        uses: samuelmeuli/action-snapcraft@v1
      - name: Publish
        run: |
+
          yarn run build:app
        env:
-          GH_TOKEN: ${{ secrets.GH_TOKEN }} # token for electron publish
-
-          WIN_CSC_LINK: ${{ secrets.WINCERT_2025 }}
-          WIN_CSC_KEY_PASSWORD: ${{ secrets.WINCERT_2025_PASSWORD }}
-          # WIN_CSC_LINK: ${{ secrets.WINCERT_CERTIFICATE }}
-          # WIN_CSC_KEY_PASSWORD: ${{ secrets.WINCERT_PASSWORD }}
-
-          CSC_LINK: ${{ secrets.APPLECERT_CERTIFICATE }}
-          CSC_KEY_PASSWORD: ${{ secrets.APPLECERT_PASSWORD }}
-
-          APPLE_ID: ${{ secrets.APPLE_ID }}
-          APPLE_TEAM_ID: ${{ secrets.APPLE_TEAM_ID }}
-          APPLE_ID_PASSWORD: ${{ secrets.APPLE_ID_PASSWORD }}
-
-      - name: publishSnap
-        if: matrix.os == 'ubuntu-22.04'
-        run: |
-          snapcraft upload --release=beta app/dist/*.snap
-        env:
-          SNAPCRAFT_STORE_CREDENTIALS: ${{secrets.SNAPCRAFT_LOGIN}}
-
+          GH_TOKEN: '${{ secrets.GH_TOKEN }}'
+          WIN_CSC_LINK: '${{ secrets.WINCERT_2025 }}'
+          WIN_CSC_KEY_PASSWORD: '${{ secrets.WINCERT_2025_PASSWORD }}'
+          CSC_LINK: '${{ secrets.APPLECERT_CERTIFICATE }}'
+          CSC_KEY_PASSWORD: '${{ secrets.APPLECERT_PASSWORD }}'
+          APPLE_ID: '${{ secrets.APPLE_ID }}'
+          APPLE_TEAM_ID: '${{ secrets.APPLE_TEAM_ID }}'
+          APPLE_ID_PASSWORD: '${{ secrets.APPLE_ID_PASSWORD }}'
+          SNAPCRAFT_STORE_CREDENTIALS: '${{secrets.SNAPCRAFT_LOGIN}}'
+          APPLE_APP_SPECIFIC_PASSWORD: '${{secrets.APPLE_APP_SPECIFIC_PASSWORD}}'
      - name: Copy artifacts
        run: |
          mkdir artifacts          
@@ -89,8 +92,10 @@ jobs:
          cp app/dist/*win*.exe artifacts/dbgate-beta.exe || true
          cp app/dist/*win_x64.zip artifacts/dbgate-windows-beta.zip || true
          cp app/dist/*win_arm64.zip artifacts/dbgate-windows-beta-arm64.zip || true
-          cp app/dist/*-mac_x64.dmg artifacts/dbgate-beta.dmg || true
+          cp app/dist/*-mac_universal.dmg artifacts/dbgate-beta.dmg || true
+          cp app/dist/*-mac_x64.dmg artifacts/dbgate-beta-x64.dmg || true
          cp app/dist/*-mac_arm64.dmg artifacts/dbgate-beta-arm64.dmg || true
+          mv app/dist/*.snap artifacts/dbgate-beta.snap || true

          mv app/dist/*.exe artifacts/ || true
          mv app/dist/*.zip artifacts/ || true
@@ -103,18 +108,21 @@ jobs:

          mv app/dist/*.yml artifacts/ || true
          rm artifacts/builder-debug.yml
-
      - name: Upload artifacts
        uses: actions/upload-artifact@v4
        with:
-          name: ${{ matrix.os }}
+          name: '${{ matrix.os }}'
          path: artifacts
-
      - name: Release
        uses: softprops/action-gh-release@v1
-        if: startsWith(github.ref, 'refs/tags/')
+        if: 'startsWith(github.ref, ''refs/tags/'')'
        with:
-          files: 'artifacts/**'
+          files: artifacts/**
          prerelease: true
        env:
-          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
+          GITHUB_TOKEN: '${{ secrets.GITHUB_TOKEN }}'
+      - name: Print content of notarization-error.log
+        if: failure() && matrix.os == 'macos-14'
+        run: |
+
+          find . -type f -name "notarization-error.log" -exec echo "=== Start of {} ===" \; -exec cat {} \; -exec echo "=== End of {} ===" \;
@@ -1,43 +1,44 @@
+# --------------------------------------------------------------------------------------------
+# This file is generated. Do not edit manually
+# --------------------------------------------------------------------------------------------
 name: Electron app PREMIUM BETA
-
-on:
+'on':
  push:
    tags:
      - 'v[0-9]+.[0-9]+.[0-9]+-premium-beta.[0-9]+'
-
 jobs:
  build:
-    runs-on: ${{ matrix.os }}
-
+    runs-on: '${{ matrix.os }}'
    strategy:
      fail-fast: false
      matrix:
-        # os: [windows-2022]
-        # os: [ubuntu-22.04]
-        # os: [windows-2022, ubuntu-22.04]
-        os: [macos-14, windows-2022, ubuntu-22.04]
-        # os: [macOS-10.15]
-
+        os:
+          - macos-14
+          - windows-2022
+          - ubuntu-22.04
    steps:
+      - name: Install python 3.11 (MacOS)
+        if: matrix.os == 'macos-14'
+        run: |
+          brew install python@3.11
+          echo "PYTHON=/opt/homebrew/bin/python3.11" >> $GITHUB_ENV
      - name: Context
        env:
-          GITHUB_CONTEXT: ${{ toJson(github) }}
+          GITHUB_CONTEXT: '${{ toJson(github) }}'
        run: echo "$GITHUB_CONTEXT"
      - uses: actions/checkout@v2
        with:
          fetch-depth: 1
-      - name: Use Node.js 18.x
+      - name: Use Node.js 22.x
        uses: actions/setup-node@v1
        with:
-          node-version: 18.x
-          
+          node-version: 22.x
      - name: Checkout dbgate/dbgate-pro
        uses: actions/checkout@v2
        with:
          repository: dbgate/dbgate-pro
-          token: ${{ secrets.GH_TOKEN }}
+          token: '${{ secrets.GH_TOKEN }}'
          path: dbgate-pro
-
      - name: Merge dbgate/dbgate-pro
        run: |
          mkdir ../dbgate-pro
@@ -49,76 +50,82 @@ jobs:
          yarn
          node sync.js --nowatch
          cd ..
+      - name: adjustPackageJson
+        run: |
+          cd ..
+          cd dbgate-merged

-      - name: yarn adjustPackageJson
-        run: |
-          cd ..
-          cd dbgate-merged
-          yarn adjustPackageJson
-      - name: adjustAppPackageJsonPremium
-        run: |
-          cd ..
-          cd dbgate-merged
-          node adjustAppPackageJsonPremium
+          node adjustPackageJson --premium
      - name: setUpdaterChannel premium-beta
        run: |
          cd ..
          cd dbgate-merged
+
          node setUpdaterChannel premium-beta
      - name: yarn set timeout
        run: |
          cd ..
          cd dbgate-merged
+
          yarn config set network-timeout 100000
      - name: yarn install
        run: |
          cd ..
          cd dbgate-merged
+
          yarn install
      - name: setCurrentVersion
        run: |
          cd ..
          cd dbgate-merged
+
          yarn setCurrentVersion
      - name: printSecrets
        run: |
          cd ..
          cd dbgate-merged
-            yarn printSecrets
+
+          yarn printSecrets
        env:
-          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
+          GIST_UPLOAD_SECRET: '${{secrets.GIST_UPLOAD_SECRET}}'
      - name: fillPackagedPlugins
        run: |
          cd ..
          cd dbgate-merged
+
          yarn fillPackagedPlugins
      - name: Publish
        run: |
          cd ..
          cd dbgate-merged
+
          yarn run build:app
        env:
-          GH_TOKEN: ${{ secrets.GH_TOKEN }} # token for electron publish
-
-          WIN_CSC_LINK: ${{ secrets.WINCERT_2025 }}
-          WIN_CSC_KEY_PASSWORD: ${{ secrets.WINCERT_2025_PASSWORD }}
-          # WIN_CSC_LINK: ${{ secrets.WINCERT_CERTIFICATE }}
-          # WIN_CSC_KEY_PASSWORD: ${{ secrets.WINCERT_PASSWORD }}
-
-          CSC_LINK: ${{ secrets.APPLECERT_CERTIFICATE }}
-          CSC_KEY_PASSWORD: ${{ secrets.APPLECERT_PASSWORD }}
-
-          APPLE_ID: ${{ secrets.APPLE_ID }}
-          APPLE_TEAM_ID: ${{ secrets.APPLE_TEAM_ID }}
-          APPLE_ID_PASSWORD: ${{ secrets.APPLE_ID_PASSWORD }}
-
+          GH_TOKEN: '${{ secrets.GH_TOKEN }}'
+          WIN_CSC_LINK: '${{ secrets.WINCERT_2025 }}'
+          WIN_CSC_KEY_PASSWORD: '${{ secrets.WINCERT_2025_PASSWORD }}'
+          CSC_LINK: '${{ secrets.APPLECERT_CERTIFICATE }}'
+          CSC_KEY_PASSWORD: '${{ secrets.APPLECERT_PASSWORD }}'
+          APPLE_ID: '${{ secrets.APPLE_ID }}'
+          APPLE_TEAM_ID: '${{ secrets.APPLE_TEAM_ID }}'
+          APPLE_ID_PASSWORD: '${{ secrets.APPLE_ID_PASSWORD }}'
+          SNAPCRAFT_STORE_CREDENTIALS: '${{secrets.SNAPCRAFT_LOGIN}}'
+          APPLE_APP_SPECIFIC_PASSWORD: '${{secrets.APPLE_APP_SPECIFIC_PASSWORD}}'
      - name: Copy artifacts
        run: |
          mkdir artifacts          

+          cp ../dbgate-merged/app/dist/*.deb artifacts/dbgate-premium-beta.deb || true
          cp ../dbgate-merged/app/dist/*x86*.AppImage artifacts/dbgate-premium-beta.AppImage || true
+          cp ../dbgate-merged/app/dist/*arm64*.AppImage artifacts/dbgate-premium-beta-arm64.AppImage || true
+          cp ../dbgate-merged/app/dist/*armv7l*.AppImage artifacts/dbgate-premium-beta-armv7l.AppImage || true
          cp ../dbgate-merged/app/dist/*win*.exe artifacts/dbgate-premium-beta.exe || true
-          cp ../dbgate-merged/app/dist/*-mac_x64.dmg artifacts/dbgate-premium-beta.dmg || true
+          cp ../dbgate-merged/app/dist/*win_x64.zip artifacts/dbgate-windows-premium-beta.zip || true
+          cp ../dbgate-merged/app/dist/*win_arm64.zip artifacts/dbgate-windows-premium-beta-arm64.zip || true
+          cp ../dbgate-merged/app/dist/*-mac_universal.dmg artifacts/dbgate-premium-beta.dmg || true
+          cp ../dbgate-merged/app/dist/*-mac_x64.dmg artifacts/dbgate-premium-beta-x64.dmg || true
+          cp ../dbgate-merged/app/dist/*-mac_arm64.dmg artifacts/dbgate-premium-beta-arm64.dmg || true
+          mv ../dbgate-merged/app/dist/*.snap artifacts/dbgate-premium-beta.snap || true

          mv ../dbgate-merged/app/dist/*.exe artifacts/ || true
          mv ../dbgate-merged/app/dist/*.zip artifacts/ || true
@@ -131,18 +138,23 @@ jobs:

          mv ../dbgate-merged/app/dist/*.yml artifacts/ || true
          rm artifacts/builder-debug.yml
-
      - name: Upload artifacts
        uses: actions/upload-artifact@v4
        with:
-          name: ${{ matrix.os }}
+          name: '${{ matrix.os }}'
          path: artifacts
-
      - name: Release
        uses: softprops/action-gh-release@v1
-        if: startsWith(github.ref, 'refs/tags/')
+        if: 'startsWith(github.ref, ''refs/tags/'')'
        with:
-          files: 'artifacts/**'
+          files: artifacts/**
          prerelease: true
        env:
-          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
+          GITHUB_TOKEN: '${{ secrets.GITHUB_TOKEN }}'
+      - name: Print content of notarization-error.log
+        if: failure() && matrix.os == 'macos-14'
+        run: |
+          cd ..
+          cd dbgate-merged
+
+          find . -type f -name "notarization-error.log" -exec echo "=== Start of {} ===" \; -exec cat {} \; -exec echo "=== End of {} ===" \;
@@ -1,44 +1,44 @@
+# --------------------------------------------------------------------------------------------
+# This file is generated. Do not edit manually
+# --------------------------------------------------------------------------------------------
 name: Electron app PREMIUM
-
-on:
+'on':
  push:
    tags:
      - 'v[0-9]+.[0-9]+.[0-9]+'
-      # - 'v*' # Push events to matching v*, i.e. v1.0, v20.15.10
-
-    # branches:
-    #   - production
-
 jobs:
  build:
-    runs-on: ${{ matrix.os }}
-
+    runs-on: '${{ matrix.os }}'
    strategy:
      fail-fast: false
      matrix:
-        # os: [ubuntu-22.04, windows-2016]
-        os: [macos-14, windows-2022, ubuntu-22.04]
-
+        os:
+          - macos-14
+          - windows-2022
+          - ubuntu-22.04
    steps:
+      - name: Install python 3.11 (MacOS)
+        if: matrix.os == 'macos-14'
+        run: |
+          brew install python@3.11
+          echo "PYTHON=/opt/homebrew/bin/python3.11" >> $GITHUB_ENV
      - name: Context
        env:
-          GITHUB_CONTEXT: ${{ toJson(github) }}
+          GITHUB_CONTEXT: '${{ toJson(github) }}'
        run: echo "$GITHUB_CONTEXT"
      - uses: actions/checkout@v2
        with:
          fetch-depth: 1
-      - name: Use Node.js 18.x
+      - name: Use Node.js 22.x
        uses: actions/setup-node@v1
        with:
-          node-version: 18.x
-
+          node-version: 22.x
      - name: Checkout dbgate/dbgate-pro
        uses: actions/checkout@v2
        with:
          repository: dbgate/dbgate-pro
-          token: ${{ secrets.GH_TOKEN }}
+          token: '${{ secrets.GH_TOKEN }}'
          path: dbgate-pro
-
      - name: Merge dbgate/dbgate-pro
        run: |
          mkdir ../dbgate-pro
@@ -50,102 +50,111 @@ jobs:
          yarn
          node sync.js --nowatch
          cd ..
+      - name: adjustPackageJson
+        run: |
+          cd ..
+          cd dbgate-merged

-      - name: yarn adjustPackageJson
-        run: |
-          cd ..
-          cd dbgate-merged
-          yarn adjustPackageJson
-      - name: adjustAppPackageJsonPremium
-        run: |
-          cd ..
-          cd dbgate-merged
-          node adjustAppPackageJsonPremium
+          node adjustPackageJson --premium
      - name: setUpdaterChannel premium
        run: |
          cd ..
          cd dbgate-merged
+
          node setUpdaterChannel premium
      - name: yarn set timeout
        run: |
          cd ..
          cd dbgate-merged
+
          yarn config set network-timeout 100000
      - name: yarn install
        run: |
          cd ..
          cd dbgate-merged
+
          yarn install
      - name: setCurrentVersion
        run: |
          cd ..
          cd dbgate-merged
+
          yarn setCurrentVersion
      - name: printSecrets
        run: |
          cd ..
          cd dbgate-merged
+
          yarn printSecrets
        env:
-          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
+          GIST_UPLOAD_SECRET: '${{secrets.GIST_UPLOAD_SECRET}}'
      - name: fillPackagedPlugins
        run: |
          cd ..
          cd dbgate-merged
+
          yarn fillPackagedPlugins
      - name: Publish
        run: |
          cd ..
          cd dbgate-merged
+
          yarn run build:app
        env:
-          GH_TOKEN: ${{ secrets.GH_TOKEN }} # token for electron publish
-
-          WIN_CSC_LINK: ${{ secrets.WINCERT_2025 }}
-          WIN_CSC_KEY_PASSWORD: ${{ secrets.WINCERT_2025_PASSWORD }}
-          # WIN_CSC_LINK: ${{ secrets.WINCERT_CERTIFICATE }}
-          # WIN_CSC_KEY_PASSWORD: ${{ secrets.WINCERT_PASSWORD }}
-
-          CSC_LINK: ${{ secrets.APPLECERT_CERTIFICATE }}
-          CSC_KEY_PASSWORD: ${{ secrets.APPLECERT_PASSWORD }}
-
-          APPLE_ID: ${{ secrets.APPLE_ID }}
-          APPLE_TEAM_ID: ${{ secrets.APPLE_TEAM_ID }}
-          APPLE_ID_PASSWORD: ${{ secrets.APPLE_ID_PASSWORD }}
-
+          GH_TOKEN: '${{ secrets.GH_TOKEN }}'
+          WIN_CSC_LINK: '${{ secrets.WINCERT_2025 }}'
+          WIN_CSC_KEY_PASSWORD: '${{ secrets.WINCERT_2025_PASSWORD }}'
+          CSC_LINK: '${{ secrets.APPLECERT_CERTIFICATE }}'
+          CSC_KEY_PASSWORD: '${{ secrets.APPLECERT_PASSWORD }}'
+          APPLE_ID: '${{ secrets.APPLE_ID }}'
+          APPLE_TEAM_ID: '${{ secrets.APPLE_TEAM_ID }}'
+          APPLE_ID_PASSWORD: '${{ secrets.APPLE_ID_PASSWORD }}'
+          SNAPCRAFT_STORE_CREDENTIALS: '${{secrets.SNAPCRAFT_LOGIN}}'
+          APPLE_APP_SPECIFIC_PASSWORD: '${{secrets.APPLE_APP_SPECIFIC_PASSWORD}}'
      - name: Copy artifacts
        run: |
          mkdir artifacts          

+          cp ../dbgate-merged/app/dist/*.deb artifacts/dbgate-premium-latest.deb || true
          cp ../dbgate-merged/app/dist/*x86*.AppImage artifacts/dbgate-premium-latest.AppImage || true
-          cp ../dbgate-merged/app/dist/*.exe artifacts/dbgate-premium-latest.exe || true
-          cp ../dbgate-merged/app/dist/*win_x64.zip artifacts/dbgate-premium-windows-latest.zip || true
-          cp ../dbgate-merged/app/dist/*win_arm64.zip artifacts/dbgate-premium-windows-latest-arm64.zip || true
+          cp ../dbgate-merged/app/dist/*arm64*.AppImage artifacts/dbgate-premium-latest-arm64.AppImage || true
+          cp ../dbgate-merged/app/dist/*armv7l*.AppImage artifacts/dbgate-premium-latest-armv7l.AppImage || true
+          cp ../dbgate-merged/app/dist/*win*.exe artifacts/dbgate-premium-latest.exe || true
+          cp ../dbgate-merged/app/dist/*win_x64.zip artifacts/dbgate-windows-premium-latest.zip || true
+          cp ../dbgate-merged/app/dist/*win_arm64.zip artifacts/dbgate-windows-premium-latest-arm64.zip || true
          cp ../dbgate-merged/app/dist/*-mac_universal.dmg artifacts/dbgate-premium-latest.dmg || true
          cp ../dbgate-merged/app/dist/*-mac_x64.dmg artifacts/dbgate-premium-latest-x64.dmg || true
          cp ../dbgate-merged/app/dist/*-mac_arm64.dmg artifacts/dbgate-premium-latest-arm64.dmg || true
+          mv ../dbgate-merged/app/dist/*.snap artifacts/dbgate-premium-latest.snap || true

          mv ../dbgate-merged/app/dist/*.exe artifacts/ || true
          mv ../dbgate-merged/app/dist/*.zip artifacts/ || true
          mv ../dbgate-merged/app/dist/*.tar.gz artifacts/ || true
          mv ../dbgate-merged/app/dist/*.AppImage artifacts/ || true
          mv ../dbgate-merged/app/dist/*.deb artifacts/ || true
+          mv ../dbgate-merged/app/dist/*.snap artifacts/ || true
          mv ../dbgate-merged/app/dist/*.dmg artifacts/ || true
          mv ../dbgate-merged/app/dist/*.blockmap artifacts/ || true

          mv ../dbgate-merged/app/dist/*.yml artifacts/ || true
          rm artifacts/builder-debug.yml
-
      - name: Upload artifacts
        uses: actions/upload-artifact@v4
        with:
-          name: ${{ matrix.os }}
+          name: '${{ matrix.os }}'
          path: artifacts
-
      - name: Release
        uses: softprops/action-gh-release@v1
-        if: startsWith(github.ref, 'refs/tags/')
+        if: 'startsWith(github.ref, ''refs/tags/'')'
        with:
-          files: 'artifacts/**'
+          files: artifacts/**
+          prerelease: false
        env:
-          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
+          GITHUB_TOKEN: '${{ secrets.GITHUB_TOKEN }}'
+      - name: Print content of notarization-error.log
+        if: failure() && matrix.os == 'macos-14'
+        run: |
+          cd ..
+          cd dbgate-merged
+
+          find . -type f -name "notarization-error.log" -exec echo "=== Start of {} ===" \; -exec cat {} \; -exec echo "=== End of {} ===" \;
@@ -1,90 +1,85 @@
+# --------------------------------------------------------------------------------------------
+# This file is generated. Do not edit manually
+# --------------------------------------------------------------------------------------------
 name: Electron app
-
-on:
+'on':
  push:
    tags:
      - 'v[0-9]+.[0-9]+.[0-9]+'
-      # - 'v*' # Push events to matching v*, i.e. v1.0, v20.15.10
-
-    # branches:
-    #   - production
-
 jobs:
  build:
-    runs-on: ${{ matrix.os }}
-
+    runs-on: '${{ matrix.os }}'
    strategy:
      fail-fast: false
      matrix:
-        # os: [ubuntu-22.04, windows-2016]
-        os: [macos-14, windows-2022, ubuntu-22.04]
-
+        os:
+          - macos-14
+          - windows-2022
+          - ubuntu-22.04
    steps:
+      - name: Install python 3.11 (MacOS)
+        if: matrix.os == 'macos-14'
+        run: |
+          brew install python@3.11
+          echo "PYTHON=/opt/homebrew/bin/python3.11" >> $GITHUB_ENV
      - name: Context
        env:
-          GITHUB_CONTEXT: ${{ toJson(github) }}
+          GITHUB_CONTEXT: '${{ toJson(github) }}'
        run: echo "$GITHUB_CONTEXT"
      - uses: actions/checkout@v2
        with:
          fetch-depth: 1
-      - name: Use Node.js 18.x
+      - name: Use Node.js 22.x
        uses: actions/setup-node@v1
        with:
-          node-version: 18.x
-      - name: yarn adjustPackageJson
+          node-version: 22.x
+      - name: adjustPackageJson
        run: |
-          yarn adjustPackageJson
+
+          node adjustPackageJson --community
      - name: yarn set timeout
        run: |
+
          yarn config set network-timeout 100000
      - name: yarn install
        run: |
-          # yarn --version
-          # yarn config set network-timeout 300000
+
          yarn install
      - name: setCurrentVersion
        run: |
+
          yarn setCurrentVersion
      - name: printSecrets
        run: |
-            yarn printSecrets
+
+          yarn printSecrets
        env:
-          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
+          GIST_UPLOAD_SECRET: '${{secrets.GIST_UPLOAD_SECRET}}'
      - name: fillPackagedPlugins
        run: |
+
          yarn fillPackagedPlugins
      - name: Install Snapcraft
        if: matrix.os == 'ubuntu-22.04'
        uses: samuelmeuli/action-snapcraft@v1
      - name: Publish
        run: |
+
          yarn run build:app
        env:
-          GH_TOKEN: ${{ secrets.GH_TOKEN }} # token for electron publish
-
-          WIN_CSC_LINK: ${{ secrets.WINCERT_2025 }}
-          WIN_CSC_KEY_PASSWORD: ${{ secrets.WINCERT_2025_PASSWORD }}
-          # WIN_CSC_LINK: ${{ secrets.WINCERT_CERTIFICATE }}
-          # WIN_CSC_KEY_PASSWORD: ${{ secrets.WINCERT_PASSWORD }}
-
-          CSC_LINK: ${{ secrets.APPLECERT_CERTIFICATE }}
-          CSC_KEY_PASSWORD: ${{ secrets.APPLECERT_PASSWORD }}
-
-          APPLE_ID: ${{ secrets.APPLE_ID }}
-          APPLE_TEAM_ID: ${{ secrets.APPLE_TEAM_ID }}
-          APPLE_ID_PASSWORD: ${{ secrets.APPLE_ID_PASSWORD }}
-
+          GH_TOKEN: '${{ secrets.GH_TOKEN }}'
+          WIN_CSC_LINK: '${{ secrets.WINCERT_2025 }}'
+          WIN_CSC_KEY_PASSWORD: '${{ secrets.WINCERT_2025_PASSWORD }}'
+          CSC_LINK: '${{ secrets.APPLECERT_CERTIFICATE }}'
+          CSC_KEY_PASSWORD: '${{ secrets.APPLECERT_PASSWORD }}'
+          APPLE_ID: '${{ secrets.APPLE_ID }}'
+          APPLE_TEAM_ID: '${{ secrets.APPLE_TEAM_ID }}'
+          APPLE_ID_PASSWORD: '${{ secrets.APPLE_ID_PASSWORD }}'
+          SNAPCRAFT_STORE_CREDENTIALS: '${{secrets.SNAPCRAFT_LOGIN}}'
+          APPLE_APP_SPECIFIC_PASSWORD: '${{secrets.APPLE_APP_SPECIFIC_PASSWORD}}'
      - name: generatePadFile
        run: |
          yarn generatePadFile
-
-      - name: publishSnap
-        if: matrix.os == 'ubuntu-22.04'
-        run: |
-          snapcraft upload --release=stable app/dist/*.snap
-        env:
-          SNAPCRAFT_STORE_CREDENTIALS: ${{secrets.SNAPCRAFT_LOGIN}}
-
      - name: Copy artifacts
        run: |
          mkdir artifacts          
@@ -93,75 +88,44 @@ jobs:
          cp app/dist/*x86*.AppImage artifacts/dbgate-latest.AppImage || true
          cp app/dist/*arm64*.AppImage artifacts/dbgate-latest-arm64.AppImage || true
          cp app/dist/*armv7l*.AppImage artifacts/dbgate-latest-armv7l.AppImage || true
-          cp app/dist/*.exe artifacts/dbgate-latest.exe || true
+          cp app/dist/*win*.exe artifacts/dbgate-latest.exe || true
          cp app/dist/*win_x64.zip artifacts/dbgate-windows-latest.zip || true
          cp app/dist/*win_arm64.zip artifacts/dbgate-windows-latest-arm64.zip || true
          cp app/dist/*-mac_universal.dmg artifacts/dbgate-latest.dmg || true
          cp app/dist/*-mac_x64.dmg artifacts/dbgate-latest-x64.dmg || true
          cp app/dist/*-mac_arm64.dmg artifacts/dbgate-latest-arm64.dmg || true
+          mv app/dist/*.snap artifacts/dbgate-latest.snap || true

          mv app/dist/*.exe artifacts/ || true
          mv app/dist/*.zip artifacts/ || true
          mv app/dist/*.tar.gz artifacts/ || true
          mv app/dist/*.AppImage artifacts/ || true
          mv app/dist/*.deb artifacts/ || true
+          mv app/dist/*.snap artifacts/ || true
          mv app/dist/*.dmg artifacts/ || true
-          mv app/dist/*.snap artifacts/dbgate-latest.snap || true
          mv app/dist/*.blockmap artifacts/ || true

          mv app/dist/*.yml artifacts/ || true
          rm artifacts/builder-debug.yml
-
-      # - name: Copy artifacts Linux, MacOs
-      #   if: matrix.os != 'windows-2016'
-      #   run: |
-      #     mkdir artifacts
-
-      #     cp app/dist/*.AppImage artifacts/ || true
-      #     cp app/dist/*.dmg artifacts/ || true
-      #     cp app/dist/*.deb artifacts/ || true
-
-      #     mv app/dist/*.deb artifacts/dbgate-linux.deb || true
-      #     mv app/dist/*.AppImage artifacts/dbgate-linux.AppImage || true
-      #     mv app/dist/*.dmg artifacts/dbgate-mac.dmg || true
-
-      # - name: Copy artifacts Win
-      #   if: matrix.os == 'windows-2016'
-      #   run: |
-      #     mkdir artifacts
-
-      #     cp app/dist/*.exe artifacts/ || true
-
-      #     mv app/dist/*.exe artifacts/dbgate-windows.exe
-
-      #     mv app/dist/latest.yml artifacts/latest.yml || true
-
      - name: Copy PAD file
        if: matrix.os == 'windows-2022'
        run: |
          mv app/dist/dbgate-pad.xml artifacts/ || true
-
      - name: Upload artifacts
        uses: actions/upload-artifact@v4
        with:
-          name: ${{ matrix.os }}
+          name: '${{ matrix.os }}'
          path: artifacts
-
      - name: Release
        uses: softprops/action-gh-release@v1
-        if: startsWith(github.ref, 'refs/tags/')
+        if: 'startsWith(github.ref, ''refs/tags/'')'
        with:
-          files: 'artifacts/**'
+          files: artifacts/**
+          prerelease: false
        env:
-          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
+          GITHUB_TOKEN: '${{ secrets.GITHUB_TOKEN }}'
+      - name: Print content of notarization-error.log
+        if: failure() && matrix.os == 'macos-14'
+        run: |

-      # - name: Create Release
-      #   id: create_release
-      #   uses: actions/create-release@v1
-      #   env:
-      #     GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
-      #   with:
-      #     tag_name: ${{ github.ref }}
-      #     release_name: Release ${{ github.ref }}
-      #     draft: false
-      #     prerelease: false
+          find . -type f -name "notarization-error.log" -exec echo "=== Start of {} ===" \; -exec cat {} \; -exec echo "=== End of {} ===" \;
@@ -1,47 +1,41 @@
+# --------------------------------------------------------------------------------------------
+# This file is generated. Do not edit manually
+# --------------------------------------------------------------------------------------------
 name: AWS image PREMIUM
-
-on:
+'on':
  push:
    tags:
      - 'v[0-9]+.[0-9]+.[0-9]+'
-      # - 'v[0-9]+.[0-9]+.[0-9]+-premium-beta.[0-9]+'
      - 'v[0-9]+.[0-9]+.[0-9]+-packer-beta.[0-9]+'
-
 jobs:
  build:
-
-    runs-on: ${{ matrix.os }}
-
+    runs-on: '${{ matrix.os }}'
    strategy:
      matrix:
-        os: [ubuntu-22.04]
-
+        os:
+          - ubuntu-22.04
    steps:
      - name: Context
        env:
-          GITHUB_CONTEXT: ${{ toJson(github) }}
+          GITHUB_CONTEXT: '${{ toJson(github) }}'
        run: echo "$GITHUB_CONTEXT"
      - uses: actions/checkout@v2
        with:
          fetch-depth: 1
-
      - name: Use Node.js 18.x
        uses: actions/setup-node@v1
        with:
          node-version: 18.x
-
      - name: Setup `packer`
        uses: hashicorp/setup-packer@main
        with:
          version: latest
-
      - name: Checkout dbgate/dbgate-pro
        uses: actions/checkout@v2
        with:
          repository: dbgate/dbgate-pro
-          token: ${{ secrets.GH_TOKEN }}
+          token: '${{ secrets.GH_TOKEN }}'
          path: dbgate-pro
-
      - name: Merge dbgate/dbgate-pro
        run: |
          mkdir ../dbgate-pro
@@ -53,33 +47,28 @@ jobs:
          yarn
          node sync.js --nowatch
          cd ..
-
-      - name: yarn adjustPackageJson
+      - name: adjustPackageJson
        run: |
          cd ..
          cd dbgate-merged
-          yarn adjustPackageJson
-
+          node adjustPackageJson --premium
      - name: yarn install
        run: |
          cd ..
          cd dbgate-merged
          yarn install
-
      - name: setCurrentVersion
        run: |
          cd ..
          cd dbgate-merged
          yarn setCurrentVersion
-          
      - name: printSecrets
        run: |
          cd ..
          cd dbgate-merged
            yarn printSecrets
        env:
-          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
-
+          GIST_UPLOAD_SECRET: '${{secrets.GIST_UPLOAD_SECRET}}'
      - name: Prepare packer build
        run: |
          cd ..
@@ -87,62 +76,48 @@ jobs:
          yarn run prepare:packer
          cd packer
          zip -r cloud-build.zip build
-
      - name: Copy artifacts
        run: |
          mkdir artifacts          
          cp ../dbgate-merged/packer/cloud-build.zip artifacts/cloud-build.zip || true
-
      - name: Upload artifacts
        uses: actions/upload-artifact@v4
        with:
-          name: ${{ matrix.os }}
+          name: '${{ matrix.os }}'
          path: artifacts
-
      - name: Release
        uses: softprops/action-gh-release@v1
-        if: startsWith(github.ref, 'refs/tags/')
+        if: 'startsWith(github.ref, ''refs/tags/'')'
        with:
-          files: 'artifacts/**'
+          files: artifacts/**
          prerelease: true
        env:
-          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
-
+          GITHUB_TOKEN: '${{ secrets.GITHUB_TOKEN }}'
      - name: Run `packer init`
        run: |
          cd ../dbgate-merged/packer
          packer init ./aws-ubuntu.pkr.hcl
        env:
-          AWS_ACCESS_KEY_ID: ${{secrets.AWS_ACCESS_KEY_ID}}
-          AWS_SECRET_ACCESS_KEY: ${{secrets.AWS_SECRET_ACCESS_KEY}}
-          AWS_DEFAULT_REGION: ${{secrets.AWS_DEFAULT_REGION}}
-
+          AWS_ACCESS_KEY_ID: '${{secrets.AWS_ACCESS_KEY_ID}}'
+          AWS_SECRET_ACCESS_KEY: '${{secrets.AWS_SECRET_ACCESS_KEY}}'
+          AWS_DEFAULT_REGION: '${{secrets.AWS_DEFAULT_REGION}}'
      - name: Run `packer build`
        run: |
          cd ../dbgate-merged/packer
          packer build ./aws-ubuntu.pkr.hcl
        env:
-          AWS_ACCESS_KEY_ID: ${{secrets.AWS_ACCESS_KEY_ID}}
-          AWS_SECRET_ACCESS_KEY: ${{secrets.AWS_SECRET_ACCESS_KEY}}
-          AWS_DEFAULT_REGION: ${{secrets.AWS_DEFAULT_REGION}}
-
-      # - name: Install AWS CLI
-      #   run: |
-      #     curl "https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip" -o "awscliv2.zip"
-      #     unzip awscliv2.zip
-      #     sudo ./aws/install
-      #     sudo apt-get install jq -y
-
+          AWS_ACCESS_KEY_ID: '${{secrets.AWS_ACCESS_KEY_ID}}'
+          AWS_SECRET_ACCESS_KEY: '${{secrets.AWS_SECRET_ACCESS_KEY}}'
+          AWS_DEFAULT_REGION: '${{secrets.AWS_DEFAULT_REGION}}'
      - name: Install jq
        run: |
          sudo apt-get install jq -y
-
      - name: Delete old AMIs
        run: |
          cd ../dbgate-merged/packer
          chmod +x delete-old-amis.sh
          ./delete-old-amis.sh
        env:
-          AWS_ACCESS_KEY_ID: ${{secrets.AWS_ACCESS_KEY_ID}}
-          AWS_SECRET_ACCESS_KEY: ${{secrets.AWS_SECRET_ACCESS_KEY}}
-          AWS_DEFAULT_REGION: ${{secrets.AWS_DEFAULT_REGION}}
+          AWS_ACCESS_KEY_ID: '${{secrets.AWS_ACCESS_KEY_ID}}'
+          AWS_SECRET_ACCESS_KEY: '${{secrets.AWS_SECRET_ACCESS_KEY}}'
+          AWS_DEFAULT_REGION: '${{secrets.AWS_DEFAULT_REGION}}'
@@ -1,35 +1,32 @@
+# --------------------------------------------------------------------------------------------
+# This file is generated. Do not edit manually
+# --------------------------------------------------------------------------------------------
 name: Docker image PREMIUM
-
-on:
+'on':
  push:
    tags:
      - 'v[0-9]+.[0-9]+.[0-9]+'
      - 'v[0-9]+.[0-9]+.[0-9]+-premium-beta.[0-9]+'
-
 jobs:
  build:
-
-    runs-on: ${{ matrix.os }}
-
+    runs-on: '${{ matrix.os }}'
    strategy:
      matrix:
-        os: [ubuntu-22.04]
-
+        os:
+          - ubuntu-22.04
    steps:
      - name: Context
        env:
-          GITHUB_CONTEXT: ${{ toJson(github) }}
+          GITHUB_CONTEXT: '${{ toJson(github) }}'
        run: echo "$GITHUB_CONTEXT"
      - uses: actions/checkout@v2
        with:
          fetch-depth: 1
-
      - name: Docker meta
        id: meta
        uses: docker/metadata-action@v4
        with:
-          images: |
-            dbgate/dbgate-premium
+          images: dbgate/dbgate-premium
          flavor: |
            latest=false
          tags: |
@@ -37,19 +34,16 @@ jobs:

            type=match,pattern=\d+.\d+.\d+,enable=${{ !contains(github.ref_name, '-docker.') && !contains(github.ref_name, '-beta.') }}
            type=raw,value=latest,enable=${{ !contains(github.ref_name, '-docker.') && !contains(github.ref_name, '-beta.') }}
-
      - name: Use Node.js 18.x
        uses: actions/setup-node@v1
        with:
          node-version: 18.x
-
      - name: Checkout dbgate/dbgate-pro
        uses: actions/checkout@v2
        with:
          repository: dbgate/dbgate-pro
-          token: ${{ secrets.GH_TOKEN }}
+          token: '${{ secrets.GH_TOKEN }}'
          path: dbgate-pro
-
      - name: Merge dbgate/dbgate-pro
        run: |
          mkdir ../dbgate-pro
@@ -61,50 +55,51 @@ jobs:
          yarn
          node sync.js --nowatch
          cd ..
-
-      - name: yarn adjustPackageJson
+      - name: adjustPackageJson
        run: |
          cd ..
          cd dbgate-merged
-          yarn adjustPackageJson

+          node adjustPackageJson --premium
      - name: yarn install
        run: |
          cd ..
          cd dbgate-merged
-          yarn install

+          # yarn --version
+          # yarn config set network-timeout 300000
+          yarn install
      - name: setCurrentVersion
        run: |
          cd ..
          cd dbgate-merged
+
          yarn setCurrentVersion
-          
      - name: printSecrets
        run: |
          cd ..
          cd dbgate-merged
-            yarn printSecrets
+
+          yarn printSecrets
        env:
-          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
+          GIST_UPLOAD_SECRET: '${{secrets.GIST_UPLOAD_SECRET}}'
      - name: Prepare docker image
        run: |
          cd ..
          cd dbgate-merged
-          yarn run prepare:docker

+          yarn run prepare:docker
      - name: Set up Docker Buildx
        uses: docker/setup-buildx-action@v2
      - name: Login to DockerHub
        uses: docker/login-action@v2
        with:
-          username: ${{ secrets.DOCKER_USERNAME }}
-          password: ${{ secrets.DOCKER_PASSWORD }}
-
+          username: '${{ secrets.DOCKER_USERNAME }}'
+          password: '${{ secrets.DOCKER_PASSWORD }}'
      - name: Build and push
        uses: docker/build-push-action@v3
        with:
          push: true
          context: ../dbgate-merged/docker
-          tags: ${{ steps.meta.outputs.tags }}
-          platforms: linux/amd64,linux/arm64
+          tags: '${{ steps.meta.outputs.tags }}'
+          platforms: 'linux/amd64,linux/arm64'
@@ -1,35 +1,32 @@
-name: Docker image
-
-on:
+# --------------------------------------------------------------------------------------------
+# This file is generated. Do not edit manually
+# --------------------------------------------------------------------------------------------
+name: Docker image Community
+'on':
  push:
    tags:
      - 'v[0-9]+.[0-9]+.[0-9]+'
      - 'v[0-9]+.[0-9]+.[0-9]+-beta.[0-9]+'
-
 jobs:
  build:
-
-    runs-on: ${{ matrix.os }}
-
+    runs-on: '${{ matrix.os }}'
    strategy:
      matrix:
-        os: [ubuntu-22.04]
-
+        os:
+          - ubuntu-22.04
    steps:
      - name: Context
        env:
-          GITHUB_CONTEXT: ${{ toJson(github) }}
+          GITHUB_CONTEXT: '${{ toJson(github) }}'
        run: echo "$GITHUB_CONTEXT"
      - uses: actions/checkout@v2
        with:
          fetch-depth: 1
-
      - name: Docker meta
        id: meta
        uses: docker/metadata-action@v4
        with:
-          images: |
-            dbgate/dbgate
+          images: dbgate/dbgate
          flavor: |
            latest=false
          tags: |
@@ -37,7 +34,6 @@ jobs:

            type=match,pattern=\d+.\d+.\d+,enable=${{ !contains(github.ref_name, '-docker.') && !contains(github.ref_name, '-beta.') }}
            type=raw,value=latest,enable=${{ !contains(github.ref_name, '-docker.') && !contains(github.ref_name, '-beta.') }}
-
      - name: Docker alpine meta
        id: alpmeta
        uses: docker/metadata-action@v4
@@ -51,56 +47,53 @@ jobs:

            type=match,pattern=\d+.\d+.\d+,suffix=-alpine,enable=${{ !contains(github.ref_name, '-docker.') && !contains(github.ref_name, '-beta.') }}
            type=raw,value=alpine,enable=${{ !contains(github.ref_name, '-docker.') && !contains(github.ref_name, '-beta.') }}
-
      - name: Use Node.js 18.x
        uses: actions/setup-node@v1
        with:
          node-version: 18.x
-
-      - name: yarn adjustPackageJson
+      - name: adjustPackageJson
        run: |
-          yarn adjustPackageJson

+          node adjustPackageJson --community
      - name: yarn install
        run: |
+
          # yarn --version
          # yarn config set network-timeout 300000
          yarn install
-
      - name: setCurrentVersion
        run: |
+
          yarn setCurrentVersion
-          
      - name: printSecrets
        run: |
-            yarn printSecrets
+
+          yarn printSecrets
        env:
-          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
+          GIST_UPLOAD_SECRET: '${{secrets.GIST_UPLOAD_SECRET}}'
      - name: Prepare docker image
        run: |
-          yarn run prepare:docker

+          yarn run prepare:docker
      - name: Set up Docker Buildx
        uses: docker/setup-buildx-action@v2
      - name: Login to DockerHub
        uses: docker/login-action@v2
        with:
-          username: ${{ secrets.DOCKER_USERNAME }}
-          password: ${{ secrets.DOCKER_PASSWORD }}
-
+          username: '${{ secrets.DOCKER_USERNAME }}'
+          password: '${{ secrets.DOCKER_PASSWORD }}'
      - name: Build and push
        uses: docker/build-push-action@v3
        with:
          push: true
          context: ./docker
-          tags: ${{ steps.meta.outputs.tags }}
-          platforms: linux/amd64,linux/arm64,linux/arm/v7
-
+          tags: '${{ steps.meta.outputs.tags }}'
+          platforms: 'linux/amd64,linux/arm64,linux/arm/v7'
      - name: Build and push alpine
        uses: docker/build-push-action@v3
        with:
          push: true
          context: ./docker
          file: ./docker/Dockerfile-alpine
-          tags: ${{ steps.alpmeta.outputs.tags }}
-          platforms: linux/amd64,linux/arm64,linux/arm/v7
+          tags: '${{ steps.alpmeta.outputs.tags }}'
+          platforms: 'linux/amd64,linux/arm64,linux/arm/v7'
@@ -1,31 +1,23 @@
+# --------------------------------------------------------------------------------------------
+# This file is generated. Do not edit manually
+# --------------------------------------------------------------------------------------------
 name: NPM packages PREMIUM
-
-# on: [push]
-
-on:
+'on':
  push:
    tags:
      - 'v[0-9]+.[0-9]+.[0-9]+'
      - 'v[0-9]+.[0-9]+.[0-9]+-alpha.[0-9]+'
-
-# on:
-#   push:
-#     branches:
-#       - production
-
 jobs:
  build:
-
-    runs-on: ${{ matrix.os }}
-
+    runs-on: '${{ matrix.os }}'
    strategy:
      matrix:
-        os: [ubuntu-22.04]
-
+        os:
+          - ubuntu-22.04
    steps:
      - name: Context
        env:
-          GITHUB_CONTEXT: ${{ toJson(github) }}
+          GITHUB_CONTEXT: '${{ toJson(github) }}'
        run: echo "$GITHUB_CONTEXT"
      - uses: actions/checkout@v2
        with:
@@ -34,14 +26,12 @@ jobs:
        uses: actions/setup-node@v1
        with:
          node-version: 18.x
-
      - name: Checkout dbgate/dbgate-pro
        uses: actions/checkout@v2
        with:
          repository: dbgate/dbgate-pro
-          token: ${{ secrets.GH_TOKEN }}
+          token: '${{ secrets.GH_TOKEN }}'
          path: dbgate-pro
-
      - name: Merge dbgate/dbgate-pro
        run: |
          mkdir ../dbgate-pro
@@ -53,65 +43,55 @@ jobs:
          yarn
          node sync.js --nowatch
          cd ..
-
      - name: adjustNpmPackageJsonPremium
        run: |
          cd ..
          cd dbgate-merged
          node adjustNpmPackageJsonPremium
-
      - name: Configure NPM token
        env:
-          NPM_TOKEN: ${{ secrets.NPM_TOKEN }}
+          NPM_TOKEN: '${{ secrets.NPM_TOKEN }}'
        run: |
          cd ..
          cd dbgate-merged
          npm config set '//registry.npmjs.org/:_authToken' "${NPM_TOKEN}"
-
      - name: Remove dbmodel - should be not published
        run: |
          cd ..
          cd dbgate-merged
          rm -rf packages/dbmodel
-
      - name: yarn install
        run: |
          cd ..
          cd dbgate-merged
          yarn install
-          
      - name: setCurrentVersion
        run: |
          cd ..
          cd dbgate-merged
          yarn setCurrentVersion
-
      - name: printSecrets
        run: |
          cd ..
          cd dbgate-merged
            yarn printSecrets
        env:
-          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
-
+          GIST_UPLOAD_SECRET: '${{secrets.GIST_UPLOAD_SECRET}}'
      - name: Publish dbgate-api-premium
        run: |
          cd ..
          cd dbgate-merged/packages/api
          npm publish
-
      - name: Publish dbgate-web-premium
        run: |
          cd ..
          cd dbgate-merged/packages/web
          npm publish
-
      - name: Publish dbgate-serve-premium
        run: |
          cd ..
          cd dbgate-merged/packages/serve
          npm publish
-
      - name: Publish dbgate-plugin-cosmosdb
        run: |
          cd ..
@@ -1,31 +1,23 @@
+# --------------------------------------------------------------------------------------------
+# This file is generated. Do not edit manually
+# --------------------------------------------------------------------------------------------
 name: NPM packages
-
-# on: [push]
-
-on:
+'on':
  push:
    tags:
      - 'v[0-9]+.[0-9]+.[0-9]+'
      - 'v[0-9]+.[0-9]+.[0-9]+-alpha.[0-9]+'
-
-# on:
-#   push:
-#     branches:
-#       - production
-
 jobs:
  build:
-
-    runs-on: ${{ matrix.os }}
-
+    runs-on: '${{ matrix.os }}'
    strategy:
      matrix:
-        os: [ubuntu-22.04]
-
+        os:
+          - ubuntu-22.04
    steps:
      - name: Context
        env:
-          GITHUB_CONTEXT: ${{ toJson(github) }}
+          GITHUB_CONTEXT: '${{ toJson(github) }}'
        run: echo "$GITHUB_CONTEXT"
      - uses: actions/checkout@v2
        with:
@@ -34,37 +26,30 @@ jobs:
        uses: actions/setup-node@v1
        with:
          node-version: 18.x
-
      - name: Configure NPM token
        env:
-          NPM_TOKEN: ${{ secrets.NPM_TOKEN }}
+          NPM_TOKEN: '${{ secrets.NPM_TOKEN }}'
        run: |
          npm config set '//registry.npmjs.org/:_authToken' "${NPM_TOKEN}"
-
      - name: yarn install
        run: |
          yarn install
-          
      - name: setCurrentVersion
        run: |
          yarn setCurrentVersion
-
      - name: printSecrets
        run: |
-            yarn printSecrets
+          yarn printSecrets
        env:
-          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
-
+          GIST_UPLOAD_SECRET: '${{secrets.GIST_UPLOAD_SECRET}}'
      - name: Publish types
        working-directory: packages/types
        run: |
          npm publish
-
      - name: Publish tools
        working-directory: packages/tools
        run: |
          npm publish
-
      - name: Publish sqltree
        working-directory: packages/sqltree
        run: |
@@ -74,82 +59,66 @@ jobs:
        working-directory: packages/api
        run: |
          npm publish
-
      - name: Publish datalib
        working-directory: packages/datalib
        run: |
          npm publish
-
      - name: Publish filterparser
        working-directory: packages/filterparser
        run: |
          npm publish
-
      - name: Publish web
        working-directory: packages/web
        run: |
          npm publish
-
      - name: Publish dbgate-serve
        working-directory: packages/serve
        run: |
          npm publish
-
      - name: Publish dbmodel
        working-directory: packages/dbmodel
        run: |
          npm publish
-
      - name: Publish dbgate-plugin-csv
        working-directory: plugins/dbgate-plugin-csv
        run: |
          npm publish
-
      - name: Publish dbgate-plugin-xml
        working-directory: plugins/dbgate-plugin-xml
        run: |
          npm publish
-
      - name: Publish dbgate-plugin-excel
        working-directory: plugins/dbgate-plugin-excel
        run: |
          npm publish
-
      - name: Publish dbgate-plugin-mssql
        working-directory: plugins/dbgate-plugin-mssql
        run: |
          npm publish
-
      - name: Publish dbgate-plugin-mysql
        working-directory: plugins/dbgate-plugin-mysql
        run: |
          npm publish
-
      - name: Publish dbgate-plugin-mongo
        working-directory: plugins/dbgate-plugin-mongo
        run: |
          npm publish
-
      - name: Publish dbgate-plugin-postgres
        working-directory: plugins/dbgate-plugin-postgres
        run: |
          npm publish
-
      - name: Publish dbgate-plugin-sqlite
        working-directory: plugins/dbgate-plugin-sqlite
        run: |
          npm publish
-
      - name: Publish dbgate-plugin-redis
        working-directory: plugins/dbgate-plugin-redis
        run: |
          npm publish
-
      - name: Publish dbgate-plugin-oracle
        working-directory: plugins/dbgate-plugin-oracle
        run: |
          npm publish
-
      - name: Publish dbgate-plugin-clickhouse
        working-directory: plugins/dbgate-plugin-clickhouse
        run: |
@@ -1,16 +1,17 @@
+# --------------------------------------------------------------------------------------------
+# This file is generated. Do not edit manually
+# --------------------------------------------------------------------------------------------
 name: Run tests
-on:
+'on':
  push:
    branches:
      - master
      - develop
-      - 'feature/**'
-
+      - feature/**
 jobs:
  test-runner:
    runs-on: ubuntu-latest
-    container: node:18
-
+    container: 'node:18'
    steps:
      - name: Install dependencies for cypress
        run: |
@@ -37,7 +38,6 @@ jobs:
        run: |
          cd integration-tests
          yarn test:ci
-#          yarn wait:ci
      - name: Filter parser tests
        if: always()
        run: |
@@ -51,54 +51,42 @@ jobs:
      - uses: tanmen/jest-reporter@v1
        if: always()
        with:
-          github-token: ${{ secrets.GITHUB_TOKEN }}
+          github-token: '${{ secrets.GITHUB_TOKEN }}'
          result-file: integration-tests/result.json
          action-name: Integration tests
      - uses: tanmen/jest-reporter@v1
        if: always()
        with:
-          github-token: ${{ secrets.GITHUB_TOKEN }}
+          github-token: '${{ secrets.GITHUB_TOKEN }}'
          result-file: packages/filterparser/result.json
          action-name: Filter parser test results
      - uses: tanmen/jest-reporter@v1
        if: always()
        with:
-          github-token: ${{ secrets.GITHUB_TOKEN }}
+          github-token: '${{ secrets.GITHUB_TOKEN }}'
          result-file: packages/datalib/result.json
          action-name: Datalib (perspectives) test results
-
    services:
      postgres:
        image: postgres
        env:
          POSTGRES_PASSWORD: Pwd2020Db
-        options: >-
-          --health-cmd pg_isready
-          --health-interval 10s
-          --health-timeout 5s
-          --health-retries 5
-
+        options: '--health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5'
      mysql:
-        image: mysql:8.0.18
+        image: 'mysql:8.0.18'
        env:
          MYSQL_ROOT_PASSWORD: Pwd2020Db
-
      mssql:
        image: mcr.microsoft.com/mssql/server
        env:
-          ACCEPT_EULA: Y
+          ACCEPT_EULA: 'Y'
          SA_PASSWORD: Pwd2020Db
          MSSQL_PID: Express
-
      clickhouse:
-        image: bitnami/clickhouse:24.8.4
+        image: 'bitnami/clickhouse:24.8.4'
        env:
          CLICKHOUSE_ADMIN_PASSWORD: Pwd2020Db
-
      oracle:
-        image: gvenzl/oracle-xe:21-slim
+        image: 'gvenzl/oracle-xe:21-slim'
        env:
          ORACLE_PASSWORD: Pwd2020Db
-
-      # cockroachdb:
-      #   image: cockroachdb/cockroach
@@ -8,6 +8,13 @@ Builds:
 - linux - application for linux
 - win - application for Windows

+### 6.1.1
+- ADDED: Trigger support (SQL Server, PostgreSQL, MySQL, Oracle)
+- FIXED: PostgreSQL and Oracle export #970
+- FIXED: Cursor Becomes Stuck When Escaping "Case" #954
+- CHANGED: Defualt search criteria for tables are names only
+- FIXED: Search in packed list
+
 ### 6.1.0
 - ADDED: Fulltext search in DB model and connections, highlight searched names
 - ADDED: Tab preview mode configuration #963
@@ -17,7 +17,7 @@ DbGate is licensed under GPL-3.0 license and is free to use for any purpose.
 * Try it online - [demo.dbgate.org](https://demo.dbgate.org) - online demo application
 * **Download** application for Windows, Linux or Mac from [dbgate.org](https://dbgate.org/download/)
 * Run web version as [NPM package](https://www.npmjs.com/package/dbgate-serve) or as [docker image](https://hub.docker.com/r/dbgate/dbgate)
-* Use nodeJs [scripting interface](https://dbgate.org/docs/scripting.html) ([API documentation](https://dbgate.org/docs/apidoc.html))
+* Use nodeJs [scripting interface](https://dbgate.org/docs/scripting) ([API documentation](https://dbgate.org/docs/apidoc))
 * [Recommend DbGate](https://testimonial.to/dbgate) | [Rate on G2](https://www.g2.com/products/dbgate/reviews)

 ## Supported databases
@@ -87,7 +87,7 @@ Any contributions are welcome. If you want to contribute without coding, conside
 * Create issue, if you find problem in app, or you have idea to new feature. If issue already exists, you could leave comment on it, to prioritise most wanted issues
 * Create some tutorial video on [youtube](https://www.youtube.com/playlist?list=PLCo7KjCVXhr0RfUSjM9wJMsp_ShL1q61A)
 * Become a backer on [GitHub sponsors](https://github.com/sponsors/dbgate) or [Open collective](https://opencollective.com/dbgate)
-* Where a small coding is acceptable for you, you could [create plugin](https://dbgate.org/docs/plugin-development.html). Plugins for new themes can be created actually without JS coding
+* Where a small coding is acceptable for you, you could [create plugin](https://dbgate.org/docs/plugin-development). Plugins for new themes can be created actually without JS coding

 Thank you!

@@ -41,6 +41,29 @@ function adjustFile(file, isApp = false) {
    delete json.optionalDependencies.msnodesqlv8;
  }

+  if (process.argv.includes('--community')) {
+    delete json.optionalDependencies['mongodb-client-encryption'];
+  }
+
+  if (isApp && process.argv.includes('--premium')) {
+    json.build.win.target = [
+      {
+        target: 'nsis',
+        arch: ['x64'],
+      },
+    ];
+    json.build.linux.target = [
+      {
+        target: 'AppImage',
+        arch: ['x64'],
+      },
+    ];
+    json.name = 'dbgate-premium';
+    json.build.artifactName = 'dbgate-premium-${version}-${os}_${arch}.${ext}';
+    json.build.appId = 'org.dbgate.premium';
+    json.build.productName = 'DbGate Premium';
+  }
+
  fs.writeFileSync(file, JSON.stringify(json, null, 2), 'utf-8');
 }

@@ -19,7 +19,6 @@
    "artifactName": "dbgate-${version}-${os}_${arch}.${ext}",
    "appId": "org.dbgate",
    "productName": "DbGate",
-    "afterSign": "electron-builder-notarize",
    "asarUnpack": "**/*.node",
    "mac": {
      "category": "database",
@@ -41,7 +40,8 @@
          "x64",
          "arm64"
        ]
-      }
+      },
+      "notarize": true
    },
    "linux": {
      "target": [
@@ -130,7 +130,6 @@
    "copyfiles": "^2.2.0",
    "cross-env": "^6.0.3",
    "electron": "30.0.2",
-    "electron-builder": "23.1.0",
-    "electron-builder-notarize": "^1.5.2"
+    "electron-builder": "25.1.8"
  }
 }
@@ -0,0 +1,174 @@
+const fs = require('fs');
+const path = require('path');
+const yaml = require('js-yaml');
+const _ = require('lodash');
+
+const indir = path.resolve(path.join(__dirname, '..', 'workflow-templates'));
+const outdir = path.resolve(path.join(__dirname, '..', '.github', 'workflows'));
+
+const includes = {};
+
+const HEADER = `# --------------------------------------------------------------------------------------------
+# This file is generated. Do not edit manually
+# --------------------------------------------------------------------------------------------
+`;
+
+function readIncludes() {
+  for (const file of fs.readdirSync(indir)) {
+    const text = fs.readFileSync(path.join(indir, file), { encoding: 'utf-8' });
+    const json = yaml.load(text);
+    if (json._module) {
+      for (const key in json) {
+        if (key === '_module') {
+          continue;
+        }
+        includes[key] = json[key];
+      }
+    }
+  }
+}
+
+let modified = false;
+
+function conditionMatch(condition, args) {
+  if (_.isString(condition)) {
+    return args.defs.includes(condition);
+  }
+  return false;
+}
+
+function processJsonStep(json, args) {
+  return _.cloneDeepWith(json, value => {
+    if (_.isArray(value)) {
+      const res = [];
+      let arrayModified = false;
+      for (const item of value) {
+        if (item._if) {
+          modified = true;
+          arrayModified = true;
+          if (conditionMatch(item._if, args)) {
+            res.push(_.omit(item, ['_if']));
+          }
+        } else if (item._replace || item._include) {
+          const replaceWith = item._replace ? args.replace?.[item._replace] : includes[item._include];
+          if (replaceWith) {
+            modified = true;
+            arrayModified = true;
+            if (_.isArray(replaceWith)) {
+              res.push(...replaceWith);
+            } else {
+              res.push(replaceWith);
+            }
+          } else {
+            res.push(item);
+          }
+        } else {
+          res.push(item);
+        }
+      }
+      if (arrayModified) {
+        return res;
+      }
+      return undefined;
+    }
+
+    if (_.isPlainObject(value)) {
+      if (_.intersection(args.allDefs ?? [], Object.keys(value))?.length > 0) {
+        modified = true;
+        for (const key in value) {
+          if (args.defs.includes(key)) {
+            return value[key];
+          }
+        }
+        return undefined;
+      }
+    }
+
+    if (_.isString(value)) {
+      let stringModified = false;
+      for (const key of Object.keys(args.stringReplace ?? {})) {
+        if (value.includes(key)) {
+          modified = true;
+          stringModified = true;
+          value = value.replaceAll(key, args.stringReplace[key]);
+        }
+      }
+      if (stringModified) {
+        return value;
+      }
+      return undefined;
+    }
+
+    if (value?._include) {
+      modified = true;
+      return includes[value?._include];
+    }
+
+    if (value?._replace) {
+      modified = true;
+      return args?.replace[value?._replace];
+    }
+  });
+}
+
+function processJson(json, args = {}) {
+  const MAX_STEPS = 64;
+  for (let i = 0; i < MAX_STEPS; i++) {
+    modified = false;
+    json = processJsonStep(json, args);
+    if (!modified) {
+      break;
+    }
+  }
+  return json;
+}
+
+function processFiles() {
+  const dumpOptions = {
+    lineWidth: -1,
+  };
+  for (const file of fs.readdirSync(indir)) {
+    const text = fs.readFileSync(path.join(indir, file), { encoding: 'utf-8' });
+    const json = yaml.load(text);
+
+    if (json._module) {
+      continue;
+    }
+
+    if (json._templates) {
+      const allDefs = Object.keys(json._templates);
+      for (const key in json._templates) {
+        allDefs.push(...(json._templates[key].defs ?? []));
+      }
+
+      for (const key in json._templates) {
+        const args = {
+          defs: [key, ...(json._templates[key]?.defs ?? [])],
+          replace: json._templates[key]?.replace,
+          stringReplace: json._templates[key]?.['string-replace'],
+          allDefs,
+        };
+        const converted = processJson(_.omit(json, ['_templates']), args);
+        const out = path.join(outdir, json._templates[key].file);
+        fs.writeFileSync(out, HEADER + yaml.dump(converted, dumpOptions));
+      }
+    } else {
+      fs.writeFileSync(path.join(outdir, file), HEADER + yaml.dump(processJson(json), dumpOptions));
+    }
+  }
+}
+
+function deleteOldFiles() {
+  const files = fs.readdirSync(outdir);
+  for (const file of files) {
+    fs.unlinkSync(path.join(outdir, file));
+  }
+}
+
+function run() {
+  deleteOldFiles();
+  readIncludes();
+  processFiles();
+}
+
+run();
@@ -23,9 +23,48 @@ describe('Initialization', () => {
    cy.contains('performance_schema');
  });

+  // it('SSH connection', () => {
+  //   const runOnCI = Cypress.env('runOnCI');
+
+  //   cy.get('body')
+  //     .trigger('keydown', {
+  //       key: 'F1',
+  //       code: 'F1',
+  //       which: 112,
+  //       keyCode: 112,
+  //       bubbles: true,
+  //     })
+  //     .trigger('keyup', {
+  //       key: 'F1',
+  //       code: 'F1',
+  //       which: 112,
+  //       keyCode: 112,
+  //       bubbles: true,
+  //     });
+  //   cy.get('body').type('Close all');
+  //   cy.get('body').type('{enter}');
+
+  //   cy.visit('http://localhost:3000');
+  //   cy.get('[data-testid=ConnectionList_buttonNewConnection]').click();
+  //   cy.get('[data-testid=ConnectionDriverFields_connectionType]').select('MySQL');
+  //   cy.get('[data-testid=ConnectionDriverFields_user]').clear().type('root');
+  //   cy.get('[data-testid=ConnectionDriverFields_password]').clear().type('root');
+
+  //   cy.get('[data-testid=ConnectionSshTunnelFields_sshLogin]').clear().type('root');
+  //   cy.get('[data-testid=ConnectionSshTunnelFields_sshPassword]').clear().type('root');
+  //   if (runOnCI) {
+  //     cy.get('[data-testid=ConnectionSshTunnelFields_sshHost]').clear().type('mysql-ssh');
+  //   } else {
+  //     cy.get('[data-testid=ConnectionSshTunnelFields_sshPort]').clear().type('16006');
+  //   }
+  //   cy.get('[data-testid=ConnectionDriverFields_displayName]').clear().type('test-mysql-ssh-1');
+  //   cy.get('[data-testid=ConnectionTab_buttonSave]').click();
+  //   cy.get('[data-testid=ConnectionTab_buttonConnect]').click();
+  //   cy.contains('performance_schema');
+  // });
+
  // it('import chinook DB', () => {
  //   cy.visit('http://localhost:3000');
  //   cy.get('[data-testid=ConnectionTab_buttonConnect]').click();
  // });
-
 });
@@ -16,3 +16,10 @@ services:
      - 16004:3306
    environment:
      - MYSQL_ROOT_PASSWORD=Pwd2020Db
+
+  mysql-ssh:
+    build: mysql-ssh
+    restart: always
+    ports: 
+      - 16005:3306
+      - 16006:22
@@ -0,0 +1,22 @@
+FROM ubuntu:22.04
+
+RUN apt-get update && \
+    apt-get install -y openssh-server mysql-server && \
+    apt-get clean && \
+    rm -rf /var/lib/apt/lists/*
+
+RUN mkdir /var/run/sshd
+
+RUN sed -i 's/#PermitRootLogin prohibit-password/PermitRootLogin yes/' /etc/ssh/sshd_config
+RUN echo 'root:root' | chpasswd
+
+RUN service mysql start && \
+    mysql -uroot -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; FLUSH PRIVILEGES;" && \
+    service mysql stop
+
+EXPOSE 22 3306
+
+COPY start.sh /start.sh
+RUN chmod +x /start.sh
+
+CMD ["/start.sh"]
@@ -0,0 +1,7 @@
+#!/bin/bash
+
+service ssh start
+
+service mysql start
+
+tail -f /dev/null
@@ -2,10 +2,11 @@ const engines = require('../engines');
 const stream = require('stream');
 const { testWrapper } = require('../tools');
 const tableWriter = require('dbgate-api/src/shell/tableWriter');
+const tableReader = require('dbgate-api/src/shell/tableReader');
 const copyStream = require('dbgate-api/src/shell/copyStream');
 const importDatabase = require('dbgate-api/src/shell/importDatabase');
 const fakeObjectReader = require('dbgate-api/src/shell/fakeObjectReader');
-const { runQueryOnDriver } = require('dbgate-tools');
+const { runQueryOnDriver, runCommandOnDriver } = require('dbgate-tools');

 function createImportStream() {
  const pass = new stream.PassThrough({
@@ -23,7 +24,17 @@ function createImportStream() {
  return pass;
 }

-describe('DB Import', () => {
+function createExportStream() {
+  const writable = new stream.Writable({ objectMode: true });
+  writable.resultArray = [];
+  writable._write = (chunk, encoding, callback) => {
+    writable.resultArray.push(chunk);
+    callback();
+  };
+  return writable;
+}
+
+describe('DB Import/export', () => {
  test.each(engines.map(engine => [engine.label, engine]))(
    'Import one table - %s',
    testWrapper(async (conn, driver, engine) => {
@@ -99,4 +110,35 @@ describe('DB Import', () => {
      // expect(res2.rows[0].cnt.toString()).toEqual('6');
    })
  );
+
+  test.each(engines.map(engine => [engine.label, engine]))(
+    'Export one table - %s',
+    testWrapper(async (conn, driver, engine) => {
+      // const reader = await fakeObjectReader({ delay: 10 });
+      // const reader = await fakeObjectReader();
+      await runCommandOnDriver(conn, driver, 'create table ~t1 (~id int primary key, ~country varchar(100))');
+      const data = [
+        [1, 'Czechia'],
+        [2, 'Austria'],
+        [3, 'Germany'],
+        [4, 'Romania'],
+        [5, 'Great Britain'],
+        [6, 'Bosna, Hecegovina'],
+      ];
+      for (const row of data) {
+        await runCommandOnDriver(conn, driver, dmp =>
+          dmp.put('insert into ~t1(~id, ~country) values (%v, %v)', ...row)
+        );
+      }
+      const reader = await tableReader({
+        systemConnection: conn,
+        driver,
+        pureName: 't1',
+      });
+      const writer = createExportStream();
+      await copyStream(reader, writer);
+
+      expect(writer.resultArray.filter(x => !x.__isStreamHeader).map(row => [row.id, row.country])).toEqual(data);
+    })
+  );
 });
@@ -419,7 +419,7 @@ describe('Deploy database', () => {
    })
  );

-  test.each(engines.enginesPostgre.map(engine => [engine.label, engine]))(
+  test.each([engines.postgreSqlEngine].map(engine => [engine.label, engine]))(
    'Current timestamp default value - %s',
    testWrapper(async (conn, driver, engine) => {
      await testDatabaseDeploy(engine, conn, driver, [
@@ -100,46 +100,50 @@ describe('Object analyse', () => {
    })
  );

-  test.each(flatSourceParameters())(
-    'Test parameters simple analyse - %s - %s',
-    testWrapper(async (conn, driver, testName, parameter, engine) => {
-      for (const sql of initSql) await runCommandOnDriver(conn, driver, sql);
-      for (const sql of engine.parametersOtherSql) await runCommandOnDriver(conn, driver, sql);
+  const flatParameters = flatSourceParameters();

-      await runCommandOnDriver(conn, driver, parameter.create);
-      const structure = await driver.analyseFull(conn);
+  if (flatParameters.length > 0) {
+    test.each(flatParameters)(
+      'Test parameters simple analyse - %s - %s',
+      testWrapper(async (conn, driver, testName, parameter, engine) => {
+        for (const sql of initSql) await runCommandOnDriver(conn, driver, sql);
+        for (const sql of engine.parametersOtherSql) await runCommandOnDriver(conn, driver, sql);

-      const parameters = structure[parameter.objectTypeField].find(x => x.pureName == 'obj1').parameters;
+        await runCommandOnDriver(conn, driver, parameter.create);
+        const structure = await driver.analyseFull(conn);

-      expect(parameters.length).toEqual(parameter.list.length);
-      for (let i = 0; i < parameters.length; i += 1) {
-        expect(parameters[i]).toEqual(expect.objectContaining(parameter.list[i]));
-      }
-    })
-  );
+        const parameters = structure[parameter.objectTypeField].find(x => x.pureName == 'obj1').parameters;

-  test.each(flatSourceParameters())(
-    'Test parameters create SQL - %s - %s',
-    testWrapper(async (conn, driver, testName, parameter, engine) => {
-      for (const sql of initSql) await runCommandOnDriver(conn, driver, sql);
-      for (const sql of engine.parametersOtherSql) await runCommandOnDriver(conn, driver, sql);
+        expect(parameters.length).toEqual(parameter.list.length);
+        for (let i = 0; i < parameters.length; i += 1) {
+          expect(parameters[i]).toEqual(expect.objectContaining(parameter.list[i]));
+        }
+      })
+    );

-      await runCommandOnDriver(conn, driver, parameter.create);
-      const structure1 = await driver.analyseFull(conn);
-      await runCommandOnDriver(conn, driver, parameter.drop);
+    test.each(flatParameters)(
+      'Test parameters create SQL - %s - %s',
+      testWrapper(async (conn, driver, testName, parameter, engine) => {
+        for (const sql of initSql) await runCommandOnDriver(conn, driver, sql);
+        for (const sql of engine.parametersOtherSql) await runCommandOnDriver(conn, driver, sql);

-      const obj = structure1[parameter.objectTypeField].find(x => x.pureName == 'obj1');
-      await driver.script(conn, obj.createSql, { discardResult: true });
+        await runCommandOnDriver(conn, driver, parameter.create);
+        const structure1 = await driver.analyseFull(conn);
+        await runCommandOnDriver(conn, driver, parameter.drop);

-      const structure2 = await driver.analyseFull(conn);
-      const parameters = structure2[parameter.objectTypeField].find(x => x.pureName == 'obj1').parameters;
+        const obj = structure1[parameter.objectTypeField].find(x => x.pureName == 'obj1');
+        await driver.script(conn, obj.createSql, { discardResult: true });

-      expect(parameters.length).toEqual(parameter.list.length);
-      for (let i = 0; i < parameters.length; i += 1) {
-        expect(parameters[i]).toEqual(expect.objectContaining(parameter.list[i]));
-      }
-    })
-  );
+        const structure2 = await driver.analyseFull(conn);
+        const parameters = structure2[parameter.objectTypeField].find(x => x.pureName == 'obj1').parameters;
+
+        expect(parameters.length).toEqual(parameter.list.length);
+        for (let i = 0; i < parameters.length; i += 1) {
+          expect(parameters[i]).toEqual(expect.objectContaining(parameter.list[i]));
+        }
+      })
+    );
+  }

  test.each(flatSourceTriggers())(
    'Test triggers - %s - %s',
@@ -158,6 +162,14 @@ describe('Object analyse', () => {

      const createdTrigger = structure[objectTypeField].find(x => x.pureName == expected.pureName);
      expect(createdTrigger).toEqual(expect.objectContaining(expected));
+
+      // test trigger createSql
+      if (triggerOtherCreateSql) await runCommandOnDriver(conn, driver, triggerOtherCreateSql);
+
+      await driver.script(conn, createdTrigger.createSql);
+      const structure2 = await driver.analyseFull(conn);
+      const createdTrigger2 = structure2[objectTypeField].find(x => x.pureName == expected.pureName);
+      expect(createdTrigger2).toEqual(expect.objectContaining(expected));
    })
  );
 });
@@ -1,6 +1,6 @@
 {
  "private": true,
-  "version": "6.1.0",
+  "version": "6.1.3-beta.1",
  "name": "dbgate-all",
  "workspaces": [
    "packages/*",
@@ -47,7 +47,6 @@
    "setCurrentVersion": "node setCurrentVersion",
    "printSecrets": "node printSecrets",
    "generatePadFile": "node generatePadFile",
-    "adjustPackageJson": "node adjustPackageJson",
    "fillPackagedPlugins": "node fillPackagedPlugins",
    "resetPackagedPlugins": "node resetPackagedPlugins",
    "prettier": "prettier --write packages/api/src && prettier --write packages/datalib/src && prettier --write packages/filterparser/src && prettier --write packages/sqltree/src && prettier --write packages/tools/src && prettier --write packages/types && prettier --write packages/web/src && prettier --write app/src",
@@ -63,7 +62,8 @@
    "ts:web": "yarn workspace dbgate-web ts",
    "ts": "yarn ts:api && yarn ts:web",
    "postinstall": "yarn resetPackagedPlugins && yarn build:lib && patch-package && yarn build:plugins:frontend",
-    "dbgate-serve": "node packages/dbgate/bin/dbgate-serve.js"
+    "dbgate-serve": "node packages/dbgate/bin/dbgate-serve.js",
+    "workflows": "node common/processWorkflows.js"
  },
  "dependencies": {
    "concurrently": "^5.1.0",
@@ -30,7 +30,7 @@
    "cors": "^2.8.5",
    "cross-env": "^6.0.3",
    "dbgate-datalib": "^6.0.0-alpha.1",
-    "dbgate-query-splitter": "^4.11.2",
+    "dbgate-query-splitter": "^4.11.3",
    "dbgate-sqltree": "^6.0.0-alpha.1",
    "dbgate-tools": "^6.0.0-alpha.1",
    "debug": "^4.3.4",
@@ -237,7 +237,7 @@ module.exports = {
      }
    );
    pipeForkLogs(subprocess);
-    subprocess.send({ connection, requestDbList });
+    subprocess.send({ ...connection, requestDbList });
    return new Promise(resolve => {
      subprocess.on('message', resp => {
        if (handleProcessCommunication(resp, subprocess)) return;
@@ -16,9 +16,9 @@ Platform: ${process.platform}

 function start() {
  childProcessChecker();
-  process.on('message', async args => {
+  process.on('message', async connection => {
    // @ts-ignore
-    const { connection, requestDbList } = args;
+    const { requestDbList } = connection;
    if (handleProcessCommunication(connection)) return;
    try {
      const driver = requireEngineDriver(connection);
@@ -8,12 +8,15 @@ const logger = getLogger('tableReader');
 * @param {object} options
 * @param {connectionType} options.connection - connection object
 * @param {object} options.systemConnection - system connection (result of driver.connect). If not provided, new connection will be created
+ * @param {object} options.driver - driver object. If not provided, it will be loaded from connection
 * @param {string} options.pureName - table name
 * @param {string} options.schemaName - schema name
 * @returns {Promise<readerType>} - reader object
 */
-async function tableReader({ connection, systemConnection, pureName, schemaName }) {
-  const driver = requireEngineDriver(connection);
+async function tableReader({ connection, systemConnection, pureName, schemaName, driver }) {
+  if (!driver) {
+    driver = requireEngineDriver(connection);
+  }
  const dbhan = systemConnection || (await connectUtility(driver, connection, 'read'));
  logger.info(`Connected.`);

@@ -41,7 +41,7 @@ STORAGE_DATABASE=dbname
 STORAGE_ENGINE=mysql@dbgate-plugin-mysql
 ```

-You could find more about environment variable configuration on [DbGate docs](https://dbgate.org/docs/env-variables.html) page.
+You could find more about environment variable configuration on [DbGate docs](https://dbgate.org/docs/env-variables/) page.

 After installing, you can run dbgate with command:
 ```sh
@@ -31,7 +31,7 @@
    "typescript": "^4.4.3"
  },
  "dependencies": {
-    "dbgate-query-splitter": "^4.11.2",
+    "dbgate-query-splitter": "^4.11.3",
    "dbgate-sqltree": "^6.0.0-alpha.1",
    "debug": "^4.3.4",
    "json-stable-stringify": "^1.0.1",
@@ -715,7 +715,7 @@ export function createAlterDatabasePlan(
 ): AlterPlan {
  const plan = new AlterPlan(wholeOldDb, wholeNewDb, driver.dialect, opts);

-  for (const objectTypeField of ['tables', 'views', 'procedures', 'matviews', 'functions']) {
+  for (const objectTypeField of ['tables', 'views', 'procedures', 'matviews', 'functions', 'triggers']) {
    for (const oldobj of oldDb[objectTypeField] || []) {
      const newobj = (newDb[objectTypeField] || []).find(x => x.pairingId == oldobj.pairingId);
      if (objectTypeField == 'tables') {
@@ -25,7 +25,7 @@
    "chartjs-adapter-moment": "^1.0.0",
    "cross-env": "^7.0.3",
    "dbgate-datalib": "^6.0.0-alpha.1",
-    "dbgate-query-splitter": "^4.11.2",
+    "dbgate-query-splitter": "^4.11.3",
    "dbgate-sqltree": "^6.0.0-alpha.1",
    "dbgate-tools": "^6.0.0-alpha.1",
    "dbgate-types": "^6.0.0-alpha.1",
@@ -194,6 +194,12 @@
 <slot />

 <style>
+  .pin,
+  .pin-active {
+    position: absolute;
+    right: 0;
+    z-index: 150;
+  }
  .main {
    padding: 5px;
    cursor: pointer;
@@ -4,12 +4,12 @@
  export const extractKey = ({ schemaName, pureName }) => (schemaName ? `${schemaName}.${pureName}` : pureName);
  export const createMatcher =
    (filter, cfg = DEFAULT_OBJECT_SEARCH_SETTINGS) =>
-    ({ schemaName, pureName, objectComment, tableEngine, columns, objectTypeField, createSql }) => {
+    ({ schemaName, pureName, objectComment, tableEngine, columns, objectTypeField, tableName, createSql }) => {
      const mainArgs = [];
      const childArgs = [];
      if (cfg.schemaName) mainArgs.push(schemaName);
+      if (cfg.pureName) mainArgs.push(pureName);
      if (objectTypeField == 'tables') {
-        if (cfg.tableName) mainArgs.push(pureName);
        if (cfg.tableComment) mainArgs.push(objectComment);
        if (cfg.tableEngine) mainArgs.push(tableEngine);

@@ -18,12 +18,12 @@
          if (cfg.columnComment) childArgs.push(column.columnComment);
          if (cfg.columnDataType) childArgs.push(column.dataType);
        }
-      } else if (objectTypeField == 'collections') {
-        if (cfg.collectionName) mainArgs.push(pureName);
      } else {
-        if (cfg.sqlObjectName) mainArgs.push(pureName);
        if (cfg.sqlObjectText) childArgs.push(createSql);
      }
+      if (objectTypeField == 'triggers' && cfg.pureName) {
+        mainArgs.push(tableName);
+      }

      const res = filterNameCompoud(filter, mainArgs, childArgs);
      return res;
@@ -894,30 +894,18 @@
  import _ from 'lodash';
  import AppObjectCore from './AppObjectCore.svelte';
  import {
-    currentDatabase,
    DEFAULT_OBJECT_SEARCH_SETTINGS,
-    extensions,
    getActiveTab,
-    getCurrentSettings,
-    getDatabaseObjectAppObjectSearchSettings,
    getExtensions,
    getLastUsedDefaultActions,
    lastUsedDefaultActions,
-    openedConnections,
    openedTabs,
    pinnedTables,
    selectedDatabaseObjectAppObject,
  } from '../stores';
  import openNewTab from '../utility/openNewTab';
-  import {
-    extractDbNameFromComposite,
-    filterName,
-    filterNameCompoud,
-    generateDbPairingId,
-    getAlterDatabaseScript,
-    getConnectionLabel,
-  } from 'dbgate-tools';
-  import { getConnectionInfo, getDatabaseInfo } from '../utility/metadataLoaders';
+  import { extractDbNameFromComposite, filterNameCompoud, getConnectionLabel } from 'dbgate-tools';
+  import { getConnectionInfo } from '../utility/metadataLoaders';
  import fullDisplayName from '../utility/fullDisplayName';
  import { showModal } from '../modals/modalTools';
  import { findEngineDriver } from 'dbgate-tools';
@@ -928,7 +916,6 @@
  import ConfirmSqlModal, { runOperationOnDatabase, saveScriptToDatabase } from '../modals/ConfirmSqlModal.svelte';
  import { alterDatabaseDialog, renameDatabaseObjectDialog } from '../utility/alterDatabaseTools';
  import ConfirmModal from '../modals/ConfirmModal.svelte';
-  import { apiCall } from '../utility/api';
  import InputTextModal from '../modals/InputTextModal.svelte';
  import { extractShellConnection } from '../impexp/createImpExpScript';
  import { format as dateFormat } from 'date-fns';
@@ -950,9 +937,8 @@
  function getExtInfo(data) {
    const res = [];
    if (data.objectTypeField === 'triggers') {
-      res.push(`${data.triggerTiming ?? ''} ${data.eventType ?? ''}`.toLowerCase());
+      res.push(`${data.tableName}, ${data.triggerTiming?.toLowerCase() ?? ''} ${data.eventType?.toLowerCase() ?? ''}`);
    }
-
    if (data.objectComment) {
      res.push(data.objectComment);
    }
@@ -289,6 +289,8 @@
    'img export': 'mdi mdi-database-export color-icon-green',
    'img transform': 'mdi mdi-rotate-orbit color-icon-blue',
    'img tip': 'mdi mdi-lightbulb-on color-icon-yellow',
+
+    'img filter-active': 'mdi mdi-filter-cog color-icon-blue',
  };
 </script>

@@ -28,7 +28,12 @@
  $: isConnected = $openedConnections.includes($values._id) || $openedSingleDatabaseConnections.includes($values._id);
 </script>

-<FormCheckboxField label="Use SSH tunnel" name="useSshTunnel" disabled={isConnected} />
+<FormCheckboxField
+  label="Use SSH tunnel"
+  name="useSshTunnel"
+  disabled={isConnected}
+  data-testid="ConnectionSshTunnelFields_useSshTunnel"
+/>

 <div class="row">
  <div class="col-9 mr-1">
@@ -37,6 +42,7 @@
      name="sshHost"
      disabled={isConnected || !useSshTunnel}
      templateProps={{ noMargin: true }}
+      data-testid="ConnectionSshTunnelFields_sshHost"
    />
  </div>
  <div class="col-3">
@@ -46,6 +52,7 @@
      disabled={isConnected || !useSshTunnel}
      templateProps={{ noMargin: true }}
      placeholder="22"
+      data-testid="ConnectionSshTunnelFields_sshPort"
    />
  </div>
 </div>
@@ -62,10 +69,16 @@
    { value: 'agent', label: 'SSH agent' },
    { value: 'keyFile', label: 'Key file' },
  ]}
+  data-testid="ConnectionSshTunnelFields_sshMode"
 />

 {#if ($values.sshMode || 'userPassword') != 'userPassword'}
-  <FormTextField label="Login" name="sshLogin" disabled={isConnected || !useSshTunnel} />
+  <FormTextField
+    label="Login"
+    name="sshLogin"
+    disabled={isConnected || !useSshTunnel}
+    data-testid="ConnectionSshTunnelFields_sshLogin"
+  />
 {/if}

 {#if ($values.sshMode || 'userPassword') == 'userPassword'}
@@ -76,6 +89,7 @@
        name="sshLogin"
        disabled={isConnected || !useSshTunnel}
        templateProps={{ noMargin: true }}
+        data-testid="ConnectionSshTunnelFields_sshLogin"
      />
    </div>
    <div class="col-6">
@@ -84,6 +98,7 @@
        name="sshPassword"
        disabled={isConnected || !useSshTunnel}
        templateProps={{ noMargin: true }}
+        data-testid="ConnectionSshTunnelFields_sshPassword"
      />
    </div>
  </div>
@@ -99,6 +114,7 @@
          disabled={isConnected || !useSshTunnel}
          templateProps={{ noMargin: true }}
          defaultFileName={$platformInfo?.defaultKeyfile}
+          data-testid="ConnectionSshTunnelFields_sshKeyfile"
        />
      {:else}
        <FormTextField
@@ -107,6 +123,7 @@
          disabled={isConnected || !useSshTunnel}
          templateProps={{ noMargin: true }}
          placeholder={$platformInfo?.defaultKeyfile}
+          data-testid="ConnectionSshTunnelFields_sshKeyfile"
        />
      {/if}
    </div>
@@ -116,6 +133,7 @@
        name="sshKeyfilePassword"
        disabled={isConnected || !useSshTunnel}
        templateProps={{ noMargin: true }}
+        data-testid="ConnectionSshTunnelFields_sshKeyfilePassword"
      />
    </div>
  </div>
@@ -162,16 +162,13 @@ export const selectedDatabaseObjectAppObject = writable(null);
 export const focusedConnectionOrDatabase = writable<{ conid: string; database?: string; connection: any }>(null);

 export const DEFAULT_OBJECT_SEARCH_SETTINGS = {
-  collectionName: true,
+  pureName: true,
  schemaName: false,
-  tableName: true,
-  viewName: true,
-  columnName: true,
+  columnName: false,
  columnDataType: false,
  tableComment: true,
-  columnComment: true,
-  sqlObjectName: true,
-  sqlObjectText: true,
+  columnComment: false,
+  sqlObjectText: false,
  tableEngine: false,
 };

@@ -185,12 +182,12 @@ export const DEFAULT_CONNECTION_SEARCH_SETTINGS = {

 export const databaseObjectAppObjectSearchSettings = writableWithStorage(
  DEFAULT_OBJECT_SEARCH_SETTINGS,
-  'databaseObjectAppObjectSearchSettings'
+  'databaseObjectAppObjectSearchSettings2'
 );

 export const connectionAppObjectSearchSettings = writableWithStorage(
  DEFAULT_CONNECTION_SEARCH_SETTINGS,
-  'connectionAppObjectSearchSettings'
+  'connectionAppObjectSearchSettings2'
 );

 export const currentThemeDefinition = derived([currentTheme, extensions], ([$currentTheme, $extensions]) =>
@@ -217,7 +217,12 @@
    }}
  />
  <CloseSearchButton bind:filter />
-  <DropDownButton icon="icon filter" menu={createSearchMenu} square={!!filter} narrow={false} />
+  <DropDownButton
+    icon={filter ? 'img filter-active' : 'icon filter'}
+    menu={createSearchMenu}
+    square={!!filter}
+    narrow={false}
+  />
  {#if $commandsCustomized['new.connection']?.enabled}
    <InlineButton
      on:click={() => runCommand('new.connection')}
@@ -131,18 +131,16 @@
    const res = [];
    res.push({ label: 'Search by:', isBold: true, disabled: true });
    if (driver?.databaseEngineTypes?.includes('document')) {
-      res.push({ label: 'Collection names', switchValue: 'collectionName' });
+      res.push({ label: 'Collection name', switchValue: 'pureName' });
    }
    if (driver?.databaseEngineTypes?.includes('sql')) {
-      res.push({ label: 'Schema name', switchValue: 'schemaName' });
-      res.push({ label: 'Table name', switchValue: 'tableName' });
-      res.push({ label: 'View name', switchValue: 'viewName' });
+      res.push({ label: 'Table/view/procedure name', switchValue: 'pureName' });
+      res.push({ label: 'Schema', switchValue: 'schemaName' });
      res.push({ label: 'Column name', switchValue: 'columnName' });
      res.push({ label: 'Column data type', switchValue: 'columnType' });
      res.push({ label: 'Table comment', switchValue: 'tableComment' });
      res.push({ label: 'Column comment', switchValue: 'columnComment' });
-      res.push({ label: 'Procedure/function/trigger name', switchValue: 'sqlObjectName' });
-      res.push({ label: 'Procedure/function/trigger text', switchValue: 'sqlObjectText' });
+      res.push({ label: 'View/procedure/trigger text', switchValue: 'sqlObjectText' });
      res.push({ label: 'Table engine', switchValue: 'tableEngine' });
    }
    return res.map(item => ({
@@ -217,7 +215,12 @@
      }}
    />
    <CloseSearchButton bind:filter />
-    <DropDownButton icon="icon filter" menu={createSearchMenu} square={!!filter} narrow={false} />
+    <DropDownButton
+      icon={filter ? 'img filter-active' : 'icon filter'}
+      menu={createSearchMenu}
+      square={!!filter}
+      narrow={false}
+    />
    {#if !filter}
      <DropDownButton icon="icon plus-thick" menu={createAddMenu} />
    {/if}
@@ -37,13 +37,13 @@
  },
  "dependencies": {
    "bson": "^6.8.0",
-    "dbgate-query-splitter": "^4.11.2",
+    "dbgate-query-splitter": "^4.11.3",
    "dbgate-tools": "^6.0.0-alpha.1",
    "is-promise": "^4.0.0",
    "lodash": "^4.17.21",
    "mongodb": "^6.3.0"
  },
  "optionalDependencies": {
-    "mongodb-client-encryption": "^6.0.0"
+    "mongodb-client-encryption": "^6.1.1"
  }
 }
@@ -37,7 +37,7 @@
  },
  "dependencies": {
    "async-lock": "^1.2.6",
-    "dbgate-query-splitter": "^4.11.2",
+    "dbgate-query-splitter": "^4.11.3",
    "dbgate-tools": "^6.0.0-alpha.1",
    "lodash": "^4.17.21",
    "tedious": "^18.2.0"
@@ -2,6 +2,6 @@ module.exports = `
 select o.object_id as objectId, o.modify_date as modifyDate, o.type, o.name as pureName, s.name as schemaName
 from sys.objects o 
 inner join sys.schemas s on o.schema_id = s.schema_id
-where o.type in ('U', 'V', 'P', 'IF', 'FN', 'TF') -- , 'TR' - triggers disabled
+where o.type in ('U', 'V', 'P', 'IF', 'FN', 'TF', 'TR')
    and s.name =SCHEMA_NAME_CONDITION
 `;
@@ -37,7 +37,7 @@
  },
  "dependencies": {
    "antares-mysql-dumper": "^0.0.1",
-    "dbgate-query-splitter": "^4.11.2",
+    "dbgate-query-splitter": "^4.11.3",
    "dbgate-tools": "^6.0.0-alpha.1",
    "lodash": "^4.17.21",
    "mysql2": "^3.11.3"
@@ -171,6 +171,7 @@ class Analyser extends DatabaseAnalyser {
      tables: tables.rows.map(table => ({
        ...table,
        objectId: table.pureName,
+        objectComment: _.isString(table.objectComment) ? table.objectComment : undefined,
        contentHash: _.isDate(table.modifyDate) ? table.modifyDate.toISOString() : table.modifyDate,
        columns: columns.rows.filter(col => col.pureName == table.pureName).map(x => getColumnInfo(x, this.driver)),
        primaryKey: DatabaseAnalyser.extractPrimaryKeys(table, pkColumns.rows),
@@ -245,9 +246,8 @@ class Analyser extends DatabaseAnalyser {
        pureName: row.triggerName,
        eventType: row.eventType,
        triggerTiming: row.triggerTiming,
-        schemaName: row.schemaName,
        tableName: row.tableName,
-        createSql: row.definition,
+        createSql: `CREATE TRIGGER ${row.triggerName} ${row.triggerTiming} ${row.eventType} ON ${row.tableName} FOR EACH ROW ${row.definition}`,
      })),
    };
    this.feedback({ analysingMessage: null });
@@ -35,7 +35,7 @@
    "webpack-cli": "^5.1.4"
  },
  "dependencies": {
-    "dbgate-query-splitter": "^4.11.2",
+    "dbgate-query-splitter": "^4.11.3",
    "dbgate-tools": "^6.0.0-alpha.1",
    "lodash": "^4.17.21"
  },
@@ -213,13 +213,15 @@ class Analyser extends DatabaseAnalyser {
          parameters: routineToParams[func.pure_name],
        })),
      triggers: triggers.rows.map(row => ({
-        pureName: row.TRIGGER_NAME,
-        trigerName: row.TRIGGER_NAME,
-        definition: row.DEFINITION,
-        tableName: row.TABLE_NAME,
-        triggerLevel: row.TRIGGER_LEVEL,
-        triggerTiming: row.TRIGGER_TIMING,
-        eventType: row.EVENT_TYPE,
+        pureName: row.trigger_name,
+        createSql: `SET SQLTERMINATOR "/"\nCREATE TRIGGER "${row.trigger_name}" ${
+          row.trigger_timing.includes('BEFORE') ? 'BEFORE' : 'AFTER'
+        } ${row.event_type} ON "${row.table_name}" FOR EACH ROW ${row.definition} \n/\n`,
+        // createSql: `SET SQLTERMINATOR "/"\n${row.definition}\n/\n`,
+        tableName: row.table_name,
+        triggerLevel: row.trigger_level,
+        triggerTiming: row.trigger_timing,
+        eventType: row.event_type,
      })),
    };

@@ -306,12 +306,9 @@ const driver = {
        }
        wasHeader = true;
      }
-
-      pass.write(zipDataRow(row, columns));
    });

    query.on('data', row => {
-      // console.log('readQuery data', row);
      pass.write(zipDataRow(row, columns));
    });

@@ -1,10 +1,10 @@
 module.exports = `
 SELECT
-    TRIGGER_TYPE AS trigger_timing,
-    TRIGGERING_EVENT AS event_type,
-    TRIGGER_BODY AS definition,
-    TRIGGER_NAME AS trigger_name,
-    TABLE_NAME AS table_name,
+    TRIGGER_TYPE AS "trigger_timing",
+    TRIGGERING_EVENT AS "event_type",
+    TRIGGER_BODY AS "definition",
+    TRIGGER_NAME AS "trigger_name",
+    TABLE_NAME AS "table_name",
    OWNER,
    CASE
        WHEN INSTR(TRIGGER_TYPE, 'ROW') > 0 THEN 'ROW'
@@ -37,7 +37,7 @@
  "dependencies": {
    "wkx": "^0.5.0",
    "pg-copy-streams": "^6.0.6",
-    "dbgate-query-splitter": "^4.11.2",
+    "dbgate-query-splitter": "^4.11.3",
    "dbgate-tools": "^6.0.0-alpha.1",
    "lodash": "^4.17.21",
    "pg": "^8.11.5"
@@ -301,7 +301,7 @@ const drivers = driverBases.map(driverBase => ({
      const zippedRow = zipDataRow(row, columns);
      const transformedRow = transformRow(zippedRow, columnsToTransform);

-      options.row(transformedRow);
+      pass.write(transformedRow);
    });

    query.on('end', () => {
@@ -34,7 +34,7 @@
    "webpack-cli": "^5.1.4"
  },
  "dependencies": {
-    "dbgate-query-splitter": "^4.11.2",
+    "dbgate-query-splitter": "^4.11.3",
    "dbgate-tools": "^6.0.0-alpha.1",
    "lodash": "^4.17.21",
    "async": "^3.2.3",
@@ -37,7 +37,7 @@
  "dependencies": {
    "dbgate-tools": "^6.0.0-alpha.1",
    "lodash": "^4.17.21",
-    "dbgate-query-splitter": "^4.11.2"
+    "dbgate-query-splitter": "^4.11.3"
  },
  "optionalDependencies": {
    "better-sqlite3": "9.6.0"
@@ -1,19 +1,6 @@
 const _ = require('lodash');
 const { DatabaseAnalyser } = global.DBGATE_PACKAGES['dbgate-tools'];
-
-const indexcolsQuery = `
-SELECT 
-    m.name as tableName,
-    il.name as constraintName,
-    il."unique" as isUnique,
-    ii.name as columnName,
-    il.origin
-  FROM sqlite_schema AS m,
-       pragma_index_list(m.name) AS il,
-       pragma_index_info(il.name) AS ii
- WHERE m.type='table' AND il.origin <> 'pk'
- ORDER BY ii.seqno, il.name
-  `;
+const sql = require('./sql');

 class Analyser extends DatabaseAnalyser {
  constructor(dbhan, driver, version) {
@@ -26,8 +13,8 @@ class Analyser extends DatabaseAnalyser {
  }

  async _getFastSnapshot() {
-    const objects = await this.driver.query(this.dbhan, "select * from sqlite_master where type='table' or type='view'");
-    const indexcols = await this.driver.query(this.dbhan, indexcolsQuery);
+    const objects = await this.driver.query(this.dbhan, sql.objects);
+    const indexcols = await this.driver.query(this.dbhan, sql.indexcols);

    return {
      tables: objects.rows
@@ -53,10 +40,7 @@ class Analyser extends DatabaseAnalyser {
  }

  async _runAnalysis() {
-    const objects = await this.analyserQuery(
-      "select * from sqlite_master where (type='table' or type='view') and name =OBJECT_ID_CONDITION",
-      ['tables', 'views']
-    );
+    const objects = await this.analyserQuery(sql.objectsConditioned, ['tables', 'views']);
    const tables = objects.rows.filter((x) => x.type == 'table');
    const views = objects.rows.filter((x) => x.type == 'view');
    // console.log('TABLES', tables);
@@ -79,7 +63,7 @@ class Analyser extends DatabaseAnalyser {
      createSql: x.sql,
    }));

-    const indexcols = await this.driver.query(this.dbhan, indexcolsQuery);
+    const indexcols = await this.driver.query(this.dbhan, sql.indexcols);

    for (const tableName of this.getRequestedObjectPureNames(
      'tables',
@@ -165,9 +149,12 @@ class Analyser extends DatabaseAnalyser {
      }));
    }

+    const triggers = await this.driver.query(this.dbhan, sql.triggers);
+
    return {
      tables: tableList,
      views: viewList,
+      triggers: triggers.rows,
    };
  }
 }
@@ -0,0 +1,11 @@
+const objects = require('./objects.js');
+const objectsConditioned = require('./objectsConditioned.js');
+const indexcols = require('./indexcols.js');
+const triggers = require('./triggers.js');
+
+module.exports = {
+  objects,
+  objectsConditioned,
+  indexcols,
+  triggers,
+};
@@ -0,0 +1,14 @@
+module.exports = `
+SELECT 
+    m.name as tableName,
+    il.name as constraintName,
+    il."unique" as isUnique,
+    ii.name as columnName,
+    il.origin
+  FROM sqlite_schema AS m,
+       pragma_index_list(m.name) AS il,
+       pragma_index_info(il.name) AS ii
+ WHERE m.type='table' AND il.origin <> 'pk'
+ ORDER BY ii.seqno, il.name
+  
+`;
@@ -0,0 +1,3 @@
+module.exports = `
+select * from sqlite_master where (type='table' or type='view')
+`;
@@ -0,0 +1,3 @@
+module.exports = `
+select * from sqlite_master where (type='table' or type='view') and name =OBJECT_ID_CONDITION
+`;
@@ -0,0 +1,23 @@
+module.exports = `
+SELECT 
+    rowid AS objectId,
+    name AS pureName,
+    CASE 
+        WHEN sql LIKE '% AFTER %' THEN 'AFTER'
+        WHEN sql LIKE '% BEFORE %' THEN 'BEFORE'
+        WHEN sql LIKE '% INSTEAD OF %' THEN 'INSTEAD OF'
+        ELSE 'UNKNOWN'
+    END AS triggerTiming,
+    CASE 
+        WHEN sql LIKE '% INSERT %' THEN 'INSERT'
+        WHEN sql LIKE '% UPDATE %' THEN 'UPDATE'
+        WHEN sql LIKE '% DELETE %' THEN 'DELETE'
+        ELSE NULL
+    END AS eventType,
+    tbl_name AS tableName,
+    sql AS createSql
+FROM 
+    sqlite_master
+WHERE 
+    type = 'trigger';
+`;
@@ -0,0 +1,220 @@
+_templates:
+  _community_beta:
+    file: build-app-beta.yaml
+    defs:
+      - _community
+      - _beta
+      - _channel
+    string-replace:
+      "<<cd_merged>>": ''
+      "<<adjust>>": '--community'
+      "<<artifact-root>>": 'app/dist'
+      "<<channel>>": beta
+      "<<suffix>>": 'beta'
+  _community_stable:
+    file: build-app.yaml
+    defs:
+      - _community
+      - _stable
+    string-replace:
+      "<<cd_merged>>": ''
+      "<<adjust>>": '--community'
+      "<<artifact-root>>": 'app/dist'
+      "<<suffix>>": 'latest'
+
+
+  _premium_beta:
+    file: build-app-pro-beta.yaml
+    defs:
+      - _premium
+      - _beta
+      - _channel
+    string-replace:
+      "<<cd_merged>>": |
+        cd ..
+        cd dbgate-merged
+      "<<adjust>>": '--premium'
+      "<<artifact-root>>": '../dbgate-merged/app/dist'
+      "<<channel>>": 'premium-beta'
+      "<<suffix>>": 'premium-beta'
+  _premium_stable:
+    file: build-app-pro.yaml
+    defs:
+      - _premium
+      - _stable
+      - _channel
+    string-replace:
+      "<<cd_merged>>": |
+        cd ..
+        cd dbgate-merged
+      "<<adjust>>": '--premium'
+      "<<artifact-root>>": '../dbgate-merged/app/dist'
+      "<<channel>>": 'premium'
+      "<<suffix>>": 'premium-latest'
+
+name: 
+  _community_beta: Electron app BETA
+  _community_stable: Electron app
+  _premium_beta: Electron app PREMIUM BETA
+  _premium_stable: Electron app PREMIUM
+
+on:
+  push:
+    tags:
+      - _community_beta: 'v[0-9]+.[0-9]+.[0-9]+-beta.[0-9]+'
+        _premium_beta: 'v[0-9]+.[0-9]+.[0-9]+-premium-beta.[0-9]+'
+        _stable: 'v[0-9]+.[0-9]+.[0-9]+'
+      # - 'v*' # Push events to matching v*, i.e. v1.0, v20.15.10
+
+    # branches:
+    #   - production
+
+jobs:
+  build:
+    runs-on: ${{ matrix.os }}
+
+    strategy:
+      fail-fast: false
+      matrix:
+        # os: [ubuntu-22.04, windows-2016]
+        os: [macos-14, windows-2022, ubuntu-22.04]
+
+    steps:
+      - name: Install python 3.11 (MacOS)
+        if: matrix.os == 'macos-14'
+        run: |
+          brew install python@3.11
+          echo "PYTHON=/opt/homebrew/bin/python3.11" >> $GITHUB_ENV
+      - name: Context
+        env:
+          GITHUB_CONTEXT: ${{ toJson(github) }}
+        run: echo "$GITHUB_CONTEXT"
+      - uses: actions/checkout@v2
+        with:
+          fetch-depth: 1
+      - name: Use Node.js 22.x
+        uses: actions/setup-node@v1
+        with:
+          node-version: 22.x
+
+      - _include: checkout-and-merge-pro
+        _if: _premium
+
+      - name: adjustPackageJson
+        run: |
+          <<cd_merged>>
+          node adjustPackageJson <<adjust>>
+      - name: setUpdaterChannel <<channel>>
+        _if: _channel
+        run: |
+          <<cd_merged>>
+          node setUpdaterChannel <<channel>>
+      - name: yarn set timeout
+        run: |
+          <<cd_merged>>
+          yarn config set network-timeout 100000
+      - name: yarn install
+        run: |
+          <<cd_merged>>
+          yarn install
+      - name: setCurrentVersion
+        run: |
+          <<cd_merged>>
+          yarn setCurrentVersion
+      - name: printSecrets
+        run: |
+          <<cd_merged>>
+          yarn printSecrets
+        env:
+          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
+      - name: fillPackagedPlugins
+        run: |
+          <<cd_merged>>
+          yarn fillPackagedPlugins
+      - name: Install Snapcraft
+        _if: _community
+        if: matrix.os == 'ubuntu-22.04'
+        uses: samuelmeuli/action-snapcraft@v1
+      - name: Publish
+        run: |
+          <<cd_merged>>
+          yarn run build:app
+        env:
+          GH_TOKEN: ${{ secrets.GH_TOKEN }} # token for electron publish
+
+          WIN_CSC_LINK: ${{ secrets.WINCERT_2025 }}
+          WIN_CSC_KEY_PASSWORD: ${{ secrets.WINCERT_2025_PASSWORD }}
+          # WIN_CSC_LINK: ${{ secrets.WINCERT_CERTIFICATE }}
+          # WIN_CSC_KEY_PASSWORD: ${{ secrets.WINCERT_PASSWORD }}
+
+          CSC_LINK: ${{ secrets.APPLECERT_CERTIFICATE }}
+          CSC_KEY_PASSWORD: ${{ secrets.APPLECERT_PASSWORD }}
+
+          APPLE_ID: ${{ secrets.APPLE_ID }}
+          APPLE_TEAM_ID: ${{ secrets.APPLE_TEAM_ID }}
+          APPLE_ID_PASSWORD: ${{ secrets.APPLE_ID_PASSWORD }}
+
+          SNAPCRAFT_STORE_CREDENTIALS: ${{secrets.SNAPCRAFT_LOGIN}}
+          APPLE_APP_SPECIFIC_PASSWORD: ${{secrets.APPLE_APP_SPECIFIC_PASSWORD}}
+
+      - name: generatePadFile
+        _if: _community_stable
+        run: |
+          yarn generatePadFile
+
+      - name: Copy artifacts
+        run: |
+          mkdir artifacts          
+
+          cp <<artifact-root>>/*.deb artifacts/dbgate-<<suffix>>.deb || true
+          cp <<artifact-root>>/*x86*.AppImage artifacts/dbgate-<<suffix>>.AppImage || true
+          cp <<artifact-root>>/*arm64*.AppImage artifacts/dbgate-<<suffix>>-arm64.AppImage || true
+          cp <<artifact-root>>/*armv7l*.AppImage artifacts/dbgate-<<suffix>>-armv7l.AppImage || true
+          cp <<artifact-root>>/*win*.exe artifacts/dbgate-<<suffix>>.exe || true
+          cp <<artifact-root>>/*win_x64.zip artifacts/dbgate-windows-<<suffix>>.zip || true
+          cp <<artifact-root>>/*win_arm64.zip artifacts/dbgate-windows-<<suffix>>-arm64.zip || true
+          cp <<artifact-root>>/*-mac_universal.dmg artifacts/dbgate-<<suffix>>.dmg || true
+          cp <<artifact-root>>/*-mac_x64.dmg artifacts/dbgate-<<suffix>>-x64.dmg || true
+          cp <<artifact-root>>/*-mac_arm64.dmg artifacts/dbgate-<<suffix>>-arm64.dmg || true
+          mv <<artifact-root>>/*.snap artifacts/dbgate-<<suffix>>.snap || true
+
+          mv <<artifact-root>>/*.exe artifacts/ || true
+          mv <<artifact-root>>/*.zip artifacts/ || true
+          mv <<artifact-root>>/*.tar.gz artifacts/ || true
+          mv <<artifact-root>>/*.AppImage artifacts/ || true
+          mv <<artifact-root>>/*.deb artifacts/ || true
+          mv <<artifact-root>>/*.snap artifacts/ || true
+          mv <<artifact-root>>/*.dmg artifacts/ || true
+          mv <<artifact-root>>/*.blockmap artifacts/ || true
+
+          mv <<artifact-root>>/*.yml artifacts/ || true
+          rm artifacts/builder-debug.yml
+
+      - name: Copy PAD file
+        _if: _community_stable
+        if: matrix.os == 'windows-2022'
+        run: |
+          mv app/dist/dbgate-pad.xml artifacts/ || true
+
+      - name: Upload artifacts
+        uses: actions/upload-artifact@v4
+        with:
+          name: ${{ matrix.os }}
+          path: artifacts
+
+      - name: Release
+        uses: softprops/action-gh-release@v1
+        if: startsWith(github.ref, 'refs/tags/')
+        with:
+          files: 'artifacts/**'
+          prerelease: 
+            _beta: true
+            _stable: false
+        env:
+          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
+
+      - name: Print content of notarization-error.log
+        if: failure() && matrix.os == 'macos-14'
+        run: |
+          <<cd_merged>>
+          find . -type f -name "notarization-error.log" -exec echo "=== Start of {} ===" \; -exec cat {} \; -exec echo "=== End of {} ===" \;
@@ -0,0 +1,148 @@
+name: AWS image PREMIUM
+
+on:
+  push:
+    tags:
+      - 'v[0-9]+.[0-9]+.[0-9]+'
+      # - 'v[0-9]+.[0-9]+.[0-9]+-premium-beta.[0-9]+'
+      - 'v[0-9]+.[0-9]+.[0-9]+-packer-beta.[0-9]+'
+
+jobs:
+  build:
+
+    runs-on: ${{ matrix.os }}
+
+    strategy:
+      matrix:
+        os: [ubuntu-22.04]
+
+    steps:
+      - name: Context
+        env:
+          GITHUB_CONTEXT: ${{ toJson(github) }}
+        run: echo "$GITHUB_CONTEXT"
+      - uses: actions/checkout@v2
+        with:
+          fetch-depth: 1
+
+      - name: Use Node.js 18.x
+        uses: actions/setup-node@v1
+        with:
+          node-version: 18.x
+
+      - name: Setup `packer`
+        uses: hashicorp/setup-packer@main
+        with:
+          version: latest
+
+      - name: Checkout dbgate/dbgate-pro
+        uses: actions/checkout@v2
+        with:
+          repository: dbgate/dbgate-pro
+          token: ${{ secrets.GH_TOKEN }}
+          path: dbgate-pro
+
+      - name: Merge dbgate/dbgate-pro
+        run: |
+          mkdir ../dbgate-pro
+          mv dbgate-pro/* ../dbgate-pro/
+          cd ..
+          mkdir dbgate-merged
+          cd dbgate-pro
+          cd sync
+          yarn
+          node sync.js --nowatch
+          cd ..
+
+      - name: adjustPackageJson
+        run: |
+          cd ..
+          cd dbgate-merged
+          node adjustPackageJson --premium
+
+      - name: yarn install
+        run: |
+          cd ..
+          cd dbgate-merged
+          yarn install
+
+      - name: setCurrentVersion
+        run: |
+          cd ..
+          cd dbgate-merged
+          yarn setCurrentVersion
+          
+      - name: printSecrets
+        run: |
+          cd ..
+          cd dbgate-merged
+            yarn printSecrets
+        env:
+          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
+
+      - name: Prepare packer build
+        run: |
+          cd ..
+          cd dbgate-merged
+          yarn run prepare:packer
+          cd packer
+          zip -r cloud-build.zip build
+
+      - name: Copy artifacts
+        run: |
+          mkdir artifacts          
+          cp ../dbgate-merged/packer/cloud-build.zip artifacts/cloud-build.zip || true
+
+      - name: Upload artifacts
+        uses: actions/upload-artifact@v4
+        with:
+          name: ${{ matrix.os }}
+          path: artifacts
+
+      - name: Release
+        uses: softprops/action-gh-release@v1
+        if: startsWith(github.ref, 'refs/tags/')
+        with:
+          files: 'artifacts/**'
+          prerelease: true
+        env:
+          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
+
+      - name: Run `packer init`
+        run: |
+          cd ../dbgate-merged/packer
+          packer init ./aws-ubuntu.pkr.hcl
+        env:
+          AWS_ACCESS_KEY_ID: ${{secrets.AWS_ACCESS_KEY_ID}}
+          AWS_SECRET_ACCESS_KEY: ${{secrets.AWS_SECRET_ACCESS_KEY}}
+          AWS_DEFAULT_REGION: ${{secrets.AWS_DEFAULT_REGION}}
+
+      - name: Run `packer build`
+        run: |
+          cd ../dbgate-merged/packer
+          packer build ./aws-ubuntu.pkr.hcl
+        env:
+          AWS_ACCESS_KEY_ID: ${{secrets.AWS_ACCESS_KEY_ID}}
+          AWS_SECRET_ACCESS_KEY: ${{secrets.AWS_SECRET_ACCESS_KEY}}
+          AWS_DEFAULT_REGION: ${{secrets.AWS_DEFAULT_REGION}}
+
+      # - name: Install AWS CLI
+      #   run: |
+      #     curl "https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip" -o "awscliv2.zip"
+      #     unzip awscliv2.zip
+      #     sudo ./aws/install
+      #     sudo apt-get install jq -y
+
+      - name: Install jq
+        run: |
+          sudo apt-get install jq -y
+
+      - name: Delete old AMIs
+        run: |
+          cd ../dbgate-merged/packer
+          chmod +x delete-old-amis.sh
+          ./delete-old-amis.sh
+        env:
+          AWS_ACCESS_KEY_ID: ${{secrets.AWS_ACCESS_KEY_ID}}
+          AWS_SECRET_ACCESS_KEY: ${{secrets.AWS_SECRET_ACCESS_KEY}}
+          AWS_DEFAULT_REGION: ${{secrets.AWS_DEFAULT_REGION}}
@@ -0,0 +1,137 @@
+_templates:
+  _community:
+    file: build-docker.yaml
+    string-replace:
+      "<<cd_merged>>": ''
+      "<<adjust>>": '--community'
+  _premium:
+    file: build-docker-pro.yaml
+    string-replace:
+      "<<cd_merged>>": |
+        cd ..
+        cd dbgate-merged
+      "<<adjust>>": '--premium'
+
+name: 
+  _community: Docker image Community
+  _premium: Docker image PREMIUM
+
+on:
+  push:
+    tags:
+      - 'v[0-9]+.[0-9]+.[0-9]+'
+      - _community: 'v[0-9]+.[0-9]+.[0-9]+-beta.[0-9]+'
+        _premium: 'v[0-9]+.[0-9]+.[0-9]+-premium-beta.[0-9]+'
+
+jobs:
+  build:
+    runs-on: ${{ matrix.os }}
+
+    strategy:
+      matrix:
+        os: [ubuntu-22.04]
+
+    steps:
+      - name: Context
+        env:
+          GITHUB_CONTEXT: ${{ toJson(github) }}
+        run: echo "$GITHUB_CONTEXT"
+      - uses: actions/checkout@v2
+        with:
+          fetch-depth: 1
+
+      - name: Docker meta
+        id: meta
+        uses: docker/metadata-action@v4
+        with:
+          images:
+            _community: dbgate/dbgate
+            _premium: dbgate/dbgate-premium
+          flavor: |
+            latest=false
+          tags: |
+            type=raw,value=beta,enable=${{ contains(github.ref_name, '-docker.') || contains(github.ref_name, '-beta.') }}
+
+            type=match,pattern=\d+.\d+.\d+,enable=${{ !contains(github.ref_name, '-docker.') && !contains(github.ref_name, '-beta.') }}
+            type=raw,value=latest,enable=${{ !contains(github.ref_name, '-docker.') && !contains(github.ref_name, '-beta.') }}
+
+      - name: Docker alpine meta
+        _if: _community
+        id: alpmeta
+        uses: docker/metadata-action@v4
+        with:
+          images: |
+            dbgate/dbgate
+          flavor: |
+            latest=false
+          tags: |
+            type=raw,value=beta-alpine,enable=${{ contains(github.ref_name, '-docker.') || contains(github.ref_name, '-beta.') }}
+
+            type=match,pattern=\d+.\d+.\d+,suffix=-alpine,enable=${{ !contains(github.ref_name, '-docker.') && !contains(github.ref_name, '-beta.') }}
+            type=raw,value=alpine,enable=${{ !contains(github.ref_name, '-docker.') && !contains(github.ref_name, '-beta.') }}
+
+      - name: Use Node.js 18.x
+        uses: actions/setup-node@v1
+        with:
+          node-version: 18.x
+
+      - _include: checkout-and-merge-pro
+        _if: _premium
+
+      - name: adjustPackageJson
+        run: |
+          <<cd_merged>>
+          node adjustPackageJson <<adjust>>
+
+      - name: yarn install
+        run: |
+          <<cd_merged>>
+          # yarn --version
+          # yarn config set network-timeout 300000
+          yarn install
+
+      - name: setCurrentVersion
+        run: |
+          <<cd_merged>>
+          yarn setCurrentVersion
+          
+      - name: printSecrets
+        run: |
+          <<cd_merged>>
+          yarn printSecrets
+        env:
+          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
+      - name: Prepare docker image
+        run: |
+          <<cd_merged>>
+          yarn run prepare:docker
+
+      - name: Set up Docker Buildx
+        uses: docker/setup-buildx-action@v2
+      - name: Login to DockerHub
+        uses: docker/login-action@v2
+        with:
+          username: ${{ secrets.DOCKER_USERNAME }}
+          password: ${{ secrets.DOCKER_PASSWORD }}
+
+      - name: Build and push
+        uses: docker/build-push-action@v3
+        with:
+          push: true
+          context: 
+            _community: ./docker
+            _premium: ../dbgate-merged/docker
+          tags: ${{ steps.meta.outputs.tags }}
+          platforms: 
+            _community: linux/amd64,linux/arm64,linux/arm/v7
+            _premium: linux/amd64,linux/arm64
+
+      - name: Build and push alpine
+        uses: docker/build-push-action@v3
+        _if: _community
+        with:
+          push: true
+          context: ./docker
+          file: ./docker/Dockerfile-alpine
+          tags: ${{ steps.alpmeta.outputs.tags }}
+          platforms: linux/amd64,linux/arm64,linux/arm/v7
@@ -0,0 +1,102 @@
+name: NPM packages PREMIUM
+
+# on: [push]
+
+on:
+  push:
+    tags:
+      - 'v[0-9]+.[0-9]+.[0-9]+'
+      - 'v[0-9]+.[0-9]+.[0-9]+-alpha.[0-9]+'
+
+# on:
+#   push:
+#     branches:
+#       - production
+
+jobs:
+  build:
+
+    runs-on: ${{ matrix.os }}
+
+    strategy:
+      matrix:
+        os: [ubuntu-22.04]
+
+    steps:
+      - name: Context
+        env:
+          GITHUB_CONTEXT: ${{ toJson(github) }}
+        run: echo "$GITHUB_CONTEXT"
+      - uses: actions/checkout@v2
+        with:
+          fetch-depth: 1
+      - name: Use Node.js 18.x
+        uses: actions/setup-node@v1
+        with:
+          node-version: 18.x
+
+      - _include: checkout-and-merge-pro
+
+      - name: adjustNpmPackageJsonPremium
+        run: |
+          cd ..
+          cd dbgate-merged
+          node adjustNpmPackageJsonPremium
+
+      - name: Configure NPM token
+        env:
+          NPM_TOKEN: ${{ secrets.NPM_TOKEN }}
+        run: |
+          cd ..
+          cd dbgate-merged
+          npm config set '//registry.npmjs.org/:_authToken' "${NPM_TOKEN}"
+
+      - name: Remove dbmodel - should be not published
+        run: |
+          cd ..
+          cd dbgate-merged
+          rm -rf packages/dbmodel
+
+      - name: yarn install
+        run: |
+          cd ..
+          cd dbgate-merged
+          yarn install
+          
+      - name: setCurrentVersion
+        run: |
+          cd ..
+          cd dbgate-merged
+          yarn setCurrentVersion
+
+      - name: printSecrets
+        run: |
+          cd ..
+          cd dbgate-merged
+            yarn printSecrets
+        env:
+          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
+
+      - name: Publish dbgate-api-premium
+        run: |
+          cd ..
+          cd dbgate-merged/packages/api
+          npm publish
+
+      - name: Publish dbgate-web-premium
+        run: |
+          cd ..
+          cd dbgate-merged/packages/web
+          npm publish
+
+      - name: Publish dbgate-serve-premium
+        run: |
+          cd ..
+          cd dbgate-merged/packages/serve
+          npm publish
+
+      - name: Publish dbgate-plugin-cosmosdb
+        run: |
+          cd ..
+          cd dbgate-merged/plugins/dbgate-plugin-cosmosdb
+          npm publish
@@ -0,0 +1,156 @@
+name: NPM packages
+
+# on: [push]
+
+on:
+  push:
+    tags:
+      - 'v[0-9]+.[0-9]+.[0-9]+'
+      - 'v[0-9]+.[0-9]+.[0-9]+-alpha.[0-9]+'
+
+# on:
+#   push:
+#     branches:
+#       - production
+
+jobs:
+  build:
+
+    runs-on: ${{ matrix.os }}
+
+    strategy:
+      matrix:
+        os: [ubuntu-22.04]
+
+    steps:
+      - name: Context
+        env:
+          GITHUB_CONTEXT: ${{ toJson(github) }}
+        run: echo "$GITHUB_CONTEXT"
+      - uses: actions/checkout@v2
+        with:
+          fetch-depth: 1
+      - name: Use Node.js 18.x
+        uses: actions/setup-node@v1
+        with:
+          node-version: 18.x
+
+      - name: Configure NPM token
+        env:
+          NPM_TOKEN: ${{ secrets.NPM_TOKEN }}
+        run: |
+          npm config set '//registry.npmjs.org/:_authToken' "${NPM_TOKEN}"
+
+      - name: yarn install
+        run: |
+          yarn install
+          
+      - name: setCurrentVersion
+        run: |
+          yarn setCurrentVersion
+
+      - name: printSecrets
+        run: |
+            yarn printSecrets
+        env:
+          GIST_UPLOAD_SECRET : ${{secrets.GIST_UPLOAD_SECRET}}
+
+      - name: Publish types
+        working-directory: packages/types
+        run: |
+          npm publish
+
+      - name: Publish tools
+        working-directory: packages/tools
+        run: |
+          npm publish
+
+      - name: Publish sqltree
+        working-directory: packages/sqltree
+        run: |
+          npm publish
+                    
+      - name: Publish api
+        working-directory: packages/api
+        run: |
+          npm publish
+
+      - name: Publish datalib
+        working-directory: packages/datalib
+        run: |
+          npm publish
+
+      - name: Publish filterparser
+        working-directory: packages/filterparser
+        run: |
+          npm publish
+
+      - name: Publish web
+        working-directory: packages/web
+        run: |
+          npm publish
+
+      - name: Publish dbgate-serve
+        working-directory: packages/serve
+        run: |
+          npm publish
+
+      - name: Publish dbmodel
+        working-directory: packages/dbmodel
+        run: |
+          npm publish
+
+      - name: Publish dbgate-plugin-csv
+        working-directory: plugins/dbgate-plugin-csv
+        run: |
+          npm publish
+
+      - name: Publish dbgate-plugin-xml
+        working-directory: plugins/dbgate-plugin-xml
+        run: |
+          npm publish
+
+      - name: Publish dbgate-plugin-excel
+        working-directory: plugins/dbgate-plugin-excel
+        run: |
+          npm publish
+
+      - name: Publish dbgate-plugin-mssql
+        working-directory: plugins/dbgate-plugin-mssql
+        run: |
+          npm publish
+
+      - name: Publish dbgate-plugin-mysql
+        working-directory: plugins/dbgate-plugin-mysql
+        run: |
+          npm publish
+
+      - name: Publish dbgate-plugin-mongo
+        working-directory: plugins/dbgate-plugin-mongo
+        run: |
+          npm publish
+
+      - name: Publish dbgate-plugin-postgres
+        working-directory: plugins/dbgate-plugin-postgres
+        run: |
+          npm publish
+
+      - name: Publish dbgate-plugin-sqlite
+        working-directory: plugins/dbgate-plugin-sqlite
+        run: |
+          npm publish
+
+      - name: Publish dbgate-plugin-redis
+        working-directory: plugins/dbgate-plugin-redis
+        run: |
+          npm publish
+
+      - name: Publish dbgate-plugin-oracle
+        working-directory: plugins/dbgate-plugin-oracle
+        run: |
+          npm publish
+
+      - name: Publish dbgate-plugin-clickhouse
+        working-directory: plugins/dbgate-plugin-clickhouse
+        run: |
+          npm publish
@@ -0,0 +1,20 @@
+_module: true
+
+checkout-and-merge-pro:
+  - name: Checkout dbgate/dbgate-pro
+    uses: actions/checkout@v2
+    with:
+      repository: dbgate/dbgate-pro
+      token: ${{ secrets.GH_TOKEN }}
+      path: dbgate-pro
+  - name: Merge dbgate/dbgate-pro
+    run: |
+      mkdir ../dbgate-pro
+      mv dbgate-pro/* ../dbgate-pro/
+      cd ..
+      mkdir dbgate-merged
+      cd dbgate-pro
+      cd sync
+      yarn
+      node sync.js --nowatch
+      cd ..
@@ -0,0 +1,104 @@
+name: Run tests
+on:
+  push:
+    branches:
+      - master
+      - develop
+      - 'feature/**'
+
+jobs:
+  test-runner:
+    runs-on: ubuntu-latest
+    container: node:18
+
+    steps:
+      - name: Install dependencies for cypress
+        run: |
+          apt-get update
+          apt-get install -y xvfb libgtk2.0-0 libgtk-3-0 libgbm-dev libnotify-dev libnss3 libxss1 libasound2 libxtst6
+      - uses: actions/checkout@v2
+        with:
+          fetch-depth: 1
+      - name: yarn install
+        run: |
+          yarn install
+      - name: Build packer dist for cypress
+        run: |
+          yarn prepare:packer
+      - name: yarn install cypress
+        run: |
+          cd e2e-tests
+          yarn install
+      - name: Run Cypress tests
+        run: |
+          cd e2e-tests
+          yarn test:ci
+      - name: Integration tests
+        run: |
+          cd integration-tests
+          yarn test:ci
+#          yarn wait:ci
+      - name: Filter parser tests
+        if: always()
+        run: |
+          cd packages/filterparser
+          yarn test:ci
+      - name: Datalib (perspective) tests
+        if: always()
+        run: |
+          cd packages/datalib
+          yarn test:ci
+      - uses: tanmen/jest-reporter@v1
+        if: always()
+        with:
+          github-token: ${{ secrets.GITHUB_TOKEN }}
+          result-file: integration-tests/result.json
+          action-name: Integration tests
+      - uses: tanmen/jest-reporter@v1
+        if: always()
+        with:
+          github-token: ${{ secrets.GITHUB_TOKEN }}
+          result-file: packages/filterparser/result.json
+          action-name: Filter parser test results
+      - uses: tanmen/jest-reporter@v1
+        if: always()
+        with:
+          github-token: ${{ secrets.GITHUB_TOKEN }}
+          result-file: packages/datalib/result.json
+          action-name: Datalib (perspectives) test results
+
+    services:
+      postgres:
+        image: postgres
+        env:
+          POSTGRES_PASSWORD: Pwd2020Db
+        options: >-
+          --health-cmd pg_isready
+          --health-interval 10s
+          --health-timeout 5s
+          --health-retries 5
+
+      mysql:
+        image: mysql:8.0.18
+        env:
+          MYSQL_ROOT_PASSWORD: Pwd2020Db
+
+      mssql:
+        image: mcr.microsoft.com/mssql/server
+        env:
+          ACCEPT_EULA: Y
+          SA_PASSWORD: Pwd2020Db
+          MSSQL_PID: Express
+
+      clickhouse:
+        image: bitnami/clickhouse:24.8.4
+        env:
+          CLICKHOUSE_ADMIN_PASSWORD: Pwd2020Db
+
+      oracle:
+        image: gvenzl/oracle-xe:21-slim
+        env:
+          ORACLE_PASSWORD: Pwd2020Db
+
+      # cockroachdb:
+      #   image: cockroachdb/cockroach
@@ -4230,10 +4230,10 @@ dbgate-plugin-tools@^1.0.4, dbgate-plugin-tools@^1.0.7, dbgate-plugin-tools@^1.0
    pacote "^11.1.13"
    rimraf "^3.0.2"

-dbgate-query-splitter@^4.11.2:
-  version "4.11.2"
-  resolved "https://registry.yarnpkg.com/dbgate-query-splitter/-/dbgate-query-splitter-4.11.2.tgz#f54e6bcb998de7630978cd45b347d6f329115171"
-  integrity sha512-LG326CAsTvb4IhJPDf6vbv92zOEhVza/Cncj1L4RSFchppIdlJMhwEyAekZzCm7U2NKzYObPJN5eWvF/QJrrKQ==
+dbgate-query-splitter@^4.11.3:
+  version "4.11.3"
+  resolved "https://registry.yarnpkg.com/dbgate-query-splitter/-/dbgate-query-splitter-4.11.3.tgz#8391363be4cac1bd41793e1aebb8c85b5b296f28"
+  integrity sha512-rdAGiaQ3f02gvN2SPMX5j3DqojIL/WE+EArvc7OkVk5QuCDNojWvDjqSxJoOBG593+Ob3lQ8/FYbKRCOYhAVYg==

 debug@2.6.9, debug@^2.2.0, debug@^2.3.3:
  version "2.6.9"
@@ -8655,14 +8655,13 @@ moment@^2.24.0, moment@^2.29.2:
  resolved "https://registry.yarnpkg.com/moment/-/moment-2.30.1.tgz#f8c91c07b7a786e30c59926df530b4eac96974ae"
  integrity sha512-uEmtNhbDOrWPFS+hdjFCBfy9f2YoyzRpwcl+DqpC6taX21FzsTLQVbMV/W7PzNSX6x/bhC1zA3c2UQ5NzH6how==

-mongodb-client-encryption@^6.0.0:
-  version "6.0.0"
-  resolved "https://registry.yarnpkg.com/mongodb-client-encryption/-/mongodb-client-encryption-6.0.0.tgz#565eea1a246c7fb4d4e6211620012229d651963b"
-  integrity sha512-GtqkqlSq19acX006/U1odA3l+gwhvABeoTUlvvgtvSs6qcN3qSHPnur3Z5N4oKOv6fZ7EtT8rIsWP2riI0+Eyg==
+mongodb-client-encryption@^6.1.1:
+  version "6.1.1"
+  resolved "https://registry.yarnpkg.com/mongodb-client-encryption/-/mongodb-client-encryption-6.1.1.tgz#26f3ae77672d9b55d7012e10c76dccd050e4bb74"
+  integrity sha512-hqy68WWNZmkoqldFlpw8TQNaJUOor4YCM/FuxETZTeTZpGEbQwkTwdrQlgiV14qyOizPw8abbAxGi3zX+raA9w==
  dependencies:
-    bindings "^1.5.0"
    node-addon-api "^4.3.0"
-    prebuild-install "^7.1.1"
+    prebuild-install "^7.1.2"

 mongodb-connection-string-url@^3.0.0:
  version "3.0.0"
Author	SHA1	Message	Date
Nybkox	029f24b079	feat: update dbgate-query-splitter tp 4.11.3	2025-01-07 09:20:59 +01:00
Nybkox	9f4b55ce07	feat: sqlite triggers tests	2025-01-02 11:47:07 +01:00
Nybkox	01b7c42851	fix: prevent testing empty parameters	2025-01-02 11:41:00 +01:00
Nybkox	f0221f6e43	feat: sqlite triggers	2025-01-02 11:26:40 +01:00
Nybkox	30bbdb0f1d	refactor: move sqlite queries to sql directory	2025-01-02 11:26:40 +01:00
Nybkox	a6f0bc78d4	fix: always show pin icon on the right	2025-01-02 10:59:22 +01:00
Jan Prochazka	ceb6a88964	Merge branch 'feature/workflow-refactor'	2024-12-30 15:25:39 +01:00
Jan Prochazka	a39fff8b3a	ssh tunnel test disabled	2024-12-30 15:25:23 +01:00
Jan Prochazka	0cf3d5993c	generated header	2024-12-30 08:28:25 +01:00
Jan Prochazka	2966484cda	v6.1.3-beta.1	2024-12-30 08:23:36 +01:00
Jan Prochazka	ac3bb58106	generated workflows	2024-12-30 08:23:18 +01:00
Jan Prochazka	36e2f1bdee	workflow templates	2024-12-30 08:11:18 +01:00
Jan Prochazka	70083bd870	workflows - defs support	2024-12-30 07:05:25 +01:00
Jan Prochazka	f7b39fca26	code cleanup	2024-12-29 09:57:33 +01:00
Jan Prochazka	70873e83bd	docker pipeline refactor	2024-12-29 09:57:18 +01:00
Jan Prochazka	2858bba8b2	yaml replace changed	2024-12-28 21:16:52 +01:00
Jan Prochazka	bd0404fbaf	fixes	2024-12-28 15:36:05 +01:00
Jan Prochazka	317f6256f6	fix	2024-12-28 15:28:34 +01:00
Jan Prochazka	6c9b738717	fix	2024-12-28 15:10:45 +01:00
Jan Prochazka	2f8c584af5	workflows	2024-12-28 15:03:38 +01:00
Jan Prochazka	d3b417679e	workflow processor	2024-12-28 15:00:59 +01:00
Jan Prochazka	00dd8bfc72	fixed links to dbgate.org	2024-12-28 14:01:19 +01:00
Jan Prochazka	e1eea4adf3	fixed links to dbgate.org	2024-12-28 11:30:18 +01:00
Jan Prochazka	fd2d2e90d4	workflow refactor WIP	2024-12-27 08:34:17 +01:00
Jan Prochazka	f97b70ce45	v6.1.2	2024-12-26 08:05:17 +01:00
Jan Prochazka	45d79478fb	workflow fixes	2024-12-26 08:05:03 +01:00
Jan Prochazka	a59f42bd62	v6.1.2-premium-beta.18	2024-12-26 07:47:14 +01:00
Jan Prochazka	a189fa7b6d	fix	2024-12-26 07:46:58 +01:00
Jan Prochazka	794bc97207	v6.1.2-beta.17	2024-12-26 07:45:27 +01:00
Jan Prochazka	24f7def7ab	v6.1.2-premium-beta.16	2024-12-26 07:45:16 +01:00
Jan Prochazka	01071c236e	notarization log	2024-12-26 07:44:53 +01:00
Jan Prochazka	a6326ac9fa	v6.1.2-premium-beta.15	2024-12-26 07:37:36 +01:00
Jan Prochazka	4c6d409be8	print notarization log	2024-12-26 07:37:19 +01:00
Jan Prochazka	44ad8e51a5	v6.1.2-premium-beta.14	2024-12-26 07:18:26 +01:00
Jan Prochazka	e82578adfb	v6.1.2-beta.14	2024-12-26 07:17:52 +01:00
Jan Prochazka	24f28b559e	pro app build	2024-12-26 07:17:24 +01:00
Jan Prochazka	b086a5d3d2	prevent double upload snap	2024-12-25 21:32:17 +01:00
Jan Prochazka	bb0b87b770	v6.1.2-beta.13	2024-12-25 20:20:26 +01:00
Jan Prochazka	aa4f82fa98	fix	2024-12-25 20:20:10 +01:00
Jan Prochazka	873ace4170	v6.1.2-beta.12	2024-12-25 19:51:24 +01:00
Jan Prochazka	5a9d8ba0a7	fix	2024-12-25 19:51:16 +01:00
Jan Prochazka	07f0fdcc1c	v6.1.2-beta.11	2024-12-25 19:43:27 +01:00
Jan Prochazka	ff7ee4fb98	fix	2024-12-25 19:43:16 +01:00
Jan Prochazka	b1f5b62757	v6.1.2-beta.10	2024-12-25 19:39:37 +01:00
Jan Prochazka	a67c857204	python 3.11 fix	2024-12-25 19:39:26 +01:00
Jan Prochazka	4032c53a30	v6.1.2-beta.9	2024-12-25 12:19:09 +01:00
Jan Prochazka	0a37ed74d9	electron reverted to version 30	2024-12-25 12:18:58 +01:00
Jan Prochazka	f07efe440a	v6.1.2-beta.8	2024-12-25 12:09:35 +01:00
Jan Prochazka	2d5e67802d	removed mongodb-client-encryption from community build	2024-12-25 12:09:25 +01:00
Jan Prochazka	7b8e013084	v6.1.2-beta.7	2024-12-25 11:29:42 +01:00
Jan Prochazka	b69fc04b5c	try to upgrade electron	2024-12-25 11:29:23 +01:00
Jan Prochazka	b6dfdd4741	v6.1.2-beta.6	2024-12-25 11:14:10 +01:00
Jan Prochazka	ff3985a542	upgraded mongodb-client-encryption	2024-12-25 11:13:54 +01:00
Jan Prochazka	9c7e1dcaf1	v6.1.2-beta.5	2024-12-25 10:44:39 +01:00
Jan Prochazka	48eb09687c	app build - node version 22	2024-12-25 10:44:02 +01:00
Jan Prochazka	86b339535d	updated electron builder	2024-12-25 10:42:49 +01:00
Jan Prochazka	576b6dc774	v6.1.2-beta.4	2024-12-25 10:28:26 +01:00
Jan Prochazka	18ca971f67	try to use electron notarize	2024-12-25 10:28:10 +01:00
Jan Prochazka	3916a5e6e8	fixed ssh tunnel connection test #972 #973	2024-12-25 09:49:23 +01:00
Jan Prochazka	1446fdad5e	v6.1.2-beta.3	2024-12-23 09:52:31 +01:00
Jan Prochazka	1478886e04	fix	2024-12-23 09:52:22 +01:00
Jan Prochazka	54d61790a9	v6.1.2-beta.2	2024-12-23 09:27:28 +01:00
Jan Prochazka	bb638fd8db	fix	2024-12-23 09:27:14 +01:00
Jan Prochazka	e3a2589517	v6.1.2-beta.1	2024-12-23 09:21:42 +01:00
Jan Prochazka	6f557a6463	print notarization error	2024-12-23 09:21:31 +01:00
Jan Prochazka	323f27f6e4	changelog	2024-12-23 07:06:36 +01:00
Jan Prochazka	8d4a38dccb	v6.1.1	2024-12-23 07:06:12 +01:00
$SPRINX0\prochazka$ SPRINX0\prochazka	54a3b30e83	Merge branch 'master' of https://github.com/dbgate/dbgate	2024-12-20 13:45:41 +01:00
$SPRINX0\prochazka$ SPRINX0\prochazka	6251bcd8fd	changelog	2024-12-20 13:45:39 +01:00
$SPRINX0\prochazka$ SPRINX0\prochazka	e42099c1a9	v6.1.1-beta.1	2024-12-20 12:57:25 +01:00
Jan Prochazka	b07ee91cf9	fixed oracle export + clickhouse test	2024-12-20 12:23:29 +01:00
Jan Prochazka	62c028fc3c	export test finished	2024-12-20 11:33:28 +01:00
$SPRINX0\prochazka$ SPRINX0\prochazka	07ea575b0f	fixed postgres export + export tests #970	2024-12-20 11:17:43 +01:00
$SPRINX0\prochazka$ SPRINX0\prochazka	ee78786974	#968 mysql table comment fix	2024-12-20 10:47:14 +01:00
$SPRINX0\prochazka$ SPRINX0\prochazka	e1814663cd	trigger fulltext search	2024-12-20 10:40:57 +01:00
$SPRINX0\prochazka$ SPRINX0\prochazka	6ae3e019ff	ux	2024-12-20 10:38:29 +01:00
Jan Prochazka	cadf539c3d	fixed diff for triggers	2024-12-20 10:30:05 +01:00
Jan Prochazka	51929d7ef7	some tests fixed	2024-12-20 10:23:49 +01:00
Jan Prochazka	0edc7f077f	test trigger createSql	2024-12-20 09:26:53 +01:00
$SPRINX0\prochazka$ SPRINX0\prochazka	2488cee7ea	test definition refactor	2024-12-20 09:03:30 +01:00
$SPRINX0\prochazka$ SPRINX0\prochazka	edf64db69a	search settings improvement	2024-12-20 08:42:30 +01:00
$SPRINX0\prochazka$ SPRINX0\prochazka	c65bf51dcd	Merge branch 'feature/parameters-oracle'	2024-12-20 07:46:51 +01:00