8cf316b853
Fixed some of the issues reported due to introduction of the custom hook 'useSchemaState'. #7776
2024-08-19 09:53:00 +05:30
b00ea3cd99
Update release notes.
2024-08-14 11:12:30 +05:30
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
636c224bd0
Updated JavaScript and Python packages according to Dependabot recommendations
2024-07-29 19:34:43 +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
3bb9f0ba8c
Remove support for Python 3.7 as Debian 10 is EOL.
2024-07-01 12:39:12 +05:30
754cd223c1
Python dependency: Bump selenium in /web/regression
...
Bumps [selenium](https://github.com/SeleniumHQ/Selenium ) from 4.21.0 to 4.22.0.
- [Release notes](https://github.com/SeleniumHQ/Selenium/releases )
- [Commits](https://github.com/SeleniumHQ/Selenium/compare/selenium-4.21.0...selenium-4.22.0 )
---
updated-dependencies:
- dependency-name: selenium
dependency-type: direct:production
update-type: version-update:semver-minor
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-06-27 13:23:57 +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
007c4840c2
Fix failing feature tests
2024-06-18 14:02:23 +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
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
056aff4742
Revert the changes done for removing support for Python 3.7
2024-06-12 16:23:27 +05:30
bc3052ed1b
Python dependency: Bump testtools from 2.7.1 to 2.7.2 in /web/regression
...
Bumps [testtools](https://github.com/testing-cabal/testtools ) from 2.7.1 to 2.7.2.
- [Release notes](https://github.com/testing-cabal/testtools/releases )
- [Changelog](https://github.com/testing-cabal/testtools/blob/master/NEWS )
- [Commits](https://github.com/testing-cabal/testtools/compare/2.7.1...2.7.2 )
---
updated-dependencies:
- dependency-name: testtools
dependency-type: direct:production
update-type: version-update:semver-patch
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-06-12 11:44:31 +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
b3cf9ce185
Unpin dnspython from 'regression/requirements.txt' as eventlet issue is fixed.
2024-06-07 17:52:46 +05:30
18deb16e36
Python dependency: Bump pbr from 5.11.1 to 6.0.0 in /web/regression
...
Bumps [pbr](https://docs.openstack.org/pbr/latest/ ) from 5.11.1 to 6.0.0.
---
updated-dependencies:
- dependency-name: pbr
dependency-type: direct:production
update-type: version-update:semver-major
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-06-07 16:53:22 +05:30
bc1a2a0b4d
Python dependency: Bump selenium in /web/regression
...
Bumps [selenium](https://github.com/SeleniumHQ/Selenium ) from 4.19.0 to 4.21.0.
- [Release notes](https://github.com/SeleniumHQ/Selenium/releases )
- [Commits](https://github.com/SeleniumHQ/Selenium/compare/selenium-4.19.0...selenium-4.21.0 )
---
updated-dependencies:
- dependency-name: selenium
dependency-type: direct:production
update-type: version-update:semver-minor
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-06-07 16:39:53 +05:30
c6739ebd6b
Python dependency: Bump dnspython from 2.3.0 to 2.6.1 in /web/regression
...
Bumps [dnspython](https://github.com/rthalley/dnspython ) from 2.3.0 to 2.6.1.
- [Release notes](https://github.com/rthalley/dnspython/releases )
- [Changelog](https://github.com/rthalley/dnspython/blob/main/doc/whatsnew.rst )
- [Commits](https://github.com/rthalley/dnspython/compare/v2.3.0...v2.6.1 )
---
updated-dependencies:
- dependency-name: dnspython
dependency-type: direct:production
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-06-06 18:11:47 +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
6690b16f8a
Added support for executing the query at the cursor position in the query tool. #6841
2024-05-27 16:11:59 +05:30
dd45f06d50
Added support for viewing PGD Clusters. #7215
2024-05-20 16:54:49 +05:30
d6a9f8a06c
Fixed issues found in testing of react-table upgrade changes. #7419
...
UI fixes and improvement in System Stats Dashboard.
2024-05-20 10:41:55 +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
e18a8bf620
Fixed issue found during testing of #7163 .
2024-04-29 13:12:21 +05:30
db23330939
Python dependency: Bump selenium in /web/regression ( #7325 )
...
Bumps [selenium](https://github.com/SeleniumHQ/Selenium ) from 4.10.0 to 4.19.0.
- [Release notes](https://github.com/SeleniumHQ/Selenium/releases )
- [Commits](https://github.com/SeleniumHQ/Selenium/compare/selenium-4.10.0...selenium-4.19.0 )
---
updated-dependencies:
- dependency-name: selenium
dependency-type: direct:production
update-type: version-update:semver-minor
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-04-18 14:03:28 +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
c0a1429664
Fix failing feature tests
2024-03-26 11:20:04 +05:30
097b630738
Added support for EDB Job Scheduler. #7098
2024-03-18 11:53:59 +05:30
7374997425
Fix an issue in table dialog where changing column name was not syncing table constraints appropriately. #7229
2024-03-08 11:45:32 +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
5a74022e8a
Allow preferences customization using a configuration file. #6058
2024-02-15 14:58:31 +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
6d399f4fd7
Explicitly set max_connections to 100 for Python test cases to fit Git action MacOS test cases
2023-12-25 12:04:10 +05:30
0d287df6dd
Administer pgAdmin Users and Preferences Using the Command Line Interface (CLI). #2483
2023-12-21 12:07:26 +05:30
a22b2a6074
Added keep-alive support for SSH sessions when connecting to a PostgreSQL server via an SSH tunnel. #7016
2023-12-19 16:16:03 +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
adab656a79
Fixes for Python 3.12 compatibility:
...
- Upgrade testtools package
- Use platstdlib instead of stdlib to get the path
2023-12-18 13:27:05 +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
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
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
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
6ba9c192ce
Fix failing JS test cases after scale related commit. #6851
2023-10-11 16:31:02 +05:30
5981f4bd13
In GUI tests, do not try to set the binary path in preferences if it is blank
2023-10-09 12:42:52 +05:30
3cd547f879
Implement column node and its features for foreign table. #640 , #6373 , #6674
2023-09-26 15:03:03 +05:30
aa973fc8ae
Added support to select/deselect objects in the Backup dialog. #642
2023-09-13 11:07:28 +05:30
a43b70e360
1. Added USING method while creating the table. #6378
...
2. Added USING method while creating the materialized view. #6400
2023-09-06 11:22:30 +05:30
c0b868b53b
Added Strategy, Locale Provider, ICU Locale, ICU Rules, and OID options while creating a database. #6383
2023-09-04 16:03:06 +05:30
77467209c2
1) Added release note for v7.7
...
2) Added exception handling while removing the test database file.
2023-08-25 11:14:54 +05:30
34f160cec7
Allow changing the POOL_SIZE and MAX_OVERFLOW config values of the pgAdmin config DB connection pool. #6208
2023-08-16 15:29:11 +05:30
27c7ea2ff1
Added all like options while creating a table. #6377
2023-08-07 11:20:04 +05:30
3ba73ab1d9
Update axios to the current latest version(1.4.0)
2023-08-01 13:04:06 +05:30
7d7b8a71c1
1. Added Expression to CREATE INDEX. #2595
...
2. Added support for ALTER INDEX column statistics. #6375
2023-08-01 12:37:47 +05:30
9ab36b0269
Fixed PEP8
2023-07-27 18:18:39 +05:30
b4e6d8c6d7
1) Fixed feature tests failed due to maintenance changes.
...
2) Update release note.
2023-07-27 18:15:36 +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
9f35728c6a
Pin dnspython==2.3.0 to fix test cases.
2023-07-19 17:59:34 +05:30
58cd21686b
Handle the intermittent failure for query tool test.
2023-07-13 19:03:16 +05:30
bd4e14da89
Added new/missing parameters to pg_restore. #6562
2023-07-13 13:01:48 +05:30
7686280cb2
1) Added --exclude-database option for Backup Server.
...
2) Fixed Jasmine test cases.
2023-07-10 12:44:26 +05:30
62056cab14
Fixed sonaqube security smells and bugs
...
1. Delete unreachable code or refactor the code to make it reachable.
2. Unexpected var, use let or const instead.
3. Remove useless assignment to variable.
4. Define a constant instead of duplicating the literal
5. Remove commented out code
2023-07-10 10:36:15 +05:30
d6cddd8c29
Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS. #6295
2023-06-30 16:08:33 +05:30
557f33c4f9
Added support to drop databases using the 'WITH (FORCE)' option. #6367
2023-06-19 15:04:40 +05:30
eef295f9d8
Fixed feature tests failing due to selenium upgrade to 4.10.0.
2023-06-19 11:43:28 +05:30
b8377be1b5
Pin selenium=4.9.1 as latest version having some issues.
2023-06-15 17:58:08 +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
745a91393c
Fix JS test cases and other JS build issues caused due to dependabot updates.
2023-06-09 18:22:20 +05:30
22f2ac0507
Python dependency: Bump coverage from 7.2.3 to 7.2.7 in /web/regression ( #6413 )
...
Bumps [coverage](https://github.com/nedbat/coveragepy ) from 7.2.3 to 7.2.7.
- [Release notes](https://github.com/nedbat/coveragepy/releases )
- [Changelog](https://github.com/nedbat/coveragepy/blob/master/CHANGES.rst )
- [Commits](https://github.com/nedbat/coveragepy/compare/7.2.3...7.2.7 )
---
updated-dependencies:
- dependency-name: coverage
dependency-type: direct:production
update-type: version-update:semver-patch
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-06-09 17:26:13 +05:30
e385aec7f7
Python dependency: Bump fixtures from 4.0.1 to 4.1.0 in /web/regression ( #6410 )
...
Bumps [fixtures](https://github.com/testing-cabal/fixtures ) from 4.0.1 to 4.1.0.
- [Changelog](https://github.com/testing-cabal/fixtures/blob/master/NEWS )
- [Commits](https://github.com/testing-cabal/fixtures/compare/4.0.1...4.1.0 )
---
updated-dependencies:
- dependency-name: fixtures
dependency-type: direct:production
update-type: version-update:semver-minor
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-06-09 17:24:43 +05:30
c42e00a090
Python dependency: Bump selenium from 4.9.1 to 4.10.0 in /web/regression ( #6409 )
...
Bumps [selenium](https://github.com/SeleniumHQ/Selenium ) from 4.9.1 to 4.10.0.
- [Release notes](https://github.com/SeleniumHQ/Selenium/releases )
- [Commits](https://github.com/SeleniumHQ/Selenium/compare/selenium-4.9.1...selenium-4.10.0 )
---
updated-dependencies:
- dependency-name: selenium
dependency-type: direct:production
update-type: version-update:semver-minor
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-06-09 17:23:39 +05:30
7e3a932890
Fixed SonarQube Bugs
2023-06-09 15:28:46 +05:30
05eb956aab
Python dependency: Bump selenium from 4.8.3 to 4.9.1 in /web/regression ( #6265 )
...
Bumps [selenium](https://github.com/SeleniumHQ/Selenium ) from 4.8.3 to 4.9.1.
- [Release notes](https://github.com/SeleniumHQ/Selenium/releases )
- [Commits](https://github.com/SeleniumHQ/Selenium/commits/selenium-4.9.1 )
---
updated-dependencies:
- dependency-name: selenium
dependency-type: direct:production
update-type: version-update:semver-minor
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-06-02 10:53:00 +05:30
05b595d32d
Fixed the failure of python test cases of EPAS and JS tests for publication node. #5868
2023-05-29 17:41:45 +05:30
8b7eeca545
Implement new PostgreSQL 15 features in publication dialog and SQL. #5868
2023-05-25 16:25:12 +05:30
8ea3346a9d
Handle SQL_ASCII databases when running test cases.
...
* Handle cases when psycopg returns bytes instead of a string.
See https://github.com/psycopg/psycopg/issues/561
* A more appropriate fix, suggested by Daniele Varrazzo
* Fix typo.
* Re-think this check. Our own driver effectively monkey-patches the psycopg encoding mappings.
2023-05-16 09:20:01 +05:30
cad4c6b8af
Fix feature tests for the database versions 11, 12 and 13, broken due to multirange data types support.
2023-05-15 11:42:17 +05:30
2a22cf077c
Fix circular reference error for the multirange data types in the query tool. #6221
...
Add support for the multirange data types.
2023-05-10 10:32:47 +05:30
eb1c36bf5b
Add extension .md to regression/README
2023-05-05 14:03:31 +05:30
1e7517dc98
Show object breadcrumbs path along with its comment on object hover. #2078
2023-04-26 11:18:16 +05:30
05938fa6e1
Update yarn.lock to support latest version of yarn
2023-04-25 12:27:55 +05:30
4c2ae44e4c
Attempt to fix failing JS test cases with error related to ERD.
2023-04-24 18:04:02 +05:30
7e2add8db1
Python test famework should log only relevant exception and exit with a non-zero code on error. #6157
2023-04-20 13:33:17 +05:30
569bf4d5a2
Python dependency: Bump coverage from 7.2.2 to 7.2.3 in /web/regression ( #6103 )
...
Bumps [coverage](https://github.com/nedbat/coveragepy ) from 7.2.2 to 7.2.3.
- [Release notes](https://github.com/nedbat/coveragepy/releases )
- [Changelog](https://github.com/nedbat/coveragepy/blob/master/CHANGES.rst )
- [Commits](https://github.com/nedbat/coveragepy/compare/7.2.2...7.2.3 )
---
updated-dependencies:
- dependency-name: coverage
dependency-type: direct:production
update-type: version-update:semver-patch
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-04-17 12:23:36 +05:30
686f52f636
Do not treat database deletion errors as Feature test failures.
2023-04-17 11:47:08 +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
a18d469c90
Fix an issue in search objects where objects were unable to locate occasionally. #5916
2023-04-04 18:29:54 +05:30
dfa367a127
Fixed video recording broken for feature tests due to selenium package update.
2023-04-03 15:28:42 +05:30
6710969143
Rename 'Edit Object..' context menu back to 'Properties...'. #4734
2023-04-03 13:10:24 +05:30
33953e9119
Fixed intermittent error "Connection Lost" shown while connecting to database.
2023-03-31 16:17:04 +05:30
Ashesh Vashi
Aditya Toshniwal
Ashesh Vashi
Akshay Joshi
Pravesh Sharma
Khushboo Vashi
dependabot[bot]
Yogesh Mahajan
Anil Sahoo
Nikhil Mohite
Aditya Toshniwal
Anil Sahoo
Dave Page