[pgadmin-org/pgadmin4] 115d4a: Fix security hotspots reported by Sonarqube.
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 115d4afd9e0242db6717025c86df46b7b6a1f9d3 https://github.com/pgadmin-org/pgadmin4/commit/115d4afd9e0242db6717025c86df46b7b6a1f9d3 Author: Khushboo Vashi Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M docs/en_US/release_notes_7_5.rst M web/pgadmin/utils/driver/psycopg3/connection.py Log Message: --- Fix security hotspots reported by Sonarqube.
[pgadmin-org/pgadmin4] 768628: 1) Added --exclude-database option for Backup Server.
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 7686280cb2ae37278901051aa9c14da5697fa021 https://github.com/pgadmin-org/pgadmin4/commit/7686280cb2ae37278901051aa9c14da5697fa021 Author: Akshay Joshi Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M docs/en_US/backup_server_dialog.rst M web/pgadmin/tools/backup/__init__.py M web/pgadmin/tools/backup/static/js/backup.ui.js M web/pgadmin/tools/backup/tests/test_backup_create_job_unit_test.py M web/regression/javascript/schema_ui_files/backup.ui.spec.js Log Message: --- 1) Added --exclude-database option for Backup Server. 2) Fixed Jasmine test cases.
[pgadmin-org/pgadmin4] a08714: Allow two controls to be inline in SchemaView.
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: a08714cd6548e5463c0b4f79fde8566407f5389c https://github.com/pgadmin-org/pgadmin4/commit/a08714cd6548e5463c0b4f79fde8566407f5389c Author: Aditya Toshniwal Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M web/pgadmin/static/js/SchemaView/FieldSetView.jsx M web/pgadmin/static/js/SchemaView/FormView.jsx M web/pgadmin/static/js/SchemaView/MappedControl.jsx M web/pgadmin/static/js/components/FormComponents.jsx M web/pgadmin/tools/backup/static/js/backup.ui.js Log Message: --- Allow two controls to be inline in SchemaView.
[pgadmin-org/pgadmin4] 16a095: Fix an issue where adding a sub-folder inside a fo...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 16a0950f63594d6f26ce7ab218f6ccb222e573dc https://github.com/pgadmin-org/pgadmin4/commit/16a0950f63594d6f26ce7ab218f6ccb222e573dc Author: San Lin Naing Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M web/pgadmin/misc/file_manager/__init__.py Log Message: --- Fix an issue where adding a sub-folder inside a folder is not working as expected. #6544
[pgadmin-org/pgadmin4] 613002: Update release notes
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 613002c4174bba852a898e39fd0ed51206e66068 https://github.com/pgadmin-org/pgadmin4/commit/613002c4174bba852a898e39fd0ed51206e66068 Author: Aditya Toshniwal Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M docs/en_US/release_notes_7_5.rst Log Message: --- Update release notes
[pgadmin-org/pgadmin4] fbb43f: Align two switch controls inline for Backup Server...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: fbb43f8c3e2c36bcfaa3d51e21c3d0ec142cfd6b https://github.com/pgadmin-org/pgadmin4/commit/fbb43f8c3e2c36bcfaa3d51e21c3d0ec142cfd6b Author: Akshay Joshi Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M web/pgadmin/tools/backup/static/js/backup.ui.js Log Message: --- Align two switch controls inline for Backup Server and Backup Object dialog.
[pgadmin-org/pgadmin4] ecf29c: Python dependency: Update botocore requirement in ...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: ecf29c5be948900d8c9784d8db76449471a6d6bf https://github.com/pgadmin-org/pgadmin4/commit/ecf29c5be948900d8c9784d8db76449471a6d6bf Author: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Date: 2023-07-11 (Tue, 11 Jul 2023) Changed paths: M requirements.txt Log Message: --- Python dependency: Update botocore requirement in /web/regression (#6541) Updates the requirements on [botocore](https://github.com/boto/botocore) to permit the latest version. - [Changelog](https://github.com/boto/botocore/blob/develop/CHANGELOG.rst) - [Commits](https://github.com/boto/botocore/compare/1.29.0...1.31.0) --- updated-dependencies: - dependency-name: botocore dependency-type: direct:production ... Signed-off-by: dependabot[bot] Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
[pgadmin-org/pgadmin4]
Branch: refs/heads/dependabot/pip/web/regression/botocore-eq-1.31.star Home: https://github.com/pgadmin-org/pgadmin4
[pgadmin-org/pgadmin4] 1e9b1c: Python dependency: Bump semver from 5.7.1 to 5.7.2...
Branch: refs/heads/dependabot/npm_and_yarn/runtime/semver-5.7.2 Home: https://github.com/pgadmin-org/pgadmin4 Commit: 1e9b1cfcfbe663e99935510a2ba7cad4bc3a7328 https://github.com/pgadmin-org/pgadmin4/commit/1e9b1cfcfbe663e99935510a2ba7cad4bc3a7328 Author: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Date: 2023-07-11 (Tue, 11 Jul 2023) Changed paths: M runtime/yarn.lock Log Message: --- Python dependency: Bump semver from 5.7.1 to 5.7.2 in /runtime Bumps [semver](https://github.com/npm/node-semver) from 5.7.1 to 5.7.2. - [Release notes](https://github.com/npm/node-semver/releases) - [Changelog](https://github.com/npm/node-semver/blob/v5.7.2/CHANGELOG.md) - [Commits](https://github.com/npm/node-semver/compare/v5.7.1...v5.7.2) --- updated-dependencies: - dependency-name: semver dependency-type: indirect ... Signed-off-by: dependabot[bot]
[pgadmin-org/pgadmin4] d13e02: Python dependency: Update pillow requirement in /w...
Branch: refs/heads/dependabot/pip/web/regression/pillow-eq-10.star Home: https://github.com/pgadmin-org/pgadmin4 Commit: d13e024ff9b09dde8b0bd3295fdffca4c89b349a https://github.com/pgadmin-org/pgadmin4/commit/d13e024ff9b09dde8b0bd3295fdffca4c89b349a Author: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Date: 2023-07-11 (Tue, 11 Jul 2023) Changed paths: M requirements.txt Log Message: --- Python dependency: Update pillow requirement in /web/regression Updates the requirements on [pillow](https://github.com/python-pillow/Pillow) to permit the latest version. - [Release notes](https://github.com/python-pillow/Pillow/releases) - [Changelog](https://github.com/python-pillow/Pillow/blob/main/CHANGES.rst) - [Commits](https://github.com/python-pillow/Pillow/compare/9.0.0...10.0.0) --- updated-dependencies: - dependency-name: pillow dependency-type: direct:production ... Signed-off-by: dependabot[bot]
[pgadmin-org/pgadmin4] 8744b2: Python dependency: Update cryptography requirement...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 8744b29edff77a942b4887b096f8a5d9edcd10d0 https://github.com/pgadmin-org/pgadmin4/commit/8744b29edff77a942b4887b096f8a5d9edcd10d0 Author: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Date: 2023-07-11 (Tue, 11 Jul 2023) Changed paths: M requirements.txt Log Message: --- Python dependency: Update cryptography requirement (#6404) Updates the requirements on [cryptography](https://github.com/pyca/cryptography) to permit the latest version. - [Changelog](https://github.com/pyca/cryptography/blob/main/CHANGELOG.rst) - [Commits](https://github.com/pyca/cryptography/compare/40.0.0...41.0.1) --- updated-dependencies: - dependency-name: cryptography dependency-type: direct:production ... Signed-off-by: dependabot[bot] Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
[pgadmin-org/pgadmin4]
Branch: refs/heads/dependabot/pip/cryptography-eq-41.0.star Home: https://github.com/pgadmin-org/pgadmin4
[pgadmin-org/pgadmin4] 21b81f: Python dependency: Bump psycopg[c] from 3.1.8 to 3...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 21b81f7999fd95a8679bd8eb113458660637fb62 https://github.com/pgadmin-org/pgadmin4/commit/21b81f7999fd95a8679bd8eb113458660637fb62 Author: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Date: 2023-07-11 (Tue, 11 Jul 2023) Changed paths: M requirements.txt Log Message: --- Python dependency: Bump psycopg[c] from 3.1.8 to 3.1.9 (#6240) Bumps [psycopg[c]](https://github.com/psycopg/psycopg) from 3.1.8 to 3.1.9. - [Release notes](https://github.com/psycopg/psycopg/releases) - [Changelog](https://github.com/psycopg/psycopg/blob/master/docs/news.rst) - [Commits](https://github.com/psycopg/psycopg/compare/3.1.8...3.1.9) --- updated-dependencies: - dependency-name: psycopg[c] dependency-type: direct:production update-type: version-update:semver-patch ... Signed-off-by: dependabot[bot] Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
[pgadmin-org/pgadmin4]
Branch: refs/heads/dependabot/pip/psycopg-c--3.1.9 Home: https://github.com/pgadmin-org/pgadmin4
[pgadmin-org/pgadmin4] 9aa116: 1) Added new/missing parameters to pg_dumpall (Bac...
Branch: refs/heads/dependabot/pip/web/regression/boto3-eq-1.28.star Home: https://github.com/pgadmin-org/pgadmin4 Commit: 9aa116bf3f8bdb712d1ee7f26a8f3ae72aa8b312 https://github.com/pgadmin-org/pgadmin4/commit/9aa116bf3f8bdb712d1ee7f26a8f3ae72aa8b312 Author: Akshay Joshi Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M docs/en_US/backup_dialog.rst M docs/en_US/backup_server_dialog.rst M docs/en_US/release_notes_7_5.rst M web/pgadmin/tools/backup/__init__.py M web/pgadmin/tools/backup/static/js/backup.js M web/pgadmin/tools/backup/static/js/backup.ui.js M web/pgadmin/tools/backup/tests/test_backup_create_job_unit_test.py M web/pgadmin/tools/sqleditor/command.py Log Message: --- 1) Added new/missing parameters to pg_dumpall (Backup Server). #6416 2) Added new/missing parameters to pg_dump (Backup Objects). #6417 Commit: 62056cab14e52017dd3a4c9a81ccc5a36508da65 https://github.com/pgadmin-org/pgadmin4/commit/62056cab14e52017dd3a4c9a81ccc5a36508da65 Author: Pravesh Sharma Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M runtime/src/js/pgadmin.js M web/pgadmin/__init__.py M web/pgadmin/authenticate/mfa/authenticator.py M web/pgadmin/browser/server_groups/servers/databases/casts/static/js/cast.ui.js M web/pgadmin/browser/server_groups/servers/databases/publications/__init__.py M web/pgadmin/browser/server_groups/servers/databases/schemas/domains/static/js/domain.ui.js M web/pgadmin/browser/server_groups/servers/databases/schemas/synonyms/static/js/synonym.ui.js M web/pgadmin/browser/server_groups/servers/static/js/server.js M web/pgadmin/static/js/pgadmin.js M web/regression/javascript/SecurityPages/ForgotPasswordPage.spec.js M web/regression/javascript/SecurityPages/LoginPage.spec.js M web/regression/javascript/SecurityPages/MfaRegisterPage.spec.js M web/regression/javascript/SecurityPages/MfaValidatePage.spec.js M web/regression/javascript/SecurityPages/PasswordResetPage.spec.js Log Message: --- 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 Commit: cb7fd7106c87a040c37d4ed669dee8af6abef381 https://github.com/pgadmin-org/pgadmin4/commit/cb7fd7106c87a040c37d4ed669dee8af6abef381 Author: Yogesh Mahajan Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M docs/en_US/cloud_edb_biganimal.rst M docs/en_US/images/cloud_biganimal_instance.png M web/pgacloud/providers/aws.py M web/pgacloud/providers/biganimal.py M web/pgadmin/misc/cloud/biganimal/__init__.py M web/pgadmin/misc/cloud/rds/__init__.py M web/pgadmin/misc/cloud/static/js/aws.js M web/pgadmin/misc/cloud/static/js/aws_schema.ui.js M web/pgadmin/misc/cloud/static/js/biganimal.js M web/pgadmin/misc/cloud/static/js/biganimal_schema.ui.js Log Message: --- Enable cluster deployment with gp3 volume for AWS & BigAnimal cloud providers. #6323 Commit: a6b8b7bfa9d78c1103787f78ab8b4f58f8746c5f https://github.com/pgadmin-org/pgadmin4/commit/a6b8b7bfa9d78c1103787f78ab8b4f58f8746c5f Author: Khushboo Vashi Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M docs/en_US/release_notes_7_5.rst Log Message: --- Update release notes. Commit: 115d4afd9e0242db6717025c86df46b7b6a1f9d3 https://github.com/pgadmin-org/pgadmin4/commit/115d4afd9e0242db6717025c86df46b7b6a1f9d3 Author: Khushboo Vashi Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M docs/en_US/release_notes_7_5.rst M web/pgadmin/utils/driver/psycopg3/connection.py Log Message: --- Fix security hotspots reported by Sonarqube. Commit: 7686280cb2ae37278901051aa9c14da5697fa021 https://github.com/pgadmin-org/pgadmin4/commit/7686280cb2ae37278901051aa9c14da5697fa021 Author: Akshay Joshi Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M docs/en_US/backup_server_dialog.rst M web/pgadmin/tools/backup/__init__.py M web/pgadmin/tools/backup/static/js/backup.ui.js M web/pgadmin/tools/backup/tests/test_backup_create_job_unit_test.py M web/regression/javascript/schema_ui_files/backup.ui.spec.js Log Message: --- 1) Added --exclude-database option for Backup Server. 2) Fixed Jasmine test cases. Commit: a08714cd6548e5463c0b4f79fde8566407f5389c https://github.com/pgadmin-org/pgadmin4/commit/a08714cd6548e5463c0b4f79fde8566407f5389c Author: Aditya Toshniwal Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M web/pgadmin/static/js/SchemaView/FieldSetView.jsx M web/pgadmin/static/js/SchemaView/FormView.jsx M web/pgadmin/static/js/SchemaView/MappedControl.jsx M web/pgadmin/static/js/comp
[pgadmin-org/pgadmin4] 2fb68b: Python dependency: Update boto3 requirement in /we...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 2fb68bf7fc6084bc37f8c42409b72a584b5984fe https://github.com/pgadmin-org/pgadmin4/commit/2fb68bf7fc6084bc37f8c42409b72a584b5984fe Author: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Date: 2023-07-11 (Tue, 11 Jul 2023) Changed paths: M requirements.txt Log Message: --- Python dependency: Update boto3 requirement in /web/regression (#6540) Updates the requirements on [boto3](https://github.com/boto/boto3) to permit the latest version. - [Release notes](https://github.com/boto/boto3/releases) - [Changelog](https://github.com/boto/boto3/blob/develop/CHANGELOG.rst) - [Commits](https://github.com/boto/boto3/compare/1.26.0...1.28.0) --- updated-dependencies: - dependency-name: boto3 dependency-type: direct:production ... Signed-off-by: dependabot[bot] Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Co-authored-by: Khushboo Vashi
[pgadmin-org/pgadmin4]
Branch: refs/heads/dependabot/pip/web/regression/boto3-eq-1.28.star Home: https://github.com/pgadmin-org/pgadmin4
[pgadmin-org/pgadmin4] 36e5eb: Python dependency: Update pillow requirement in /w...
Branch: refs/heads/dependabot/pip/web/regression/pillow-eq-10.star Home: https://github.com/pgadmin-org/pgadmin4 Commit: 36e5eb82d5b29f4b85a1ca215ff7a12b65aec9d4 https://github.com/pgadmin-org/pgadmin4/commit/36e5eb82d5b29f4b85a1ca215ff7a12b65aec9d4 Author: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Date: 2023-07-11 (Tue, 11 Jul 2023) Changed paths: M requirements.txt Log Message: --- Python dependency: Update pillow requirement in /web/regression Updates the requirements on [pillow](https://github.com/python-pillow/Pillow) to permit the latest version. - [Release notes](https://github.com/python-pillow/Pillow/releases) - [Changelog](https://github.com/python-pillow/Pillow/blob/main/CHANGES.rst) - [Commits](https://github.com/python-pillow/Pillow/compare/9.0.0...10.0.0) --- updated-dependencies: - dependency-name: pillow dependency-type: direct:production ... Signed-off-by: dependabot[bot]
[pgadmin-org/pgadmin4] fbf25f: Python dependency: Update urllib3 requirement from...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: fbf25f861bb265ff44f747e6386f80a94ccf25a8 https://github.com/pgadmin-org/pgadmin4/commit/fbf25f861bb265ff44f747e6386f80a94ccf25a8 Author: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Date: 2023-07-11 (Tue, 11 Jul 2023) Changed paths: M requirements.txt Log Message: --- Python dependency: Update urllib3 requirement from ==1.26.* to ==2.0.* (#6200) Updates the requirements on [urllib3](https://github.com/urllib3/urllib3) to permit the latest version. - [Release notes](https://github.com/urllib3/urllib3/releases) - [Changelog](https://github.com/urllib3/urllib3/blob/main/CHANGES.rst) - [Commits](https://github.com/urllib3/urllib3/compare/1.26.0...2.0.0) --- updated-dependencies: - dependency-name: urllib3 dependency-type: direct:production ... Signed-off-by: dependabot[bot] Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Co-authored-by: Khushboo Vashi
[pgadmin-org/pgadmin4]
Branch: refs/heads/dependabot/pip/urllib3-eq-2.0.star Home: https://github.com/pgadmin-org/pgadmin4
[pgadmin-org/pgadmin4] 66c466: Python dependency: Update pillow requirement in /w...
Branch: refs/heads/dependabot/pip/web/regression/pillow-eq-10.star Home: https://github.com/pgadmin-org/pgadmin4 Commit: 66c466a932df0b967467376c0edd42ab0110 https://github.com/pgadmin-org/pgadmin4/commit/66c466a932df0b967467376c0edd42ab0110 Author: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Date: 2023-07-11 (Tue, 11 Jul 2023) Changed paths: M requirements.txt Log Message: --- Python dependency: Update pillow requirement in /web/regression Updates the requirements on [pillow](https://github.com/python-pillow/Pillow) to permit the latest version. - [Release notes](https://github.com/python-pillow/Pillow/releases) - [Changelog](https://github.com/python-pillow/Pillow/blob/main/CHANGES.rst) - [Commits](https://github.com/python-pillow/Pillow/compare/9.0.0...10.0.0) --- updated-dependencies: - dependency-name: pillow dependency-type: direct:production ... Signed-off-by: dependabot[bot]
Re: Pgadmin4 System Stats Extension Design
On Tue, Jul 11, 2023 at 11:58 AM Sahil Harpal wrote: > Hi, > > I have written code for the Summary and CPU tabs and would like to post it > here for review. > > I'm currently displaying the static values in the process info pie chart > because of a minor bug. The pg_sys_process_info() query takes much longer > (around 2 mins) to execute and prevents the updation of other graphs and > tables. I tried adding it in separate useInterval with larger pollDelay, > but it didn't work. In the patch, I commented out that snippet (In > Summary.jsx). > Try preloading the extension in the PostgreSQL server. e.g. Add this extension in the 'shared_preload_libraries' in postgresql.conf. Reference: https://pgpedia.info/s/shared_preload_libraries.html -- Ashesh > > I'm attaching the *WIP.patch* file which contains the latest changes and > also the SS of the Summary and CPU tabs. > >
