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
b9686fcb00
Fixed an issue where import/export data is not working if service file is used to connect server.
2023-04-29 13:54:42 +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
60265b306f
Fixed an issue where PSQL is not working if the PGUSER env variable is set and service file is used for server connection details. #6180
2023-04-26 11:14:10 +05:30
3ac789f615
Fix ERD JS test cases failing due to previous commit.
2023-04-24 18:49:04 +05:30
4c2ae44e4c
Attempt to fix failing JS test cases with error related to ERD.
2023-04-24 18:04:02 +05:30
d98f411ea9
Show proper message if the debugger is stopped by the user. #6059
2023-04-20 17:05:05 +05:30
c19fc3628c
Ensure that the ERD tool should work with the external database after moving to psycopg3. #6159
2023-04-20 15:37:43 +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
a18d469c90
Fix an issue in search objects where objects were unable to locate occasionally. #5916
2023-04-04 18:29:54 +05:30
bc5e710d49
Fixed error while executing continue in debugging session after some time of debug execution. #5953
2023-04-03 15:28: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
12f82820c9
Fix an issue where Backup, Restore, and Maintenance not working if connection timeout is set in the server dialog. #5959
2023-03-27 17:41:19 +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
1d01b5a8a2
Add a note on top of keyboard shortcuts preferences to show the Accesskey of the browser. #5022
2023-03-24 15:44:43 +05:30
5cb64f7602
Fix Debugger restart issue.
2023-03-24 14:33:07 +05:30
70b2ead852
Ensure that the schema diff tool should not allow comparison between Postgres Server and EDB Postgres Advanced Server. #5952
2023-03-24 13:03:35 +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
42ac0d577d
Add .ts and .tsx files under linter and fix linter issues. #5830
2023-03-16 17:22:26 +05:30
89c8a7f907
Added option to create unique constraint with nulls not distinct. #5855
2023-03-15 18:55:42 +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
0a543d0e95
Ensure that the user's storage directory is created when the users are created, as well as for those users who have not yet been created. #5824
2023-03-14 18:21:18 +05:30
66c4b9d05a
Fix Debugger test cases.
2023-03-13 11:51:15 +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
1c0b826d23
Fixed schema diff UI alignment issues.
2023-02-27 15:47:24 +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
d8c5bc4320
Ensure that content on the DDL comparison panel should get refreshed on selecting the object using the up and down arrow keys. #5747
2023-02-14 17:15:04 +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
ed2b8ea1de
Fix an issue where the maintenance dialog for Materialized View gives an error. #5764
2023-02-10 15:19:53 +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
1806866bf5
Allow changing cardinality notation in ERD to use Chen notation. #5832
2023-02-10 10:27:16 +05:30
ca43f938bd
1. Ensure that the system columns should not visible in the import/export data. #5733
...
2. Fixed console error while attaching the partition. #5748
2023-02-02 18:14:38 +05:30
e247867abf
Incorporated review comments for #5705
2023-02-01 14:24:49 +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
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
a48828e7a3
Improve performance by removing signal-based zoom-in, zoom-out, etc functionality from the runtime environment. #5723
2023-01-17 17:18:35 +05:30
1a64af2743
Fixed the issue where the user cannot add via user management if the email field is blank.
2023-01-16 19:33:17 +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
8b236e7bc8
Ensure that the authenticated users can't access each other's directories and files by providing relative paths. #5734
2023-01-13 12:29:21 +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
18a7e85c6a
Fixed an issue where the ignore owner flag is not working for some cases in the Schema Diff. #5622 , #5655
2023-01-02 13:00:55 +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
4ab06b4a2a
Enhancements to the ERD when selecting a relationship. #4088
2022-12-05 10:47:05 +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
83bfdf9b3c
Fixed an issue where the wrong schema is displayed for a foreign key in the schema diff tool. #5488
2022-11-28 17:27:21 +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
500e59a3cf
Fixed PSQL API test cases.
2022-11-19 10:12:14 +05:30
2ab5d2b647
Ensure that the correct error message in ERD for permission denied should be shown. #5537
2022-11-16 14:37:54 +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
669a3a7673
Fixed SocketIO calls when pgAdmin 4 server is running from a sub directory. #5521
2022-11-15 13:51: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
af32e3c296
Added the ability to generate ERDs for tables. #4756
2022-11-09 11:36:04 +05:30
5f911ed0d8
Ensure that the browser path column in the search object shows the complete path. #5458
2022-11-03 11:08:31 +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
1647fc54e1
Use SocketIO instead of REST for schema diff compare. #4841
2022-10-21 09:29:19 +05:30
964c7b1d28
Fixed API test cases.
2022-10-20 17:47:27 +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
e17c50d304
Added support for storing configurations of pgAdmin in an external database. #1832
2022-10-20 16:18:41 +05:30
d50e9f7fc2
Cleanup code left in previous commit. #5065
2022-10-17 15:42:48 +05:30
4fc0f288c7
Use SocketIO instead of REST for fetching database tables data in ERD. #5065
2022-10-17 15:24:22 +05:30
ff095fc7c4
More fixes related to ERD color change. #4392
2022-10-13 18:34:34 +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
794cbed57c
Added support to specify the background fill color to the table nodes in the ERD tool. #4392
2022-10-12 10:07:30 +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
b086e1fd83
Add option to generate SQL with DROP table DDL in ERD Tool. #4997
2022-10-06 09:30:45 +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
56fb24c24a
Fixed the .psqlrc issue for PSQL Tool. #5167
2022-09-29 12:29:32 +05:30
1b11a6cd4b
Fixed a couple of SonarQube issues.
2022-09-27 14:28:31 +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
98c50afe8e
Ensure that the continue/start button should be disabled if the user stops the Debugger for the procedures. #5188 ( #5353 )
2022-09-23 11:11:23 +05:30
ed1184fcf8
Ensure that the user management dialog should not allow the same email addresses
...
with different letter casings when creating users. #5262
2022-09-22 14:59:42 +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
a2a18d4b4a
Fixed an error while saving changes to the ERD table. Fixes #5342
2022-09-19 16:20:07 +05:30
04b1e26041
Fixed an issue where server names with special characters are not displayed correctly in the process tab. Fixes #7695
2022-09-15 16:43:37 +05:30
9ac233f244
Fixed an issue where ERD throws an error if variable is added to the column. Fixes #7709
2022-09-15 13:16:27 +05:30
01a9a41bd9
1) Warn the user when connecting to a server that is older than pgAdmin supports.
...
2) Fixed Debugger API test cases.
2022-09-15 13:12:46 +05:30
0cb00c7b4f
Fixed the Debugger issue introduced by security fixes.
2022-09-14 15:15:52 +05:30
16bcb7d4a2
Ensure that the browser tree should be refreshed after changing the ownership. Fixes #7607
2022-09-14 15:08:05 +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
ab5d53f3b1
Fixed following issues for Schema Diff:
...
1) When some option from filter is selected, that particular type should be completely removed from top level result instead of showing identical:0
2) Copy button is missing for Difference SQL
3) Throw error when source & target server versions selected are different
4) In High contrast - Font color for identical turns same as background.
5) In High contrast - Checkbox box column turns same color of row resulting unable to distingiush about selection of item.
refs #6133
2022-09-13 16:49:44 +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
93f5fbc797
Fixed SonarQube issues.
2022-09-12 11:28:00 +05:30
76a6feb2e7
Remove some more references of Backgrid and Backform.
...
refs #6134
2022-09-12 11:17:23 +05:30
ca8b5c68fd
Remove Backgrid and Backform. Fixes #6134
2022-09-10 14:22:49 +05:30
b128ba2f57
Fixed a couple of SonarQube issues.
2022-09-10 14:04:28 +05:30
cbf5886430
Fixed the following code smells:
...
1. Use concise character class syntax
2. Add a "break" statement or remove this "else" clause.
3. Replace this generic exception class with a more specific one.
4. Use a regular expression literal instead of the 'RegExp' constructor.
5. Use the opposite operator ("not in") instead.
2022-09-10 13:48:14 +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
b8f63adf41
Fixes following code smell reported by SonarQube:
...
1) Replace this if-then-else flow by a single return statement
2) Remove the unnecessary boolean literals.
2022-09-08 19:56:02 +05:30
7086719640
Fixed SonarQube issues.
2022-09-08 18:08:58 +05:30
0c9c57e608
1. Resolved resize window issue for DDL result panel.
...
2. Updated the Screenshots.
3. Updated server group title to bold.
refs #6133
2022-09-08 15:24:43 +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
ad59380676
Fixed an issue with the non-visibility of columns added prior to import/export data. Fixes #7649
2022-09-07 17:40:52 +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
e58b9c767b
Port search object dialog to React. Fixes #7622
2022-08-30 17:08:12 +05:30
71a4b20d90
Fixed some SonarQube issues.
2022-08-30 14:21:33 +05:30
fe0577be5f
Ensure that the Import/Export server menu option is visible. Fixes #7646
2022-08-26 14:38:50 +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
ef91207669
1) Fixed an issue where an existing user is deleted and recreated again in the User Management dialog. Fixes #7618
...
2) Fixed preferences issue when changing themes.
3) Added validation for user names that already exist.
2022-08-16 17:28:45 +05:30
d45072fae5
Ensure that rename panel should work on view/edit panels. Fixes #7540
2022-08-16 15:31:55 +05:30
485265979e
Fixed an issue email already exists and disable the 'Locked' switch when its value is false. Fixes #7618
2022-08-16 15:25:25 +05:30
2d27a97b8c
Fixed improper parsing of HTTP requests in Pallets Werkzeug v2.1.0 and below (CVE-2022-29361). Fixes #7602
2022-08-16 12:20:01 +05:30
06d454473c
Fixed an issue where an invalid email error was not visible on the GUI. Fixes #7609
2022-08-14 08:48:58 +05:30
1e94c3bd81
Fixed Security Hotspot reported by SonarQube.
2022-08-14 07:09:45 +05:30
084203debc
Fixed Securtiy Hotspot reported by SonarQube.
2022-08-12 17:10:26 +05:30
b34078c6d2
Fixed SonarQube issues
2022-08-12 12:19:11 +05:30
c2b23465cc
1) Added support to show all background processes in separate panel. Fixes #3709
...
2) Port process watcher to React. Fixes #7404
2022-08-11 10:49:45 +05:30
271b6d91fc
Port User Management dialog to React. Fixes #7345
2022-08-11 10:25:52 +05:30
8b7ce2c276
Port change user password and 2FA dialog to React. Fixes #7568
2022-08-10 18:02:54 +05:30
9c418188ee
Fixed SonarQube issues.
2022-08-10 15:05:20 +05:30
f5793e9a7a
Fixed SonarQube issues.
2022-08-09 15:42:16 +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
81b0d1138b
Remove Alertify dialog from Grant Wizard, Import/Export Servers and Cloud.
2022-07-28 10:14:04 +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
3f8c36789f
Fixed copy command error on Windows in Import/Export data.
...
refs #7428
2022-07-21 13:07:42 +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
8f73956d1e
Fixed API test cases.
...
refs #7428
2022-07-18 18:15:46 +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
9c45a62b53
Fixed jasmine test cases introduced by the theme patch.
2022-07-01 15:01:51 +05:30
9c745db413
Enable the start debugging button once execution is completed. Fixes #7517
2022-07-01 12:41:06 +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
cb635f6706
Removing dynamic module loading and replacing it with static loading. Fixes #7492
...
Gets rid of all occurrences and usage of get_own_javascripts since it is no longer used.
2022-06-30 11:06:50 +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
35fb3bb38f
Fixed the typo in the layout id for the Debugger.
...
refs #6132
2022-06-27 16:34:04 +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
41ceda01d0
Fixed an issue where Debugger is not getting started if arguments loaded from SQLite database. Fixes #6132
2022-06-22 11:16:50 +05:30
4e3783c544
Fixed the following issues in the debugger:
...
1. If debugger arguments are array debugger sets the null value to parameters.
2. Popup screen is not being closed if debug Package procedure/Function and select Null option.
3. Updated validation for debugger argument of the array type parameter.
refs #6132
2022-06-20 19:05:26 +05:30
2adca6bbc4
1) Added mouse over indication for breakpoint area in the Debugger. Fixes #2647
...
2) Added search text option to the Debugger panel. Fixes #2648
3) Port Debugger to React. Fixes #6132
2022-06-15 11:37:54 +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
efe613d13e
Fixed an issue where comments on domain constraints were not visible when selecting a domain node. Fixes #7403
2022-05-24 14:50:33 +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
Akshay Joshi
Yogesh Mahajan
Nikhil Mohite
Khushboo Vashi
Aditya Toshniwal
Pravesh Sharma
Anil Sahoo
Aditya Toshniwal
San Lin Naing
Kevapo
Matěj Cepl
Anil Sahoo
Mark Mayo
Nikhil Mohite
Dave Page
Pradip Parkale