Date: Thu, 01 Feb 2024 22:58:38 -0800
From: Pravesh Sharma <noreply@github.com>
To: pgadmin-hackers@lists.postgresql.org
Message-ID: 
 <pgadmin-org/pgadmin4/push/refs/heads/master/459121-f7045b@github.com>
Subject: [pgadmin-org/pgadmin4] f7045b: Fixed an issue where format sql was
 messing up ope...
Mime-Version: 1.0
Content-Type: text/plain;
 charset=UTF-8
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/pgadmin-org/pgadmin4/push/refs/heads/master/459121-f7045b%40github.com>
Precedence: bulk

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: f7045b58d4d1b98b6a2f035267d2dd01c7235aa6
      https://github.com/pgadmin-org/pgadmin4/commit/f7045b58d4d1b98b6a2f035267d2dd01c7235aa6
  Author: Pravesh Sharma <pravesh.sharma@enterprisedb.com>
  Date:   2024-02-02 (Fri, 02 Feb 2024)

  Changed paths:
    M docs/en_US/images/preferences_sql_formatting.png
    M docs/en_US/preferences.rst
    M web/package.json
    M web/pgadmin/misc/__init__.py
    R web/pgadmin/misc/sql/__init__.py
    M web/pgadmin/tools/sqleditor/static/js/components/sections/Query.jsx
    M web/pgadmin/tools/sqleditor/utils/query_tool_preferences.py
    M web/yarn.lock

  Log Message:
  -----------
  Fixed an issue where format sql was messing up operator. #5083

- The formatting is done on client side now using sql-formattor JS lib. Backend API based formatting is removed.
- Added new options data type case, expression width, function case, lines between queries, logical operator new line and new line before semicolon available in the new lib.
- Removed old options comma-first notations, re-indent aligned, re-indent, strip comments and wrap after N characters as not available in the new library.
- Capitalise casing is replaced with Preserve casing as it is not supported by the new library.
- Also fixes #6785, #6990, #7115.