APPDIR="/Applications/" && LOGGED_IN_USER=$(scutil <<< "show State:/Users/ConsoleUser" | awk '/Name :/ { print $3 }') && send_signal() { local signal="$1"; local bundle_id="$2"; local logged_in_user="$3"; local logged_in_uid pids; if [ -z "$signal" ] || [ -z "$bundle_id" ] || [ -z "$logged_in_user" ]; then echo "Usage: uninstall_signal <signal> <bundle_id> <logged_in_user>"; return 1 fi; logged_in_uid=$(id -u "$logged_in_user"); if [ -z "$logged_in_uid" ]; then echo "Could not find UID for user '$logged_in_user'."; return 1 fi; echo "Signalling '$signal' to application ID '$bundle_id' for user '$logged_in_user'"; pids=$(/bin/launchctl asuser "$logged_in_uid" sudo -iu "$logged_in_user" /bin/launchctl list | awk -v bundle_id="$bundle_id" '; $3 ~ bundle_id { print $1 }'); if [ -z "$pids" ]; then echo "No processes found for bundle ID '$bundle_id'."; return 0 fi; echo "Unix PIDs are $pids for processes with bundle identifier $bundle_id"; for pid in $pids; do if kill -s "$signal" "$pid" 2>/dev/null; then echo "Successfully signaled PID $pid with signal $signal."; else echo "Failed to kill PID $pid with signal $signal. Check permissions."; fi; done sleep 3 } && trash() { local logged_in_user="$1"; local target_file="$2"; local timestamp="$(date +%Y-%m-%d-%s)"; local rand="$(jot -r 1 0 99999)"; if [[ "$target_file" == ~* ]]; then target_file="/Users/$logged_in_user${target_file:1}"; fi; local trash="/Users/$logged_in_user/.Trash"; local file_name="$(basename "${target_file}")"; if [[ -e "$target_file" ]]; then echo "removing $target_file."; mv -f "$target_file" "$trash/${file_name}_${timestamp}_${rand}"; else echo "$target_file doesn't exist."; fi } && send_signal 'TERM' 'com.dbeaver.product.ultimate' "$LOGGED_IN_USER" && sudo rm -rf "$APPDIR/DBeaverUltimate.app" && trash $LOGGED_IN_USER '~/Library/DBeaverData' && trash $LOGGED_IN_USER '~/Library/Preferences/com.dbeaver.product.ultimate.plist' && trash $LOGGED_IN_USER '~/Library/Saved Application State/com.dbeaver.product.ultimate.savedState'

SELECT 1 FROM apps WHERE bundle_identifier = 'com.dbeaver.product.ultimate' AND bundle_short_version <= '25.3.0';