Thread: [pgadmin-org/pgadmin4] f7045b: Fixed an issue where format sql was messing up ope...

[pgadmin-org/pgadmin4] f7045b: Fixed an issue where format sql was messing up ope...

From
Pravesh Sharma
Date:
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
andnew 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
asnot 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.