pgAdmin 4 commit: 1) Port query tool to React. Fixes #6131

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: pgadmin-hackers(at)lists(dot)postgresql(dot)org
Subject: pgAdmin 4 commit: 1) Port query tool to React. Fixes #6131
Date: 2022-04-07 12:07:55
Message-ID: E1ncQvb-0007fF-D7@gothos.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

1) Port query tool to React. Fixes #6131
2) Added status bar to the Query Tool. Fixes #3253
3) Ensure that row numbers should be visible in view when scrolling horizontally. Fixes #3989
4) Allow removing a single query history. Refs #4113
5) Partially fixed Macros usability issues. Ref #6969
6) Fixed an issue where the Query tool opens on minimum size if the user opens multiple query tool Window quickly. Fixes #6725
7) Relocate GIS Viewer Button to the Left Side of the Results Table. Fixes #6830
8) Fixed an issue where the connection bar is not visible. Fixes #7188
9) Fixed an issue where an Empty message popup after running a query. Fixes #7260
10) Ensure that Autocomplete should work after changing the connection. Fixes #7262
11) Fixed an issue where the copy and paste row does not work if the first column contains no data. Fixes #7294

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=b5b9ee46a1f7aa9cc228e6c4c676da20c80a8260
Author: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>

Modified Files
--------------
docs/en_US/release_notes_6_9.rst | 10 +
web/package.json | 3 +-
web/pgadmin/browser/__init__.py | 4 +-
.../browser/register_browser_preferences.py | 4 +-
.../browser/server_groups/servers/__init__.py | 79 +-
.../browser/static/js/ConnectServerContent.jsx | 103 +
web/pgadmin/browser/static/js/collection.js | 4 +-
web/pgadmin/browser/static/js/keyboard.js | 4 +-
web/pgadmin/browser/static/js/node.js | 4 +-
web/pgadmin/browser/static/js/preferences.js | 12 +-
web/pgadmin/browser/static/js/toolbar.js | 6 +-
web/pgadmin/browser/templates/browser/js/utils.js | 1 +
.../misc/static/explain/js/svg_downloader.js | 2 +-
.../static/js/components/PreferencesComponent.jsx | 6 +-
web/pgadmin/settings/__init__.py | 23 +-
web/pgadmin/static/bundle/app.js | 2 +-
web/pgadmin/static/js/Explain/Analysis.jsx | 215 +
.../static/js/Explain/ExplainStatistics.jsx | 143 +
web/pgadmin/static/js/Explain/Graphical.jsx | 435 ++
web/pgadmin/static/js/Explain/ImageMapper.js | 300 ++
web/pgadmin/static/js/Explain/css/explain.css | 23 +
web/pgadmin/static/js/Explain/img/ex_aggregate.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_append.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_bmp_and.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_bmp_heap.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_bmp_index.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_bmp_or.svg | 1 +
.../static/js/Explain/img/ex_broadcast_motion.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_cte_scan.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_delete.svg | 1 +
.../static/js/Explain/img/ex_foreign_scan.svg | 1 +
.../static/js/Explain/img/ex_gather_merge.svg | 1 +
.../static/js/Explain/img/ex_gather_motion.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_group.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_hash.svg | 1 +
.../static/js/Explain/img/ex_hash_anti_join.svg | 1 +
.../static/js/Explain/img/ex_hash_semi_join.svg | 1 +
.../static/js/Explain/img/ex_hash_setop_except.svg | 1 +
.../js/Explain/img/ex_hash_setop_except_all.svg | 1 +
.../js/Explain/img/ex_hash_setop_intersect.svg | 1 +
.../js/Explain/img/ex_hash_setop_intersect_all.svg | 1 +
.../js/Explain/img/ex_hash_setop_unknown.svg | 1 +
.../static/js/Explain/img/ex_index_only_scan.svg | 1 +
.../static/js/Explain/img/ex_index_scan.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_insert.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_join.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_limit.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_lock_rows.svg | 1 +
.../static/js/Explain/img/ex_materialize.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_merge.svg | 1 +
.../static/js/Explain/img/ex_merge_anti_join.svg | 1 +
.../static/js/Explain/img/ex_merge_append.svg | 1 +
.../static/js/Explain/img/ex_merge_semi_join.svg | 1 +
.../js/Explain/img/ex_named_tuplestore_scan.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_nested.svg | 1 +
.../js/Explain/img/ex_nested_loop_anti_join.svg | 1 +
.../js/Explain/img/ex_nested_loop_semi_join.svg | 1 +
.../static/js/Explain/img/ex_projectset.svg | 1 +
.../static/js/Explain/img/ex_recursive_union.svg | 1 +
.../js/Explain/img/ex_redistribute_motion.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_result.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_scan.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_seek.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_setop.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_sort.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_subplan.svg | 1 +
.../static/js/Explain/img/ex_table_func_scan.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_tid_scan.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_unique.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_unknown.svg | 1 +
web/pgadmin/static/js/Explain/img/ex_update.svg | 1 +
.../static/js/Explain/img/ex_values_scan.svg | 1 +
.../static/js/Explain/img/ex_window_aggregate.svg | 1 +
.../static/js/Explain/img/ex_worktable_scan.svg | 1 +
web/pgadmin/static/js/Explain/index.jsx | 487 ++
web/pgadmin/static/js/Explain/svg_download.js | 54 +
web/pgadmin/static/js/SchemaView/FormView.jsx | 4 +-
web/pgadmin/static/js/SchemaView/index.jsx | 5 +-
web/pgadmin/static/js/Theme/dark.js | 10 +-
web/pgadmin/static/js/Theme/high_contrast.js | 10 +-
web/pgadmin/static/js/Theme/index.jsx | 23 +-
web/pgadmin/static/js/Theme/standard.js | 4 +-
web/pgadmin/static/js/api_instance.js | 2 +-
web/pgadmin/static/js/clipboard.js | 13 +
web/pgadmin/static/js/components/Buttons.jsx | 31 +-
web/pgadmin/static/js/components/CodeMirror.jsx | 203 +-
web/pgadmin/static/js/components/ExternalIcon.jsx | 13 +-
.../static/js/components/FormComponents.jsx | 9 +-
web/pgadmin/static/js/components/JsonEditor.jsx | 9 +-
web/pgadmin/static/js/components/Menu.jsx | 3 +
web/pgadmin/static/js/components/ShortcutTitle.jsx | 48 +-
web/pgadmin/static/js/custom_hooks.js | 78 +-
web/pgadmin/static/js/custom_prop_types.js | 6 +-
web/pgadmin/static/js/helpers/EventBus.js | 10 +-
web/pgadmin/static/js/helpers/Layout.jsx | 179 +-
web/pgadmin/static/js/helpers/ModalProvider.jsx | 13 +-
.../js/sqleditor/calculate_query_run_time.js | 35 -
.../static/js/sqleditor/call_render_after_poll.js | 57 -
web/pgadmin/static/js/sqleditor/execute_query.js | 370 --
web/pgadmin/static/js/sqleditor/filter_dialog.js | 278 --
.../static/js/sqleditor/filter_dialog_model.js | 137 -
web/pgadmin/static/js/sqleditor/geometry_viewer.js | 434 --
.../js/sqleditor/history/history_collection.js | 40 -
.../static/js/sqleditor/history/query_history.js | 96 -
.../js/sqleditor/history/query_history_details.js | 216 -
.../js/sqleditor/history/query_history_entries.js | 296 --
.../static/js/sqleditor/history/query_sources.js | 35 -
web/pgadmin/static/js/sqleditor/macro.js | 341 --
web/pgadmin/static/js/sqleditor/macro_model.js | 225 -
.../static/js/sqleditor/new_connection_dialog.js | 289 --
.../js/sqleditor/new_connection_dialog_model.js | 477 --
.../static/js/sqleditor/query_tool_actions.js | 172 -
.../js/sqleditor/query_tool_http_error_handler.js | 78 -
.../js/sqleditor/query_tool_notifications.js | 133 -
.../static/js/sqleditor/query_tool_preferences.js | 241 -
.../js/sqleditor/query_txn_status_constants.js | 11 -
web/pgadmin/static/js/sqleditor_utils.js | 260 +-
web/pgadmin/static/js/utils.js | 8 +-
web/pgadmin/static/scss/_codemirror.overrides.scss | 5 +
web/pgadmin/static/scss/_pgadmin.style.scss | 4 +
.../static/scss/resources/_default.variables.scss | 2 +-
web/pgadmin/tools/datagrid/__init__.py | 617 ---
web/pgadmin/tools/datagrid/static/js/datagrid.js | 370 --
.../tools/datagrid/templates/datagrid/index.html | 507 --
web/pgadmin/tools/datagrid/tests/__init__.py | 0
.../tools/datagrid/tests/datagrid_test_data.json | 134 -
.../tests/test_data_grid_init_query_tool.py | 73 -
.../tools/datagrid/tests/test_data_grid_panel.py | 90 -
.../tests/test_data_grid_query_tool_close.py | 78 -
.../tests/test_data_grid_update_connection.py | 121 -
.../tests/test_data_grid_validate_filter.py | 92 -
.../datagrid/tests/test_initialize_data_grid.py | 109 -
web/pgadmin/tools/datagrid/tests/utils.py | 33 -
web/pgadmin/tools/debugger/static/js/debugger.js | 4 +-
.../tools/debugger/static/js/debugger_utils.js | 4 +-
web/pgadmin/tools/erd/static/js/erd_module.js | 2 +-
.../js/erd_tool/ui_components/BodyWidget.jsx | 4 +-
web/pgadmin/tools/psql/static/js/psql_module.js | 2 +-
.../tools/schema_diff/static/js/schema_diff_ui.js | 11 +-
.../static/js/search_objects_dialog.js | 2 +-
web/pgadmin/tools/sqleditor/__init__.py | 539 +-
.../tools/sqleditor/static/css/sqleditor.css | 401 --
web/pgadmin/tools/sqleditor/static/img/loading.gif | Bin 1728 -> 0 bytes
.../tools/sqleditor/static/js/SQLEditorModule.js | 424 ++
.../static/js/components/QueryToolComponent.jsx | 646 +++
.../static/js/components/QueryToolConstants.js | 97 +
.../js/components/QueryToolDataGrid/CopyData.js | 99 +
.../js/components/QueryToolDataGrid/Editors.jsx | 345 ++
.../js/components/QueryToolDataGrid/Formatters.jsx | 73 +
.../js/components/QueryToolDataGrid/index.jsx | 398 ++
.../js/components/dialogs/ConfirmSaveContent.jsx | 39 +
.../dialogs/ConfirmTransactionContent.jsx | 38 +
.../static/js/components/dialogs/FilterDialog.jsx | 155 +
.../static/js/components/dialogs/MacrosDialog.jsx | 189 +
.../js/components/dialogs/NewConnectionDialog.jsx | 254 +
.../js/components/sections/ConnectionBar.jsx | 148 +
.../js/components/sections/GeometryViewer.jsx | 386 ++
.../static/js/components/sections/MainToolBar.jsx | 607 +++
.../static/js/components/sections/Messages.jsx | 46 +
.../js/components/sections/Notifications.jsx | 58 +
.../static/js/components/sections/Query.jsx | 401 ++
.../static/js/components/sections/QueryHistory.jsx | 500 ++
.../static/js/components/sections/ResultSet.jsx | 1225 +++++
.../js/components/sections/ResultSetToolbar.jsx | 170 +
.../static/js/components/sections/StatusBar.jsx | 117 +
web/pgadmin/tools/sqleditor/static/js/index.js | 26 +
.../static/js/show_query_tool.js | 63 +-
.../static/js/show_view_data.js} | 53 +-
web/pgadmin/tools/sqleditor/static/js/sqleditor.js | 5189 --------------------
.../static/js/sqleditor_title.js} | 63 +-
.../tools/sqleditor/static/scss/_history.scss | 254 -
.../tools/sqleditor/static/scss/_sqleditor.scss | 431 --
.../templates/sqleditor}/filter.html | 0
.../tools/sqleditor/templates/sqleditor/index.html | 70 +
.../tests/test_download_csv_query_tool.py | 12 +-
.../tools/sqleditor/tests/test_editor_history.py | 4 +-
.../tools/sqleditor/tests/test_encoding_charset.py | 4 +-
.../tools/sqleditor/tests/test_explain_plan.py | 4 +-
web/pgadmin/tools/sqleditor/tests/test_macros.py | 4 +-
.../tools/sqleditor/tests/test_poll_query_tool.py | 4 +-
.../sqleditor/tests/test_transaction_status.py | 4 +-
.../tools/sqleditor/tests/test_view_data.py | 2 +-
web/pgadmin/tools/sqleditor/utils/macros.py | 9 +-
web/pgadmin/tools/sqleditor/utils/query_history.py | 35 +-
.../sqleditor/utils/query_tool_preferences.py | 49 +-
.../tools/sqleditor/utils/start_running_query.py | 2 -
.../tests/test_is_query_resultset_updatable.py | 4 +-
.../utils/tests/test_save_changed_data.py | 4 +-
.../utils/tests/test_start_running_query.py | 8 +-
web/pgadmin/utils/constants.py | 1 +
web/pgadmin/utils/csrf.py | 3 +-
.../javascript/components/CodeMirror.spec.js | 28 +
.../javascript/components/ShortcutTitle.spec.js | 2 +-
.../javascript/datagrid/get_panel_title_spec.js | 94 -
.../javascript/datagrid/show_data_spec.js | 167 -
.../javascript/datagrid/show_query_tool_spec.js | 132 -
.../erd/ui_components/body_widget_spec.js | 5 +-
web/regression/javascript/fake_endpoints.js | 8 +-
.../geometry_viewer/geometry_viewer_spec.js | 232 -
.../javascript/history/history_collection_spec.js | 82 -
.../javascript/history/query_history_spec.js | 405 --
.../sqleditor/calculate_query_run_time_spec.js | 105 -
.../sqleditor/call_render_after_poll_spec.js | 202 -
.../javascript/sqleditor/execute_query_spec.js | 1044 ----
.../javascript/sqleditor/filter_dialog_specs.js | 28 -
.../sqleditor/keyboard_shortcuts_spec.js | 733 ---
.../sqleditor/query_tool_actions_spec.js | 608 ---
.../query_tool_http_error_handler_spec.js | 191 -
web/regression/javascript/sqleditor_utils_spec.js | 19 -
web/webpack.config.js | 5 +-
web/webpack.shim.js | 4 +-
web/webpack.test.config.js | 5 +
web/yarn.lock | 3089 ++++++------
213 files changed, 11146 insertions(+), 18842 deletions(-)

Browse pgadmin-hackers by date

  From Date Subject
Next Message Akshay Joshi 2022-04-08 05:29:04 pgAdmin 4 commit: Fixed audit issues
Previous Message Aditya Toshniwal 2022-04-07 10:07:03 Re: [pgAdmin][RM6131] Port query tool to React