92dd13e72a
Introduced a 'exclude' option in the 'Field' to exclude it from the change.
...
* Introduced a 'exclude' option in the 'Field' to exclude it from the
change completely. Use the option 'exclude' to add field
'notNullColumns', which will be excluded from the data, but - can be
used to force rerender the 'Not Null Columns' select control on
change of it.
* Fixed the linter issue
2024-09-16 15:28:33 +05:30
0d39e791c9
Fixed the import-export 'Not null columns' and User Management issue #7884
2024-09-16 13:12:41 +05:30
5e96f0fd61
Fixes the Variable Schema UI issues and InlineView bug reported in #7884
...
* Show the icon for the 'Reset' button. (Reference #7884 )
* Reload the server list after connecting to a server in the 'New
connection' dialog (QueryTool). (Reference: #7884 )
* Pass the grid path during the bulk update (click on a radio action)
* Don't assign the cell value to the 'rowValue' variable.
* Don't rely on the 'optionsLoaded' for setting the variable types as it
is loaded asynchronously, and variable types data may not be available
while rendering the 'value' cell. (Fixes #7884 )
* Fixed a type while checking for the 'inline-group'. fixes (#7884 )
* 'vnameOptions' can be a Promise function too, hence - taken care accrodingly.
* Introduced a parameter 'reloadOnDepChanges' in the BaseSchemaUI field
to force reload the control on value change for one of the
dependencies.
* Reload on the components in case of dependent value changes.
* Introduced 'useSchemaStateSubscriber', which generates a state
subscriber mananager instance. It helps multiple subscribers in a
single control as we could have multiple subscribe within a control.
(For example - value, options, errors, etc).
* Fixed all the issues reported (#7884 )
2024-09-16 00:04:37 +05:30
e21911b1c6
All the issues are fixed reported in #7884
...
* Show the icon for the 'Reset' button. (Reference #7884 )
* Reload the server list after connecting to a server in the 'New
connection' dialog (QueryTool). (Reference: #7884 )
* Pass the grid path during the bulk update (click on a radio action)
* Don't assign the cell value to the 'rowValue' variable.
2024-09-11 12:21:41 +05:30
e9af0c3226
Improved the extendability of the SchemaView and DataGridView. ( #7876 )
...
Restructured these modules for ease of maintenance and apply the single
responsibility principle (wherever applicable).
* SchemaView
- Split the code based on the functionality and responsibility.
- Introduced a new View 'InlineView' instead of using the
'nextInline' configuration of the fields to have a better, and
manageable view.
- Using the separate class 'SchemaState' for managing the data and
states of the SchemaView (separated from the 'useSchemaState'
custom hook).
- Introduced three new custom hooks 'useFieldValue',
'useFieldOptions', 'useFieldError' for the individual control to
use for each Schema Field.
- Don't pass value as the parameter props, and let the
'useFieldValue' and other custom hooks to decide, whether to
rerender the control itself or the whole dialog/view. (single
responsibility principle)
- Introduced a new data store with a subscription facility.
- Moving the field metadata (option) evaluation to a separate place
for better management, and each option can be defined for a
particular kind of field (for example - collection, row, cell,
general, etc).
- Allow to provide custom control for all kind of Schema field.
* DataGridView
- Same as SchemaView, split the DataGridView call into smaller,
manageable chunks. (For example - grid, row, mappedCell, etc).
- Use context based approach for providing the row and table data
instead of passing them as parameters to every component
separately.
- Have a facility to extend this feature separately in future.
(for example - selectable cell, column grouping, etc.)
- Separated the features like deletable, editable, reorder,
expandable etc. cells using the above feature support.
- Added ability to provide the CustomHeader, and CustomRow through the
Schema field, which will extend the ability to customize better.
- Removed the 'DataGridViewWithHeaderForm' as it has been achieved
through providing 'CustomHeader', and also introduced
'DataGridFormHeader' (a custom header) to achieve the same feature
as 'DataGridViewWithHeaderForm'.
2024-09-09 14:27:31 +05:30
8bae604129
Fix the query tool restore connection issue on the server disconnection from the left side object explorer. #6502
2024-09-02 15:06:11 +05:30
47fcf87ae4
Update JS and Python packages
2024-08-22 17:20:50 +05:30
35d585251a
Upgrade xterm realted packages to the latest @xterm based namespace.
2024-08-14 18:15:03 +05:30
c0b6c8726e
Add a home button to the geometry viewer to set original zoom level when the viewer was opened. #2046
2024-08-14 11:09:28 +05:30
52c550e3fe
Fix an issue where ERD tool should to be able to open saved pgerd file when using keyboard shortcuts. #7688
2024-08-13 14:30:58 +05:30
57e72ce598
Fixed bugs found when testing react-data-grid upgrade changes. #7705
2024-08-13 13:00:52 +05:30
fb0022923a
Fix import Export Server loading issue, affected due to SchemaView component changes.
2024-08-12 11:27:21 +05:30
00e2480b7b
1) Fixed an issue where refreshing the Schema Diff tool opened in a new tab caused an error. #7499
...
2) Fixed an issue where the Generate Script ignored filter conditions when a parent node was selected. #7682
2024-08-08 13:02:38 +05:30
c6e7ce03cc
Upgrade react-data-grid fork to latest and change pgAdmin accordingly. #7705
2024-07-31 19:12:36 +05:30
1d5f5a2067
Fixed an issue where ERD Open/Save shorcuts were not working on Windows/Linux. #7639
2024-07-24 15:11:05 +05:30
87ba177ff3
Fixed linter error.
2024-07-24 13:02:46 +05:30
0511554db9
The following issues have been fixed:
...
1) White screen issue after closing the Macro dialog.
2) Schema Diff database and schema selection issue.
3) CSV download issue.
2024-07-24 12:54:20 +05:30
8030bc708b
Add support for highlighting selection matches in the query editor. #7530
2024-07-18 17:51:20 +05:30
bfcdcdc4f1
Add a precautionary check for the query tool connection cursor to fix the error 'NoneType' object has no attribute '_query'. #7660
2024-07-18 14:24:50 +05:30
8e16e000c3
Fix issues found in electron testing. #7494
2024-07-16 20:29:10 +05:30
cd6ff48cc0
Fix query tool, ERD closing issue in Electron. #7494
2024-07-10 15:01:35 +05:30
721a5da895
Fixed an issue where Generate Script button should be disabled if no objects are selected in the schema diff result. #7638
2024-07-09 13:44:04 +05:30
5c5b61c4db
Fixed an issue where paste operation in query tool data grid should skip bytea columns and put the value as NULL instead. #3199
2024-07-09 10:33:29 +05:30
760e38293c
Fix issues found during Electron testing. #7494
...
Fix application crash when using users dialog. #7607
2024-07-08 19:24:29 +05:30
dcfef154ce
- Set the browser target to ES6 and reduce the JS bundle size considerably
...
- Upgrade ESLint to v9.x and migrate the .eslintrc.js file to make it work
2024-07-04 18:25:47 +05:30
10b2e91e29
Update react-diagrams library which is used in ERD to the latest version. #7644
...
Added patch for DataGridView failing when adding a new row.
2024-07-03 18:19:27 +05:30
4f415f9768
Added support for viewing PostgreSQL Server Logs in Text, CSV and JSON formats. #3981
2024-07-03 16:17:29 +05:30
22cdb86aab
Fix issue with missing new added records in download file. #5345
2024-07-02 11:48:13 +05:30
f8fa1cf6d6
- Fix few SonarQube issues.
...
- Cleanup NW.js related stuff.
2024-07-02 10:34:30 +05:30
3bb9f0ba8c
Remove support for Python 3.7 as Debian 10 is EOL.
2024-07-01 12:39:12 +05:30
91eb60a363
Replace pgAdmin NW.js container with Electron container. #7494
2024-07-01 11:27:42 +05:30
feb3093c6d
Automatically apply virtualization in the DataGridView of SchemaView if the schema contains only one collection. #7607
2024-06-27 13:21:18 +05:30
3be2221948
Ensure that pgAdmin 4 is compatible with PostgreSQL v17. #7537
2024-06-27 13:18:26 +05:30
6410ae5f69
Fixed some more styling issues broken due to JSS changes. #7363
2024-06-20 17:18:38 +05:30
9279393dcd
Add missing files from last commit. #7593
2024-06-19 17:57:34 +05:30
6984e97f8d
Use correct for loop syntax.
2024-06-19 13:15:45 +05:30
95ffd1b9a1
More fixes for issues reported while testing changes related to makeStyle JSS changes and auto-theme. #7363
2024-06-19 11:54:18 +05:30
0452828cc7
1) Change the cursor to a pointer for JSON editor toolbar buttons.
...
2) Remove the extra scrollbar in JSON editor.
3) Set the focus on the PSQL tool.
2024-06-18 16:42:17 +05:30
2b04f3ca1d
Fixed incorrect handling of the code smell for the reject API call
2024-06-17 18:22:38 +05:30
b0e7847962
Fixed bugs found while testing makeStyles JSS changes. #7363
2024-06-17 15:45:40 +05:30
a946c70869
Fixed an issue where changing a column name should reflect in all the constraints in table object dialog and ERD table dialog. #7476
2024-06-17 14:07:45 +05:30
5866da8194
Fixed SonarQube code smells.
2024-06-13 18:48:02 +05:30
ad34ee2699
Fixed new line indentation in query editor and add a user preference to disable it. #7295
2024-06-13 18:06:13 +05:30
e03d65d547
Fixed an issue where query tool shortcuts for find/replace are not working. #7555
2024-06-13 17:26:47 +05:30
b5c8692f34
Fixed an issue where resizable data editors in query tool should not be allowed to resize beyond the app window bounds. #7241
2024-06-13 14:07:44 +05:30
dea5335ce5
Fixed the following SonarQube code smells:
...
1) Do not use the Array index in keys.
2) Import from the same module should be merged.
3) Mutable variables should not be exported.
4) Variables should not be initialized to undefined.
5) startswith or endswith method should be used.
6) Unwrap this unnecessarily grouped subpattern.
Additionally, addressed many other SonarQube rules.
2024-06-12 18:09:06 +05:30
c98cea2ea9
Search Objects dialog should focus on search input on open. #7536
2024-06-12 17:17:35 +05:30
056aff4742
Revert the changes done for removing support for Python 3.7
2024-06-12 16:23:27 +05:30
c47390e643
Fixed API test cases for BatchProcess
2024-06-11 12:59:48 +05:30
8857f0d179
Fix SonarQube code smells:
...
1) String literals should not be duplicated.
2) Prefer using an optional chain expression instead, as it's more concise and easier to read.
3) Expected the Promise rejection reason to be an Error.
2024-06-10 18:04:32 +05:30
de712b0805
- Update JS packages.
...
- Remove support for Python 3.7 as Debian 10 is EOL.
2024-06-07 14:17:22 +05:30
85d4473af4
Disable the query tool editor input if any SQL is being loaded to prevent users from typing. #6357
2024-06-06 18:06:49 +05:30
cc999ae5a5
Remove the usage of MUI makeStyles as it doesn't support React 18. #7363
2024-06-06 17:13:12 +05:30
f66bd4bcfb
Remove the use of is_normalized function for Python 3.7.
2024-06-05 14:11:59 +05:30
a46f99d360
1) Partially fixed the issue with inserting characters at the end of the line by setting 'Underline query at cursor?' to false by default.
...
2) Update release note.
2024-06-04 18:18:16 +05:30
24aefd2c7a
Fix an issue where user authentication fails with special characters in password. #5785
2024-05-31 11:22:36 +05:30
b5b0538fe3
Fixed an issue where canceling a query without privilege does not display any message on query tool. #7480
2024-05-31 11:19:44 +05:30
6690b16f8a
Added support for executing the query at the cursor position in the query tool. #6841
2024-05-27 16:11:59 +05:30
16b9b103a2
Resolved the intermittent issue with macros not displaying in the macros dialog.
2024-05-27 15:56:02 +05:30
4e3ec91d23
Added support for the 'Add to macros' feature and fixed various usability issues. #4735
2024-05-24 15:30:31 +05:30
5c30695d66
Fixed Typos
2024-05-23 12:52:41 +05:30
6c7bc1c815
Ensure that Schema Diff does not indicate a table as different when the trigger names are the same but the trigger function body is different. #5762
2024-05-21 16:04:25 +05:30
dd45f06d50
Added support for viewing PGD Clusters. #7215
2024-05-20 16:54:49 +05:30
0e786c519e
Replace the current FontAwesome based PSQL tool icon with MUI Terminal icon. #7472
2024-05-14 11:05:27 +05:30
afc28d95cf
1. Disable ERD for system Catalogs. #5849
...
2. Disable Debugger for system catalogs. #6060
3. Fixed an issue where the keyboard shortcut for launching the debugger from Object Explorer was not working.
2024-05-08 15:29:01 +05:30
5ec6faff13
Upgrade react-table from v7 to v8. #7419
2024-05-07 16:31:04 +05:30
b85d8c1446
Changes in Query Tool, Debugger, and ERD Tool shortcuts to remove the use of Accesskey which will allow them to be customized. #7192
2024-05-06 11:15:44 +05:30
f4761f55f7
Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215). #7425
2024-04-29 13:41:02 +05:30
e18a8bf620
Fixed issue found during testing of #7163 .
2024-04-29 13:12:21 +05:30
f88c89f3eb
Fixed an issue when closing the materialized view data second tab; it raises the error that the 'MViewCommand' object has no attribute 'auto_commit'.
2024-04-26 15:53:15 +05:30
10ba029980
Fixed an issue where connection to the database is not automatically re-established after connectivity drop. #7372
2024-04-24 14:37:33 +05:30
84c024f6fa
Fixed an issue when closing the view data second tab; it raises the error that the 'ViewCommand' object has no attribute 'auto_commit'. #7384
2024-04-23 14:45:15 +05:30
f0185fbe7f
Fix issues reported while testing MUI5 library update.
2024-04-17 17:31:55 +05:30
f143aa05a3
Added support for excluding multiple tables while taking Backup. #7163
2024-04-15 11:50:08 +05:30
30d2d1b23e
Fixed the following code smells:
...
1) useState call is not destructured into value + setter pair.
2) A fragment with only one child is redundant.
3) Unnecessary '.apply()' and '.call()'.
4) Expected the Promise rejection reason to be an Error.
2024-04-09 19:18:56 +05:30
102e0a9839
- Update MUI v4 to v5
...
- Remove the SCSS dependency completely and use MUI for theming.
- Update - date-fns, @date-io, notistack. Remove - popper.js, sass-loader.
- Cleanup webpack config.
- Port PSQL tool to use MUI themes instead of SCSS theme.
- Theme change will reflect realtime without refreshing pgAdmin.
2024-04-09 08:21:14 +05:30
edec9adbfb
Fixed SonarQube code smell 'Unnecessary use of boolean literals in conditional expression'.
2024-04-08 17:19:51 +05:30
9f31ec115a
Fixed Schema Diff issues while comparing Materialized View. #7271
2024-04-01 16:56:18 +05:30
5931162556
Fixed an issue where maximize icon is missing from query tool panel. #7218
2024-03-28 11:53:56 +05:30
082fb165d3
Implemented shortcut mapping for the edit menu in the query tool.
2024-03-27 16:41:08 +05:30
a02ebe192b
Fixed rollback and commit button activation on execute button click. #7248
2024-03-27 16:38:42 +05:30
089f890f2e
Fixed an issue where Triggers, Rules, Indexes were absent from the Schema Diff when comparing views. #7271
...
Fixed an issue in Schema Diff where Columns with sequences get altered unnecessarily. #4413
2024-03-27 11:40:23 +05:30
1bcf343ceb
Fixed an issue where taking backup of a shared server was using server owner's user name. #7255
2024-03-26 11:28:20 +05:30
c0a1429664
Fix failing feature tests
2024-03-26 11:20:04 +05:30
cc1ce09b73
More CodeMirror fixes. #7268
...
Fix query tool autocomplete results when cursor is in between the SQL query. #7299
Fix an issue in query tool where custom keyboard shortcuts are not working for some. #7305
2024-03-23 18:22:06 +05:30
f351b10ed0
Fix an issue in query tool where toggle case of selected text loses selection. #7277
...
Also make changes to give pgAdmin shortcuts higher priority over CodeMirror default shortcuts.
2024-03-14 18:18:53 +05:30
794c7cb335
Fixed multiple editor related issues:
...
1. Replace option in query tool edit menu is not working on non-Mac OS. #7262
2. Format SQL shortcut and multiline selection are not working. #7268
3. "Use Spaces?" Preference of Editor is not working. #7269
2024-03-11 16:52:56 +05:30
134e651989
Added support to exclude multiple tables while taking backup. #7163
2024-03-08 11:44:29 +05:30
a5530f59f7
Fix sonarqube issues for the rule - 'If' statement should not be the only statement in 'else' block
2024-02-26 11:55:36 +05:30
29e85a6b06
Fix SonarQube issues
2024-02-22 16:54:20 +05:30
b5bd236387
Fix edit menu related issues of query tool codemirror
2024-02-21 15:54:57 +05:30
d3ede3151a
Upgrade CodeMirror from version 5 to 6. #7097
2024-02-21 11:15:25 +05:30
47b2bc8a83
1) Fix the tabbed panel backward/forward shortcut for tabs. #6808
...
2) Remove shortcuts for the dialog tab backward/forward.
3) Used hotkeys.js in place of mousetrap for listening to keyboard shortcuts.
2024-02-09 16:33:30 +05:30
f7045b58d4
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 .
2024-02-02 12:28:25 +05:30
8145e042a6
Fix a backend server error when creating a named restore point. #7166
2024-02-01 14:20:22 +05:30
cdf49d6300
Fix failing feature tests
2024-01-30 13:01:57 +05:30
028b70203c
Fix SonarQube bugs
2024-01-29 18:39:30 +05:30
4c5324bd99
Fixed API test cases for Backup.
2024-01-25 18:07:40 +05:30
639a28fbfc
Fixed code smell 'Prefer using an optional chain expression instead, as it's more concise and easier to read'.
2024-01-25 16:51:40 +05:30
41fe1db884
Fixed PEP8
2024-01-25 12:51:29 +05:30
cafe69c235
Fixed SonarQube Bugs and API test cases.
2024-01-25 12:46:55 +05:30
0e0cbc40b8
Fixed SonarQube code smell Replace the unused local variable with '_'.
2024-01-24 18:33:43 +05:30
a166f8dc89
Skip debugger test cases to fix "too many clients" error on github actions.
2024-01-18 16:41:18 +05:30
ad0567bd85
Add support for selecting a schema in the backup database dialog with no tables, mviews, views or foreign tables. #7053
...
Fixed a UI border issue on the dependencies tab for columns with icon. #7055
2024-01-12 17:19:27 +05:30
fdaedacf40
Fixed multiple CLI issues. #2483
2024-01-03 16:09:42 +05:30
5248055a01
Fixed an issue where auto commit/rollback setting not persisting across query tool connection change. #7091
2024-01-01 15:34:40 +05:30
740ce15bd7
Update copyright notices for 2024
2024-01-01 14:13:48 +05:30
2b736c18ab
Ensure that eventlet's subprocess should be used following the resolution of an issue with Python 3.12 by eventlet. #6926
2024-01-01 14:01:56 +05:30
e837de5e8f
Fixed browser autocomplete related issues on pgAdmin authentication related pages. #7082
2023-12-28 16:29:15 +05:30
ec12dc5288
Fixed the following issues found in testing #5908 :
...
1. Filter buttons remain highlighted after promotion but the button is disabled.
2. Data changes are getting committed even when Auto commit is turned off on the promoted query tool window.
2023-12-27 13:36:20 +05:30
9ccdaf73cd
Ensure that the 'Dbo' schema is displayed as a regular schema rather than a system catalog schema. #7061
2023-12-21 18:52:27 +05:30
c8d6ff8a6d
Fixed an issue where query tool title did not change after 'Save As' until any new change is made. #6193
2023-12-21 17:41:27 +05:30
0d287df6dd
Administer pgAdmin Users and Preferences Using the Command Line Interface (CLI). #2483
2023-12-21 12:07:26 +05:30
2d60bc2800
Fixed an issue where export servers was not adding extension if not specified. #6781
2023-12-20 11:36:43 +05:30
04580652ab
Allow users to convert View/Edit table into a Query tool to enable editing the SQL generated. #5908
2023-12-19 15:52:57 +05:30
4490b623f8
Fixed an issue where option key was not registering in PSQL tool. #6968
2023-12-11 11:28:33 +05:30
a01b0973fc
Fixed an issue where syntax error was not highlighting for explain query. #6887
2023-12-11 10:57:17 +05:30
51b02ae6d4
Fix few accessibility related issues. #6991
2023-12-06 11:18:23 +05:30
9cf3288934
Fixed an issue where option key was not registering in PSQL tool. #6968
2023-12-05 11:59:27 +05:30
4b71519b80
Rename all references of 'Execute query' to 'Execute script' to be more relevant. #6842
2023-12-04 12:28:53 +05:30
f2876cabe8
1. Fixed an issue where database name was missing in an error message if name contains any special characters. #6488
...
2. Add a confirmation dialog before closing a query tool when a query is already running.
2023-11-30 18:23:52 +05:30
16d1df2a1b
Fixed an issue where schema diff tool is not loading preferences on start. #7017
2023-11-30 15:31:23 +05:30
377216caec
Add support for generating ERD for a schema. #4580
2023-11-28 16:42:51 +05:30
412375af3c
- Add support for creating a function with custom return type. #6854
...
- Fixed an issue where create object dialog title was not showing object type name.
2023-11-28 15:54:44 +05:30
3bd2dec663
Fixed an issue where the Vacuum option INDEX_CLEANUP have an incorrect value ('AUTO') for database versions < 14. #6984
2023-11-28 12:32:57 +05:30
85255b65b1
1) Ensure that the Authentication Source in the drop-down of the UserManagement dialog aligns with the entries specified for AUTHENTICATION_SOURCES in the configuration file. #6950
...
2) Fixed an issue where the pgAdmin page went blank when clicking the delete button in the User Management dialog. #6989
2023-11-27 14:16:49 +05:30
b51df0e5fd
Fixed an issue where syntax error was not highlighting in query tool. #6887
2023-11-23 15:55:23 +05:30
115208c8d8
Reverse engineer serial columns when generating ERD for database/table. #6958
2023-11-23 15:50:54 +05:30
0bc044fa67
Fixed an issue where Geometry Viewer renders geometry incorrectly after trying to view 3D or non-4326 SRID geometry. #6017
2023-11-17 16:29:01 +05:30
c9db4a0d16
Add DROP SQL for foreign keys in SQL generated by ERD when using WITH DROP option. #5770
2023-11-16 16:55:26 +05:30
cc239149ba
Fixed and improve few API test cases.
2023-11-16 14:43:10 +05:30
c4a5f8d707
Fix a crash issue occurring when debugging a function with arguments when using pgAdmin with external config database. #6904
2023-11-15 17:42:58 +05:30
0ac471d160
Fix an issue where import/export data is not working for shared servers. #6875
2023-11-13 13:40:38 +05:30
85dd1e92ad
Fix issues found when testing Flask upgrade and wcDocker changes. #6479
2023-11-08 18:07:32 +05:30
ef0b30b1ca
Continue fixing multiple UI issues found when testing wcDocker changes. #6479
2023-11-06 18:08:16 +05:30
96fccd28a9
Upgrade Flask, Flask-SQLAlchemy, Flask-WTF, Flask-Babel, Flask-Security-Too, WTForms, Werkzeug and keep backward compatibility with Python 3.7
2023-11-03 18:19:01 +05:30
5f3965ff0a
1) Replace utcnow() function with datetime.now(timezone.utc) as it is deprecated from Python v3.12.
...
2) Correct the URL to log an issue in pgAdmin in the ERD tool script.
2023-11-03 16:55:24 +05:30
9eb7c1cbea
1) Ensure that eventlet's subprocess is used for Python versions up to 3.11 and await the issue resolution for Python versions 3.12.
...
2) Fixed unescape sequence for Python 3.12
2023-11-02 16:03:50 +05:30
5d70803d6d
1. Fixed an issue where psql was not taking the role used to connect in server properties. #5807
...
2. Corrected title in query tool connection link.
2023-11-02 11:00:27 +05:30
17acce3e7b
Continue fixing multiple UI issues found when testing wcDocker changes. #6479
2023-11-01 20:52:38 +05:30
0b707be615
Fixed restoration of query tool database connection after dropping and re-creating the database with the same name. #6487
2023-11-01 15:27:18 +05:30
e30d2eca90
Continue fixing multiple UI and SonarQube issues found when testing wcDocker changes. #6479
2023-10-30 16:57:01 +05:30
46a8c1ad6a
Use Python's subprocess module instead of the eventlet's subprocess as it is not working with Python v3.12
2023-10-27 17:23:33 +05:30
b11b2a2f50
Continue fixing multiple UI and SonarQube issues found when testing wcDocker changes. #6479
2023-10-27 15:51:45 +05:30
3bcac26ff9
Fix multiple UI and SonarQube issues found when testing wcDocker changes. #6479
2023-10-26 12:06:28 +05:30
c5f4a56c0c
Fixed an issue where Schema Diff does not work when the user language is set to any language other than English in Preferences. #6784
2023-10-26 11:49:55 +05:30
862f101772
Significant changes to use ReactJS extensively.
...
1. Replace the current layout library wcDocker with ReactJS based rc-dock. #6479
2. Have close buttons on individual panel tabs instead of common. #2821
3. Changes in the context menu on panel tabs - Add close, close all and close others menu items. #5394
4. Allow closing all the tabs, including SQL and Properties. #4733
5. Changes in docking behaviour of different tabs based on user requests and remove lock layout menu.
6. Fix an issue where the scroll position of panels was not remembered on Firefox. #2986
7. Reset layout now will not require page refresh and is done spontaneously.
8. Use the zustand store for storing preferences instead of plain JS objects. This will help reflecting preferences immediately.
9. The above fix incorrect format (no indent) of SQL stored functions/procedures. #6720
10. New version check is moved to an async request now instead of app start to improve startup performance.
11. Remove jQuery and Bootstrap completely.
12. Replace jasmine and karma test runner with jest. Migrate all the JS test cases to jest. This will save time in writing and debugging JS tests.
13. Other important code improvements and cleanup.
2023-10-23 17:43:17 +05:30
c07c153f15
Fix an issue where the browser window stuck on spinning with an Oauth user without email. #6874
2023-10-20 11:16:35 +05:30
6e3ee1c607
Fix an issue where servers are not listed in add new connection dialog.
2023-10-18 11:43:42 +05:30
5bb6e9133f
Fixed query history slowness issue by storing query only for those having certain threshold max length. #6666
2023-10-17 15:17:53 +05:30
b4b2a4ff67
Fix an issue where user login is not working if username/email contains single quote in server mode. #6865
2023-10-17 13:49:18 +05:30
fc411bfc49
Allow setting custom username for shared servers, with default as username of server being shared. #6229
2023-10-11 12:56:06 +05:30
6997d0149e
Fetch database objects after opening the backup dialog. #6799
2023-10-10 15:28:25 +05:30
5113fda7a6
Fix an issue where global/native keyboard shortcuts are not working when any cell of data output grid has focus. #6579 ( #6834 )
2023-10-06 13:28:16 +05:30
5d2ce142dd
Fixed an issue in ERD tool where the downloaded images have a few links cut. #4995
2023-10-04 18:23:41 +05:30
541d9dfcb4
Fix API test cases for backup dialog.
2023-09-29 14:49:11 +05:30
4050545f7c
Fixed an issue where the wrong message 'Current database has been moved or renamed' is displayed when debugging any function. #6482
2023-09-26 18:07:25 +05:30
aa973fc8ae
Added support to select/deselect objects in the Backup dialog. #642
2023-09-13 11:07:28 +05:30
edd1783353
Fixed an issue where ignore owner is not working when owner and grants both are different
2023-08-16 18:46:42 +05:30
2c81b33925
Sort parent objects as well in Schema Diff tool.
2023-08-14 17:14:58 +05:30
0e0eb3c2d5
Fixed the validation for source and target schema in schema diff tool.
2023-08-14 14:03:49 +05:30
3c43aa12af
1) Added 'Ignore Grants' option in the schema diff tool. #5759
...
2) Added 'Ignore Tablespace' option in the schema diff tool. #6004
3) Ensure that Schema Diff comparison results should be displayed in the sorted order. #6595
4) Fixed an issue where the SET directive is excluded from the function header in the schema diff tool. #6651
2023-08-11 17:38:44 +05:30
0b24a8f39a
Ensure keyboard shortcut for query execution is disabled when query execution is in progress. #6664
2023-08-09 10:49:45 +05:30
c72e2f159d
Fix the query tool issue 'pgAdminThread' object has no attribute 'native_id'. #6660
2023-08-08 11:00:52 +05:30
b55164c454
Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live. #6420
2023-08-07 17:19:08 +05:30
1a7a23de3f
Added WAL option to EXPLAIN ANALYZE command. #6382
2023-08-03 15:57:12 +05:30
0f86b78d87
Added support for PostgreSQL and EPAS 16 to ensure it works without any errors. #6588
2023-08-02 11:26:09 +05:30
a1c7265c41
Fix PEP8 issues with latest pycodestyle ( #6636 )
2023-07-31 18:14:39 +05:30
a460644ae8
1) Added support for SYSTEM, CONCURRENTLY and TABLESPACE options in REINDEX. #6381
...
2) Added new/missing options to the VACUUM command. #6397
3) Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command. #6415
2023-07-27 17:34:25 +05:30
8ec5fca4a0
Remove the 'Objects' tab from the backup dialog as the feature is not yet implemented
2023-07-24 17:30:54 +05:30
a7f06eea0b
Fix an issue where inserting more than 10 rows does not work correctly in View Data; only parts end up in the table. #6582
2023-07-24 12:49:42 +05:30
a3c3d91515
Fixed some issues in Backup and PSQL tool
2023-07-19 20:31:29 +05:30
4676961fc4
Fix multiple Query Tool, ERD title related issues.
2023-07-13 20:06:24 +05:30
75d14565e4
Fixed escape/unescape issues in Query Tool and PSQL.
2023-07-13 17:02:51 +05:30
bd4e14da89
Added new/missing parameters to pg_restore. #6562
2023-07-13 13:01:48 +05:30
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
45b1794941
1) Added extra check in qtLiteral method.
...
2) Fixed some escaping issues.
2023-07-12 15:26:19 +05:30
def1f31ba8
Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used. #6499
2023-07-11 15:34:27 +05:30
fbb43f8c3e
Align two switch controls inline for Backup Server and Backup Object dialog.
2023-07-10 18:47:07 +05:30
a08714cd65
Allow two controls to be inline in SchemaView.
2023-07-10 17:42:20 +05:30
7686280cb2
1) Added --exclude-database option for Backup Server.
...
2) Fixed Jasmine test cases.
2023-07-10 12:44:26 +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
944b614431
Fixed an issue where Import Export not working when using pgpassfile. #6165
2023-06-29 11:13:50 +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
5d619fd455
1) Fixed Schema Diff issue.
...
2) Remove unsupported versions from the get_version_mapping_directories() function.
3) Updated test cases for version template loader.
2023-06-19 18:44:55 +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
be4db5ce04
Fixed an issue where PSQL tool not working if the database name have single and double quotes #6431
2023-06-13 12:04:26 +05:30
c90f831493
Fix new code smell
2023-06-12 19:06:01 +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
6949b41fb9
Ensure that a new row should be added on top in the User Management dialog. Fixes #5817
2023-05-18 13:26:47 +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
Ashesh Vashi
Anil Sahoo
Aditya Toshniwal
Pravesh Sharma
Rohit Bhati
Khushboo Vashi
Akshay Joshi
Yogesh Mahajan
Ahmad
JyotiEdb
Florian
Nikhil Mohite
Aditya Toshniwal
San Lin Naing
Kevapo