52af8d3e49
Introduce custom React Hook useSchemaState to simplify SchemaView component. #7776
...
Changes include:
- Simplify current SchemaView code
- Add ability to reuse the schema data & state management implementation outside the SchemaDialogView component.
- Further split components in small and manageable separate files.
- Removed the 'DepListenerContext' context as there was no need for separate context.
- Added a reload functionality in the 'useSchemaState'
- Changes in feature tests.
2024-08-02 09:59:01 +05:30
c6e7ce03cc
Upgrade react-data-grid fork to latest and change pgAdmin accordingly. #7705
2024-07-31 19:12:36 +05:30
1eb07608e9
Ensure processes related notifiers disappears. #7219
2024-07-17 13:07:52 +05:30
a06c13623d
Fixed an issue where theme preview under theme options was broken in pgAdmin server mode. #7626
2024-07-16 10:25:48 +05:30
6b012193e3
Pin Psycopg Binary packages to 3.1.19 for the ARM64 MacOS platform wheel packages.
2024-07-10 17:43:13 +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
4f415f9768
Added support for viewing PostgreSQL Server Logs in Text, CSV and JSON formats. #3981
2024-07-03 16:17:29 +05:30
f8fa1cf6d6
- Fix few SonarQube issues.
...
- Cleanup NW.js related stuff.
2024-07-02 10:34:30 +05:30
91eb60a363
Replace pgAdmin NW.js container with Electron container. #7494
2024-07-01 11:27:42 +05:30
31a91409a0
Fixed incorrect sorting of size in statistics tab. #7542
2024-06-19 18:27:43 +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
5866da8194
Fixed SonarQube code smells.
2024-06-13 18:48:02 +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
6357672387
Provide an option to set the theme based on the OS theme. #5932
2024-06-12 16:18:37 +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
cc999ae5a5
Remove the usage of MUI makeStyles as it doesn't support React 18. #7363
2024-06-06 17:13:12 +05:30
29a526626f
Fixed an issue where the size displayed as 'NaN B' for all databases in the statistics tab. #7524
2024-06-03 17:10:11 +05:30
5c30695d66
Fixed Typos
2024-05-23 12:52:41 +05:30
dd45f06d50
Added support for viewing PGD Clusters. #7215
2024-05-20 16:54:49 +05:30
5ec6faff13
Upgrade react-table from v7 to v8. #7419
2024-05-07 16:31:04 +05:30
f4761f55f7
Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215). #7425
2024-04-29 13:41:02 +05:30
7c6fdcb12e
Disabled auto-fill on password fields. #2410
2024-04-29 11:44:17 +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
fbbbfe22dd
Fixed a remote code execution issue in the validate binary path (CVE-2024-3116). #7326
2024-04-01 11:34:01 +05:30
ace73ebb60
Added support for viewing Log Based Clusters. #7216
...
Co-authored-by: Akshay Joshi <akshay.joshi@enterprisedb.com>
2024-03-28 12:19:34 +05:30
097b630738
Added support for EDB Job Scheduler. #7098
2024-03-18 11:53:59 +05:30
43f4cc4e17
Fix an issue where type column in dependencies tab is not showing correct label. #7225
2024-02-26 11:59:30 +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
d3ede3151a
Upgrade CodeMirror from version 5 to 6. #7097
2024-02-21 11:15:25 +05:30
721290b1e9
Fix an issue where type column in dependents/dependencies tab is not showing correct label. #7225
2024-02-20 16:23:05 +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
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
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
0e0cbc40b8
Fixed SonarQube code smell Replace the unused local variable with '_'.
2024-01-24 18:33:43 +05:30
30509d1bc1
Added copy server support, allowing the duplication of existing servers with the option to make certain modifications. #6085 ( #7106 )
...
Added copy server support, allowing the duplication of existing servers with the option to make certain modifications. #6085
2024-01-08 12:16:49 +05:30
740ce15bd7
Update copyright notices for 2024
2024-01-01 14:13:48 +05:30
a4e9f04a2e
Fixed an issue where changes done to a node using edit dialog are not reflecting on the properties tab if the properties tab is active. #7041
2023-12-27 11:06:04 +05:30
338bb64a55
Fixed an issue where reading process logs throws an error when DATA_DIR is moved to a networked drive. #6803
2023-11-23 16:32:52 +05:30
19cbe8c39f
More fixes related to rc-dock changes. #6479
2023-11-20 17:45:17 +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
75a2d880f6
More fixes for UI issues found when testing wcDocker changes. #6479
2023-11-14 16:47:40 +05:30
0d8adf9ced
Ensure backup/restore/maintenance works with invalid pgpass file parameter. #6820
2023-11-06 18:02:52 +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
17acce3e7b
Continue fixing multiple UI issues found when testing wcDocker changes. #6479
2023-11-01 20:52:38 +05:30
a8a7574e69
Fixed circular import error occurring while deploying cloud PostgreSQL instance from pgAdmin. #6840
...
Update AWS, Google Cloud lib version.
2023-10-31 14:07:34 +05:30
e30d2eca90
Continue fixing multiple UI and SonarQube issues found when testing wcDocker changes. #6479
2023-10-30 16:57:01 +05:30
4bc6dcca67
Fix the sorting of size on the statistics panel. #6459
2023-10-30 11:23:46 +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
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
35f05e49b3
Fix the security issue of validate bin path to consider and fix more scenarios. #6763
2023-09-20 11:17:07 +05:30
02ecc82e73
Fix a security related issue where an authenticated user can run remote command using validate binary path API (CVE-2023-5002). #6763 ( #6764 )
2023-09-18 14:01:11 +05:30
a1c7265c41
Fix PEP8 issues with latest pycodestyle ( #6636 )
2023-07-31 18:14:39 +05:30
39d70a94a6
Ensure user gets proper error if incorrect credentials are entered while authenticating AWS. #6406
2023-07-20 16:56:17 +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
16a0950f63
Fix an issue where adding a sub-folder inside a folder is not working as expected. #6544
2023-07-10 18:32:21 +05:30
cb7fd7106c
Enable cluster deployment with gp3 volume for AWS & BigAnimal cloud providers. #6323
2023-07-10 11:22:24 +05:30
557f33c4f9
Added support to drop databases using the 'WITH (FORCE)' option. #6367
2023-06-19 15:04:40 +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
7e3a932890
Fixed SonarQube Bugs
2023-06-09 15:28:46 +05:30
87c1023c4f
Use dependent instead of dependant in the message. #6278
2023-05-22 11:38:19 +05:30
8428df97ca
Fixed the error occurring while postgresql cloud instance deployment on AWS RDS.
2023-04-28 15:16:22 +05:30
ed941b5b95
Fix a SQL error occurring on roles dependents SQL. #6128
2023-04-20 10:18:00 +05:30
48839983fd
Updated config file documentation for shared storage and While doing save as operation, ensure the error message is shown if access is restricted in shared storage #5014
2023-03-29 13:49:32 +05:30
fc0e36b313
Removed old path library used to validate client secret path while google authentication. #5750
2023-03-28 11:27:16 +05:30
501bff6f7a
Ensure google authentication can be completed successfully, while pgAdmin is running in behind proxy servers. #5750
2023-03-28 11:07:41 +05:30
b429a38176
Fixed shared storage file accessibility issues in import/export servers and cloud deployment. #5014
2023-03-24 16:27:02 +05:30
40013fb26c
Added support of BigAnimal v3 API. #5805
2023-03-24 16:07:02 +05:30
58aca506fe
Fixed error occurring while authentication in Google Cloud SQL deployment wizard in server mode. #5750
2023-03-24 15:50:37 +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
a026353df8
Fixed the UI related issues reported during testing for Google Cloud SQL deployment. #5750
2023-03-23 11:51:21 +05:30
1b327d1997
Fix issues reported during testing. #5750
2023-03-20 18:22:16 +05:30
a9399030f4
Fixed issue where pgAgent jobs were not getting dropped from properties tab #5834
2023-03-17 17:43:42 +05:30
63c7d14638
Added capability to deploy PostgreSQL servers on Google Cloud. #5750
2023-03-13 14:56:16 +05:30
79de2ad571
Fixed jasmine test cases.
2023-03-08 11:20:39 +05:30
9da8a188fa
Added support for mounting shared storage in server mode. #5014
2023-03-06 17:03:47 +05:30
7a4951f211
Remove dependency on simplejson package.
2023-02-15 11:10:12 +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
7a18ceab64
Fixed the server heartbeat logging issue when server is removed. #5567
2023-01-30 15:39:34 +05:30
a7cf698d09
1) Added support for setting PostgreSQL connection parameters. #4728
...
2) Fixed an issue where Kerberos authentication to the server is not imported/exported. #5732
3) Increase the length of the value column of the setting table. #5746
4) Upgrade Flask-Migrate to 4.0.0. #5525
2023-01-23 17:19:59 +05:30
6ae91592d1
Fix orphan database connections resulting in an inability to connect to databases. #5567
2023-01-19 15:57:02 +05:30
53ae657cc9
Fix menu closing issue on file manager. #5615
...
Fix file path issue in import/export servers caused due to vulnerability fix.
2023-01-16 19:28:23 +05:30
9ff015e73c
Added support of AWS provider for BigAnimal cloud deployment. #5569
2023-01-09 12:32:26 +05:30
98184e5835
Update copyright notices for 2023
2023-01-02 11:53:55 +05:30
5d9bcde50d
Fix BigAnimal API v2 compatibility issue for checking the cluster creation permission.
2022-12-21 18:22:05 +05:30
799b6d8f7c
Use the login_required decorator in the appropriate place. #5593
2022-12-13 16:26:35 +05:30
d9fba3a186
Ignore SQLAlchemy vulnerability as it is ignored by the upstream too.
...
Fix BigAnimal database versions by type. #5637
2022-12-13 15:57:43 +05:30
bb07d36963
Fixed BigAnimal authentication aborted issue. #5629
2022-12-12 14:23:25 +05:30
2fca1033a0
Ensure that table statistics are sorted by size. #5564
2022-12-05 10:50:45 +05:30
461849c276
Ensure that only authorized and authenticated users can validate binary paths (CVE-2022-4223). #5593
2022-11-30 12:02:45 +05:30
a824d9dd59
Improved error message to make it easier for users to understand. #5539
2022-11-29 18:15:46 +05:30
6442854fb5
Update the BigAnimal API version to V2. #5147
2022-11-24 10:49:42 +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
e17c50d304
Added support for storing configurations of pgAdmin in an external database. #1832
2022-10-20 16:18:41 +05:30
Ashesh Vashi
Aditya Toshniwal
Yogesh Mahajan
Pravesh Sharma
Khushboo Vashi
Akshay Joshi
Ahmad
Nikhil Mohite
San Lin Naing
Matěj Cepl
Mark Mayo