1b11a6cd4b
Fixed a couple of SonarQube issues.
2022-09-27 14:28:31 +05:30
add5404f5e
Fixed an issue where the prompt is not visible when clicking on the 'save results to file' button on the large data. #5338
...
corrected issue id
corrected order of release notes
2022-09-27 14:27:22 +05:30
0b6b2e733a
1) Remove Python's 'Six' package completely. #5357
...
2) Replace deprecated @abstractproperty with @property, @abstractmethod.
2022-09-26 12:47:31 +05:30
f64b572150
Fix failing API test cases. #5210
2022-09-23 16:22:16 +05:30
9a6516a8b3
Ensure that the query tool creates a new tab with the appropriate user when pressing Alt+Shift+Q. #5210 ( #5350 )
2022-09-23 11:19:48 +05:30
98c50afe8e
Ensure that the continue/start button should be disabled if the user stops the Debugger for the procedures. #5188 ( #5353 )
2022-09-23 11:11:23 +05:30
ed1184fcf8
Ensure that the user management dialog should not allow the same email addresses
...
with different letter casings when creating users. #5262
2022-09-22 14:59:42 +05:30
3765131d21
Ensure that the default value for a column should be used if it is made empty. #5308
2022-09-22 14:59:42 +05:30
a2a18d4b4a
Fixed an error while saving changes to the ERD table. Fixes #5342
2022-09-19 16:20:07 +05:30
04b1e26041
Fixed an issue where server names with special characters are not displayed correctly in the process tab. Fixes #7695
2022-09-15 16:43:37 +05:30
9ac233f244
Fixed an issue where ERD throws an error if variable is added to the column. Fixes #7709
2022-09-15 13:16:27 +05:30
01a9a41bd9
1) Warn the user when connecting to a server that is older than pgAdmin supports.
...
2) Fixed Debugger API test cases.
2022-09-15 13:12:46 +05:30
0cb00c7b4f
Fixed the Debugger issue introduced by security fixes.
2022-09-14 15:15:52 +05:30
16bcb7d4a2
Ensure that the browser tree should be refreshed after changing the ownership. Fixes #7607
2022-09-14 15:08:05 +05:30
2de965d710
1. Use EDB's repo for react-data-grid instead of the personal repo.
...
2. Improved searching in the Search Objects.
3. Fixed react warnings in the query tool.
4. Fixed some SonarQube issues.
2022-09-13 19:13:33 +05:30
ab5d53f3b1
Fixed following issues for Schema Diff:
...
1) When some option from filter is selected, that particular type should be completely removed from top level result instead of showing identical:0
2) Copy button is missing for Difference SQL
3) Throw error when source & target server versions selected are different
4) In High contrast - Font color for identical turns same as background.
5) In High contrast - Checkbox box column turns same color of row resulting unable to distingiush about selection of item.
refs #6133
2022-09-13 16:49:44 +05:30
1bff94d0ea
1) Ensure that properties should be displayed after the SonarQube fixes. (Patch by: Aditya)
...
2) Fixed Tablespace wrong path issue. (Patch by: Nikhil)
3) Align the label and drop-down on Graph Visualizer.
2022-09-12 14:05:21 +05:30
93f5fbc797
Fixed SonarQube issues.
2022-09-12 11:28:00 +05:30
76a6feb2e7
Remove some more references of Backgrid and Backform.
...
refs #6134
2022-09-12 11:17:23 +05:30
ca8b5c68fd
Remove Backgrid and Backform. Fixes #6134
2022-09-10 14:22:49 +05:30
b128ba2f57
Fixed a couple of SonarQube issues.
2022-09-10 14:04:28 +05:30
cbf5886430
Fixed the following code smells:
...
1. Use concise character class syntax
2. Add a "break" statement or remove this "else" clause.
3. Replace this generic exception class with a more specific one.
4. Use a regular expression literal instead of the 'RegExp' constructor.
5. Use the opposite operator ("not in") instead.
2022-09-10 13:48:14 +05:30
d967d5046d
Fixed 'Remove the unused function parameter' code smell.
2022-09-09 18:36:51 +05:30
3b95a416ca
Fixed 'Remove the unnecessary boolean literals' code smell.
2022-09-09 15:23:18 +05:30
b8f63adf41
Fixes following code smell reported by SonarQube:
...
1) Replace this if-then-else flow by a single return statement
2) Remove the unnecessary boolean literals.
2022-09-08 19:56:02 +05:30
7086719640
Fixed SonarQube issues.
2022-09-08 18:08:58 +05:30
0c9c57e608
1. Resolved resize window issue for DDL result panel.
...
2. Updated the Screenshots.
3. Updated server group title to bold.
refs #6133
2022-09-08 15:24:43 +05:30
18b77f15dd
Remove Alertify from pgAdmin completely. Fixes #7619
2022-09-08 15:16:48 +05:30
e1942d8c9e
1) Port schema diff to React. Fixes #6133
...
2) Remove SlickGrid.
2022-09-07 19:20:03 +05:30
ad59380676
Fixed an issue with the non-visibility of columns added prior to import/export data. Fixes #7649
2022-09-07 17:40:52 +05:30
0f46f070ed
Port the remaining components of the ERD Tool to React. Fixes #7343
...
1. Make use of MUI styles and remove SCSS.
2. Use the new common components for buttons and tooltips, so that they are consistent.
3. UI design should be aligned with the query tool.
4. Remove tippyjs and Alertify dependencies.
2022-09-06 18:09:13 +05:30
e58b9c767b
Port search object dialog to React. Fixes #7622
2022-08-30 17:08:12 +05:30
71a4b20d90
Fixed some SonarQube issues.
2022-08-30 14:21:33 +05:30
fe0577be5f
Ensure that the Import/Export server menu option is visible. Fixes #7646
2022-08-26 14:38:50 +05:30
a84118823e
Title case tab label
2022-08-25 13:47:59 +01:00
f2cc897f2f
1. Fixed an issue where copy and pasting a row in the results grid doesn't set the default for boolean. Fixes #7579
...
2. Fixed an issue where the History tab is getting blank and showing an error after some queries are executed. Fixes #7468
3. Fixed query tool view data crash.
2022-08-22 14:33:38 +05:30
09e2c0eac0
1. Explain plan crashes query tool after SonarQube fixes.
...
2. Fix XSS issue in query tool.
3. Process details for cloud process not showing complete command.
4. Confirm dialog before removing processes.
2022-08-18 18:42:03 +05:30
306b184e11
1. Fixed an issue where Alt-Shift-Q didn't work after creating a new query. Fixes #7575
...
2. Fixed an issue where the Query Editor loses focus when saving a query (Alt+s). Fixes #7521
3. Ensure that an error is thrown if clipboard access is not provided and change the copy rows shortcut. Fixes #7452
2022-08-17 17:23:44 +05:30
da927f4897
1) Autocomplete on keypress should be set to False by default.
...
2) Update the documentation for the locked option in user management.
2022-08-17 14:38:37 +05:30
f771d3a4bb
Conditionally pin Flask version based on Python version.
2022-08-17 12:21:05 +05:30
d4fdd4601e
1) Pin Flask version 2.1.*
...
2) Fixed API test cases that failed due to a change in the Werkzeug version.
3) Change password issue is fixed.
2022-08-17 11:54:16 +05:30
ef91207669
1) Fixed an issue where an existing user is deleted and recreated again in the User Management dialog. Fixes #7618
...
2) Fixed preferences issue when changing themes.
3) Added validation for user names that already exist.
2022-08-16 17:28:45 +05:30
d45072fae5
Ensure that rename panel should work on view/edit panels. Fixes #7540
2022-08-16 15:31:55 +05:30
485265979e
Fixed an issue email already exists and disable the 'Locked' switch when its value is false. Fixes #7618
2022-08-16 15:25:25 +05:30
2d27a97b8c
Fixed improper parsing of HTTP requests in Pallets Werkzeug v2.1.0 and below (CVE-2022-29361). Fixes #7602
2022-08-16 12:20:01 +05:30
06d454473c
Fixed an issue where an invalid email error was not visible on the GUI. Fixes #7609
2022-08-14 08:48:58 +05:30
1e94c3bd81
Fixed Security Hotspot reported by SonarQube.
2022-08-14 07:09:45 +05:30
084203debc
Fixed Securtiy Hotspot reported by SonarQube.
2022-08-12 17:10:26 +05:30
b34078c6d2
Fixed SonarQube issues
2022-08-12 12:19:11 +05:30
c2b23465cc
1) Added support to show all background processes in separate panel. Fixes #3709
...
2) Port process watcher to React. Fixes #7404
2022-08-11 10:49:45 +05:30
271b6d91fc
Port User Management dialog to React. Fixes #7345
2022-08-11 10:25:52 +05:30
8b7ce2c276
Port change user password and 2FA dialog to React. Fixes #7568
2022-08-10 18:02:54 +05:30
9c418188ee
Fixed SonarQube issues.
2022-08-10 15:05:20 +05:30
f5793e9a7a
Fixed SonarQube issues.
2022-08-09 15:42:16 +05:30
f96653e9af
Fixed an issue with rendering geometry when selecting a complete column. Fixes #7586
2022-08-09 13:28:09 +05:30
d1c94ac73d
Fixed SonarQube issues.
2022-08-05 18:58:03 +05:30
53887c32bf
Port change ownership dialog to React. Fixes #7590
2022-08-05 14:11:17 +05:30
95312f2d14
1) Ensure that autocomplete does not appear when navigating code using arrow keys. Fixes #7573
...
2) Fixed an issue where autocomplete is not working after clearing the query editor. Fixes #7563
2022-08-01 14:38:32 +05:30
81b0d1138b
Remove Alertify dialog from Grant Wizard, Import/Export Servers and Cloud.
2022-07-28 10:14:04 +05:30
a7fd7d67b3
1. Intermittently failing test cases.
...
2. Dialog vertical position should be more on the upper side.
3. File not supported error is not showing.
refs #7313
2022-07-25 11:48:27 +05:30
3e3f06c55d
Fixed an issue where Autocomplete did not work after pressing CTRL/CMD + Space
...
for the second time and autocomplete on keypress is off. Fixes #7563
2022-07-22 18:49:46 +05:30
3f8c36789f
Fixed copy command error on Windows in Import/Export data.
...
refs #7428
2022-07-21 13:07:42 +05:30
631a08189a
1) Improved autocomplete loading indicator.
...
2) Avoid too many ajax requests per key press.
refs #4488
2022-07-20 18:02:45 +05:30
4808df5e95
1) Port the file/storage manager to React. Fixes #7313
...
2) Allow users to delete files/folders from the storage manager. Fixes #4607
3) Allow users to search within the file/storage manager. Fixes #7389
4) Fixed an issue where new folders cannot be created in the save dialog. Fixes #7524
2022-07-19 15:27:47 +05:30
4585597388
Added option to trigger autocomplete on key press in the query tool. Fixes #4488
2022-07-19 11:55:37 +05:30
8f73956d1e
Fixed API test cases.
...
refs #7428
2022-07-18 18:15:46 +05:30
8f2bda2309
1) Preserve the settings set by the user in the import/export data dialog. Fixes #7428
...
2) Fixed the JSON editor issue of hiding the first record. Fixes #7520
2022-07-18 10:54:03 +05:30
9dde195af4
Ensure that notices should not disappear from the messages tab. Fixes #7512
2022-07-14 18:05:36 +05:30
1fecf70123
Ensure that geometry should be shown for all the selected cells. Fixes #7519
2022-07-14 17:38:42 +05:30
50c930f5fa
Make the controls on the Graph Visualiser collapsible and reorganize the controls.
2022-07-07 14:10:10 +05:30
9cdcad7a88
1) Keep the selected columns for the X and Y-axis.
...
2) Lighten the color of the stacked line chart.
2022-07-06 18:58:15 +05:30
7414394ceb
Fixed the following issues in the Graph Visualiser:
...
1) Change all theme's color codes.
2) Bar graph for the first and last labels on the X-axis does not display all the bars.
3) Make the graphs always start from zero on the Y-axis.
2022-07-05 18:44:20 +05:30
8b62cd1f04
Added support for visualise the graph using a Pie chart in the query tool. Fixes #7487
2022-07-05 10:47:17 +05:30
239e3bb6f1
Some more theme related fixes.
2022-07-04 14:26:33 +05:30
9c45a62b53
Fixed jasmine test cases introduced by the theme patch.
2022-07-01 15:01:51 +05:30
9c745db413
Enable the start debugging button once execution is completed. Fixes #7517
2022-07-01 12:41:06 +05:30
86b30b3c83
Theme component usage has been fixed, a component should never be wrapped in multiple Theme components.
2022-06-30 15:18:20 +05:30
b92e2fcfc9
Added support for visualizing the graphs using Stacked Line, Bar, and Stacked Bar charts in the query tool. Fixes #7486
2022-06-30 12:38:48 +05:30
cb635f6706
Removing dynamic module loading and replacing it with static loading. Fixes #7492
...
Gets rid of all occurrences and usage of get_own_javascripts since it is no longer used.
2022-06-30 11:06:50 +05:30
524626b895
Ensure that the file name should be reflected on the query tool for the new tab title.
2022-06-28 18:21:08 +05:30
d4657dcd32
Fixed module import issue.
...
refs #7506
2022-06-28 11:28:55 +05:30
f905dc07cf
Reset the zoom to original when chart object is created. Fixed an error on Windows.
2022-06-28 10:25:38 +05:30
35fb3bb38f
Fixed the typo in the layout id for the Debugger.
...
refs #6132
2022-06-27 16:34:04 +05:30
e95eb14651
Fixed an issue where the connection wasn't being closed when the user switched
...
to a new connection and closed the query tool. Fixes #7461
Fixed the 'Show activity?' issue which was missed during Dashboard porting.
2022-06-23 18:15:16 +05:30
2556771c32
The following issues were fixed in Graph Visualiser:
...
1) Allow the user to set the row limit and chart line width.
2) Zoom should only be applied to X-axis, not both.
3) On clicking the 'Generate' button, the chart should return to its original zoom level.
4) Negative values are not displayed.
refs #7485
2022-06-23 14:52:11 +05:30
93bc1f3c57
Added support for visualise the graph using a Line chart in the query tool. Fixes #7485
2022-06-22 17:18:51 +05:30
41ceda01d0
Fixed an issue where Debugger is not getting started if arguments loaded from SQLite database. Fixes #6132
2022-06-22 11:16:50 +05:30
4e3783c544
Fixed the following issues in the debugger:
...
1. If debugger arguments are array debugger sets the null value to parameters.
2. Popup screen is not being closed if debug Package procedure/Function and select Null option.
3. Updated validation for debugger argument of the array type parameter.
refs #6132
2022-06-20 19:05:26 +05:30
2adca6bbc4
1) Added mouse over indication for breakpoint area in the Debugger. Fixes #2647
...
2) Added search text option to the Debugger panel. Fixes #2648
3) Port Debugger to React. Fixes #6132
2022-06-15 11:37:54 +05:30
5c1493bd7e
Fixed an issue where there is no setting to turn off notifications in the Query Tool. Fixes #7423
2022-06-13 14:32:07 +05:30
725726f083
Ensure that the Query Editor should be focused when switching between query tool tabs. Fixes #7441
2022-06-13 14:26:01 +05:30
f615ef30f9
Skip the history records if the JSON info can't be parsed instead of showing 'No history'. Fixes #7468
2022-06-13 11:43:26 +05:30
4c50940634
Fixed some issues related to the dropdown background color. Fixes #7374
2022-05-30 17:05:48 +05:30
b507eb8857
Fixed an issue when switching between connections in the Query Tool dropdown,
...
the background and foreground colors should be changed. Fixes #7374
2022-05-26 15:31:18 +05:30
aaab5c51a7
Fixed an issue where the data grid scroll is not reset when a query is executed.
2022-05-25 17:53:52 +05:30
1e1e1f027a
Fixed an issue where geometry is not visible when a single cell is selected. Fixes #7394
2022-05-24 17:08:02 +05:30
c5ca45c461
Ensure that null values are accepted for the numeric columns in react-data-grid. Fixes #7405
2022-05-24 15:02:06 +05:30
04fa7dee68
Added missing toggle case keyboard shortcuts to the query tool. Fixes #7399
2022-05-24 14:54:43 +05:30
efe613d13e
Fixed an issue where comments on domain constraints were not visible when selecting a domain node. Fixes #7403
2022-05-24 14:50:33 +05:30
6d26d5833f
Added support for multi-cell selection in the query tool grid. Fixes #7380
2022-05-24 11:39:34 +05:30
4f7bcc2919
Added the ability to detect and warn users about bidirectional Unicode characters. Fixes #7002
2022-05-23 16:04:21 +05:30
5e0dfff42a
Ensure that the editor position should not get changed once it is opened. Fixes #7393
2022-05-18 13:52:09 +05:30
b36004b702
The following are the initial fixes for PG15:
...
1) From PG 15 onward, the datlastsysoid has been removed from the table pg_database.
We have added the constant _DATABASE_LAST_SYSTEM_OID = 16383, all the objects below
this value are considered to be system objects. Modified the pgAdmin logic accordingly.
2) Concatenation operator '||' needs a specific typecast to be applied to query variables. Modified SQL's accordingly.
Fixes #7283
2022-05-17 20:32:17 +05:30
2d8aff6ca0
Fixed an issue with geometry window zoom mouse scroll not working. Fixes #7373
2022-05-17 18:58:49 +05:30
fbe7b56054
Fixed an issue where a popup for unsaved changes appears when clicking on the
...
open file button for a blank query editor. Fixes #7376
2022-05-17 18:56:15 +05:30
cb05d2924f
Fixed an issue where an error message fills the entire window if the query is long. Fixes #7388
2022-05-17 18:52:19 +05:30
44f9ba4a57
Port connect server password dialog to React. Fixes #7337
2022-05-16 16:21:14 +05:30
ca8e14455f
Fixed the following issues:
...
1. Feature test cases for the new query tool.
2. Query tool panel rename is not persisting.
2022-05-12 18:29:09 +05:30
1135821870
Fix Query tool issues:
...
1. Warning/Confirm dialogs should be inside the query tool.
2. The Help button in View/Edit data should open the corresponding help page.
3. Disable execute options when query tool in transaction.
4. Grid not loading more than 10000 rows. react-data-grid issue, PR sent. Use a fork till then.
5. NOTICE messages should not be part of Notifier success popups.
Fixes #7350
2022-05-09 12:39:29 +05:30
5ebc9d7d2e
Ensure the Copy button is enabled when columns or rows are selected in the query tool results.
2022-05-05 09:52:14 +01:00
64ffed0ddb
1. Filter dialog doesn't work in edit mode (getting back end errors), reverting it back to create mode of SchemaView.
...
2. Enable the copy button when a cell is selected.
3. Exclude, Include related fixes.
2022-04-29 16:29:46 +05:30
c56fe813a5
Use gettext to wrap some strings.
2022-04-29 16:18:28 +05:30
7b66777600
Fixed an issue where Import/Export Servers did not work in languages other than English.
2022-04-29 12:00:52 +05:30
38f642d361
Ensure that the "Save results" button should be disabled when there are no rows.
...
refs #6131
2022-04-28 18:01:54 +05:30
6e2ee9a21f
Port data filter dialog to React. Fixes #7340
2022-04-28 12:04:56 +05:30
1bee39a67e
Fixed ERDInitialize API test case.
2022-04-26 18:23:24 +05:30
0795b22ae6
Fixed the following issues for the new query tool:
...
1) In Dark mode > Replace/Find dialogue forward & reverse buttons are stuck to each other.
2) In Dark/High contrast mode > Checkbox is not visible for false value.
3) Wrap toolbar when size goes very small.
4) Replace functionality does not work when tried in sequence 2 times. Codemirror search is not cyclic. So, changes are made to always search from the start.
5) Replace all does not work when tried in sequence 2 times. Same reason as above.
6) Fix broken macros $SELECTION$ feature.
7) Make query history SQL readonly.
8) The Filter dialog save button should be disabled when opened.
2022-04-26 16:27:53 +05:30
3d1a9624c1
Fixed an issue where the drag and drop table in ERD throws an error. Fixes #7333
2022-04-26 16:25:42 +05:30
4f9eaf850d
Updated documentation for the new query tool.
...
refs #6131
2022-04-26 16:18:28 +05:30
25b89f7624
Fixed the following issues for the new query tool:
...
1) Failed to fetch query history error sometimes.
2) In copy paste row, if a copied row has [null], then those are pasted as an empty string.
3) When Data output is empty, show an empty grid.
4) Schema diff generates a script button resulting in an empty window. Fixes #7306 .
5) Detach the DataOutput panel > Try editing text cell > Text editor is hidden behind the data output panel
refs #6131
2022-04-25 18:11:39 +05:30
c5ca394cec
1. Add min width to panels.
...
2. Fix issues related to New connection in query tool. Also fixed some existing bugs related to this.
refs #6131
2022-04-22 18:17:01 +05:30
e5ef6a7b21
Fixed following issues for Query Tool (after React Porting):
...
1) Find/Replace both opens the same dialogue box.(by clicking menu option)
2) Add New Server Connection > Server options keep loading(For multiple Server groups & should have some server)
3) Fixed CSS issues of slickgrid at various places.
4) C should be captial in ’<New connection…>'
5) In pop title for New Connection, all words should be capital.(Add new connection)
6) Explain > Analaysis tab > Column heading missing ROWS PLAN with cost & In explain only.
7) Explain > Analaysis tab > with cost enabled > Upward arrow size does not match with font of number. Arrow is little bigger than number.
8) Boolean default is not considered while ading new row.(try table from feature test defaults)
9) In query history , when not query history present, warning icon size big. Match it to warning message - No history found
10) Select table/db object > Open query tool from Tools menu > NOT FOUND error is shown. Existing issue, fixed.
11) Any cell just open by clicking it > Do NOT change any thing > Click Ok > Cell is shown as edited.
refs #6131
2022-04-20 19:02:16 +05:30
9470c68c18
Fixed failure in 'SchemaDiffTestCase'
2022-04-20 17:28:16 +05:30
828235dd9b
Move the 'btn-ignore-dropdown' css to the scss file to ensure that it works with dark and high contrast themes.
...
refs #7282
2022-04-20 17:21:07 +05:30
1ac13a2788
Added options 'Ignore owner' and 'Ignore whitespace' to the schema diff panel. Fixes #7282
2022-04-20 15:27:17 +05:30
9c30d983bd
Fixed following issues for query tool after react porting:
...
1) Add New Server Connection > Server options keep loading(For empty Server group).
2) After clicking indent/Unindent(for all operations) for large query option left as it is till operation completes
3) Check sign beside options in Execute Option/Copy Header is little bit big
4) In explain > Analysis tab does not show ROWS column
5) In explain > Explain > analysis previous explain output is NOT cleared. New rows are appended. Same applies to the statistics tab.
6) Update new query tool connection tool tip. Fixes #7289
7) Explain-Analyze > Loops column is empty.
8) Explain-Analyze with Verbose & Costs > in ROW X columns upward arrows are missing.
9) Explain-Analyze with all option checked > background colors are missing for timing.
10) Explain-Analyze > Additional bullet is added before Hash Cond.
11) Browser Tree > Filtered rows icon is not working.
12) Create table with timestamp and default value as function now() > Add new row > Enter mandatory columns except column where default value is function(now()) > Click Save > New row added but column with default value has value [default]. not updated to actual value. / Default values are not considered for any column while adding a new entry.
13) Disable execute options in View/Edit data.
14) The Boolean column always shows null.
15) In Query history Remove & Remove all buttons are stuck to each other.
16) On Remove all, the right panel is empty.
17) Create a column with boolean[]/ text[], Try to add a new entry from data grid, enter “” quotes > Click Ok > Now try edit cell > You can not change value.
18) In query history - Select queries are suffixed by ’Save Data’ icon
19) Edit any table with PK > Try to insert duplicate PK > Error thrown > Correct pK value > Still old error shown > Not able to add new entry (This works when focus is moved from edited cell)
20) Clicking arrows after opening dropdown options, does not collapse dropdown.
refs #6131
2022-04-18 12:50:51 +05:30
86a3696ab4
Remove aciTree and its references.
2022-04-13 17:35:01 +05:30
a91762fb30
Ensure that Columns should always be visible in the import/export dialog. Fixes #7252
2022-04-11 17:25:19 +05:30
9dfa5ea77d
Improvement to the Geometry Viewer popup to change the size of the result tables when column names are quite long. Fixes #7168
2022-04-09 12:09:36 +05:30
b5b9ee46a1
1) Port query tool to React. Fixes #6131
...
2) Added status bar to the Query Tool. Fixes #3253
3) Ensure that row numbers should be visible in view when scrolling horizontally. Fixes #3989
4) Allow removing a single query history. Refs #4113
5) Partially fixed Macros usability issues. Ref #6969
6) Fixed an issue where the Query tool opens on minimum size if the user opens multiple query tool Window quickly. Fixes #6725
7) Relocate GIS Viewer Button to the Left Side of the Results Table. Fixes #6830
8) Fixed an issue where the connection bar is not visible. Fixes #7188
9) Fixed an issue where an Empty message popup after running a query. Fixes #7260
10) Ensure that Autocomplete should work after changing the connection. Fixes #7262
11) Fixed an issue where the copy and paste row does not work if the first column contains no data. Fixes #7294
2022-04-07 17:36:56 +05:30
bf8e569bde
Fixed an issue where the downloaded ERD diagram was 0 bytes. Fixes #7187
2022-04-07 15:19:32 +05:30
4fff26c571
Makes some improvements/restructurings to the PgTable component.
2022-04-04 19:06:43 +05:30
143ae19b8d
Ensure that the correct user should be selected in the new connection dialog. Fixes #7264
2022-03-31 15:51:46 +05:30
e6821a610b
Fixed 'Cannot read properties of undefined' error while creating the table via the ERD tool. Fixes #7275
2022-03-31 11:53:17 +05:30
cb052f1988
1) Port Properties panel for collection node, Dashboard, and SQL panel in React. Fixes #7132
...
2) Added transaction start time to Server activity sessions view. Fixes #7215
2022-03-30 12:06:59 +05:30
903b300b9e
1) Added support for unique keys in ERD. Fixes #7249
...
2) Fixed an issue where foreign key relationships do not update when the primary key is modified. Fixes #7197
2022-03-28 16:26:43 +05:30
74e794b416
Port preferences dialog to React. Fixes #7149
2022-03-21 13:29:26 +05:30
3299b0c1b0
Fixed an issue where foreign key is not removed even if the referred table is removed in ERD. Fixes #7238
2022-03-17 17:02:00 +05:30
9ed2506062
Fixed a schema diff issue where string separator '_$PGADMIN$_' is visible for identical user mappings. Fixes #7228
2022-03-10 14:40:38 +05:30
1af431dcc2
Fixed a schema diff issue in which user mappings were not compared correctly. Fixes #6956
2022-03-04 17:21:30 +05:30
4033bf3748
Fixed typo in User Management
2022-03-04 11:40:28 +05:30
1cdbb9a643
Fixed an issue where the User Management dialog is not opening. Fixes #7173
2022-02-14 15:17:48 +05:30
e61a1045f5
Added capability to deploy PostgreSQL servers on Amazon RDS. Fixes #7177
2022-02-14 12:13:48 +05:30
1141aeb524
1) Fixes the incorrect title shown for the error message in restore/backup.
...
2) Doc updates for webserver authentication.
3) Cleanup task for API tests.
2022-02-07 11:51:27 +05:30
4a195e7ef6
Fixed value error in the restore dialog. Fixes #7151
2022-02-03 17:44:54 +05:30
ad64491a98
Fixed debugger issue introduce due to SonarQube fixes.
2022-02-03 11:32:15 +05:30
4d727015fd
Fixed an issue where the query tool is displaying an incorrect label. Fixes #7136
2022-02-02 14:45:31 +05:30
c2d9219add
Added JSON as a supported type in Storage Manager.
2022-02-01 16:18:32 +05:30
aa5b1d50b9
Fixed issues introduce by SonarQube fixes.
2022-02-01 14:11:18 +05:30
1a89c1f85f
Fixed code smell 'Update this function so that its implementation is not identical' reported by SonarQube.
2022-01-28 17:20:34 +05:30
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
Nikhil Mohite
Pravesh Sharma
Akshay Joshi
Aditya Toshniwal
Aditya Toshniwal
Nikhil Mohite
Khushboo Vashi
Yogesh Mahajan
Dave Page
Pradip Parkale
Rahul Shirsat
Ashesh Vashi
huangj.fnst@fujitsu.com
Florian Sabonchi
Libor M
Murtuza Zabuawala
Pramod Ahire
Nidhi Bhammar
Huang Jun
Cyril Jouve
Chethana Kumar
Neel Patel
Satish V