8dd8d1d03a
Fixed an issue where ERD Tool can't load the saved pgerd file from Shared Storage. #6558
2023-07-13 11:06:46 +05:30
9aa116bf3f
1) Added new/missing parameters to pg_dumpall (Backup Server). #6416
...
2) Added new/missing parameters to pg_dump (Backup Objects). #6417
2023-07-10 10:34:30 +05:30
326dc2bbcc
Fix an issue where queries longer than 1 minute get stuck - Container 7.1. #6317 ( #6491 )
...
Fix an issue where queries longer than 1 minute get stuck - Container 7.1. #6317
Fix an issue where queries get stuck with auto-completion enabled. #6356
Fix an issue where queries can't complete execution. #6163
2023-07-04 10:44:46 +05:30
d6cddd8c29
Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS. #6295
2023-06-30 16:08:33 +05:30
732bcc2b4d
Fixed an issue where the query tool is unable to execute a query on Postgres 10 and below versions. #6515
2023-06-30 12:40:48 +05:30
8dc79e73bd
Fix an XSS issue in PSQL tool title
2023-06-26 13:36:25 +05:30
4746fbd346
Fixed an issue where View/Edit data is throwing an error if the user deleted and re-create the same table for which View/Edit data was opened. #6431
2023-06-19 19:37:10 +05:30
c5cbb33a06
Fix raise notice from func/proc or code blocks are no longer displayed live. #6420
2023-06-19 17:04:22 +05:30
a9ae7ca099
Ensure that query tool status poller is paused if the query tool is not visible/active
2023-06-19 16:28:48 +05:30
64446790d2
Add a precautionary fix to handle connection timeout issue when fetching more rows in query tool grid. #6291
2023-06-14 16:53:47 +05:30
251bf05692
Fixed the following SonarQube code smells:
...
1) Do not use Array index in keys.
2) Unnecessary escape character.
3) Rename this local variable to match the regular expression ^[_a-z][a-z0-9_]*$
4) Remove the unused local variable.
2023-06-12 18:44:31 +05:30
f4ea95da12
Fixed few query tool query tool shortcuts. #6065
2023-06-09 18:20:43 +05:30
c0c9034326
Fix an issue where varchar column sizes are not visible in query tool data grid. #6281
2023-05-17 12:10:43 +05:30
cba42ef277
Allow user to set the minimum value to 1 from preferences for ON_DEMAND_ROW_COUNT
2023-05-03 12:37:37 +05:30
a73f58160f
Fix an issue where running any query in query tool gives 'list index out of range' error. #5922
2023-05-03 11:05:00 +05:30
46a9d4a69d
Fix an issue where query tool hangs for some time when multiple columns are selected to open geometry viewer. #5044
2023-04-27 11:58:50 +05:30
861c66d180
Ensure that when pasting a row in query tool grid, default value is used for autogenerated/serial columns. #5922
2023-04-26 15:41:10 +05:30
a6faa77e5b
Throw an appropriate error when a table for which View/Edit data is open is deleted and query is executed. #6138
2023-04-18 15:26:40 +05:30
47a0009d32
Ensure to quote the primary key value if needed while deleting rows from the table. #6130
2023-04-17 12:38:16 +05:30
64d5457e2b
Try to fix feature test failures happening due to error occurring while deleting test databases.
...
* Try to fix feature test failures happening due to error occurring while deleting test databases.
* Updated ON_DEMAND_ROW_COUNT to ON_DEMAND_RECORD_COUNT missed in #3275 .
2023-04-13 17:25:12 +05:30
993e1eb1b6
Allow on demand record count setting to be changed per user using preferences. #3275
2023-04-13 16:43:11 +05:30
6c7116a20c
Fix an issue where insert was failing when copy pasting a row and saving in result grid. #5934
2023-04-03 10:57:45 +05:30
50391ae3fd
Fixed an issue loading file fails in Desktop mode
2023-03-31 10:47:48 +05:30
140494454a
Fixed linter errors after eslint upgrade.
2023-03-29 17:22:50 +05:30
9924fae378
Nomenclature changes:
...
1. Rename "Properties..." context menu option of object to "Edit Object...".
2. Rename "Browser" tree to "Object Explorer". #4734
2023-03-28 22:20:14 +05:30
eef7461ae6
Ensure that default values are set only for insert statement if user does not provide any values, in case of updating existing values to blank it should be set to null. #5934
...
Incorporated review comments
2023-03-27 10:22:28 +05:30
e4eeba2aa7
Fixed the UI related issues reported during testing for Shared Storage in Server Mode. #5014
2023-03-24 11:08:27 +05:30
319701dbbd
Ensure that when pasting rows the rows are added right below the selected rows for copying. #5921
2023-03-23 18:49:15 +05:30
b923f5fcfa
Use fetch instead of axios to close connections in SQLEditor, ERD, Schema Diff and Debugger to ensure it completes. When closing a browser tab, axios does not guarantee AJAX request completion. #5894
2023-03-20 18:20:48 +05:30
64aa739224
Fix SQLEditor Notifier and InetLoader issue.
2023-03-20 18:20:25 +05:30
366dd3a973
Remove psycopg2 completely.
2023-03-20 16:57:30 +05:30
3ce1589681
Fix an issue where query tool is stuck when running query after discarding changed data. #5955
2023-03-16 17:23:57 +05:30
292d76b39e
Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions. #5901
...
- Update Flask, Flask-SQLAlchemy, Flask-Babel, Flask-Security-Too, Flask-SocketIO, pytz, psutil, SQLAlchemy, bcrypt, cryptography, eventlet, Authlib, requests python packages
- Remove pinned dnspython, Werkzeug packages from requirements.txt
2023-03-15 11:57:16 +05:30
3c56c0e4b7
Revert "Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions. #5901"
...
This reverts commit 31818bb67a
2023-03-09 16:53:43 +05:30
31818bb67a
Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions. #5901
...
Remove the python version check from the requirements.txt.
2023-03-08 18:26:51 +05:30
6bd0ea7a02
Fixed an issue where the file name in the query tool tab was not changing if another file is opened. #5909
2023-03-08 17:37:45 +05:30
9da8a188fa
Added support for mounting shared storage in server mode. #5014
2023-03-06 17:03:47 +05:30
b640df5bdd
Fix Query Tool error messages for psycopg3 driver.
2023-02-22 14:07:05 +05:30
08062e67ca
Do not allow to save invalid JSON in query tool JSON editor. #5822
2023-02-20 15:37:59 +05:30
5e0daccf76
Added support for psycopg3 along with psycopg2. #5011
2023-02-15 11:31:29 +05:30
7a4951f211
Remove dependency on simplejson package.
2023-02-15 11:10:12 +05:30
8388f1e7ba
Fix for query tool prompting for unsaved changes even if no changes have been made. #5756
2023-02-14 11:04:30 +05:30
713ddb5f62
Remove usage of jQuery in pgAdmin.
...
Remove usage of Bootstrap in React components. #5701
2023-02-10 10:28:39 +05:30
932dcd9666
Fix an issue where role is used as username for newly added servers when opening query tool. #5702
2023-02-01 13:11:00 +05:30
706019d639
Fixed an issue where Geometry viewer does not show popup when columns are less than 3. #5641
2023-01-03 10:28:03 +05:30
98184e5835
Update copyright notices for 2023
2023-01-02 11:53:55 +05:30
953fb31e14
Fixed an issue with auto-complete not working as expected with double quotes. #5551
2022-12-09 14:13:40 +05:30
cc0d467927
Fixed blank screen issue while opening query tools in new tab from native menu. #5503
2022-12-08 19:17:12 +05:30
2480d08e0f
Added native menu support in desktop mode. #5503
2022-12-06 18:16:36 +05:30
be011a4f3d
Fixed an issue where Transaction IDs were not found in session in the Query Tool. #5453
2022-12-05 10:48:42 +05:30
9e078c0fa8
Fixed issue of opening query tool from new query tool icon beside connection status. #5575
2022-11-30 13:59:45 +05:30
7710d5e21c
Ensure the query tool is launched successfully for the servers registered with the PostgreSQL service. #5575
2022-11-28 17:23:43 +05:30
a954f22fe8
Fixed an issue where the CSV file would not download if the CSV quote character length exceeded 1. #5505
2022-11-28 13:49:22 +05:30
a305c03238
Fixed an issue where editor position was wrong when editing data from result grid. #5548
2022-11-25 11:43:56 +05:30
9d3654bd69
Ensure that the query history date format in Desktop mode matches the format of the locale of the pgadmin server. #5495
...
Format the time based on pgadmin servers locale.
2022-11-24 10:48:05 +05:30
41508f7f67
python 3 updates
...
- Fix super() calls for python 3
- No need to inherit objects.
- No need for u at the start of strings
- Tidied up some brackets and f-strings too
2022-11-19 10:13:41 +05:30
6d881fa34e
Use the shared server username when opening query tool. #5533
2022-11-16 13:40:38 +05:30
2a7b5a572f
Fixed linter error.
2022-11-15 14:13:05 +05:30
aa4f992e30
Ensure that autocomplete works properly with objects starting with double quotes. #5281
2022-11-15 13:59:12 +05:30
c5e9aa6357
Ensure that the load file paths are children of the storage directory. #5522
2022-11-14 19:28:48 +05:30
e701da7390
Fixed an issue where the editor was not visible in the result grid when editing a cell with a large string. #5463
2022-11-14 18:51:22 +05:30
c8666f0029
Fixed an issue where the result grid was not working properly while trying to edit data by hitting Enter key. #5463
2022-11-10 16:49:41 +05:30
1979ea53c7
Fixed an issue where the 'Confirm on close or refresh' setting was ignored when closing the query/ERD tool opened in the new tab. #5475
2022-11-02 14:03:52 +05:30
abfc30db8b
Ensure that users can use custom characters as CSV field separators/CSV quotes when downloading query results. #5066
2022-10-20 16:28:42 +05:30
b4fcb61d64
Ensure that the save button should be disabled by default on the Sort/Filter dialog in the query tool. #5058
2022-10-20 16:22:40 +05:30
1904a64e42
Fixed XSS vulnerability issues. #5277
2022-10-13 10:59:05 +05:30
8a76122949
Fixed an issue where filtered rows was not working. #5427
2022-10-13 10:25:27 +05:30
19f96799df
Ensure that the scroll position should be preserved for the result set in the query tool on tab change. #5296
2022-10-11 10:53:46 +05:30
7e51a2f517
Ensure that the result grid column should take width as pre preferences setting on first execution. #5132
2022-10-06 15:59:27 +05:30
d13ee8db29
1) Remove folders that are no longer used for older database versions.
...
2) Fixed RESQL tests for View/MView.
2022-09-29 16:45:51 +05:30
add5404f5e
Fixed an issue where the prompt is not visible when clicking on the 'save results to file' button on the large data. #5338
...
corrected issue id
corrected order of release notes
2022-09-27 14:27:22 +05:30
0b6b2e733a
1) Remove Python's 'Six' package completely. #5357
...
2) Replace deprecated @abstractproperty with @property, @abstractmethod.
2022-09-26 12:47:31 +05:30
f64b572150
Fix failing API test cases. #5210
2022-09-23 16:22:16 +05:30
9a6516a8b3
Ensure that the query tool creates a new tab with the appropriate user when pressing Alt+Shift+Q. #5210 ( #5350 )
2022-09-23 11:19:48 +05:30
3765131d21
Ensure that the default value for a column should be used if it is made empty. #5308
2022-09-22 14:59:42 +05:30
2de965d710
1. Use EDB's repo for react-data-grid instead of the personal repo.
...
2. Improved searching in the Search Objects.
3. Fixed react warnings in the query tool.
4. Fixed some SonarQube issues.
2022-09-13 19:13:33 +05:30
1bff94d0ea
1) Ensure that properties should be displayed after the SonarQube fixes. (Patch by: Aditya)
...
2) Fixed Tablespace wrong path issue. (Patch by: Nikhil)
3) Align the label and drop-down on Graph Visualizer.
2022-09-12 14:05:21 +05:30
b128ba2f57
Fixed a couple of SonarQube issues.
2022-09-10 14:04:28 +05:30
d967d5046d
Fixed 'Remove the unused function parameter' code smell.
2022-09-09 18:36:51 +05:30
3b95a416ca
Fixed 'Remove the unnecessary boolean literals' code smell.
2022-09-09 15:23:18 +05:30
7086719640
Fixed SonarQube issues.
2022-09-08 18:08:58 +05:30
18b77f15dd
Remove Alertify from pgAdmin completely. Fixes #7619
2022-09-08 15:16:48 +05:30
e1942d8c9e
1) Port schema diff to React. Fixes #6133
...
2) Remove SlickGrid.
2022-09-07 19:20:03 +05:30
0f46f070ed
Port the remaining components of the ERD Tool to React. Fixes #7343
...
1. Make use of MUI styles and remove SCSS.
2. Use the new common components for buttons and tooltips, so that they are consistent.
3. UI design should be aligned with the query tool.
4. Remove tippyjs and Alertify dependencies.
2022-09-06 18:09:13 +05:30
71a4b20d90
Fixed some SonarQube issues.
2022-08-30 14:21:33 +05:30
a84118823e
Title case tab label
2022-08-25 13:47:59 +01:00
f2cc897f2f
1. Fixed an issue where copy and pasting a row in the results grid doesn't set the default for boolean. Fixes #7579
...
2. Fixed an issue where the History tab is getting blank and showing an error after some queries are executed. Fixes #7468
3. Fixed query tool view data crash.
2022-08-22 14:33:38 +05:30
09e2c0eac0
1. Explain plan crashes query tool after SonarQube fixes.
...
2. Fix XSS issue in query tool.
3. Process details for cloud process not showing complete command.
4. Confirm dialog before removing processes.
2022-08-18 18:42:03 +05:30
306b184e11
1. Fixed an issue where Alt-Shift-Q didn't work after creating a new query. Fixes #7575
...
2. Fixed an issue where the Query Editor loses focus when saving a query (Alt+s). Fixes #7521
3. Ensure that an error is thrown if clipboard access is not provided and change the copy rows shortcut. Fixes #7452
2022-08-17 17:23:44 +05:30
da927f4897
1) Autocomplete on keypress should be set to False by default.
...
2) Update the documentation for the locked option in user management.
2022-08-17 14:38:37 +05:30
f771d3a4bb
Conditionally pin Flask version based on Python version.
2022-08-17 12:21:05 +05:30
d4fdd4601e
1) Pin Flask version 2.1.*
...
2) Fixed API test cases that failed due to a change in the Werkzeug version.
3) Change password issue is fixed.
2022-08-17 11:54:16 +05:30
d45072fae5
Ensure that rename panel should work on view/edit panels. Fixes #7540
2022-08-16 15:31:55 +05:30
084203debc
Fixed Securtiy Hotspot reported by SonarQube.
2022-08-12 17:10:26 +05:30
f96653e9af
Fixed an issue with rendering geometry when selecting a complete column. Fixes #7586
2022-08-09 13:28:09 +05:30
d1c94ac73d
Fixed SonarQube issues.
2022-08-05 18:58:03 +05:30
53887c32bf
Port change ownership dialog to React. Fixes #7590
2022-08-05 14:11:17 +05:30
95312f2d14
1) Ensure that autocomplete does not appear when navigating code using arrow keys. Fixes #7573
...
2) Fixed an issue where autocomplete is not working after clearing the query editor. Fixes #7563
2022-08-01 14:38:32 +05:30
a7fd7d67b3
1. Intermittently failing test cases.
...
2. Dialog vertical position should be more on the upper side.
3. File not supported error is not showing.
refs #7313
2022-07-25 11:48:27 +05:30
3e3f06c55d
Fixed an issue where Autocomplete did not work after pressing CTRL/CMD + Space
...
for the second time and autocomplete on keypress is off. Fixes #7563
2022-07-22 18:49:46 +05:30
631a08189a
1) Improved autocomplete loading indicator.
...
2) Avoid too many ajax requests per key press.
refs #4488
2022-07-20 18:02:45 +05:30
4808df5e95
1) Port the file/storage manager to React. Fixes #7313
...
2) Allow users to delete files/folders from the storage manager. Fixes #4607
3) Allow users to search within the file/storage manager. Fixes #7389
4) Fixed an issue where new folders cannot be created in the save dialog. Fixes #7524
2022-07-19 15:27:47 +05:30
4585597388
Added option to trigger autocomplete on key press in the query tool. Fixes #4488
2022-07-19 11:55:37 +05:30
8f2bda2309
1) Preserve the settings set by the user in the import/export data dialog. Fixes #7428
...
2) Fixed the JSON editor issue of hiding the first record. Fixes #7520
2022-07-18 10:54:03 +05:30
9dde195af4
Ensure that notices should not disappear from the messages tab. Fixes #7512
2022-07-14 18:05:36 +05:30
1fecf70123
Ensure that geometry should be shown for all the selected cells. Fixes #7519
2022-07-14 17:38:42 +05:30
50c930f5fa
Make the controls on the Graph Visualiser collapsible and reorganize the controls.
2022-07-07 14:10:10 +05:30
9cdcad7a88
1) Keep the selected columns for the X and Y-axis.
...
2) Lighten the color of the stacked line chart.
2022-07-06 18:58:15 +05:30
7414394ceb
Fixed the following issues in the Graph Visualiser:
...
1) Change all theme's color codes.
2) Bar graph for the first and last labels on the X-axis does not display all the bars.
3) Make the graphs always start from zero on the Y-axis.
2022-07-05 18:44:20 +05:30
8b62cd1f04
Added support for visualise the graph using a Pie chart in the query tool. Fixes #7487
2022-07-05 10:47:17 +05:30
239e3bb6f1
Some more theme related fixes.
2022-07-04 14:26:33 +05:30
86b30b3c83
Theme component usage has been fixed, a component should never be wrapped in multiple Theme components.
2022-06-30 15:18:20 +05:30
b92e2fcfc9
Added support for visualizing the graphs using Stacked Line, Bar, and Stacked Bar charts in the query tool. Fixes #7486
2022-06-30 12:38:48 +05:30
524626b895
Ensure that the file name should be reflected on the query tool for the new tab title.
2022-06-28 18:21:08 +05:30
d4657dcd32
Fixed module import issue.
...
refs #7506
2022-06-28 11:28:55 +05:30
f905dc07cf
Reset the zoom to original when chart object is created. Fixed an error on Windows.
2022-06-28 10:25:38 +05:30
e95eb14651
Fixed an issue where the connection wasn't being closed when the user switched
...
to a new connection and closed the query tool. Fixes #7461
Fixed the 'Show activity?' issue which was missed during Dashboard porting.
2022-06-23 18:15:16 +05:30
2556771c32
The following issues were fixed in Graph Visualiser:
...
1) Allow the user to set the row limit and chart line width.
2) Zoom should only be applied to X-axis, not both.
3) On clicking the 'Generate' button, the chart should return to its original zoom level.
4) Negative values are not displayed.
refs #7485
2022-06-23 14:52:11 +05:30
93bc1f3c57
Added support for visualise the graph using a Line chart in the query tool. Fixes #7485
2022-06-22 17:18:51 +05:30
5c1493bd7e
Fixed an issue where there is no setting to turn off notifications in the Query Tool. Fixes #7423
2022-06-13 14:32:07 +05:30
725726f083
Ensure that the Query Editor should be focused when switching between query tool tabs. Fixes #7441
2022-06-13 14:26:01 +05:30
f615ef30f9
Skip the history records if the JSON info can't be parsed instead of showing 'No history'. Fixes #7468
2022-06-13 11:43:26 +05:30
4c50940634
Fixed some issues related to the dropdown background color. Fixes #7374
2022-05-30 17:05:48 +05:30
b507eb8857
Fixed an issue when switching between connections in the Query Tool dropdown,
...
the background and foreground colors should be changed. Fixes #7374
2022-05-26 15:31:18 +05:30
aaab5c51a7
Fixed an issue where the data grid scroll is not reset when a query is executed.
2022-05-25 17:53:52 +05:30
1e1e1f027a
Fixed an issue where geometry is not visible when a single cell is selected. Fixes #7394
2022-05-24 17:08:02 +05:30
c5ca45c461
Ensure that null values are accepted for the numeric columns in react-data-grid. Fixes #7405
2022-05-24 15:02:06 +05:30
04fa7dee68
Added missing toggle case keyboard shortcuts to the query tool. Fixes #7399
2022-05-24 14:54:43 +05:30
6d26d5833f
Added support for multi-cell selection in the query tool grid. Fixes #7380
2022-05-24 11:39:34 +05:30
4f7bcc2919
Added the ability to detect and warn users about bidirectional Unicode characters. Fixes #7002
2022-05-23 16:04:21 +05:30
5e0dfff42a
Ensure that the editor position should not get changed once it is opened. Fixes #7393
2022-05-18 13:52:09 +05:30
2d8aff6ca0
Fixed an issue with geometry window zoom mouse scroll not working. Fixes #7373
2022-05-17 18:58:49 +05:30
fbe7b56054
Fixed an issue where a popup for unsaved changes appears when clicking on the
...
open file button for a blank query editor. Fixes #7376
2022-05-17 18:56:15 +05:30
cb05d2924f
Fixed an issue where an error message fills the entire window if the query is long. Fixes #7388
2022-05-17 18:52:19 +05:30
44f9ba4a57
Port connect server password dialog to React. Fixes #7337
2022-05-16 16:21:14 +05:30
ca8e14455f
Fixed the following issues:
...
1. Feature test cases for the new query tool.
2. Query tool panel rename is not persisting.
2022-05-12 18:29:09 +05:30
1135821870
Fix Query tool issues:
...
1. Warning/Confirm dialogs should be inside the query tool.
2. The Help button in View/Edit data should open the corresponding help page.
3. Disable execute options when query tool in transaction.
4. Grid not loading more than 10000 rows. react-data-grid issue, PR sent. Use a fork till then.
5. NOTICE messages should not be part of Notifier success popups.
Fixes #7350
2022-05-09 12:39:29 +05:30
5ebc9d7d2e
Ensure the Copy button is enabled when columns or rows are selected in the query tool results.
2022-05-05 09:52:14 +01:00
64ffed0ddb
1. Filter dialog doesn't work in edit mode (getting back end errors), reverting it back to create mode of SchemaView.
...
2. Enable the copy button when a cell is selected.
3. Exclude, Include related fixes.
2022-04-29 16:29:46 +05:30
c56fe813a5
Use gettext to wrap some strings.
2022-04-29 16:18:28 +05:30
38f642d361
Ensure that the "Save results" button should be disabled when there are no rows.
...
refs #6131
2022-04-28 18:01:54 +05:30
6e2ee9a21f
Port data filter dialog to React. Fixes #7340
2022-04-28 12:04:56 +05:30
0795b22ae6
Fixed the following issues for the new query tool:
...
1) In Dark mode > Replace/Find dialogue forward & reverse buttons are stuck to each other.
2) In Dark/High contrast mode > Checkbox is not visible for false value.
3) Wrap toolbar when size goes very small.
4) Replace functionality does not work when tried in sequence 2 times. Codemirror search is not cyclic. So, changes are made to always search from the start.
5) Replace all does not work when tried in sequence 2 times. Same reason as above.
6) Fix broken macros $SELECTION$ feature.
7) Make query history SQL readonly.
8) The Filter dialog save button should be disabled when opened.
2022-04-26 16:27:53 +05:30
4f9eaf850d
Updated documentation for the new query tool.
...
refs #6131
2022-04-26 16:18:28 +05:30
25b89f7624
Fixed the following issues for the new query tool:
...
1) Failed to fetch query history error sometimes.
2) In copy paste row, if a copied row has [null], then those are pasted as an empty string.
3) When Data output is empty, show an empty grid.
4) Schema diff generates a script button resulting in an empty window. Fixes #7306 .
5) Detach the DataOutput panel > Try editing text cell > Text editor is hidden behind the data output panel
refs #6131
2022-04-25 18:11:39 +05:30
c5ca394cec
1. Add min width to panels.
...
2. Fix issues related to New connection in query tool. Also fixed some existing bugs related to this.
refs #6131
2022-04-22 18:17:01 +05:30
e5ef6a7b21
Fixed following issues for Query Tool (after React Porting):
...
1) Find/Replace both opens the same dialogue box.(by clicking menu option)
2) Add New Server Connection > Server options keep loading(For multiple Server groups & should have some server)
3) Fixed CSS issues of slickgrid at various places.
4) C should be captial in ’<New connection…>'
5) In pop title for New Connection, all words should be capital.(Add new connection)
6) Explain > Analaysis tab > Column heading missing ROWS PLAN with cost & In explain only.
7) Explain > Analaysis tab > with cost enabled > Upward arrow size does not match with font of number. Arrow is little bigger than number.
8) Boolean default is not considered while ading new row.(try table from feature test defaults)
9) In query history , when not query history present, warning icon size big. Match it to warning message - No history found
10) Select table/db object > Open query tool from Tools menu > NOT FOUND error is shown. Existing issue, fixed.
11) Any cell just open by clicking it > Do NOT change any thing > Click Ok > Cell is shown as edited.
refs #6131
2022-04-20 19:02:16 +05:30
9c30d983bd
Fixed following issues for query tool after react porting:
...
1) Add New Server Connection > Server options keep loading(For empty Server group).
2) After clicking indent/Unindent(for all operations) for large query option left as it is till operation completes
3) Check sign beside options in Execute Option/Copy Header is little bit big
4) In explain > Analysis tab does not show ROWS column
5) In explain > Explain > analysis previous explain output is NOT cleared. New rows are appended. Same applies to the statistics tab.
6) Update new query tool connection tool tip. Fixes #7289
7) Explain-Analyze > Loops column is empty.
8) Explain-Analyze with Verbose & Costs > in ROW X columns upward arrows are missing.
9) Explain-Analyze with all option checked > background colors are missing for timing.
10) Explain-Analyze > Additional bullet is added before Hash Cond.
11) Browser Tree > Filtered rows icon is not working.
12) Create table with timestamp and default value as function now() > Add new row > Enter mandatory columns except column where default value is function(now()) > Click Save > New row added but column with default value has value [default]. not updated to actual value. / Default values are not considered for any column while adding a new entry.
13) Disable execute options in View/Edit data.
14) The Boolean column always shows null.
15) In Query history Remove & Remove all buttons are stuck to each other.
16) On Remove all, the right panel is empty.
17) Create a column with boolean[]/ text[], Try to add a new entry from data grid, enter “” quotes > Click Ok > Now try edit cell > You can not change value.
18) In query history - Select queries are suffixed by ’Save Data’ icon
19) Edit any table with PK > Try to insert duplicate PK > Error thrown > Correct pK value > Still old error shown > Not able to add new entry (This works when focus is moved from edited cell)
20) Clicking arrows after opening dropdown options, does not collapse dropdown.
refs #6131
2022-04-18 12:50:51 +05:30
86a3696ab4
Remove aciTree and its references.
2022-04-13 17:35:01 +05:30
9dfa5ea77d
Improvement to the Geometry Viewer popup to change the size of the result tables when column names are quite long. Fixes #7168
2022-04-09 12:09:36 +05:30
b5b9ee46a1
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
2022-04-07 17:36:56 +05:30
143ae19b8d
Ensure that the correct user should be selected in the new connection dialog. Fixes #7264
2022-03-31 15:51:46 +05:30
74e794b416
Port preferences dialog to React. Fixes #7149
2022-03-21 13:29:26 +05:30
4d727015fd
Fixed an issue where the query tool is displaying an incorrect label. Fixes #7136
2022-02-02 14:45:31 +05:30
aa5b1d50b9
Fixed issues introduce by SonarQube fixes.
2022-02-01 14:11:18 +05:30
9f836f5433
Fixed following code smells reported by SonarQube:
...
1) Immediately return this expression instead of assigning it to the temporary variable.
2) Extract this nested ternary operation into an independent statement.
3) Expected a `for-of` loop instead of a `for` loop with this simple iteration.
2022-01-18 14:49:54 +05:30
e38c38cd58
Fixed following SonarQube code smells:
...
1) Remove this useless assignment to a variable.
2) Remove the unused local variable.
2022-01-12 14:53:19 +05:30
2786f7ac5a
Update copyright notices for 2022
2022-01-04 13:54:25 +05:30
191e2b6242
Fixed an issue where an operation error message pop up showing the database object's name incorrectly. Fixes #7078
2021-12-28 13:49:04 +05:30
e5e9981836
Fixed an issue where Columns with default value not showing when adding a new row. Fixes #7034
2021-12-21 18:09:20 +05:30
9754b0fe14
Fixed an issue where Columns with default value not showing when adding a new row. Fixes #7034
2021-12-17 10:48:24 +05:30
701e6f86f5
Ensure that statue message should not hide the last line of messages when running a long query. Fixes #7020
2021-12-13 13:10:56 +05:30
91a288c2bb
Correct the SQL definition for function/procedure with the Atomic keyword in PG14. Fixes #7029
2021-12-08 12:31:59 +05:30
fd53e4f5f9
Replace Alertify alert and confirm with React-based model dialog. Fixes #7053
2021-12-07 18:52:40 +05:30
f8cb62180e
Fixed API test cases for StartRunningQueryTest.
2021-12-03 13:19:31 +05:30
36c9eb3dfd
Added support for Two-factor authentication for improving security. Fixes #6543
2021-12-02 16:47:18 +05:30
c6424e3897
Replaced alertifyjs notifiers with React-based notistack. Fixes #7004
2021-12-02 16:05:52 +05:30
bef692d431
Fixed an issue where On-demand rows throw an error when any row cell is edited
...
and saved it then scroll to get more rows.
Fixes #7005
2021-11-28 13:26:40 +05:30
d644b4f94e
1) Replace Flask-BabelEx with Flask-Babel. Fixes #6088
...
2) Upgrade Flask to version 2. Fixes #7010
2021-11-24 17:22:57 +05:30
8a21d9b500
Fixed some typos in the documentation and comments.
2021-10-14 11:13:16 +05:30
2ced82c7b3
Ensure that query highlighting color in the query tool should be less intensive. Fixes #6754
2021-10-12 14:30:29 +05:30
ca32828281
Fixed an issue where Execute button of the query tool gets disabled once we change anything in the data grid. Fixes #6798
2021-10-06 16:59:38 +05:30
5f9bb1c160
Correct the implementation of query details should be scrollable as per design.
...
Fixes #3827
2021-10-01 13:01:24 +05:30
483e2ca8d0
Port browser tree to React. Fixes #6129
2021-09-27 16:44:26 +05:30
99c99a9ce9
Ensure that in the Query History tab, query details should be scrollable. Fixes #3827
2021-09-17 21:01:24 +05:30
eeff75ba20
Remove GPDB support completely. Fixes #6692
2021-09-09 13:09:53 +05:30
f91908f627
Resolve the issue related to the close query tool panel with the save query tool changes.
...
refs #6710
2021-09-06 19:17:16 +05:30
7deda52bd9
Fixed an issue where multiple query tool tabs getting closed for the single close event. Fixes #6710
2021-08-30 16:59:46 +05:30
51d73b1672
Fixed errors related to HTML tags shown in the error message for JSON editor. Fixes #6668
2021-08-26 14:54:51 +05:30
3e4b5fd0d7
Renamed 'Auto rollback?' to 'Auto rollback on error?'. Fixes #6682
2021-08-19 15:30:58 +05:30
a6edfb498f
Partially fixes the data output panel display issue. Fixes #6572
2021-08-17 17:22:08 +05:30
7483ddf2b2
Added support to copy SQL from main window to query tool. Fixes #4904
2021-08-09 14:29:31 +05:30
703478c13d
Fixed an issue where the titles in query tabs are different. Fixes #6618
2021-08-06 19:09:39 +05:30
025c98ced8
1) Flash warning message of N no of attempts left for the unsuccessful login attempt.
...
2) Updated some strings in the Preferences for the "Maximum column width" option.
2021-08-03 17:06:06 +05:30
8e214ca8fb
Added support for formatted JSON viewer/editor when interacting with data in a JSON column. Fixes #5198
2021-08-03 11:36:45 +05:30
508f97b08e
Rename the "Resize by data?" to "Columns sized by" and disabled the 'Maximum column width'
...
button if 'Columns sized by' is set to 'Column data'. Fixes #6622
2021-07-27 15:17:06 +05:30
e68c8305a2
Added option to provide maximum width of the column when 'Resize by data?’ option in the preferences is set to True. Fixes #6559
2021-06-28 11:51:21 +05:30
2adb29ffc0
Fixed an issue where the New Connection Drop Down has lost default maintenance database, auto-select, and tab-through functionality. Fixes #6505
2021-06-23 12:48:17 +05:30
81b78dd2b2
Do not block the query editor window when running a query. Fixes #3920
2021-06-23 12:22:24 +05:30
e3190b86ab
Fixed an issue where a decimal number is appended for character varying fields while downloading the data in CSV format. Fixes #6520
2021-06-11 19:29:20 +05:30
e1067ffe67
Ensure that the Query Tool connection string should not be changed as per the 'Query Tool tab title'. Fixes #6404
2021-06-07 22:07:51 +05:30
d5f537aae4
Added extra check for verifying the rename of the database.
...
refs #4203
2021-06-07 21:11:28 +05:30
658a2de619
Fixed the issue of renaming the database by another user. Fixes #4203
2021-05-31 12:41:09 +05:30
3ddf941cd7
Added support to launch PSQL for the connected database server. Fixes #2341
2021-05-25 20:12:57 +05:30
f34adaca41
Fixed column sizing issue when there are no rows in a table.
...
refs #5954
2021-05-17 17:55:13 +05:30
7ed97eeec4
Fixed an issue where file dialog showing incorrect files for the selected file types. Fixes #6443
2021-05-14 12:12:17 +05:30
bd7808a104
Fixed an issue where the filter 'Include/Exclude By Selection' not working for null values. Fixes #6392
2021-05-11 19:12:43 +05:30
2b7f8d8298
Improve some strings.
2021-05-11 11:31:14 +01:00
d80087f6d5
Added support to set auto width of columns by content size in the data output window. Fixes #5954
2021-05-07 17:18:50 +05:30
4c55044440
Remove duplicate code and avoid DOM search operation.
...
refs #6355
2021-05-06 10:53:32 +05:30
ac403d0dfa
Fixed an issue where the current debug line is not visible in the 'Dark' theme. Fixes #6409
2021-05-04 12:34:03 +05:30
72f3730c34
Added support to connect PostgreSQL servers via Kerberos authentication. Fixes #6158
2021-05-03 16:10:45 +05:30
3a2145e5fa
Fixed an issue where query editor is not being closed if the user clicks on the 'Don't Save' button. Fixes #6417
2021-05-03 12:52:28 +05:30
488dc1849d
Fixed an issue where data is displayed in the wrong order when executing the query repeatedly. Fixes #5555
2021-04-29 13:13:52 +05:30
9dd1bae3c7
Ensure that pgAdmin should not allow opening external files that are dragged into it. Fixes #6355
2021-04-28 11:59:45 +05:30
dc65cbb08c
Fixed an issue where foreign data wrapper properties are not visible if the host option contains two host addresses. Fixes #6379
2021-04-19 11:08:21 +05:30
2b1910c1c1
Better fix for the black screen issues, reverted the old fix.
...
refs #6334
2021-04-16 18:23:29 +05:30
b4d44541bb
Fixed SQL panel black screen issue when detaching it in runtime. Fixes #6334
2021-04-15 16:40:35 +05:30
49095ccba6
1) Fixed an issue where shortcut keys are not working with manage macro. Fixes #5908
...
2) Fixed an issue where the cursor shifts its focus to the wrong window for all the query tool related model dialogs. Fixes #6161
2021-04-09 12:41:13 +05:30
1f4affcb1e
Fixed an issue where a connection warning should be displayed when the user
...
clicks on explain or explain analyze and the database server is disconnected
from the browser tree. Fixes #6376
2021-04-08 18:49:31 +05:30
14dcb70b95
Ensure that the user should not be to change the connection when a long query is running. Fixes #6082
2021-04-08 18:09:13 +05:30
566f03beca
Ensure that the query tool tab should be closed after server disconnection when auto-commit/auto-rollback is set to false. Fixes #5519
2021-04-01 11:58:59 +05:30
9395ce3fda
Fixed an issue where copy/paste rows in view data paste the wrong value for boolean type. Fixes #6312
2021-03-16 11:29:47 +05:30
68132e2a8f
Fixed an issue where adding/updating records fails if the table name contains percent sign.
...
refs #4438
2021-03-12 11:59:45 +05:30
9d8360641f
Use schema qualification while accessing the catalog objects.
...
refs #3976
2021-03-12 11:17:25 +05:30
a2be30d257
Use schema qualification while accessing the catalog objects. Fixes #3976
2021-03-09 13:18:45 +05:30
8cf7c41ad9
Fixed an issue where adding/updating records fails if the table name contains percent sign. Fixes #4438 .
2021-03-09 12:40:59 +05:30
87b9549ff4
Fixed encoding issue when database encoding set to SQL_ASCII and name of the column is in ASCII character. Fixes #6018
2021-02-26 13:23:07 +05:30
d9847ed1f3
Fixed an issue where the user is not able to use the query tool when
...
any other long-running operation is in progress.
refs #5793
2021-02-19 15:57:55 +05:30
32197a8405
Fix explain plan and geometry viewer issue. It's a regression of SonarQube fixes. Fixes #6239
2021-02-19 14:29:43 +05:30
3fc0cc3e92
Fixed SonarQube issues
2021-02-15 17:31:20 +05:30
1b850ff616
Fixed an issue where strikeout is getting removed on scrolling of index column of the table.
...
refs #6157
2021-02-10 17:40:54 +05:30
1317e4254b
Updated the JS dependencies to the latest
...
1) Migrate from webpack 4 to webpack 5. This had a lot of breaking changes,
so updated multiple webpack plugins and changed the config accordingly.
2) Replaced iconfont-webpack-plugin with a more maintained webfonts-loader.
3) Replaced deprecated babel-eslint with @babel/eslint-parser.
4) Replaced optimize-css-assets-webpack-plugin with a more maintained css-minimizer-webpack-plugin.
5) Updated all other JS packages and made the required code changes.
Fixes #6207
2021-02-10 12:47:52 +05:30
9e85fb3de3
Fixed an issue where strike-through is not visible for rows selected for deletion after scrolling. Fixes #6157
2021-02-05 13:57:35 +05:30
9bee91b6f6
1) Fixed an issue where the Save button is enabled by default in Macro. Fixes #5905
...
2) Remove extra line after Manage Macros menu while clearing all macros. Fixes #5906
3) Ensure that 'Clear All Rows' should not work if there is no existing macro available and the user does not specify any value. Fixes #5907
4) Fixed an issue where the server is disconnected error message displayed if the user creates Macro with invalid SQL. Fixes #5929
2021-01-20 13:52:00 +05:30
b3ca172f3a
Fixed an issue of deleting records when the user tries to delete multiple records. Fixes #6098
2021-01-20 12:39:12 +05:30
d4a3e4d92c
Fixed issues reported by SonarQube.
2021-01-18 13:02:19 +05:30
0c8226ff39
Added ERD Diagram support with basic table fields, primary key, foreign key, and DDL SQL generation. Fixes #1802
2021-01-16 17:06:50 +05:30
b372f08a59
Update copyright notices for 2021
2021-01-04 15:34:45 +05:30
98b7603ebd
Close query tool connection for API test cases.
2020-12-25 18:32:01 +05:30
a7b8d77ed7
Fixed an issue where the state of the Save File icon does not match the dirty editor indicator. Fixes #6046
2020-12-17 11:37:03 +05:30
52780079f3
Fixed an issue where the dirty indicator stays active even if all changes were undone. Fixes #6047
2020-12-14 12:02:02 +05:30
6475a70514
Ensure that the macro query result should be download properly. Fixes #5965
2020-12-14 11:58:53 +05:30
abd0748a77
Ensure that dirty indicator (*) should not be visible when renaming the tabs. Fixes #5991
2020-12-01 11:28:10 +05:30
5370bb4515
Added the appropriate server icon based on the server type in the new connection dialog. Fixes #5983
2020-11-12 17:52:54 +05:30
1dca4313f7
Fixed an issue where Query Tool/View Data panel closed event is not registered for changes.
...
It's a regression of #4231 .
refs #4231
2020-11-08 19:14:08 +05:30
2793747d3c
1) Added support for dynamic tab size. Fixes #4231
...
2) Fixed an issue where a long file name is not visible on the process watcher dialog. Fixes #5950
2020-11-04 17:45:28 +05:30
6c723a7e43
Fixed an issue where connection to the server is on wait state if a different user is provided. Fixes #5953
2020-10-28 12:32:22 +05:30
7648bd9646
Added missing gettext.
2020-10-27 10:51:35 +05:30
275d13d40f
Following issues have been resolved for the new connection feature:
...
1. Show servers with server groups in the dropdown.
2. Highlighted current selected connection in the new connection dropdown.
3. Notify the user before changing the connection.
refs #3794
2020-10-21 17:14:59 +05:30
18cad32bd4
Added tab title placeholder for Query Tool, View/Edit Data, and Debugger. Fixes #4232
2020-10-20 15:41:54 +05:30
6addd207af
Ensure that macros should be run on the older version of Safari and Chrome. Fixes #5911
2020-10-15 15:59:53 +05:30
49b139bb75
Added escape and unescape for the strings used in query tool and new connection support. Fixes #5899 .
2020-10-12 16:20:33 +05:30
1c796720be
Fixed the following issues for RM 3794:
...
1. Updated connection success message. (Added database name in the success message.)
2. Resolve issue of the mouse pointer and dropdown will show below the connection string only.
3. Added loader for both new connections and load existing connections.
4. Removed async: false for update connection.
refs #3794
2020-10-08 11:38:05 +05:30
c28509ac28
Fixed an issue where the user is unable to change the macro name. Fixes #5885
2020-10-05 14:40:21 +05:30
be7bb81a19
Allow user to change the database connection from an open query tool tab. Fixes #3794
2020-10-01 13:29:46 +05:30
228d4bb321
Fixed SQLAlchemy operation error with the boolean value as true/false for Python version < 3.7
2020-10-01 13:29:46 +05:30
1c70a43b91
Fixed code smells 'Define a constant instead of duplicating this literal' reported by SonarQube.
2020-09-29 15:08:14 +05:30
1fc06b8d57
Added useful message when the explain plan is not used and empty. Fixes #4806
2020-09-28 17:51:59 +05:30
4616a74029
Added Macro support. Fixes #1402
2020-09-28 15:26:45 +05:30
San Lin Naing
Akshay Joshi
Khushboo Vashi
Aditya Toshniwal
Nikhil Mohite
Aditya Toshniwal
Pravesh Sharma
Yogesh Mahajan
Matěj Cepl
Mark Mayo
Dave Page
Pradip Parkale
Rahul Shirsat
Ashesh Vashi
huangj.fnst@fujitsu.com
Murtuza Zabuawala
Libor M