47479e5e5c
Fixed issue of duplicate values shown in Column>Columns to Import/Export dropdown when a value(values) is unselected.
...
refs #7017
2022-01-27 17:20:05 +05:30
deab1bfaba
Ensure that JSON files should be downloaded properly from the storage manager. Fixes #7118
2022-01-25 20:17:50 +05:30
04729f63b8
Fixed an issue where restore generates incorrect options for the schema. Fixes #7123
2022-01-25 20:14:10 +05:30
0ce3434631
Fixed code smell 'Update this function so that its implementation is not identical' reported by SonarQube.
2022-01-25 20:10:31 +05:30
343c3ee49c
Fixed following code smells reported by SonarQube:
...
1) Remove this redundant jump.
2) Remove this commented out code.
3) Variables should not be shadowed.
2022-01-21 18:54:23 +05:30
c983aae881
Port Import/Export dialog to React. Fixes #7017 .
2022-01-21 11:48:52 +05:30
1013d7ccdd
Fixed code smell reported by SonarQube.
2022-01-20 16:58:21 +05:30
e7e4d5cf0a
Fixed feature test cases for maintenance dialog.
2022-01-18 14:51:02 +05:30
9f836f5433
Fixed following code smells reported by SonarQube:
...
1) Immediately return this expression instead of assigning it to the temporary variable.
2) Extract this nested ternary operation into an independent statement.
3) Expected a `for-of` loop instead of a `for` loop with this simple iteration.
2022-01-18 14:49:54 +05:30
e3807ec3d6
Fixed following code smells reported by SonarQube:
...
1) Boolean checks should not be inverted.
2) Review this redundant assignment.
3) Extract this nested ternary operation into an independent statement.
4) Unexpected empty function.
5) Immediately return this expression instead of assigning it to the temporary variable.
2022-01-17 13:56:01 +05:30
3f7e921cce
Fixed code smell 'Unexpected empty arrow function' reported by SonarQube.
2022-01-12 18:59:21 +05:30
4e414f57e6
Fixed code smell 'Default parameters should be last' reported by SonarQube.
2022-01-12 18:40:18 +05:30
c98fb887cc
Fixed code smell 'Unexpected empty arrow function' reported by SonarQube.
2022-01-12 17:32:20 +05:30
e38c38cd58
Fixed following SonarQube code smells:
...
1) Remove this useless assignment to a variable.
2) Remove the unused local variable.
2022-01-12 14:53:19 +05:30
4ecd05e33b
1) Fixed import/export servers issue in server mode.
...
2) Fixed an issue where files are not showing as per the selected format in
the file dialog when opened the first time.
2022-01-07 21:29:17 +05:30
ad862f4084
Port Maintenance dialog to React. Fixes #7019
2022-01-07 12:07:49 +05:30
7cc76c7d2d
Fixed import/export server issues reported while testing.
2022-01-06 20:01:25 +05:30
6528d086ba
Fixed review comments:
...
1. Split the restore options/backup options into 2 tabs
2. Restore icon changes
3. feature tests issues
4. restore help link broken
5. Comment section not visible
refs #7018
2022-01-06 16:46:44 +05:30
8b13f158ab
Fixed review comments for Import/Export Servers.
...
refs #4803
2022-01-05 14:02:49 +05:30
964eddf952
Corrected wrong import statement.
2022-01-04 15:27:06 +05:30
2786f7ac5a
Update copyright notices for 2022
2022-01-04 13:54:25 +05:30
9dd957a2aa
Added support to import/export server groups and servers from GUI. Fixes #4803
2022-01-04 12:27:17 +05:30
e18ce2c9e3
Updates CSS and structure in Wizard, also fixed css issues in GrantWizard.
2021-12-31 14:16:50 +05:30
191e2b6242
Fixed an issue where an operation error message pop up showing the database object's name incorrectly. Fixes #7078
2021-12-28 13:49:04 +05:30
603d91be0e
Port Restore dialog to React. Fixes #7018
2021-12-28 13:45:59 +05:30
45179ccb8c
Change logic for grant wizard, wizard component, and updated CSS.
2021-12-22 18:26:21 +05:30
e5e9981836
Fixed an issue where Columns with default value not showing when adding a new row. Fixes #7034
2021-12-21 18:09:20 +05:30
02b83146be
1) Added spacing for message and loading spinner.
...
2) Rename the GrantWizard Dialog.
3) Return the activeStep from disableNextStep function.
2021-12-21 18:00:07 +05:30
9754b0fe14
Fixed an issue where Columns with default value not showing when adding a new row. Fixes #7034
2021-12-17 10:48:24 +05:30
92a997b16a
Rearrange tools menu on the basis of usability and form groups of similar sub-menus.
2021-12-16 18:29:44 +05:30
701e6f86f5
Ensure that statue message should not hide the last line of messages when running a long query. Fixes #7020
2021-12-13 13:10:56 +05:30
bd545fd5b2
1) Fixed schema diff owner related issue. Fixes #6877
...
2) Fixed schema diff related some issues. Fixes #6957
2021-12-11 22:10:28 +05:30
91a288c2bb
Correct the SQL definition for function/procedure with the Atomic keyword in PG14. Fixes #7029
2021-12-08 12:31:59 +05:30
fd53e4f5f9
Replace Alertify alert and confirm with React-based model dialog. Fixes #7053
2021-12-07 18:52:40 +05:30
f8cb62180e
Fixed API test cases for StartRunningQueryTest.
2021-12-03 13:19:31 +05:30
36c9eb3dfd
Added support for Two-factor authentication for improving security. Fixes #6543
2021-12-02 16:47:18 +05:30
c6424e3897
Replaced alertifyjs notifiers with React-based notistack. Fixes #7004
2021-12-02 16:05:52 +05:30
bef692d431
Fixed an issue where On-demand rows throw an error when any row cell is edited
...
and saved it then scroll to get more rows.
Fixes #7005
2021-11-28 13:26:40 +05:30
3dcee71a92
Resolved issue if the binary path is not present/correct, then show error notification to add/correct the binary path.
...
refs #6984
2021-11-24 17:28:04 +05:30
d644b4f94e
1) Replace Flask-BabelEx with Flask-Babel. Fixes #6088
...
2) Upgrade Flask to version 2. Fixes #7010
2021-11-24 17:22:57 +05:30
3afeb8ca46
Port Backup Global, Backup Server, and Backup object dialog in React. Fixes #6984
2021-11-22 11:20:44 +05:30
a5b79564ff
Fixed an issue where the user can't debug function with timestamp parameter. Fixes #6986
2021-11-18 12:25:21 +05:30
cc38bc132e
Fixed scroll issue in the browser tree when navigating using the keyboard.
2021-11-15 18:26:16 +05:30
25ace94d10
Fixed API test cases for search object.
2021-11-12 19:58:29 +05:30
ca4d5d0ca4
Added operators and aggregates in search objects. Fixes #6974
2021-11-12 17:45:08 +05:30
7b85253465
Corrected some menu lables.
2021-10-27 11:05:23 +05:30
9de1489322
Ensure that only the table node should be allowed to drop on the ERD tool. Fixes #6929
2021-10-19 12:01:43 +05:30
c13b1b60e3
Fixed the issue where all FKs are removed if one of the multiple FKs on the same column is removed.
...
refs #6891
2021-10-16 12:57:30 +05:30
7f3c3fa6f9
Added support to allow tables to be dragged to ERD Tool. Fixes #6241
2021-10-16 12:43:39 +05:30
8a21d9b500
Fixed some typos in the documentation and comments.
2021-10-14 11:13:16 +05:30
8b7b63868f
Added support for composite foreign keys in the ERD tool. Fixes #6891
2021-10-13 14:28:55 +05:30
2ced82c7b3
Ensure that query highlighting color in the query tool should be less intensive. Fixes #6754
2021-10-12 14:30:29 +05:30
d81960a6eb
Fixed API Test Case for ERD
2021-10-12 14:26:01 +05:30
f23b0702f2
Fixed PEP8.
2021-10-11 18:07:26 +05:30
a92c1b43a2
1) Added support for advanced table fields like the foreign key, primary key in the ERD tool. Fixes #6081
...
2) Added index creation when generating SQL in the ERD tool. Fixes #6529
2021-10-11 17:42:14 +05:30
9796f50362
Fixed an issue where the tree is not scrolling to the object selected from the search result. Fixes #6828
2021-10-07 17:23:21 +05:30
ca32828281
Fixed an issue where Execute button of the query tool gets disabled once we change anything in the data grid. Fixes #6798
2021-10-06 16:59:38 +05:30
5f9bb1c160
Correct the implementation of query details should be scrollable as per design.
...
Fixes #3827
2021-10-01 13:01:24 +05:30
7d07770244
Reverting 'Two-factor authentication' support as it cause OSX and docker build failures.
...
This reverts commit 787a441343
2021-09-29 13:24:18 +05:30
787a441343
Added support for Two-factor authentication for improving security. Fixes #6543
2021-09-28 17:47:00 +05:30
483e2ca8d0
Port browser tree to React. Fixes #6129
2021-09-27 16:44:26 +05:30
b9bc628189
1. Placeholder should be inside the controlProps. Change the placeholder from 'Select...' to 'Select an item...'
...
2. Updated grant wizard screenshot and documentation.
3. Remove '(Beta)' from ERD Tool and PSQL Tool.
2021-09-23 16:17:39 +05:30
15a494c189
Fixed review comments for Grant Wizard.
...
refs #6687
2021-09-23 14:40:38 +05:30
f192be3667
Added flag to check before adding 'IF NOT EXISTS' and 'OR REPLACE' clause to the SQL. While creating any object the respective clause should not be added.
2021-09-22 19:14:19 +05:30
7aa213a5ce
1) Port Grant Wizard to react. Fixes #6687
...
2) Fixed an issue where grant wizard is unresponsive if the database size is huge. Fixes #2097
2021-09-20 13:02:41 +05:30
99c99a9ce9
Ensure that in the Query History tab, query details should be scrollable. Fixes #3827
2021-09-17 21:01:24 +05:30
f1c04096e5
Fixed an issue where the last message is not visible in the Debugger. Fixes #6713
2021-09-17 20:44:57 +05:30
eeff75ba20
Remove GPDB support completely. Fixes #6692
2021-09-09 13:09:53 +05:30
c02705c53c
- Fix all the jasmine test case failures. - Show default value column in Table->Columns grid. Fixes #4353 .
2021-09-09 13:06:24 +05:30
6021e07761
Revisit all the CREATE and DROP DDL's to add appropriate 'IF EXISTS', 'CASCADE' and 'CREATE OR REPLACE'. Fixes #5741
2021-09-09 13:00:35 +05:30
f91908f627
Resolve the issue related to the close query tool panel with the save query tool changes.
...
refs #6710
2021-09-06 19:17:16 +05:30
4e0bd557d9
Increase the width of the user management dialog.
2021-08-31 14:06:03 +05:30
7deda52bd9
Fixed an issue where multiple query tool tabs getting closed for the single close event. Fixes #6710
2021-08-30 16:59:46 +05:30
56e2af9efc
Fixed test case failures.
2021-08-26 15:01:26 +05:30
51d73b1672
Fixed errors related to HTML tags shown in the error message for JSON editor. Fixes #6668
2021-08-26 14:54:51 +05:30
c6f9d447f7
Fixed failed test cases.
2021-08-25 11:10:45 +05:30
94b40775a1
Allow the referenced table to be the same as the local table in one to many relationship for ERD Tool. Fixes #6495
2021-08-24 18:19:03 +05:30
7efef73ff7
Added database and server information on the Maintenance process watcher dialog. Fixes #4629
2021-08-24 17:10:16 +05:30
8bf1c96065
Fixed the export image issue where relation lines are over the nodes. Fixes #6531
2021-08-24 17:05:23 +05:30
008a458fe9
Fixed width limitation issue in PSQL tool window. Fixes #6544
2021-08-23 16:23:30 +05:30
fbc6c30b62
Set PSQLRC and PSQL_HISTORY env vars to apt. user storage path in the server mode. Fixes #6691
2021-08-23 16:19:01 +05:30
3e4b5fd0d7
Renamed 'Auto rollback?' to 'Auto rollback on error?'. Fixes #6682
2021-08-19 15:30:58 +05:30
a6edfb498f
Partially fixes the data output panel display issue. Fixes #6572
2021-08-17 17:22:08 +05:30
ab04b30726
1. Unverified email id is getting locked.
...
2. Admin should be able to lock the user, as currently it only unlocks it via
user management dialog.
3. There were some indefinite login page loading issues when trying to log in
with invalid password, where it should redirect to the login page again instead.
refs #6337 (Initial patch by Khushboo Vashi)
2021-08-09 21:04:49 +05:30
7483ddf2b2
Added support to copy SQL from main window to query tool. Fixes #4904
2021-08-09 14:29:31 +05:30
703478c13d
Fixed an issue where the titles in query tabs are different. Fixes #6618
2021-08-06 19:09:39 +05:30
025c98ced8
1) Flash warning message of N no of attempts left for the unsuccessful login attempt.
...
2) Updated some strings in the Preferences for the "Maximum column width" option.
2021-08-03 17:06:06 +05:30
8e214ca8fb
Added support for formatted JSON viewer/editor when interacting with data in a JSON column. Fixes #5198
2021-08-03 11:36:45 +05:30
508f97b08e
Rename the "Resize by data?" to "Columns sized by" and disabled the 'Maximum column width'
...
button if 'Columns sized by' is set to 'Column data'. Fixes #6622
2021-07-27 15:17:06 +05:30
fdc3028124
Fixed linter error.
2021-07-23 12:57:40 +05:30
d95a6f2af7
Fixed an issue where paste is not working through Right-Click option on PSQL. Fixes #6574
2021-07-23 12:41:48 +05:30
a3d3c74e67
Ensure that the login account should be locked after N number of attempts. N is configurable using the 'MAX_LOGIN_ATTEMPTS' parameter. Fixes #6337
2021-07-22 12:24:43 +05:30
b2205fc6e1
Fixed an issue in the search object when searching in 'all types' or 'subscription' if the user doesn't have access to the subscription. Fixes #6448
2021-07-19 14:11:10 +05:30
5d4c073730
Fixed an issue where Schema Diff and Debugger give a blank white panel.
...
refs #6398
2021-07-06 18:56:21 +05:30
48ca83f31d
Added support for OAuth 2 authentication. Fixes #5940
...
Initial patch sent by: Florian Sabonchi
2021-07-06 13:22:58 +05:30
9fdda038a9
Resolve the log in issue for a user having a non-existing email id
...
1) Added CHECK_EMAIL_DELIVERABILITY & SECURITY_EMAIL_VALIDATOR_ARGS.
2) Added test cases for deliverability check.
Fixes #6550
2021-07-05 12:55:40 +05:30
e68c8305a2
Added option to provide maximum width of the column when 'Resize by data?’ option in the preferences is set to True. Fixes #6559
2021-06-28 11:51:21 +05:30
e095d382b3
Fixed an issue where incorrect column name listed in the properties of Index. Fixes #6557
2021-06-27 19:00:16 +05:30
25ada15546
Temporary comment the logic to check API test cases are fixed for EPAS/PG 9.6
2021-06-25 19:40:52 +05:30
5581f0909a
Fixed an issue where Debugger and ERD tool panel give a blank white panel, missing from the last patch.
...
refs #6398
2021-06-25 11:38:02 +05:30
6645625e6b
Fixed copy/paste issues for PSQL tool terminal. Fixes #6547 .
2021-06-24 20:00:52 +05:30
cc989c5c08
Added missing gettexts and text space improvements.
2021-06-24 11:15:50 +05:30
2adb29ffc0
Fixed an issue where the New Connection Drop Down has lost default maintenance database, auto-select, and tab-through functionality. Fixes #6505
2021-06-23 12:48:17 +05:30
80ccd62d38
Fixed an issue in the search object when searching in 'all types' or 'subscription' if the user doesn't have access to the subscription. Fixes #6448
2021-06-23 12:39:55 +05:30
b81ff45d34
Fixed replace keyboard shortcut issue in the query tool on the normal keyboard layout. Fixes #6388
2021-06-23 12:34:01 +05:30
81b78dd2b2
Do not block the query editor window when running a query. Fixes #3920
2021-06-23 12:22:24 +05:30
0b52ef6eb0
Fixed an issue where detaching the query editor panel gives a blank white panel. Fixes #6398
2021-06-23 11:49:40 +05:30
2549688bdf
1) Disable the PSQL feature entirely in server mode by default.
...
2) Remove the code that attempts to filter out commands.
refs #2341
2021-06-14 20:53:11 +05:30
09693d14d1
Added check if the Windows version is not supporting the ConPty or WinPty disable the PSQL for that version.
...
refs #2341
2021-06-14 11:47:40 +05:30
e3190b86ab
Fixed an issue where a decimal number is appended for character varying fields while downloading the data in CSV format. Fixes #6520
2021-06-11 19:29:20 +05:30
9f12747d9b
Added PSQL tool support for the Windows platform.
...
Fixed following issues:
1. If the database name contains escape characters then PSQL unable to connect.
2. If the user terminates the connection by typing the 'exit' command, PSQL
will show the connection termination msg.
Fixes #2341
2021-06-08 14:58:43 +05:30
e1067ffe67
Ensure that the Query Tool connection string should not be changed as per the 'Query Tool tab title'. Fixes #6404
2021-06-07 22:07:51 +05:30
d5f537aae4
Added extra check for verifying the rename of the database.
...
refs #4203
2021-06-07 21:11:28 +05:30
4bc4ca1ba9
1) Added browse button to select the binary path in the Preferences. Fixes #1561
...
2) Added support to set the binary path for the different database server versions. Fixes #5370
2021-06-04 17:55:35 +05:30
ac8e8961ce
Added Grant Wizard option under Package node. Fixes #1591
2021-06-04 12:47:37 +05:30
e0eac875b6
Disable the PSQL tool for Windows, the 'fcntl' module is not working on Windows.
2021-06-01 20:04:43 +05:30
658a2de619
Fixed the issue of renaming the database by another user. Fixes #4203
2021-05-31 12:41:09 +05:30
a487a51135
Fixes SonarQube issues.
2021-05-29 12:55:59 +05:30
3ddf941cd7
Added support to launch PSQL for the connected database server. Fixes #2341
2021-05-25 20:12:57 +05:30
f34adaca41
Fixed column sizing issue when there are no rows in a table.
...
refs #5954
2021-05-17 17:55:13 +05:30
7275ce906e
1) Fixed an issue where the user is not warned if Kerberos ticket expiration
...
is less than 30 min while initiating a global backup. Fixes #6444
2) Ensure that proper identification should be there when the server is
connected using Kerberos or without Kerberos. Fixes #6445
2021-05-14 12:33:01 +05:30
7ed97eeec4
Fixed an issue where file dialog showing incorrect files for the selected file types. Fixes #6443
2021-05-14 12:12:17 +05:30
bd7808a104
Fixed an issue where the filter 'Include/Exclude By Selection' not working for null values. Fixes #6392
2021-05-11 19:12:43 +05:30
2b7f8d8298
Improve some strings.
2021-05-11 11:31:14 +01:00
d80087f6d5
Added support to set auto width of columns by content size in the data output window. Fixes #5954
2021-05-07 17:18:50 +05:30
4c55044440
Remove duplicate code and avoid DOM search operation.
...
refs #6355
2021-05-06 10:53:32 +05:30
b13627398b
Fixed API test cases
2021-05-05 13:12:20 +05:30
b30ec71098
Ensure that while connecting to the server using SSPI login, it should not prompt for the password. Fixes #5776
2021-05-05 11:40:48 +05:30
ac403d0dfa
Fixed an issue where the current debug line is not visible in the 'Dark' theme. Fixes #6409
2021-05-04 12:34:03 +05:30
72f3730c34
Added support to connect PostgreSQL servers via Kerberos authentication. Fixes #6158
2021-05-03 16:10:45 +05:30
3a2145e5fa
Fixed an issue where query editor is not being closed if the user clicks on the 'Don't Save' button. Fixes #6417
2021-05-03 12:52:28 +05:30
488dc1849d
Fixed an issue where data is displayed in the wrong order when executing the query repeatedly. Fixes #5555
2021-04-29 13:13:52 +05:30
9dd1bae3c7
Ensure that pgAdmin should not allow opening external files that are dragged into it. Fixes #6355
2021-04-28 11:59:45 +05:30
8ae8fea6d2
Ensure that Backup and Restore should work on shared servers as some cases were failing due to initial changes.
...
Fixes #6385
2021-04-22 17:29:04 +05:30
dc65cbb08c
Fixed an issue where foreign data wrapper properties are not visible if the host option contains two host addresses. Fixes #6379
2021-04-19 11:08:21 +05:30
2b1910c1c1
Better fix for the black screen issues, reverted the old fix.
...
refs #6334
2021-04-16 18:23:29 +05:30
b4d44541bb
Fixed SQL panel black screen issue when detaching it in runtime. Fixes #6334
2021-04-15 16:40:35 +05:30
cb7bcaf939
Ensure that Backup and Restore should work on shared servers. Fixes #6385
2021-04-14 12:11:55 +05:30
49095ccba6
1) Fixed an issue where shortcut keys are not working with manage macro. Fixes #5908
...
2) Fixed an issue where the cursor shifts its focus to the wrong window for all the query tool related model dialogs. Fixes #6161
2021-04-09 12:41:13 +05:30
1f4affcb1e
Fixed an issue where a connection warning should be displayed when the user
...
clicks on explain or explain analyze and the database server is disconnected
from the browser tree. Fixes #6376
2021-04-08 18:49:31 +05:30
14dcb70b95
Ensure that the user should not be to change the connection when a long query is running. Fixes #6082
2021-04-08 18:09:13 +05:30
c88a63edf8
Included JSX files in the linter check.
2021-04-08 17:56:18 +05:30
8aea86613e
Fixed an issue where users are unable to see data of the partition table using the View/Edit data option. Fixes #6375 .
2021-04-07 16:25:21 +05:30
585ba81492
Fixed sizing issue of help dialog for Query Tool and ERD Tool when open in the new browser tab. Fixes #6333
2021-04-06 15:26:25 +05:30
566f03beca
Ensure that the query tool tab should be closed after server disconnection when auto-commit/auto-rollback is set to false. Fixes #5519
2021-04-01 11:58:59 +05:30
fb0d8c348a
Remove the alertify error message as no need to show it when the user presses
...
the keyboard shortcut to open the View/Edit data on unsupported nodes.
refs #6206
2021-03-30 16:21:22 +05:30
2872b5c5d3
1) Ensure that the zoom level should be set for the newly opened window.
...
2) Ensure that if the zoom level is changed on the main window then it should
be applicable for all the opened windows.
refs #6271
2021-03-22 17:50:26 +05:30
3f63f65674
Ensure that the view/edit data panel should not be opened for unsupported nodes using the keyboard shortcut. Fixes #6206
2021-03-19 15:38:40 +05:30
9395ce3fda
Fixed an issue where copy/paste rows in view data paste the wrong value for boolean type. Fixes #6312
2021-03-16 11:29:47 +05:30
68132e2a8f
Fixed an issue where adding/updating records fails if the table name contains percent sign.
...
refs #4438
2021-03-12 11:59:45 +05:30
9d8360641f
Use schema qualification while accessing the catalog objects.
...
refs #3976
2021-03-12 11:17:25 +05:30
a2be30d257
Use schema qualification while accessing the catalog objects. Fixes #3976
2021-03-09 13:18:45 +05:30
8cf7c41ad9
Fixed an issue where adding/updating records fails if the table name contains percent sign. Fixes #4438 .
2021-03-09 12:40:59 +05:30
9317fe21b2
Fixed an issue where the user is not able to change the connection in Query Tool when any SQL file is opened. Fixes #6272
2021-03-04 13:17:31 +05:30
cb5d7190c4
Fixed SonarQube issues.
2021-03-01 18:00:06 +05:30
87b9549ff4
Fixed encoding issue when database encoding set to SQL_ASCII and name of the column is in ASCII character. Fixes #6018
2021-02-26 13:23:07 +05:30
e0639602e6
Fixed ERD API test case failing for PG13
2021-02-22 15:01:01 +05:30
3132fa175a
Added missing updated shared server owner name in the 'sharedserver' table
...
while the user changing the ownership of the shared server.
refs #6143
2021-02-22 14:49:34 +05:30
d9847ed1f3
Fixed an issue where the user is not able to use the query tool when
...
any other long-running operation is in progress.
refs #5793
2021-02-19 15:57:55 +05:30
32197a8405
Fix explain plan and geometry viewer issue. It's a regression of SonarQube fixes. Fixes #6239
2021-02-19 14:29:43 +05:30
76217ffa8f
Fixed ERDTables API test case.
2021-02-18 14:23:30 +05:30
e5a91d30bf
Fixed API test cases.
2021-02-15 18:29:49 +05:30
3fc0cc3e92
Fixed SonarQube issues
2021-02-15 17:31:20 +05:30
44cc7a308a
Added publication and subscription support in Schema Diff. Fixes #6153
2021-02-15 16:05:40 +05:30
c1e80ac38a
Fixed an issue where the ERD image is not properly downloaded. Fixes #6197
2021-02-15 15:24:57 +05:30
1b850ff616
Fixed an issue where strikeout is getting removed on scrolling of index column of the table.
...
refs #6157
2021-02-10 17:40:54 +05:30
4c660f2155
Fixed an issue where roles are not deleted after API test execution.
2021-02-10 13:50:16 +05:30
1317e4254b
Updated the JS dependencies to the latest
...
1) Migrate from webpack 4 to webpack 5. This had a lot of breaking changes,
so updated multiple webpack plugins and changed the config accordingly.
2) Replaced iconfont-webpack-plugin with a more maintained webfonts-loader.
3) Replaced deprecated babel-eslint with @babel/eslint-parser.
4) Replaced optimize-css-assets-webpack-plugin with a more maintained css-minimizer-webpack-plugin.
5) Updated all other JS packages and made the required code changes.
Fixes #6207
2021-02-10 12:47:52 +05:30
9e85fb3de3
Fixed an issue where strike-through is not visible for rows selected for deletion after scrolling. Fixes #6157
2021-02-05 13:57:35 +05:30
181bec62ce
Fixed API test cases by making the connection id unique for ERD.
2021-02-04 16:14:55 +05:30
14036b7aeb
Fixed an issue where the focus is not properly set on the filter text editor after closing the error dialog. Fixes #5809
2021-02-04 11:45:16 +05:30
02c3863e8c
Fixed an issue where shared server entries not getting deleted from SQLite database if the user gets deleted. Fixes #6143
2021-02-04 11:31:39 +05:30
ee679e39e5
Use unique database name in ERD API test cases.
2021-02-03 16:49:17 +05:30
9e90350e44
Fixed jasmine test cases and added some missing messages for disabled menus.
2021-02-03 12:15:37 +05:30
b948f43dda
Added Quick Search functionality for menu items and help articles. Fixes #6148
2021-02-02 14:47:58 +05:30
75f887f5dc
Ensure that ERD throws a warning before closing unsaved changes if open in a new tab. Fixes #6193
2021-02-02 11:47:10 +05:30
bf56a6723b
Added support for Logical Replication. Fixes #5912
2021-02-01 15:12:43 +05:30
a0271c7656
Fixed an issue while downloading ERD images in Safari and Firefox. Fixes #6177
2021-01-29 12:19:24 +05:30
48e257e5af
1) Fixed an issue where Zoom to fit button only works if the diagram is larger than the canvas. Fixes #6163
...
2) Ensure that the diagram should not vanish entirely if zooming out too far in ERD. Fixes #6164
3) Fixed an issue where Generate SQL displayed twice in the ERD tool. Fixes #6179
4) Updated missing documentation for the 'Download Image' option in ERD. Fixes #6180
2021-01-29 11:54:50 +05:30
3f563d8cbf
1) Fixed an issue where the Save button is disabled due to the existing table check in ERD.
...
2) Fix warnings given by webpack.
2021-01-25 19:44:24 +05:30
13db981445
Fixed following issues in ERD:
...
1) After opening an existing project, the first table is already selected but the edit, clone, delete buttons are disabled.
2) ERD project title gets changed when 2 ERD projects are open & anyone of it edited.
3) Closing the ERD tab does not ask for a confirmation pop-up.
4) Shortcut for 'Show more/Fewer details' is missing.
5) Deleting the primary key does not delete associated links.
6) The long table & schema name are getting out of the box.
7) The long table name in the notes pop-up needs re-alignment.
8) The same table name present in ERD/canvas is allowed in Add Table dialogue. Added validation in the dialog.
9) Download image option is added, but it is not perfect yet. Image icons (table, schema, etc.) are not showing up.
10) Rename panel option should be disabled by default. It should be enabled for the tools which implement rename functionality.
11) The Toolbar is not visible in Safari for the ERD tool.
refs #1802
2021-01-25 17:32:56 +05:30
e20f26c500
Documentation of ERD Diagram support. Fixes #6152
2021-01-25 12:18:47 +05:30
f92b0961ee
Revert "Fixed an issue where shared server entries not getting deleted from SQLite database if the user gets deleted. Fixes #6143"
...
This reverts commit 57ed02a9aa
2021-01-21 15:23:03 +05:30
57ed02a9aa
Fixed an issue where shared server entries not getting deleted from SQLite database if the user gets deleted. Fixes #6143
2021-01-21 14:23:02 +05:30
a2f626046a
Fix labels.
2021-01-20 15:47:41 +00:00
9bee91b6f6
1) Fixed an issue where the Save button is enabled by default in Macro. Fixes #5905
...
2) Remove extra line after Manage Macros menu while clearing all macros. Fixes #5906
3) Ensure that 'Clear All Rows' should not work if there is no existing macro available and the user does not specify any value. Fixes #5907
4) Fixed an issue where the server is disconnected error message displayed if the user creates Macro with invalid SQL. Fixes #5929
2021-01-20 13:52:00 +05:30
b3ca172f3a
Fixed an issue of deleting records when the user tries to delete multiple records. Fixes #6098
2021-01-20 12:39:12 +05:30
9fa29457a4
Update copyright notice for ERD and Kerberos files.
2021-01-19 16:22:53 +05:30
da9f9017a9
Fixed cognitive complexity reported by SonarQube.
2021-01-19 13:34:14 +05:30
c0ef0a893d
1) Added support for Kerberos authentication, using SPNEGO to forward the Kerberos tickets through a browser. Fixes #5457
...
2) Fixed incorrect log information for AUTHENTICATION_SOURCES. Fixes #5829
2021-01-18 16:32:10 +05:30
a60cfd3cc3
Fixed an issue while checking the major version of servers in schema diff.
2021-01-18 14:40:07 +05:30
d4a3e4d92c
Fixed issues reported by SonarQube.
2021-01-18 13:02:19 +05:30
0c8226ff39
Added ERD Diagram support with basic table fields, primary key, foreign key, and DDL SQL generation. Fixes #1802
2021-01-16 17:06:50 +05:30
065bda37b4
Added informative message when there is no difference found for schema diff. Fixes #6122
2021-01-15 14:03:22 +05:30
f0debdd513
Revert "1) Added support for Kerberos authentication, using SPNEGO to forward the Kerberos tickets through a browser. Fixes #5457"
...
This reverts commit 6ead597b43
2021-01-14 14:46:59 +05:30
6ead597b43
1) Added support for Kerberos authentication, using SPNEGO to forward the Kerberos tickets through a browser. Fixes #5457
...
2) Fixed incorrect log information for AUTHENTICATION_SOURCES. Fixes #5829
2021-01-14 13:46:48 +05:30
18e4b30634
Reverting fix for #4892 , updated the RM with the workaround.
2021-01-13 11:05:46 +05:30
3f089f31a3
Fixed an issue where target connection is wrong while checking version compatibility in schema diff.
2021-01-12 15:09:57 +05:30
b372f08a59
Update copyright notices for 2021
2021-01-04 15:34:45 +05:30
98b7603ebd
Close query tool connection for API test cases.
2020-12-25 18:32:01 +05:30
dbb4a46d46
Fixed accessibility issues in various dialogs. Fixes #6077
2020-12-24 13:26:25 +05:30
4c9853f10d
Fixed an issue where pressing the back button will show another instance of the main page inside of the Query Tool tab. Fixes #4892
2020-12-24 13:13:57 +05:30
c933771016
Fixed accessibility issues in schema diff module. Fixes #6065
2020-12-23 12:57:16 +05:30
ed5fc20ee2
Fixed TypeError exception in schema diff when selected any identical object. Fixes #6084
2020-12-21 15:06:01 +05:30
a0ff0e30fb
Fixed Debugger API test cases.
...
refs #5343
2020-12-17 18:59:44 +05:30
a7b8d77ed7
Fixed an issue where the state of the Save File icon does not match the dirty editor indicator. Fixes #6046
2020-12-17 11:37:03 +05:30
21333490ef
1. Added check to skip debugger test case if the plugin is not installed.
...
2. Added code to delete the existing "pldbgapi" extension and create a new extension.
3. Updated a few test cases that are falling on specific servers.
4. Fixed test cases for pgAgent.
Fixed by: Nikhil & Yogesh
2020-12-16 11:25:16 +05:30
52780079f3
Fixed an issue where the dirty indicator stays active even if all changes were undone. Fixes #6047
2020-12-14 12:02:02 +05:30
6475a70514
Ensure that the macro query result should be download properly. Fixes #5965
2020-12-14 11:58:53 +05:30
c79614786f
Ensure that the rename panel should be disabled when the SQL file opened in the query tool. Fixes #6058
2020-12-10 18:13:04 +05:30
c7ae5024d5
Added random function name generation logic for the debugger test cases.
2020-12-09 13:36:52 +05:30
9450065850
1. Resolved the issues related to the database connection.
...
2. Updated the create "pldbgapi" extension for the debugger.
refs #5343
2020-12-07 15:44:56 +05:30
794bd50ed1
Improve code coverage and API test cases for Debugger. Fixes #5343
2020-12-03 10:31:24 +05:30
abd0748a77
Ensure that dirty indicator (*) should not be visible when renaming the tabs. Fixes #5991
2020-12-01 11:28:10 +05:30
fb51ef569e
Fixed an issue where escape character is shown when the server/database name has some special characters. Fixes #5992
2020-12-01 11:19:07 +05:30
29c3c0cf7f
Fixed BatchProcessTest cases failing on Jenkins.
2020-11-19 18:09:35 +05:30
17ce84dd0a
Fixed an issue where dynamic tab title has not applied the first time for debugger panel. Fixes #5978
2020-11-19 10:25:20 +05:30
5839e7cda8
Added validation in schema diff which will not allow the user to compare the same objects.
2020-11-12 18:08:40 +05:30
ebf5e871e0
Fixed an issue where the debugger's custom tab title not applied when opened in the new browser tab. Fixes #5974
2020-11-12 17:59:13 +05:30
5370bb4515
Added the appropriate server icon based on the server type in the new connection dialog. Fixes #5983
2020-11-12 17:52:54 +05:30
be386e77f2
1) Fixed an issue where the process watcher dialog throws an error for
...
the database server which is already removed. Fixes #5985
2) Fixed cognitive complexity reported by SonarQube.
2020-11-12 17:47:21 +05:30
a026f339c3
Fixed cognitive complexity reported by SonarQube.
2020-11-12 17:20:58 +05:30
64964f82cf
Ensure that Grant Wizard should include foreign tables. Fixes #5959
2020-11-09 12:44:00 +05:30
1dca4313f7
Fixed an issue where Query Tool/View Data panel closed event is not registered for changes.
...
It's a regression of #4231 .
refs #4231
2020-11-08 19:14:08 +05:30
2793747d3c
1) Added support for dynamic tab size. Fixes #4231
...
2) Fixed an issue where a long file name is not visible on the process watcher dialog. Fixes #5950
2020-11-04 17:45:28 +05:30
14a5d05b80
Ensure that non-superuser should be able to debug the function. Fixes #5760
2020-10-30 15:03:18 +05:30
df31fe7dc4
Updated schema diff script generation message as we have removed the Beta keyword.
2020-10-29 14:32:37 +05:30
6c723a7e43
Fixed an issue where connection to the server is on wait state if a different user is provided. Fixes #5953
2020-10-28 12:32:22 +05:30
b76bb58378
Added support to compare schemas and databases in schema diff. Fixes #5891
2020-10-27 16:36:10 +05:30
5284a1c66b
Fixed API test cases.
2020-10-27 11:15:45 +05:30
b5f9fffadd
Fixed the following issues:
...
RM-4232:
1. If the user adds a percentage (other than for placeholders) then it is stripped off.
2. Backslash is getting removed in the connection string if we provide the backslash(\) in placeholders or the database name contains it.
3. If the user added only spaces( )in placeholders it is not getting reset to default values.
RM-4230:
1. Rename panel option is not working in the debugger.
2. Added Rename panel for schema diff.
Fixes #4232 #4230
2020-10-27 11:03:00 +05:30
892fb83907
Remove commented code.
2020-10-27 10:53:18 +05:30
7648bd9646
Added missing gettext.
2020-10-27 10:51:35 +05:30
c86a3d64fc
Added support to rename query tool and debugger tabs. Fixes #4230
...
Fixed an issue where non-closeable tabs are getting closed. Fixes #5923
2020-10-23 17:16:31 +05:30
c2ad97d0ab
Added support to download utility files at the client-side. Fixes #3318
2020-10-23 16:14:55 +05:30
275d13d40f
Following issues have been resolved for the new connection feature:
...
1. Show servers with server groups in the dropdown.
2. Highlighted current selected connection in the new connection dropdown.
3. Notify the user before changing the connection.
refs #3794
2020-10-21 17:14:59 +05:30
18cad32bd4
Added tab title placeholder for Query Tool, View/Edit Data, and Debugger. Fixes #4232
2020-10-20 15:41:54 +05:30
38b90f7b00
Ensure that search object functionality works with case insensitive string. Fixes #5858
2020-10-15 16:17:54 +05:30
6addd207af
Ensure that macros should be run on the older version of Safari and Chrome. Fixes #5911
2020-10-15 15:59:53 +05:30
49b139bb75
Added escape and unescape for the strings used in query tool and new connection support. Fixes #5899 .
2020-10-12 16:20:33 +05:30
fa267805c9
Fixed fg_color and bg_color issue for connection string on query tool.
...
refs #3794
2020-10-12 13:51:48 +05:30
1c796720be
Fixed the following issues for RM 3794:
...
1. Updated connection success message. (Added database name in the success message.)
2. Resolve issue of the mouse pointer and dropdown will show below the connection string only.
3. Added loader for both new connections and load existing connections.
4. Removed async: false for update connection.
refs #3794
2020-10-08 11:38:05 +05:30
483eeeca39
Added gettext and escape around Macro name and label. Fixes #5894
2020-10-08 11:23:45 +05:30
c28509ac28
Fixed an issue where the user is unable to change the macro name. Fixes #5885
2020-10-05 14:40:21 +05:30
be7bb81a19
Allow user to change the database connection from an open query tool tab. Fixes #3794
2020-10-01 13:29:46 +05:30
228d4bb321
Fixed SQLAlchemy operation error with the boolean value as true/false for Python version < 3.7
2020-10-01 13:29:46 +05:30
a707d818f5
Removed (Beta) keyword from Schema Diff and High Contrast theme.
2020-09-29 18:27:28 +05:30
1c70a43b91
Fixed code smells 'Define a constant instead of duplicating this literal' reported by SonarQube.
2020-09-29 15:08:14 +05:30
1fc06b8d57
Added useful message when the explain plan is not used and empty. Fixes #4806
2020-09-28 17:51:59 +05:30
4616a74029
Added Macro support. Fixes #1402
2020-09-28 15:26:45 +05:30
952197f130
Added support to ignore the owner while comparing objects in the Schema Diff tool. Fixes #5200 .
2020-09-28 15:22:46 +05:30
68588fbb44
Fixed an issue where schema diff is showing identical table as different due to default vacuum settings. Fixes #5826
2020-09-24 13:24:25 +05:30
1ee9cddceb
Ensure that the import/export feature should work with SSH Tunnel. Fixes #5739
2020-09-22 09:40:59 +05:30
ed3c692b1f
Fixed an issue where the query tool is not fetching more than 1000 rows for the table does not have any primary key. Fixes #5845
2020-09-21 15:36:19 +05:30
55b5080c77
Fixed and improve API test cases for the schema diff tool. Fixes #5417
2020-09-17 20:10:01 +05:30
8e132eab08
Fixed some accessibility issues. Fixes #5732
2020-09-15 13:03:18 +05:30
8029d9e65e
1) Fixed internal server error when clicking on the open new query tool button
...
from the View/Edit Data window. Fixes #5831
2) Fixed schema diff panel title issue on new tab.
2020-09-14 17:42:59 +05:30
b82e6dbdb8
1) Added email id validation on the login page.
...
2) Added validation for the file manager.
2020-09-11 19:55:19 +05:30
a7d40e238e
Ensure that the 'CREATE SCHEMA' statement should be present in the generated script if the schema is not present in the target database. Fixes #5816
2020-09-11 19:06:56 +05:30
7fac72cac5
Fixed an issue where alert message should get displayed on active browser window.
...
refs #4059
2020-09-10 12:09:56 +05:30
d0310b669e
Fixed an issue where clicking on the 'Generate script' button shows a forever spinner due to pop up blocker. Fixes #5815
2020-09-09 20:10:56 +05:30
62e6848dc8
1) Added tooltip & keyboard shortcut for the query tool button.
...
2) Fixed TypeError issue.
refs #4059
2020-09-09 19:32:33 +05:30
535739c0c7
Fixed cognitive complexity issues reported by SonarQube.
2020-09-09 11:25:43 +05:30
f8f00b4ecf
Fixed an issue in the query tool when columns are having the same name as javascript object internal functions. Fixes #5765 .
2020-09-07 18:10:27 +05:30
31bbdd6a12
Fixed code smell 'String literals should not be duplicated'.
2020-09-03 18:35:58 +05:30
974d395a48
Fixed cognitive complexity issues reported by SonarQube.
2020-09-03 18:10:57 +05:30
b562ab7681
Added shared server support for admin users. Fixes #4979
2020-09-03 12:59:28 +05:30
1c9badec9c
Rename the menu option 'Search objects' to 'Search Objects...'
2020-09-02 16:44:30 +05:30
5a253f9053
Change the following to replace Python 2 code with Python 3:
...
1) Replace the deprecated unit test method.
2) Wraps filter usage in a list call.
3) Converts the old metaclass syntax to new.
4) Use range instead of xrange method.
5) Change Unicode to str.
6) Several other transformations.
7) Fixed change password test cases.
8) Use simplejson instead of plain JSON.
2020-08-31 16:45:31 +05:30
3984544bdb
Fixed code smell 'String literals should not be duplicated'.
2020-08-28 18:17:27 +05:30
e8b192be3e
Added a new button to the query tool toolbar to open a new query tool window. Fixes #4059
2020-08-28 13:53:08 +05:30
8222bf6420
Modified the 'Commit' and 'Rollback' query tool button icons. Fixes #5662
2020-08-27 12:58:13 +05:30
d2577e32e6
Fixed cognitive complexity issues reported by SonarQube.
2020-08-25 18:13:01 +05:30
e582ffca38
Fixed regression issue in taking backup of the table. Added some more test cases.
2020-08-25 18:06:38 +05:30
275c671576
Fixed cognitive complexity issues reported by SonarQube.
2020-08-25 12:39:14 +05:30
7f947f146c
Fixed cognitive complexity issues reported by SonarQube.
2020-08-25 12:28:55 +05:30
52d0241a17
Fixed an issue where schema diff is not working when providing the options to Foreign Data Wrapper, Foreign Server, and User Mapping. Fixes #5754
2020-08-24 12:11:09 +05:30
b53de0c31d
Updated some more font awesome icons for v5
2020-08-21 14:15:18 +05:30
19491d79a5
Fixed cognitive complexity issues reported by SonarQube.
2020-08-21 13:52:05 +05:30
fbbbc36221
Fixed code smell 'Define a constant instead of duplicating this literal' reported by SonarQube.
2020-08-20 20:26:51 +05:30
103b08c9c5
Define constants for preferences label to fix SonarQube issues.
2020-08-20 17:58:37 +05:30
99a7ada58a
Cleanup a bunch of duplicated gettext calls.
2020-08-20 10:00:12 +01:00
6415294782
Improve code coverage and API test cases for Grant Wizard. Fixes #5344
2020-08-20 14:04:24 +05:30
79e6480513
Added SQL Formatter support in Query Tool. Fixes #2042
2020-08-20 13:05:00 +05:30
4b56962c1b
Fixed cognitive complexity issues reported by SonarQube.
2020-08-19 13:41:53 +05:30
ae18b9a0ac
Fixed schema diff issue when selecting any identical node.
2020-08-17 17:26:58 +05:30
8f61944386
1) Added special handling for the extension to resolve the dependency.
...
2) Added 'is_sys_obj' to the ignore list of Schema Diff.
3) Font awesome v5 fixes.
2020-08-13 17:48:04 +05:30
63df19ee1c
Fixed following schema diff issues:
...
1) Avoid template databases from the Database drop-down list.
2) Exclude system schemas while comparing two databases.
3) Escape group name for XSS.
2020-08-13 14:12:37 +05:30
93adf6884f
Upgrade font awesome from v4 to v5. Fixes #5731
2020-08-13 12:04:00 +05:30
36574b25b6
The 'str' object never has attribute decode in Python3, so remove the dead code.
2020-08-12 18:55:35 +05:30
26506a9727
Fix PEP8
2020-08-12 17:48:08 +05:30
5b688cf949
Resolve schema diff dependencies by selecting the appropriate node automatically and maintain the order in the generated script. Fixes #5730
2020-08-12 17:36:48 +05:30
7dd313f5fc
Fixed an issue where debugger doesn't work if the search path is set other than 'public'. Fixes #4123
2020-08-12 14:24:40 +05:30
26a758a0d6
Fixed an issue where copying and pasting a cell with multiple line data
...
will result in multiple rows. Fixes #5526
Fixed an old issue where quotes are not escaped when copying the cells.
As per CSV standards, if the string is in double quotes and there are
double quotes inside the string then they should be escaped with extra double-quotes.
2020-08-10 16:53:32 +05:30
9d006d0ec5
Fixed cognitive complexity issues reported by SonarQube.
2020-08-10 16:30:07 +05:30
4f74609ecf
Modified schema diff tool to compare two databases instead of two schemas. Fixes #5126
2020-08-10 15:13:34 +05:30
3672013ddc
Fixed an issue where the error message does not have a close button on utility dialogs. Fixes #5670
2020-08-07 17:17:51 +05:30
d6400bbcae
Replace the generic exception class with a more specific one.
2020-08-07 12:37:00 +05:30
e3dfe03a2a
Fixed an issue where the user is not able to insert the data if the table and columns name contains special characters. Fixes #4387
2020-08-06 12:30:10 +05:30
aa679e06b2
Replace the generic exception class with a more specific one to fix SonarQube issues.
2020-08-05 12:41:28 +05:30
43e127de31
Ensure that the original file format should be retained when saving the same file in SQL editor. Fixes #3767
2020-08-03 13:18:04 +05:30
536593bf8a
Fixed following SonarQube issues:
...
- Remove this assignment to the local variable, the value is never used.
- Rename local variables to match the regular expression
- Add logic to this except clause or eliminate it and rethrow the exception automatically.
- Rename fields to match the regular expression
- Extract this nested conditional expression into an independent statement.
- Change this default value to "None" and initialize this parameter inside the function/method.
- Update this function so that its implementation is not identical to __repr__
- Refactor this method to not always return the same value
- Reraise this exception to stop the application as the user expects
- Add missing parameters _w _PY3. This method overrides simplejson.decoder.JSONDecoder.decode.
- Remove this redundant continue.
- Remove this unused function declaration
- Remove this identity check; it will always be False.
2020-08-03 12:59:51 +05:30
eb2c554601
Fixed cognitive complexity issues reported by SonarQube.
2020-08-03 12:46:34 +05:30
56cf64ad22
Fixed following SonarQube issues:
...
- Refactor functions to not always return the same value.
- Rename "cls" to "self" or add the missing "self" parameter.
- Remove useless assignment to variables.
2020-07-30 14:04:22 +05:30
fb0bc65ced
Fixed following SonarQube issues:
...
1) Define a constant instead of duplicating this literal.
2) Reduce cognitive complexity (Patch by Aditya)
2020-07-27 16:31:03 +05:30
f93cfe8c4c
Remove old Python 2 compatibility code. Fixes #5700
2020-07-27 11:03:13 +01:00
043025d1eb
Fixed an issue where the user is not able to save the new row if the table is empty. Fixes #4810
2020-07-24 14:30:22 +05:30
937877e841
Ensure that RLS Policy node should be searchable using search object. Fixes #5646
2020-07-24 13:47:39 +05:30
505a3ac960
1) Fixed cognitive complexity issues reported by SonarQube.
...
2) Fixed code smell 'Add a nested comment explaining why this method is
empty, or complete the implementation'.
2020-07-24 11:46:30 +05:30
5f619ae40a
Ensure that data output color is readable on row selection. Fixes #5687
2020-07-21 18:54:06 +05:30
3983e2c13c
Fix the following issues for High Contrast Theme:
...
1) Schema diff compare button icon is not visible on hover.
2) Schema diff for identical section text is not readable due to the same color as the background.
3) Removed extra variables used for set text color for explain - Analysis section (Issue related dark theme.).
4) Issue related to the disabled toggle button.
refs #5653
2020-07-20 15:12:46 +05:30
7edcca9b07
Added High Contrast theme support. Fixes #5653
...
Fixed text color issue in explain analyze for the Dark theme. Fixes #5677
2020-07-20 11:51:21 +05:30
9d0f3ce90b
Fixed code smell 'potential hiding of variables declared in an outer scope'.
2020-07-16 19:53:39 +05:30
703faf3b15
Fixed following SoanrQube issues
...
1) Rename field "node_type" to prevent any misunderstanding/clash with field "NODE_TYPE" defined.
2) Define a constant instead of duplicating this literal.
Solution:
1) Rename the field "NODE_TYPE" and "COLLECTION_LABEL" to "_NODE_TYPE" and "_COLLECTION_LABEL"
2) Declare the constant in PGChildNodeView for SQL files.
2020-07-16 19:39:55 +05:30
2469032f15
Fixed an issue where fetching the schema throws an error if the database
...
is not connected in Schema Diff. Fixes #5673
Maintenance Database is selected by default in Schema Diff.
2020-07-15 13:07:28 +05:30
161c9b0fc7
Fixed code smell 'Variables should not be shadowed'.
...
Fixed all the duplicate CSS blocks issues raised by SonarQube.
2020-07-14 15:45:01 +05:30
357a9179b1
Fixed convention related issues reported by SonarQube.
2020-07-09 18:55:33 +05:30
2cefa9afca
Fixed code smell 'Variables should not be shadowed'.
2020-07-09 18:44:58 +05:30
2db9242f5c
Fixed accessibility issue where few dialogs are not rendering properly
...
when we zoomed in browser window 200% and screen resolution is low.
Fixes #5662
2020-07-09 18:18:37 +05:30
b4c25bdc0a
Fixed code smell 'Functions, methods, and lambdas should not have too many parameters' reported by SonarQube.
2020-07-07 19:39:06 +05:30
ab2dc60097
Fixed the SoanrQube code smell 'Variables should not be shadowed'.
2020-07-07 16:18:18 +05:30
2ebf203412
Fixed issue of error message not getting displayed when filename is empty for backup, restore, and import/export. Fixes #3814 .
2020-07-06 19:04:26 +05:30
45a03dd663
Fixed 'convention' related code smell reported by SonarQube.
2020-07-06 11:48:23 +05:30
fcf720a5d8
Fixed code smell 'Variable should not be shadowed'
2020-07-06 11:31:36 +05:30
80ab596992
Fixed the SoanrQube code smell 'Variables should not be shadowed'.
2020-07-03 14:33:30 +05:30
341c3aded6
Fixed dark theme-related CSS and modify the color codes. Fixes #5287
...
Fixed backgrid row hover issue where on hover background color is set for edit and delete cell only. Fixes #5470
2020-07-03 11:47:40 +05:30
2ec8051303
Remove the duplicate code for tab indent and add the logic into codemirror.
2020-07-03 10:47:39 +05:30
b30c590866
Fixed SonarQube code smell 'Rename function and variable name to match the regular expression'.
2020-07-01 13:50:51 +05:30
c2e875d54b
Fixed tab indent issue on a selection of lines is deleting the content when 'use spaces == true' in the preferences. Fixes #4235
2020-07-01 13:34:48 +05:30
c7a16a4bd5
Fixed code smells having rule 'Nested blocks of code should not be left empty'.
2020-06-26 13:18:27 +05:30
707ff450b5
Fixed following SonarQube issues:
...
1. Boolean checks should not be inverted.
2. The comma operator should not be used.
3. Arguments to built-in functions should match documented types.
4. Redundant pairs of parentheses should be removed.
5. A conditionally executed single line should be denoted by indentation,
6. A while loop should be used instead of a 'for' loop.
2020-06-26 13:12:07 +05:30
d3b3d07f2e
Fixed SonarQube issues with the tag unused. All the unused variables, assignments, code comments are fixed.
2020-06-25 11:09:43 +05:30
15c621b1d8
Fixed following SonarQube issues:
...
1) TypeError can be thrown as <variable_name> might be null or undefined here.
2) Unexpected duplicate "white-space".
3) Unexpected missing generic font family.
4) Unexpected shorthand "padding" after "padding-left".
2020-06-24 15:57:01 +05:30
daad16ea93
Fixed issue related to reducing the if-else statement to single return expression. Reported by SonarQube.
2020-06-22 12:58:48 +05:30
6620f9263d
Fixed issues reported by SonarQube with tag 'bad-practice'.
2020-06-22 12:18:59 +05:30
d6b22f1f4c
Fixed an issue where the search object is unable to locate inherited tables and constraint filters are not working. Fixes #5492
2020-06-22 11:53:00 +05:30
bc24e3643f
More code cleanup for SonarQube.
2020-06-18 16:20:34 +01:00
6d3f13076f
Fixed 'Comma operator should not be used' issue reported by SonarQube.
2020-06-18 16:17:55 +05:30
f0490a54b7
Fixed redundant tagged issue reported by SonarQube.
2020-06-18 11:14:56 +05:30
df05efd7d9
Fixed vulnerabilities and few design suspicions where two conditional structures are having the same implementation.
2020-06-17 17:15:09 +05:30
cb268075c2
1) Added option to ignore the whitespaces while comparing objects in schema diff. Fixes #5468
...
2) Added server group name while selecting servers in schema diff. Fixes #5500
3) Fixed an issue where two identical tables showing different by schema diff tool. Fixes #5584
2020-06-17 16:27:51 +05:30
641f7bbe9d
Some clumsy coding related fixes reported by SonarQube.
2020-06-15 16:50:07 +05:30
eb971a0320
Update Codemirror version to the latest which allows us to set screen reader labels on Codemirror editor.
...
refs #5197
2020-06-08 12:26:12 +05:30
726ecd79e6
Fixed import statements.
...
refs #3669
2020-06-03 12:49:05 +05:30
d22e276586
Ensure that proper error should be displayed for the deleted node. Fixes #3669
2020-06-03 11:26:26 +05:30
e10f1274dc
Ensure that the query tool panel gets closed when clicking on the 'Don't Save' button. Fixes #5416
2020-05-28 16:39:26 +05:30
b1cbcc7ef6
Fixed data truncation issue when updating the data of type character with length. Fixes #5481
2020-05-25 17:05:47 +05:30
d58c33dec0
Search object UI improvements. Fixes #5493
2020-05-18 11:29:12 +05:30
9d08776824
Ensure that maintenance job should be worked properly for indexes under a materialized view. Fixes #4223 .
2020-05-11 16:47:36 +05:30
e73e2d2502
Fixed the errors, and warnings reported by pylama.
...
TODO::
- Don't use unicode in Python 3 for removing the support of Python 2 (
psycopg2 driver - __init__.py, server_manager.py).
- Merge the lastest pgcli (version: 3.0.0) for SQL autocompletion.
2020-05-08 14:13:38 +05:30
d68e6bd892
Remove Python2 modules.
...
refs #5443
2020-05-08 12:28:21 +05:30
a662d866af
Ensure that 'With OID' option should be disabled while taking backup of database server version 12 and above. Fixes #4840
2020-05-07 11:56:43 +05:30
943495de31
Fixed list sorting issue in the schema diff tool. Fixes #5440
...
Fixed an issue while comparing the two identical schemas using the schema diff tool. Fixes #5449
2020-05-06 11:25:43 +05:30
ad80217593
Remove Python2 references from the source code.
...
refs #5443
Initial patch: Neel Patel
2020-04-30 17:22:48 +05:30
86afec860f
Remove Python 2 support from the Python tests.
...
refs #5443
2020-04-30 12:56:45 +05:30
b695329d2d
Fixed API test cases for backup, restore and maintenance.
2020-04-27 21:17:34 +05:30
99d1068f70
Fixed an issue where the search object not able to locate pg_toast_* tables in the pg_toast schema. Fixes #5441
2020-04-27 19:51:56 +05:30
17129b259b
Reverting patch for RM #3269 .
...
We observed that sometimes the browser is getting hanged and sometimes
the ViewData grid is getting disappear. We suspect its due to the number
of rows to update on the slick grid after fetching next of rows.
2020-04-24 11:13:13 +05:30
c76732e3e7
Ensure that default sort order should be using the primary key in View/Edit data. Fixes #5157
2020-04-22 18:47:13 +05:30
b0464500ca
Ensure that the user should not be able to change the authentication source. Fixes #5419
...
Ensure error should be handled properly when LDAP user is created with the same name. Fixes #5420
Fixed an issue where an internal user is not created if the authentication source is set to internal and ldap. Fixes #5432
2020-04-22 18:47:13 +05:30
5e91ed2bb1
Fixed slider jump issue by making an API call to fetch the next batch of rows only after a user stops scrolling down. Fixes #3269
2020-04-22 18:47:13 +05:30
b29bc6868c
Fixed an issue where [null] and [default] values are not get copied. Part of #3947
2020-04-22 12:08:52 +05:30
8d4f3c07c7
Fixed an issue where slider jumps up when new rows get loaded while scrolling down in the DataView panel in the query tool. Fixes #3269
2020-04-21 13:29:49 +05:30
3d516101a4
Fixed an issue wherein grant wizard the last object is not selectable. Fixes #4545
2020-04-21 13:09:15 +05:30
dc4571a3c8
Fixed search object issue when the object name contains special characters. Fixes #5401
2020-04-20 18:40:40 +05:30
7361470b64
Fixed an issue where the search object module unable to locate the object in the browser tree. Fixes #5396
2020-04-20 18:27:36 +05:30
f282b26883
Fixed an issue when the user creates a temporary table with 'on commit drop as' clause. Fixes #4946
2020-04-20 18:22:34 +05:30
4692b21bcf
Fixed an issue where schema diff marks an identical table as different. Fixes #5350
...
Fixed an issue where schema diff showing changes in the identical domain constraints. Fixes #5315
Ignore the keys from the source and target list and also sort both the lists.
2020-04-20 18:04:16 +05:30
36a3d4e53b
Some more gettext() usage fixes:
...
- fixed `%` vs. `.format()`
- unified texts and usage `%s` vs. `{}`/`{0}`
- improved text sentences for translate
- added gettext for next texts
2020-04-20 11:19:09 +05:30
8bdfa18efb
Ensure that if the delimiter is set other than comma then download the file as '.txt' file. Fixes #4573
2020-04-17 17:37:02 +05:30
52d031f2d0
Fixed encoding issue while saving data in encoded charset other than 'utf-8'. Fixes #4684
2020-04-17 16:30:22 +05:30
0ce4f49e08
Fixed copy-paste row issues in View/Edit Data. Fixes #3947
...
1) Copy table rows across two or more active query tool sessions.
2) Copied rows can be pasted multiple times without selecting a row in the query tool grid.
3) Adds an empty row at the end in the query tool grid after pasting rows.
2020-04-16 15:25:39 +05:30
dc1e32a632
Fixed internal server error when the database server is logged in with non-super user. Fixes #5400
2020-04-16 15:05:17 +05:30
c0a2f1f24d
Ensure that text larger than underlying field size should not be truncated automatically. Fixes #5210
2020-04-16 14:39:31 +05:30
c41da41efe
Fixed python exception error when user tries to download the CSV and there is a connection issue. Fixes #4858
2020-04-15 16:46:03 +05:30
ed0a596286
Added alert message to Reset Layout if any of the panels from Query Tool failed to load. Fixes #5366
2020-04-15 16:23:54 +05:30
781b766ac4
Fixed an issue where difference SQL is not seen in the schema diff tool for Types. Fixes #5302
2020-04-13 20:24:12 +05:30
df11f28593
Fixed an issue where the identical packages and sequences visible as different in the schema diff tool. Fixes #5362
2020-04-13 18:06:20 +05:30
014ce31589
Fixed user management related issues:
...
1) Unable to add a user when there are many users. The dialog went blank. Fixed.
2) The error message did not have a close button. Fixed.
3) When clicked on the add button, then the cursor will focus on the email box of
the new row for convenience.
4) When the dialog opens, the cursor will focus on the search text box.
5) By default, the "User" role will be selected when adding a new user.
Also removed an empty option in the roles dropdown.
6) When the search filter is applied and we try to add an already existing user, the
validation is done only on the filtered data and not on all the users' data.
Fixes #5227
2020-04-10 16:49:33 +05:30
6a9af07f7a
Fixed gettext usage:
...
- fixed gettext usage with .format() only for original text with %s
- fixed typos
- fixed translation yes/no buttons in the dialog.
- improved translating sentences without "connecting" words (eg. see web/pgadmin/dashboard/static/js/dashboard.js,
word 'cancel' needs to be translated in the Czech language as 'zrušit' but in another sentence as 'zrušení')
- added gettext for text translations.
2020-04-10 14:52:41 +05:30
e238ecf182
Ensure that OID should be shown in properties for Synonyms. Fixes #5270
2020-04-10 13:19:52 +05:30
c8646f99c0
Fixed typo
2020-04-09 21:46:47 +05:30
31f255b541
Added support of Foreign Tables to the Schema Diff. Fixes #5263
2020-04-09 21:03:28 +05:30
aa7ced4ef1
Fixed a typo in previous commit
2020-04-08 14:30:29 +05:30
d9f6baac72
Various misc fixes:
...
- Using the 'gettext' as oppose to '_', which is not defined
- Define missing variables
- Fixed escape character in string with double quote
- Removed some dead code in a test case
- Removed unnecessary self assignment
Includes some fixes for Accessibility improvements
- Use semantic markup to mark emphasized or special text
- Added hidden legend in <fieldset> for better screen reader support
2020-04-08 14:14:25 +05:30
073e310a5a
[Accessibility] Use semantic markup to mark emphasized or special text.
...
Reference: https://www.w3.org/TR/WCAG20-TECHS/H49.html
2020-04-08 12:27:18 +05:30
134c1802e7
Enable the save button by default when a query tool is opened with CREATE or other scripts. Fixes #4856
2020-04-07 13:54:16 +05:30
33deacacee
Ensure that the grant wizard should be closed on pressing the ESC key. Fixes #4206
2020-04-07 13:48:56 +05:30
e1f990190e
Added search object functionality. Fixes #2172
2020-04-06 17:33:07 +05:30
f77aa3284f
Added LDAP authentication support. Fixes #2186
2020-04-06 15:57:05 +05:30
ce89ae3c1d
Added support of Packages, Sequences and Synonyms to the Schema Diff. Fixes #5264
2020-04-03 16:52:45 +05:30
13b65c9a6a
Fixed tab key navigation issue for Grant Wizard. Fixes #5241
...
1) Added entry for .scss to change the shadow of 'ajs-close' button.
2) allow the user to use the keyboard to update the Backgrid cell DateTime picker control.
2020-03-30 17:31:50 +05:30
94a76cc9e0
Added support of Domain, Domain Constraints and Types to the Schema Diff. Fixes #5262
2020-03-26 14:30:09 +05:30
94864104e4
Added and fixed gettext usage for better translation coverage. Fixes #5284
...
1) Fixed usage gettext('') instead of _('') in javascript files.
2) Fixed usage gettext('') instead of `${gettext('')}` in javascript files,
because "pybabel extract" not support extracting from this syntax.
2020-03-24 11:14:05 +05:30
a7ba446703
Fixed Unicode character issue causing error on Python2 environment. Fixes #5279
2020-03-20 15:17:45 +05:30
96361656e4
Fixed some accessibility issues in the dialogs:
...
1) Aria-label additions at few missing places.
2) Label additions with 'sr-only' class where hidden labels required.
3) Converted label to span to solve accessibility error.
Fixes #4608
2020-03-19 16:08:51 +05:30
4fe69e825e
Added support of Collation, FTS Configuration, FTS Dictionary, FTS Parser, and FTS Template to the Schema Diff. Fixes #5261
2020-03-19 13:54:25 +05:30
44c0d76541
Improve logic to get the DDL statements as a part of the comparison. Fixes #5221
...
Fixed 23 issues related to schema diff.
2020-03-15 14:52:19 +05:30
82155cd859
Fix an accessibility issue to maximize the panel for all alertify dialog. Fixes #5143
2020-03-06 18:47:22 +05:30
4db0a6524d
Fix an issue where debugger not showing all arguments anymore after hitting SQL error while debugging. Fixes #5101
...
Added a "Clear All" button to the argument dialog which will clear all the saved arguments values from SQLite DB.
2020-02-28 15:27:01 +05:30
6d766176c1
Fixed linter error.
2020-02-25 18:41:19 +05:30
eaf4781f5f
1) Added accessibility support in AlertifyJS. Fixes #5154
...
2) Fix accessibility issue for the maximize button of the Alertify dialog. Fixes #5143
2020-02-25 18:23:36 +05:30
9bad590e9e
Improvements in the UI for both default and dark themes. Fixes #5133
...
Improve the style of the highlighted code after query execution for Dark mode. Fixes #4996 .
Changed background pattern for geometry viewer to use #fff for all themes. Fixes #5077
Changed the color of selected and hovered item for Select2 dropdown, also tweak the appearance of the tags in multi-select boxes. Fixes #4955
Fixed Firefox monospaced issue by updating the font to the latest version. Fixes #5184
2020-02-24 14:11:00 +05:30
915b09255c
Added Python 3.8 support. Fixes #5179
...
1) Upgraded passlib==1.7.1 to passlib==1.7.2
2) Replace unmaintained Flask-Security with maintained Flask-Security-Too package, which is also compatible with python 3.8
3) Other compatibility code changes.
2020-02-18 12:10:38 +05:30
26cdda090e
1) Source/Target database and schema should be selected by default when the user selects any server in the schema diff tool.
...
2) Added line break for the generated script if select multiple objects.
3) Remove reactivated RM from the release notes.
2020-02-05 14:36:05 +05:30
641701ca16
Added missing imports and remove unused imports from schema diff.
2020-02-03 15:30:57 +05:30
0d77bc305e
1) Improve wording for script header while generating the script using the schema diff tool.
...
2) Fixed an issue where closing the query tool panel throws an error.
3) Fixed schema diff close panel issue.
2020-02-03 12:38:02 +05:30
3b1c8abd2f
Fixed following issue of schema diff tool:
...
1. Comparison result of 2 exact identical Trigger Functions is different
2. EPAS 12: Table comparison with the compound trigger shown as different, but all SQL panels are blank
3. Compound trigger properties panel is not opening
4. The DDL difference of the table containing the foreign key is not accurate
5. The DDL difference of the view which refers the table from schema is not accurate
6. DDL comparison fails if we have procedure with plpgsql in source and edbsql in target
2020-01-31 21:28:08 +05:30
02f9de5bdb
Improve wordings.
2020-01-28 18:36:42 +05:30
c418a9c9ca
Fixed following schema diff issues:
...
1) Version mismatch should be displayed if you select EPAS 11 as the source and EPAS 12 as the target.
2) We should handle schema diff if the user stops the server after compare.
3) The data type is not visible for column headers in the query tool/view data.
4) Difference SQL is shown, though source & target SQL are same.
5) Error is shown when the 'target only' table is selected & clicked on Generate Script.
6) Difference SQL generated on deleting primary constraints from source throwing error on running from query tool.
7) Copy button for Difference SQL does not work.
8) Incorrect SQL is generated when check constraint from the source table is dropped.
9) Difference SQL is NOT shown when 'Unique Constraint' is dropped from the source table.
10) In case of difference, no message displayed related to copied successfully or not.
11) create or replace trigger should be on the next line.
12) Comparison Result of exactly identical tables having foreign key constraints is shown as different.
13) The wrong SQL displayed in the difference tab for view and materialized view for the select statements.
14) Wrong SQL displayed for the procedure in the difference section.
15) If the user already opens the compare section of Schema diff tool and Disconnects the server then '<' not supported between instances of 'NoneType' and 'int' message displayed.
16) When 'check constraint' is added on the source table which has already unique constraint & identical target table is created, all SQL panels remain empty.
17) Difference SQL is NOT shown when after adding 'Foreign Key' constraint to existing source table.
18) Incorrect SQL is generated when the existing index on the source table is modified.
19) Wrong SQL displayed for function in difference section.
20) Additional space is added before & after in difference SQL generated on the addition of an index to the source table.
21) Difference SQL is NOT shown when tables have different permission/grants.
22) Incorrect SQL is shown when the source had inherited table & target has a normal table.
23) Exactly identical child(inherited) tables show difference SQL.
24) Comparison is NOT working when the custom vacuum is enabled & one of the parameter modified & again custom vacuum is disabled.
2020-01-28 14:53:17 +05:30
f167d77b61
Allow screen-reader to read label & description of non-textable elements. Fixes #4762 .
...
Allow screen-reader to identify the alert errors. Fixes #4763
Added role alertdialog for confirm and alert dialog.
Added role status for all status bars/banners.
Added role alert for error bars.
Added aria-labelledby for charts on each dashboard.
Added tabindex for each chart so that it is navigable using tab key.
2020-01-28 11:32:11 +05:30
f5d46bf9f1
Fixed an issue while editing char[] or character varying[] column from View/Edit data throwing an error.Fixes #4410 .
2020-01-23 14:55:02 +05:30
fde8e4054a
Fixed an issue where Grant wizard unable to handle multiple objects when the query string parameter exceeds its limit. Fixes #4511
2020-01-20 17:53:21 +05:30
8c3bba65e5
Logout the pgAdmin session when no user activity of mouse move, click or keypress. Fixes #5000 .
...
Introduced two config params:
1. USER_INACTIVITY_TIMEOUT - Interval in seconds for the timeout. Default is 0-Zero which means disabled.
2. OVERRIDE_USER_INACTIVITY_TIMEOUT - If set to true, tools like query tool or debugger will override USER_INACTIVITY_TIMEOUT
and will not allow the application to timeout if a query is running for a long time.
2020-01-15 18:07:46 +05:30
d59816054f
Schema Diff Improvements:
...
1. Grid header should be center aligned vertically.
2. Increase the space between object counts.
3. The previous selected objects should not be re-selected on comparison.
2020-01-13 18:19:07 +05:30
45f2e35a99
Added Schema Diff tool to compare two schemas and generate the difference script.
...
Currently supported objects are Table, View, Materialized View, Function and Procedure.
Backend comparison of two schemas implemented by: Akshay Joshi
Fixes #3452 .
2020-01-10 15:42:09 +05:30
01c7636c75
Update copyright notices for 2020.
2020-01-02 14:43:50 +00:00
fc5287bd9f
Added tab navigation for tabs under explain panel in query tool. Fixes #5047 .
2020-01-01 10:51:45 +05:30
8c4dff057f
Added aria-label attribute wherever missing for accessibility.
2020-01-01 10:37:17 +05:30
f1a18749f6
1) Allow screen-reader to read relationship attributes for tab, tabpanels and tables under it. Similar changes are done for subnode controls.
...
2) Add role="img" for font icons.
Fixes #4764
2019-12-17 13:22:36 +05:30
9bda583d5b
Added aria-label to the buttons in the debugger.
2019-12-11 14:52:15 +05:30
6e2cf8ced2
Changed the open query tool and data filter icons. Fixes #4990 .
2019-12-06 19:27:55 +05:30
f8e443bda7
Fix scrolling issue in 'Users' dialog. Fixes #4220 .
2019-12-05 17:50:19 +05:30
0bd26222d8
Fix query tool launch error if user name contains HTML characters. It's a regression. Fixes #4674 .
2019-12-05 13:13:33 +05:30
ac2bd5e6ee
Use a 'play' icon for the Execute Query button in the Query Tool for greater consistency with other applications. Fixes #4711
2019-12-02 20:44:54 -05:00
cccc6e5676
Added role=status attribute to all the status messages for accessibility. Fixes #4773 .
2019-12-02 14:15:31 +05:30
4ed2d74d9c
1) Fix network disconnect issue while establishing the connection via SSH Tunnel and it impossible to expand the Servers node. Fixes #4724 .
...
2) Fix server connection drops out issue in query tool. Fixes #4818
3) Fix VPN network disconnect issue where pgAdmin4 hangs on expanding the Servers node. Fixes #4926 .
4) Ensure that the Servers collection node should expand independently of server connections. Fixes #4933 .
Set the default connection timeout to 10 seconds instead of 0.
2019-11-26 09:04:41 +05:30
425cc2a966
Fix some more feature tests:
...
1. Added an attribute 'data-click-counter' in query execute button which gets incremented
once query button is clicked up to 9 and then reset to 0. This is added just to support automation.
2. Locator for login_group_role is added and used to expand tree.
3. Functions for enabling and disable auto_commit and auto_rollback are made more precise.
4. Some scrolling problem is addressed in view_data_dml_query test.
5. Handled the stale element reference exception in query_tool_journey_test
2019-11-20 12:50:04 +05:30
3d4d40fa02
Fix the help button link on the User Management dialog. Fixes #4934
2019-11-14 11:51:26 +00:00
c1c682402a
1) Further styling tweaks for Dark Theme.
...
2) Theme related code changes are removed from config.py and moved to miscellaneous under a new package - "themes".
2019-11-11 18:47:43 +05:30
2522c8c9e2
Fixed an issue where escape key not working to close the open/save file dialog. Fixes #4896
2019-11-08 18:26:46 +05:30
8180403f97
1) Added support for custom theme creation and selection. Fixes #4348 .
...
2) Added Dark(Beta) UI Theme option. Fixes #3741 .
3) Fix an issue where a black arrow-kind image is displaying at the background of browser tree images. Fixes #4171
Changes include:
1) New theme option in preferences - Miscellaneous -> Themes. You can select the theme from the dropdown.
It also has a preview of the theme just below the dropdown. Note that, a page refresh is needed to apply changes.
On saving, a dialog appears to ask for refresh.
2) You can create your own theme and submit to hackers. README is updated to help you create a theme. Theme will be available only after the bundle.
3) Correction of SASS variables at few places and few other CSS corrections.
4) Added iconfont-webpack-plugin, which will convert all the SVG files(monochrome) used as icons for buttons to font icons.
This will allow us to change the color of the icon by using CSS color property.
5) All the .css files will bundle into a separate file now- pgadmin.style.css. This will help reduce the size of
theme CSS files as CSS in .css files will not change with the change of SASS variables.
2019-11-07 18:51:03 +05:30
30c7effa50
Fix the toggle case shortcut key combination. Fixes #3999
2019-11-01 12:10:14 +00:00
2182dc3cc5
2 fixes for the backup dialogue when using directory format:
...
Ensure compression level is passed to pg_dump when backing up in directory format. Fixes #4482
Ensure the number of jobs can be specified when backing up in directory format. Fixes #4483
2019-10-25 13:21:53 +01:00
6d7ff9444a
Don't quote bigints when copying them from the Query Tool results grid. Fixes #4459
2019-10-25 11:53:39 +01:00
d056a94f0c
popen() function strips the quotes from the arguments, so backup fails
...
for the schema name that needs quoting.
Code is changed to add escapers.
Fixes #4590
2019-10-10 17:58:32 +05:30
f16498a8a7
Optimize Webpack to improve overall performance.
...
Changes include:
1) Remove underscore-string and sprintf-js packages as we were using only %s. Instead, added a function to do the same. Also changed gettext to behave like sprintf directly.
2) backgrid.sizeable.columns was not used anywhere, removed. @babel/polyfill is deprecated, replaced it with core-js.
3) Moved few css to make sure they get minified and bundled.
4) Added Flask-Compress to send static files as compressed gzip. This will reduce network traffic and improve initial load time for pgAdmin.
5) Split few JS files to make code reusable.
6) Lazy load few modules like leaflet, wkx is required only if geometry viewer is opened. snapsvg loaded only when explain plan is executed. This will improve sqleditor initial opening time.
Reviewed By: Khushboo Vashi
Fixes #4701
2019-10-10 12:05:28 +05:30
1e4fd552ac
Ensure backup a partition table should not backup the whole database.
...
For the partition table same argument '--table' is used with pg_dump.
Fixes #3386
2019-10-07 16:32:37 +05:30
bf2c001c87
Export job fails when deselecting all the columns.
...
Select2 parameter 'first_empty' should be set to false for the controls of type array.
If it is true then on deselecting/clearing all the values, an empty entry is still there.
Fixes #4751
2019-10-04 13:00:39 +05:30
6032692de0
Unable to open Query tool on Internet Explorer.
...
Remove extra comma in the function argument while starting the query tool.
Other browsers had no problems, but it is an issue on Internet explorer.
Fixes #4769
2019-09-27 14:32:52 +05:30
56e00d74ad
There is no option to Copy data with headers from Query Tool/View Data.
...
Added drop-down 'Copy with headers' near to the copy button in Query Tool/View Data.
Fixes #3009
2019-09-27 12:14:39 +05:30
051e5038b5
Fix issue where query history is not visible in the query history tab. Fixes #4777
2019-09-25 13:18:33 +05:30
73dc130908
Fix issue where pgAdmin does not load completely if loaded in an iframe. Fixes #4756
2019-09-23 12:55:02 +05:30
1bef98fdfa
Ensure that 'ENTER' key in the data filter should not run the query. Fixes #4199
2019-09-20 18:13:44 +05:30
b10378fe70
Fix query history issue for Python 2.7, it is a regression of #4750 .
2019-09-17 11:01:13 +05:30
80b05973c6
Fix query history exception for Python 3.6. Fixes #4750 .
2019-09-16 19:09:22 +05:30
83170a0e94
Fix display of validation error message in SlickGrid cells. Fixes #4408
2019-09-12 20:27:44 -04:00
1c2ba72f02
Add editor options for plain text mode and to disable block folding to
...
workaround rendering speed issues in CodeMirror with very large scripts.
Fixes #4631 .
Re-arrange editor options in the Preferences dialogue to tidy things up.
2019-09-04 15:46:08 +01:00
04357b7a55
Fix error while importing data to a table using Import/Export dialog and providing Not null columns option. Fixes #4461 .
2019-09-03 11:19:33 +05:30
a68f0702e2
Re-fix database name unescaping the query tool title bar.
2019-09-02 16:57:28 +01:00
47f26cc377
Fix exception in query history for python 2.7. Fixes #4663
2019-08-30 09:07:03 +05:30
028473eb83
Fix an issue where oid column should not be pasted when copy/paste row is used on query output containing the oid column. Fixes #4381
2019-08-28 13:35:40 +05:30
dbbbb2e5ed
Fix query tool launch error if user name contain html characters. Fixes #4674
2019-08-28 10:46:28 +05:30
f8f7d5ac6f
Ensure editable and read-only columns in Query Tool should be identified by icons and tooltips in the column header. Fixes #4667
2019-08-26 14:17:40 +05:30
5887fb3815
Some refactoring of sqleditor.js.
2019-08-23 16:15:43 +01:00
234efc3be7
Don't wait for the database connection before rendering the Query Tool UI, for improved UX. Fixes #4453
...
In addition, unescape HTML entities in database names in the Query Tool title bar. Fixes #4584
2019-08-23 12:14:20 +01:00
3dadb8989b
Fix a debugger error when using Python 2.7. Fixes #4419
...
Also fixes a minor bug where a reload warning was unnecessarily given when closing the debugger.
2019-08-23 09:43:51 +01:00
ed76787b76
Fix the Transaction Status failed test cases.
2019-08-20 10:22:11 +05:30
624f229ce7
Comment out the failed Transaction Status API test cases for successful Jenkins build
2019-08-20 09:33:42 +05:30
3155380621
Fix issue where Deleting N number of rows makes first N number of rows disable. Fixes #3605
2019-08-19 12:12:28 +05:30
663e8382f3
1) Added new python test that checks the transaction status after executing queries and saving data when auto-commit is on/off.
...
2) Some refactoring of previously written python tests.
2019-08-19 11:45:36 +05:30
687204771c
Add support in query history to show internal queries generated by pgAdmin during save data operations. Fixes #4612
2019-08-16 17:17:12 +05:30
a51de78292
Fix issue in drag drop feature. It's regression of RM #4552
2019-08-12 13:11:56 +05:30
b618dfe286
Fix double click issue to expand the contents of a cell if the resultset was not editable. Fixes #4585
2019-08-09 11:45:05 +05:30
99a8b70e00
Fix some errors thrown on the JS console when dragging text in the Query Tool. Fixes #4552
2019-08-02 11:28:57 +01:00
0cfd76c279
Fix load on demand in View/Edit data mode. Fixes #4536
2019-08-02 10:39:19 +01:00
97e39699ea
Ensure the Query Tool doesn't throw an error when viewing the contents of a table with no columns. Fixes #4492
2019-08-01 14:39:02 +01:00
76e658ee12
Ensure command tags are shown in the messages tab of the Query Tool. Fixes #4520
2019-08-01 14:29:38 +01:00
7b65507533
Ensure the query tool will work with older versions of psycopg2 than we officially support, albeit without updateable resultsets. Fixes #4520
2019-08-01 13:59:53 +01:00
bcb1392a1a
Ensure type names are properly encoded in the results grid. Fixes #4401
2019-08-01 13:17:00 +01:00
82d209946f
Added support for editing of result sets from tables with OIDs in query tool.
2019-07-29 12:26:53 +05:30
c019778a47
1) Fix an error while retrieving json data from the table. Fixes #4427
...
2) Fix an issue where Explain and Explain Analyze are not working, it's regression of #1760 . Fixes #4484
3) Fix an issue where Filter toolbar button is not working in view/edit data, it's regression of keyboard navigation. Fixes #4485
2019-07-22 18:42:48 +05:30
f5b927b925
Randomise table names for tests.
2019-07-17 16:50:59 +01:00
710d520631
Add support for editing of resultsets in the Query Tool, if the data can be identified as updatable. Fixes #1760
...
When a query is run in the Query Tool, check if the source of the columns
can be identified as being from a single table, and that we have all
columns that make up the primary key. If so, consider the resultset to
be editable and allow the user to edit data and add/remove rows in the
grid. Changes to data are saved using SAVEPOINTs as part of any
transaction that's in progress, and rolled back if there are integrity
violations, without otherwise affecting the ongoing transaction.
Implemented by Yosry Muhammad as a Google Summer of Code project.
2019-07-17 11:45:20 +01:00
6b5ca07715
Fix external utility tests to run on Windows
2019-07-12 13:55:18 +01:00
3f4d5a687b
Rename horribly named function.
2019-07-12 13:00:23 +01:00
3dd1e8e102
Fix wording.
2019-07-12 11:17:35 +01:00
bd0e4a5a8f
Remove some files committed in error.
2019-07-08 12:07:50 +01:00
11a3aa56be
Use different folders for pg vs. ppas RE-SQL tests. Fall back to the tests folder without a subdirectory if neither exist.
2019-07-05 14:40:51 +01:00
0aa18fd466
Ensure drag/drop from the treeview works as expected on Firefox. Fixes #4429
2019-07-04 14:49:09 +01:00
0340b8fb28
Add EXPLAIN options for SETTINGS and SUMMARY. Fixes #4335
...
Prevent flickering of large tooltips on the Graphical EXPLAIN canvas. Fixes #4224
EXPLAIN options should be Query Tool instance-specific. Fixes #4395
2019-07-03 13:57:56 +01:00
da8cf14047
Prevent an error that may occur when editing data with an integer primary key. Fixes #4404
2019-06-27 10:43:25 -04:00
2451db8797
Ensure the browser close confirmation is only shown when closing a Query Tool which is running in a separate browser tab. Fixes #4403
2019-06-27 10:37:50 -04:00
173b812b93
Allow some objects to be dragged/dropped into the Query Tool to insert their signature into the query text. Fixes #4139
2019-06-27 10:30:05 -04:00
c39d257bf6
Fix an XSS issue when username contains XSS vulnerable text. Fixes #4386
2019-06-24 16:06:03 +05:30
ebb5e3fe65
Ensure Python escaping matched JS escaping and fix a minor XSS issue in the Query Tool that required superuser access to trigger. Fixes #4378
2019-06-21 09:53:57 +01:00
78d55c7cc0
Fix regression tests.
2019-06-20 13:26:06 +01:00
6e8ebbd375
Allow editing of data where a primary key column includes a % sign in the value. Fixes #4036
...
Fix an XSS issue seen in View/Edit data mode if a column name includes HTML. Fixes #4367
2019-06-20 12:21:37 +01:00
5c0ea0c012
Capitalize the word 'export' used in Import/Export module. Fixes #4345
2019-06-19 16:17:29 +05:30
ce7679c4bd
Added missing __init__.py file in debugger utils which is required for Python 2.7
2019-06-19 13:31:48 +05:30
b36d5d153b
Ensure the debugger control buttons are only enabled once initialisation is complete. Fixes #4360
2019-06-18 14:46:28 +01:00
bf548dda3f
Fix help links for backup globals and backup server. Fixes #4365
2019-06-17 13:27:21 +05:30
2894c6cd14
Add minor change missed in previous commit. Fixes #4329
2019-06-14 12:46:48 +01:00
23364464c2
Ensure the correct label is used in panel headers when viewing filtered rows. Fixes #4228
2019-06-11 15:11:23 +01:00
5437a8adab
Fix an initialisation error when two functions with parameters are debugged in parallel. Fixes #4329
2019-06-10 14:58:07 +01:00
6d52f2b911
Initial support for PostgreSQL 12. Fixes #4283 . Fixes #4288 . Fixes #4290 .
2019-06-10 14:24:45 +01:00
f561c0cee6
Fix keyboard navigation in "inner" tabsets such as the Query Tool and Debugger. Fixes #4195
2019-06-10 11:10:49 +01:00
2dd075161d
Allow the UI layout to be fully locked or to prevent docking changes. Fixes #2653
2019-05-31 11:51:30 -04:00
2185ea302d
Omit the geometry viewer in the Query Tool from layout saving. Fixes #4169
2019-05-30 15:15:37 -04:00
dfa892d2a2
1. Added Master Password to increase the security of saved passwords. Fixes #4184
...
2. In server(web) mode, update all the saved server credentials when user password is changed. Fixes #3377
2019-05-28 12:00:18 +05:30
6f0eafb223
Fixed CSRF security vulnerability issue. per Alvin Lindstam. Fixes #4217
...
Initial patch by: Khushboo Vashi
Modified by: Ashesh Vashi and Murtuza Zabuawala
2019-05-28 10:59:51 +05:30
ee37be56f9
Fix handling of JSON in the Query Tool with NULL elements. Fixes #4263
2019-05-23 08:53:29 +01:00
2cd58efcdd
1) Fixed Tab key navigation for Maintenance dialog. Fixes #4227
...
2) Fix Tab key issue for Toggle switch controls and button on the dialog footer in Safari browser. Fixes #4244
2019-05-15 16:37:06 +05:30
b7121bb2d2
1) Make folder name pluralise inside 'templates' folder and fix naming inconsistency.
...
2) Remove unwanted functions "module_js()" from the code.
3) Change naming convention for 'Roles' module.
2019-05-15 15:11:54 +05:30
05ae330030
Improvement for 'beforeunload' event, bind the event only from where it is required.
2019-04-22 11:30:33 +05:30
49b318c39e
Ensure that confirmation dialog should be popped up before reload of query tool or debugger
...
if it is opened in a new browser tab. Fixes #4101
2019-04-18 15:39:36 +05:30
0b47d1dbf6
1) Fix an issue where Deleting N number of rows makes first N number of rows disable. Fixes #3605
...
2) Ensure that on clicking Delete button should not delete rows immediately from the database server,
it should be deleted when Save button will be clicked. Fixes #2392
2019-04-18 12:09:35 +05:30
a25bb2b7db
Add tests for the CSV download.
2019-04-11 17:15:01 +01:00
a9d964b5ca
1) Added support for Default Partition. Fixes #3938
...
2) Ensure that record should be add/edited for root partition table with primary keys. Fixes #4104
2019-04-11 13:25:24 +05:30
5c4c09f237
Fixed feature test issues
2019-04-05 12:25:03 +05:30
7627e9c699
Display errors during CSV download from the Query Tool in the UI rather than putting them in the CSV file. Fixes #4085
...
Ensure the toolbar buttons are properly reset following a CSV download in the Query Tool. Fixes #4096
2019-03-29 14:31:33 +00:00
fbc6aea497
Fix an issue where JSON data would not be rendered in the Query Tool. Fixes #4105
2019-03-28 08:12:09 -04:00
6fb35f2649
Overhaul the layout saving code so it includes the Query Tool and Debugger, and stores the layout when change events are detected rather than (unreliably) on exit. Fixes #4084
2019-03-26 11:08:45 -04:00
be26fc540c
Many fixes to the stability of the feature tests, including:
...
tree toggle issue
Query tool inteliSence issue eg. when there is only one option and drop down is not shown
Backup and restore windows locator changes
Fixes required due to resolving rm # 4041
Dependent tab not showing data sometime, so refreshed the page and handled it
Due to change of logic for auto commit, did the required changes
Due to fix of RM 4062, did the required workaround which broke the test case.
2019-03-21 12:04:37 +00:00
8c5894dd6a
Revert "Remove the cp1252 test to see if it un-breaks the Windows buildfarm runs."
...
This reverts commit ce51204
2019-03-18 09:28:28 +00:00
04c776cbeb
Randomise the database name used for encoding tests to avoid collisions when multiple tests are running against the same server.
2019-03-15 12:03:42 +00:00
ce5120431b
Remove the cp1252 test to see if it un-breaks the Windows buildfarm runs.
2019-03-15 11:01:53 +00:00
e4417229aa
Update all Python and JS dependencies. Fixes #4019
2019-03-14 15:11:16 +00:00
ab9a3a57ad
Make the Query Tool history persistent across sessions. Fixes #4017
2019-03-13 13:37:34 +00:00
2356988bdf
Ensure that Firefox prompts for a filename/location when downloading query results as a CSV file. Fixes #4071
2019-03-12 12:45:25 +00:00
6aae9d6e20
Handle resultsets with zero columns correctly in the Query Tool. Fixes #4054
2019-03-07 15:22:45 +00:00
4b895941b3
Remove the large and unnecessary dependency on React and 87 other related libraries. Fixes #4018
2019-03-07 10:51:59 +00:00
d7bf6ec69f
String review and subsequent cleanup
...
Ashesh Vashi
Abhilasha Narendra
Karen Blatchley
Susan Douglas
Dave Page
2019-03-05 14:08:16 +00:00
0aeb20ee64
Prevent auto-commit/rollback being changed mid-transaction, and make the Preferences the defaults, not the current values.
2019-03-04 10:44:31 +00:00
36ffdb93e8
Custom-encode forward slashes in URL parameters as Apache HTTPD doesn't allow them in some cases. Fixes #3998
2019-03-01 14:55:25 +00:00
849e34c2f7
Add full support and testsfor all PG server side encodings. Fixes #3992 . Fixes #3982 . Fixes #3911
2019-03-01 13:51:50 +00:00
fb747b8031
Fix download CSV for IE11 which doesn't support the download attribute. Fixes #4040
2019-03-01 13:32:40 +00:00
c6d295727c
Fix resizing of the results grid, when full of data.
2019-03-01 12:49:41 +00:00
74cfeabd02
Fix graphical explain now that JSON data is sent as text to stop JS futzing with it. Fixes #4041
2019-03-01 12:38:57 +00:00
acb61f0990
Use POST instead of GET for Query Tool downloads to avoid errors with long queries. Fixes #4013
2019-02-27 17:08:53 +00:00
6b3a628e7a
Fix double scrollbar on the query tool results grid.
2019-02-27 10:59:58 +00:00
9c5b9364b6
Support double-click on Query Tool result grid column resize handles to auto-size to the content. Fixes #4034
2019-02-26 13:44:16 +00:00
59446bb4b5
Ensure JSON data isn't modified in-flight by psycopg2 when using View/Edit data. Fixes #3600
2019-02-25 10:34:36 +00:00
27d3990ba2
Allow editing of values in columns with the oid datatype which are not an actual row OID. Fixes #3418
2019-02-22 16:18:39 +00:00
38b034ec3c
Add Commit and Rollback buttons to the Query Tool. Fixes #2418
2019-02-22 14:28:05 +00:00
0766b17726
Enable/disable the Download button with the Execute button.
2019-02-22 09:34:48 +00:00
98283c1213
Disable the editor and execute functions whilst queries are executing. Fixes #4021
2019-02-21 14:19:25 +00:00
5be0d17df5
Don't exclude SELECT statements from transaction management in the Query Tool in case they call data-modifying functions. Fixes #3958
2019-02-21 14:05:10 +00:00
34045efb38
Modify the Download as CSV option to use the same connection as the Query Tool its running in so temporary tables etc. can be used. Fixes #3673
2019-02-20 11:49:45 +00:00
841af6868d
Fix paste issue during commit :-s
2019-02-18 17:08:18 +00:00
e2482d2294
Set the background colour for backform notes, and add an icon. Fixes #3948
2019-02-18 16:59:39 +00:00
255afe673a
Add a "scratch pad" to the Query Tool to hold text snippets whilst editing. Fixes #2233
2019-02-15 15:44:49 +00:00
c64373435b
Make the Query Tool tab titles more concise and useful. Fixes #3544
2019-02-15 15:09:49 +00:00
944cc55df7
Prevent an error when closing the Sort/Filter dialogue with an empty filter string. Fixes #3970
2019-02-13 16:44:57 +00:00
1fc66406f5
Don't embed docs and external sites in iframes, to allow the external sites to set X-FRAME-OPTIONS = DENY for security. Fxies #3985
2019-02-12 16:07:38 +00:00
22d458b01e
Close connections gracefully when the user logs out of pgAdmin. Fixes #3942
2019-02-06 13:17:52 +00:00
8f4d1f14f2
1) Fix alignment of import/export toggle switch. Fixes #3963
...
2) Remove unnecessary options for toggle switch which are already the default options.
2019-02-06 16:49:36 +05:30
4a75053514
Clean up the unwanted extended versions of Backform Switch controls.
...
The Bootstrap Switch Control was extended only for alignment in most
places. IIntroduce a configurable option to set the necessary class
on the main div and also remove the extra extended controls.
2019-02-05 16:22:35 +00:00
9c21c07fc4
Correct error message.
2019-02-04 10:23:43 +00:00
dae8186c2a
Replace Bootstrap switch with Bootstrap4 toggle to improve the performance. Fixes #3051
2019-02-04 11:31:48 +05:30
cbd8f8236a
Remove Python 2.6 code that's now obsolete. Fixes #3935
2019-01-31 13:47:56 +01:00
317a04eafc
Handle backend errors properly and display them correctly on GUI for Grant Wizard
2019-01-30 16:39:34 +05:30
0e489df7b0
Fixed debugger issue for procedure inside package for EPAS servers. Fixes #3927
2019-01-30 14:48:58 +05:30
fedbcd4045
Ensure that output of the query should be displayed even if Data Output window is detached from the Query Tool. Fixes #3697
2019-01-29 18:48:21 +05:30
821496dc84
Fixed Query Tool Initialization Error. Fixes #3903
2019-01-29 11:45:31 +05:30
07f16f40cd
Ensure that grant wizard should list down functions for EPAS server running with no-redwood-compat mode. Fixes #3935
2019-01-28 12:47:27 +05:30
d9fc9fdc4d
Ensure object names in external process dialogues are properly escaped. Fixes #3872
2019-01-24 16:34:18 +00:00
42c7ae372f
Fixed dialog tab navigation for Backup and Restore dialog. Fixes regression of #3862
2019-01-24 17:15:12 +05:30
f316e0533e
1) Messages tab of query tool should be clear on subsequent execution of table/view using View/Edit Data. Fixes #3608
...
2) Clear drop-down menu should be disabled for View/Edit Data. Fixes #3609
2019-01-23 18:25:33 +05:30
1f29859040
Improve application level exception handling for unhandled exceptions.
2019-01-23 12:49:05 +05:30
f731ab730b
Fixed keyboard navigation for dialog tabs. Fixes #3862
2019-01-22 16:28:32 +05:30
3e7381414f
Drop-down should be closed when click on any other toolbar button. Fixes #3858
2019-01-22 16:05:02 +05:30
a163edec7a
Inline edbspl trigger functions should not be visible in Grant Wizard. Fixes #3740
2019-01-17 18:37:36 +05:30
7ac4e2a9d9
Fixed following issues:
...
- Process watcher made fixed width with header changes, time details rounded to 2 decimals
- Query history will show "No query history" if no query fired. Query editor default size increased.
- Fixed a bug where New folder create button not working when in List mode and No files/folder present.
- Other minor improvements.
2019-01-16 11:55:08 +05:30
d4a2f1b8cd
Ensure that last row of table data should be visible and user will be able to add new row. Fixes #3866
2019-01-11 23:25:05 +05:30
8fb340d23b
Fix ordering of VACUUM options which changed in PG11. Fixes #3836
...
While we're at it, fix the JSON handling in the maintenance/backup/restore routes.
2019-01-10 15:29:55 +05:30
868622912e
Fix help for the backup/restore dialogues. Fixes #3861
2019-01-10 11:20:42 +05:30
3c7742f3b2
Fixed an issue while creating export job. Fixes #3856
2019-01-08 13:02:29 +05:30
598f69b63d
Improve wording.
2019-01-03 15:24:47 +00:00
7d765fea04
Further styling fixes.
2019-01-03 14:50:24 +00:00
e23d307c56
Update copyright notices for 2019
2019-01-02 15:54:12 +05:30
86ecf9c84e
Fixed following:
...
- Base font size changed from 0.815rem to 0.875rem, for navbar from 0.875rem to 0.925rem.
- Dialog sizes made consistent throughout the application. Now there are 3 size options for width and height each - sm, md, lg. Combination of any of these to be used hereafter
- Alignment fix for controls of Node properties dialogs which includes showing text and label in one line without dialog size change, checkbox alignment, switch control alignment at places and other minor improvements in other dialogs
- Error message design change in dialogs validation
- SQL Editor data grid editor popup design changes which were missed
- Design change for dashboard server activity grid
- Login page language dropdown color fix
- Properties accordion collapse design fix
- Help, Info icon fixed across all dialogs which were not working if clicked exactly on the text
- Added missing icon with buttons at few places
- Shadow behind the dialogs is increased to make it look clearly separated and depth.
- Control Alignment fix in maintenance dialog
- Min height of alertify dialogs set for better UX
- File dialog design fix when no files found
- Grant wizard fixes - Scroll bar visibility on first page, use full space for SQL generated on the last page
- Browser toolbar buttons changed to sync with SQL editor toolbar buttons
- Rounded corners for docker floating dialog (no properties)
- Renaming file in file dialog should show original file name
- SQL data grid text edit popup buttons behaviour was swapped. This is fixed.
- Import/Export dialog changes as per new design.
2019-01-02 15:07:59 +05:30
41c028f944
Ensure that null values handled properly in CSV download. Fixes #3780
2019-01-01 15:15:36 +05:30
5799ac14ba
Improvement in the look and feel of the whole application
...
Changed the SCSS/CSS for the below third party libraries to adopt the
new look 'n' feel:
- wcDocker
- Alertify dialogs, and notifications
- AciTree
- Bootstrap Navbar
- Bootstrap Tabs
- Bootstrap Drop-Down menu
- Backgrid
- Select2
Adopated the new the look 'n' feel for the dialogs, wizard, properties,
tab panels, tabs, fieldset, subnode control, spinner control, HTML
table, and other form controls.
- Font is changed to Roboto
- Using SCSS variables to define the look 'n' feel
- Designer background images for the Login, and Forget password pages in
'web' mode
- Improved the look 'n' feel for the key selection in the preferences
dialog
- Table classes consistency changes across the application
- File Open and Save dialog list view changes
Author(s): Aditya Toshniwal & Khushboo Vashi
2018-12-21 17:14:55 +05:30
d14fb85fff
Tweak the wording on the Grant Wizard. Fixes #3796
2018-12-20 10:17:00 +00:00
52fb8e197f
Increase the size of the resize handle of the edit grid text pop-out. Fixes #3083
...
Allow horizontal sizing of the edit grid text pop-out. Fixes #3805
2018-12-13 10:56:45 +00:00
12ef55334b
Fix encoding test for older Python versions.
2018-12-06 10:15:58 +00:00
7e3bd8b88a
Fix an encoding issue in the query tool. Fixes #3711
2018-12-04 17:03:19 +00:00
660293456c
Don't use a hard coded server ID for mocking!
2018-12-04 13:07:35 +00:00
0100997aab
Hide Radio buttons that should not be shown on the maintenance dialogue.
2018-12-04 11:00:58 +00:00
f4f0fa0e47
Fix utility route check for Windows.
2018-12-04 10:46:59 +00:00
9a3047c89c
Add API tests for utility check route. Fixes #3790
2018-11-30 09:56:41 +00:00
d801ed5008
Add titles to the code areas of the Query Tool and Debugger to ensure that panels can be re-docked within them. Fixes #3619
2018-11-29 15:47:48 +00:00
bdf9f3404f
Fix handling of array types as inputs to the debugger. Fixes #3354
2018-11-27 11:18:47 +00:00
c79ac2f8d2
Fix some minor CSS issues.
2018-11-27 10:57:30 +00:00
05e067035f
Prevent the debugger controls being pressed again before previous processing is complete. Fixes #3734
...
Note that this needs to be re-visited in the future, as the current fix is somewhat hacky.
2018-11-20 16:35:27 +00:00
782b7419f6
Fix toggle breakpoints buttons in the debugger. Fixes #3736
2018-11-20 16:22:56 +00:00
ef68cae1f1
Properly report errors when debugging cannot be started. Fixes #3723
2018-11-15 15:18:12 -05:00
220fdf583e
Allow use of 0 (integer) and empty strings as parameters in the debugger. Fixes #3629
2018-11-02 16:44:09 +00:00
3359a0de7a
Allow the selection order to be preserved in the Select2 control to fix column ordering in data Import/Export. Fixes #3029
2018-10-31 10:09:40 +00:00
0d5a6eeeff
Ensure that utility existence check should work for schema and
...
other child objects while taking Backup/Restore. Fixes #3722
2018-10-25 18:55:21 +05:30
6ddab02769
1) Fixed process watcher status message when user has stopped the process.
...
2) Saved the process state in sqlite database.
2018-10-25 17:03:34 +05:30
2058cdf662
Fixed test cases for Utilities when default_binary_path is not provided in test_config file.
2018-10-22 13:22:35 +05:30
6bc6bc7f60
Ensure that Utilities(Backup/Restore/Maintenence/Import-Export) should not be started
...
if binary path is wrong and also added 'Stop Process' button to cancel the process.
2018-10-22 12:35:53 +05:30
6991c06937
Additional Bootstrap 4 fixes:
...
- Calendar control
- Query Tool's Sort/Filter drop down
- Backform hidden controls
- Debugger toolbar
2018-10-11 13:23:59 +01:00
55cf0cf2f9
Fix message.
2018-10-10 13:30:55 +01:00
0565f8dd78
Update to use Bootstrap 3 instead of Bootstrap 4. Fixes #3562
2018-10-10 12:43:26 +01:00
c66840bc8e
Fix some styling regressed in #2927 .
2018-10-09 11:22:54 +01:00
26ad6d4c5d
Rename the 'SQL Editor' section of the Preferences to 'Query Tool' as it applies to the whole tool, not just the editor. Fixes #3660
2018-10-08 11:43:02 +01:00
15fe26a710
Fix handling of backslashes in the edit grid. Fixes #3551
2018-09-25 10:34:33 -04:00
1b20831338
Ensure changes to Query Tool settings from the Preferences dialogue are applied before executing queries. Fixes #3657
2018-09-19 16:50:11 +01:00
0ec3224212
Fix logic around validation and highlighting of Sort/Filter in the Query Tool. Fixes #3607
2018-09-14 14:18:43 +01:00
532cbe216a
Add shortcuts for View Data and the Query tool to the Browser header bar. Fixes #3564
2018-09-10 15:16:13 +01:00
82c9cca683
Move all CSS into SCSS files for consistency and ease of colour maintenance etc. Fixes #2927
2018-09-04 11:24:51 +01:00
89e283fbc2
Add a geometry viewer that can render PostGIS data on a blank canvas or various map sources. Fixes #1407
2018-08-30 13:59:44 +01:00
283a69a21a
Fix auto scrolling issue in debugger on step in and step out. Fixes #3554 .
2018-08-29 18:20:45 +05:30
208ee4da8c
Fixed debugger execution issues:
...
1. Allow debugging of EPAS package procedures/functions with INOUT params.
2. Add support for indirect debugging for EPAS package procedures/functions.
3. Allow debugging with NULL param values.
4. Remove saved debug arguments.
Fixes #3191
2018-08-29 17:44:37 +05:30
25679fd542
Ensure sort/filter dialog should display proper message after losing database connection. Fixes #3561
2018-08-22 16:38:31 +05:30
0ab1305ddf
1. Added new backup/restore options for PostgreSQL 11. Fixes #3503
...
2. Ensure backup should work with '--data-only' and '--schema-only' for any format. Fixes #3347
3. Added supported "Dump Options" for "pg_dumpall" which was not there since pgAdmin 3.
4. Fixed issue where "--clean" should not clubbed with "--data-only" while taking backup.
5. Fixed "--oids" should not clubbed with "--inserts" or "--column-inserts" while taking backup.
2018-08-22 12:17:50 +05:30
70c95fcdd5
Stabilise feature tests for continuous running on CI systems. Fixes #3136 .
2018-08-21 17:39:36 +05:30
57660d131f
1) Fix sort/filter dialog editing issue. Fixes #3558 .
...
2) Fix sort/filter dialog issue where it incorrectly requires ASC/DESC. Fixes #3325 .
2018-08-21 13:05:40 +05:30
d68c967423
Fix passing of --globals-only to global backups.
2018-08-16 14:20:32 +01:00
7b2c1bb9f8
Handle connection errors properly in the query tool. Fixes #3528
2018-08-10 13:51:32 +01:00
c8c5f83dfe
Add support to save and clear SSH Tunnel password. Fixes #3511
2018-08-06 15:56:46 +05:30
52fc0846cd
pgAdmin4 should work with python 3.7, Fixes #3458
2018-08-06 15:35:03 +05:30
8f45e6fe68
View Data->Filtered Rows dialog should be displayed. Fixes #3527
2018-08-02 18:15:58 +05:30
f7e43d5e50
Realtime preference handling for the Dashboards and Debugger. Fixes #3294
2018-07-24 16:31:44 +01:00
c353135a3a
Add support for INCLUDE columns on indexes and index constraints with PG 11+. Fixes #3462
2018-07-19 13:13:37 +01:00
1fc82d328c
Fix backup in directory format on Windows.
2018-07-17 13:04:28 +01:00
ba8f745f70
Exclude system columns in Import/Export. Fixes #3448
2018-07-17 13:01:40 +01:00
8869fd6eb3
Fix a number of debugger execution issues. Fixes #3191
...
1. EPAS packages' function/procedure does not honour INOUT arguments, it converts INOUT to OUT.
2. Packages' functions and procedures are not getting listed in their respected nodes in some scenarios like procedure having INOUT argument and function with void return type
3. The Reverse engineering SQL is not correct for Packages' functions/procedures
4. In case of INOUT argument, debugger asks for mendatory input which should not.
5. Re-executing a procedure whilst direct debugging doesn't work.
2018-07-17 12:51:24 +01:00
41a8333145
Replace deprecated success, error callbacks in $.ajax call with new functions .done and .fail.
2018-07-09 13:54:00 +01:00
bdb7e3fde2
Infrastructure and changes to the Query Tool for realtime preference handling. Refs #3294
...
Highlights of this patch include:
- Changes will affect SQL Editors in Create dialog boxes, SQL tab of the main screen, Query tool, History entries in the query tool, Query tool opened in New Tab/Window
- All the components of SQL editor will refer to single source of preferences which is cached in the Browser object. All other redundant ajax get preference calls are removed.
- SQL editor will not refer template JS variables anymore, once all the references are removed the template variables will also be removed.
- Code refactoring wherever possible.
- Covered JS test cases wherever possible.
2018-07-05 11:38:43 +01:00
d56f1b17f3
Fix restoring of restore options for sections. Fixes #3362
2018-07-02 15:53:19 +01:00
28e0220e97
Fix restoring of restore options for sections. Fixes #
2018-07-02 15:52:15 +01:00
d53c47e1cf
Cleanup and fix handling of Query Tool Cancel button status. Fixes #3319
2018-07-02 15:43:36 +01:00
b390c033cf
Fix debugging of procedures in EPAS packages. Fixes #3457
2018-06-29 15:20:33 +01:00
fb1ef9ac0b
Properly support backups in Directory format. Fixes #3309
2018-06-29 15:14:37 +01:00
08e4cdf2ac
Updated extension upgrade message. Fixes #3445
2018-06-26 11:53:46 +05:30
5bdd80e3da
Correct version comparison, per Khushboo.
2018-06-25 16:41:34 +01:00
cf29e8df90
Require v1.1 of the pldbgapi extension to debug on EPAS 11.
2018-06-25 16:01:53 +01:00
4a71c6d7af
Various EPAS/PG11 function & procedure fixes. Fixes #3421 . Fixes #3422
2018-06-25 14:58:02 +01:00
df85392bbf
Fix handling of SQL_ASCII data in the query tool. Fixes #3289 . Fixes #3250
2018-06-21 08:26:01 -04:00
7a06acb678
Allow the connection timeout to be configured on a per-server basis. Fixes #3388
2018-06-19 19:58:46 -04:00
ba8829b64f
Further Python 2.6 fixes.
2018-06-15 15:03:53 +01:00
d1902cd639
Add Python API tests for execution of external utilities such as pg_dump.
2018-06-15 11:36:07 +01:00
b48145f01f
Add an option to auto-complete keywords in upper case. Fixes #2686
2018-06-15 10:18:56 +01:00
d1ecba56b8
Function and procedure support for PG11. Fixes #3362
2018-06-13 15:03:17 +01:00
419f9069ae
Move the notifications tab between messages and history as it seems more natural there.
2018-06-06 09:23:33 +01:00
7dd6372eeb
Extract the tests and refactor some of the methods.
...
Extract some of the ACI Tree functionalities, and decouple it from the
main source. Also - create some abstractions from the repeated code
around the enable/disable the schema children object create/edit/delete
functionalities, and also created the dialog wrappers for backup and
restore dialogs.
Reviewed by: Khushboo and Ashesh
Refactored by: Ashesh
2018-06-05 16:42:59 +05:30
920934759f
Handle a potential error case in the connection status monitoring.
...
When you disconnect the server with an open sqleditor tab, exception
occurs at the back end. Also, after connecting server, the sqleditor
is not able to connect back because of the exception.
2018-06-05 11:57:56 +01:00
38ee39ae7a
Add support for LISTEN/NOTIFY in the query tool. Fixes #3204
2018-05-30 21:58:28 -04:00
2b4605a9d3
Ensure backup/restore/maintenance work via SSH tunnels. Fixes #3355
2018-05-30 21:25:42 -04:00
9f13865777
Update jQuery to 3.3.1. Fixes #3271
...
Patch by Aditya, with test enhancements from Anthony and Joao at Pivotal.
2018-05-25 16:26:37 +01:00
6492dacbb2
Ensure the debugger container has focus when loaded. Fixes #3295 - this time on Firefox too!
2018-05-18 11:33:42 +01:00
ab27b9d118
Fix template handling in tests for Windows.
2018-05-14 15:47:38 +01:00
ba23ba9b8b
Ensure the debugger container has focus when loaded. Fixes #3295
2018-05-09 14:26:50 +01:00
5b86a67a41
Fixed query tool keyboard issue where arrow keys were not behaving as expected for execute options dropdown. Fixes #3298
2018-05-09 13:05:22 +05:30
567f764234
Backup, Maintenance and Restore should not be started if database name contains "=" symbol. Fixes #1220 #1221
2018-05-07 15:09:12 +05:30
b7fb01ab04
Add support for SSH tunneled connections. Fixes #1447
2018-05-04 11:27:27 +01:00
Yogesh Mahajan
Rahul Shirsat
Nikhil Mohite
Akshay Joshi
Pradip Parkale
Aditya Toshniwal
Ashesh Vashi
Khushboo Vashi
huangj.fnst@fujitsu.com
Aditya Toshniwal
Florian Sabonchi
Libor M
Dave Page
Murtuza Zabuawala
Pramod Ahire
Nidhi Bhammar
Huang Jun
Cyril Jouve
Chethana Kumar
Neel Patel
Satish V
Nagesh Dhope
navnath gadakh
Amol Vyavahare
Yogesh Jain
Nick Barnes
Ganesh Jaybhay
Shubham Agarwal
Yosry Muhammad
Usman Muzaffar
Harshal Dhumal
Xuri Gong
Joao De Almeida Pereira
Anthony Emengo