Re: [pgAdmin][RM6131] Port query tool to React

Please ignore the previous patch. Attached is the new one.
Fixes:

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.

On Tue, Apr 26, 2022 at 3:05 PM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:

> Hi,
>
> Attached path fixes:
>
> 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.
>
>
>
> On Mon, Apr 25, 2022 at 6:13 PM Akshay Joshi <
> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>
>> Thanks, the patch applied.
>>
>> On Mon, Apr 25, 2022 at 6:07 PM Aditya Toshniwal <
>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>
>>> Attached path fixes:
>>>
>>> 1. Failed to fetch query history error sometimes.
>>> 2. In copy paste row, if a copied row has [null], then those are
>>> pasted as empty string.
>>> 3. When Dataoutput is empty, show an empty grid.
>>> 4. Schema diff generate script button results in empty window. Fixes
>>> #7306.
>>> 5. Detach the DataOutput panel > Try editing text cell > Text editor
>>> is hidden behind data output panel
>>>
>>>
>>> On Fri, Apr 22, 2022 at 6:18 PM Akshay Joshi <
>>> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>>
>>>> Thanks, the patch applied
>>>>
>>>> On Fri, Apr 22, 2022 at 6:02 PM Aditya Toshniwal <
>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> Attached patch fixes:
>>>>> 1. Add min width to panels.
>>>>> 2. Fix issues related to New connection in query tool. Also fixed some
>>>>> existing bugs related to this.
>>>>>
>>>>> Please review.
>>>>>
>>>>> On Wed, Apr 20, 2022 at 7:04 PM Akshay Joshi <
>>>>> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>> Thanks, the patch applied.
>>>>>>
>>>>>> On Wed, Apr 20, 2022 at 6:31 PM Aditya Toshniwal <
>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>
>>>>>>> Attached patch fixes following issues:
>>>>>>>
>>>>>>>
>>>>>>> 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. Try to edit cell with char varying data type(which opens text
>>>>>>> editor, leave editor open) > Scroll result grid verticall so that ediot
>>>>>>> disappaears > Click on another cell > query edior shows white screen &
>>>>>>> refresh is the only option left.(TypeError: Cannot read properties of null
>>>>>>> (reading 'querySelector’) - Issue is not reproducible if you scroll
>>>>>>> horizontally
>>>>>>> 5. C should be captial in ’<New connection…>'
>>>>>>> 6. In pop title for New Connection, all words should be
>>>>>>> capital.(Add new connection)
>>>>>>> 7. Explain > Analaysis tab > Column heading missing ROWS PLAN with
>>>>>>> cost & In explain only.
>>>>>>> 8. Explain > Analaysis tab > with cost enabled > Upward arrow
>>>>>>> size does not match with font of number. Arrow is little bigger than number.
>>>>>>> 9. Boolean default is not considered while ading new row.(try
>>>>>>> table from feature test defaults)
>>>>>>> 10. In query history , when not query history present, warning
>>>>>>> icon size big. Match it to warning message - No history found
>>>>>>> 11. Select table/db object > Open query tool from Tools menu >
>>>>>>> NOT FOUND error is shown. Existing issue, fixed.
>>>>>>> 12. Any cell just open by clicking it > Do NOT change any thing
>>>>>>> > Click Ok > Cell is shown as edited.
>>>>>>>
>>>>>>> Please review.
>>>>>>>
>>>>>>> On Mon, Apr 18, 2022 at 12:54 PM Akshay Joshi <
>>>>>>> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>>>>>>
>>>>>>>> Thanks, the patch applied.
>>>>>>>>
>>>>>>>> On Mon, Apr 18, 2022 at 11:27 AM Aditya Toshniwal <
>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>>
>>>>>>>>> Hi,
>>>>>>>>> Attached is the patch to fix the issues raised. Few of them are
>>>>>>>>> pending and will send it later.
>>>>>>>>> Fixed:
>>>>>>>>>
>>>>>>>>> 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. Also 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.(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.
>>>>>>>>>
>>>>>>>>> I was not able to reproduce some of the bugs on webpack dev mode,
>>>>>>>>> but reproducible on webpack prod mode bundles. After a lot of debugging it
>>>>>>>>> turned out that webpack/babel transpile was changing the meaning of a piece
>>>>>>>>> of code in prod mode. I tweaked the code then most issues were not
>>>>>>>>> reproducible anymore.
>>>>>>>>> That said, following issues were not reproducible and this fix
>>>>>>>>> could be the reason:
>>>>>>>>>
>>>>>>>>> 1. Not able to load more than 1000 rows.
>>>>>>>>> 2. Find/Replace both opens the same dialogue box.
>>>>>>>>> 3. Try to edit cell with char varying data type(which opens
>>>>>>>>> text editor) > Scroll result grid > Click on another cell > query edior
>>>>>>>>> shows white screen & refresh is the only option left.(TypeError: Cannot
>>>>>>>>> read properties of null (reading 'querySelector')
>>>>>>>>> at getCellElement (sqleditor.js?ver=60800:1:995456))
>>>>>>>>> 4. Generate script is not working for schema diff for tables
>>>>>>>>> with target only/ not working for any.(TypeError: Cannot read properties of
>>>>>>>>> undefined (reading 'database'))
>>>>>>>>> 5. Query results are appended in the Notification tab.
>>>>>>>>> 6. Panel name is NOT updated on opening file. Panel-name
>>>>>>>>> should be filename
>>>>>>>>> 7. Open a file in query tool > Open another file > Check panel
>>>>>>>>> name > It is the first file name.
>>>>>>>>> 8. Incorrect CSV downloaded (film table) when CSV quotes
>>>>>>>>> select single quote from preferences. *CSV generated at
>>>>>>>>> backend. No changes done.*
>>>>>>>>> 9. In Data grid > Add New data to cell > without clicking on
>>>>>>>>> other cell click on Add New row > previous data is gone.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Please find the comment inline for other issues:
>>>>>>>>>
>>>>>>>>> 1. Small white line is added below Total rows status bar.
>>>>>>>>> This is an existing issue with wcDocker. It is somehow not
>>>>>>>>> getting the correct size for the query tool. You can verify this by opening
>>>>>>>>> query tool in new tab.
>>>>>>>>> 2. In explain > Data output > Query Plan is editable.
>>>>>>>>> To be precise, the JSON editor is editable but does not allow
>>>>>>>>> saving it. This is inline with other editors like text editor which allows
>>>>>>>>> editing but no save.
>>>>>>>>> 3. Color is NOT fainted in View/Edit data when query tool is
>>>>>>>>> NOT editable.
>>>>>>>>> This is inline with other places where the SQL is read
>>>>>>>>> only like the properties dialog SQL tab or the RE-SQL tab. Plus, greying
>>>>>>>>> out of SQL affects query readability.
>>>>>>>>> 4. If data in result grid is edited & changes are reverted,
>>>>>>>>> then also Save button remain enabled/ Cell is shown in bold indicating data
>>>>>>>>> is edited.
>>>>>>>>> This is based on existing behaviour. A separate RM can be
>>>>>>>>> raised to have any improvement in this.
>>>>>>>>> 5. When the Save button is disabled then 'Save as' should be
>>>>>>>>> disabled as well.
>>>>>>>>> Save and Save As are different in behaviour. You can change a
>>>>>>>>> file and save it. The save will be disabled but the user should be allowed.
>>>>>>>>> I also checked the behaviour of VS-Code and PyCharm. They never disable the
>>>>>>>>> "save as" button. After all, there is no harm in allowing a user to save as
>>>>>>>>> even if it is empty.
>>>>>>>>> 6. Manage Macros - Help button is disabled. Remove SQL help
>>>>>>>>> button(Not sure).
>>>>>>>>> As I already mentioned in the review by Askhay, the existing
>>>>>>>>> help button opens the query tool help. Query tool help is
>>>>>>>>> already added on the toolbar and so this one is disabled.
>>>>>>>>> 7. Macros defined in one database are shown for other
>>>>>>>>> databases also/even across servers.
>>>>>>>>> As per the existing design.
>>>>>>>>> 8. Query tool notifier setting is missing in preferences.
>>>>>>>>> Previously, the total time and number of rows were shown in
>>>>>>>>> the notifier. And so, the notifier setting was added so that users can
>>>>>>>>> tweak it to keep it open for a longer time. Now, we do not show those
>>>>>>>>> details on the notifier since we have a fixed status bar for that. This
>>>>>>>>> setting is not relevant anymore.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Issues that need to be checked and pending:
>>>>>>>>>
>>>>>>>>> 1. Explain-Analyze with all option checked > Statistics tab >
>>>>>>>>> % of query is always 0 for node type. Need to check all the calculations.
>>>>>>>>> 2. In the Result grid multiple rows can not be selected with
>>>>>>>>> shift + down arrow.
>>>>>>>>> 3. In Geometry Viewer , map disappears if taken to bottom.
>>>>>>>>> 4. Keyboard shortcut - Focus in query tool and try
>>>>>>>>> Previous/Next tab is Not working add quotes in query tool
>>>>>>>>> 5. Keyboard shortcut Switch Panel is not working
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Thu, Apr 7, 2022 at 3:37 PM Aditya Toshniwal <
>>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>>>
>>>>>>>>>> Hi,
>>>>>>>>>>
>>>>>>>>>> Please find an updated patch with PEP8 issues fixed.
>>>>>>>>>>
>>>>>>>>>> On Thu, Apr 7, 2022 at 3:12 PM Aditya Toshniwal <
>>>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi Hackers,
>>>>>>>>>>>
>>>>>>>>>>> Attached is updated patch which now also includes:
>>>>>>>>>>> Can't copy and paste row correctly if first column contains no
>>>>>>>>>>> data #7294
>>>>>>>>>>>
>>>>>>>>>>> On Tue, Apr 5, 2022 at 5:45 PM Aditya Toshniwal <
>>>>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Hi Akshay,
>>>>>>>>>>>>
>>>>>>>>>>>> Thank you for doing such a detailed review. Please find my
>>>>>>>>>>>> comments inline below and attached patch.
>>>>>>>>>>>>
>>>>>>>>>>>> On Thu, Mar 17, 2022 at 4:05 PM Akshay Joshi <
>>>>>>>>>>>> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Hi Aditya
>>>>>>>>>>>>>
>>>>>>>>>>>>> Following are the review comments:
>>>>>>>>>>>>>
>>>>>>>>>>>>> *GUI:*
>>>>>>>>>>>>>
>>>>>>>>>>>>> - The Maximize/Minimize button on the panel should be
>>>>>>>>>>>>> consistent with other panels.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Scratch Pad is missing or is there any new setting to
>>>>>>>>>>>>> add a scratch pad?
>>>>>>>>>>>>>
>>>>>>>>>>>>> Added. The layout lib currently does not have a context menu
>>>>>>>>>>>> on the header to add a panel. For now, you can use the reset layout button
>>>>>>>>>>>> to add the scratch pad again if closed. Context menu can be added
>>>>>>>>>>>> separately later. Reset layout will not refresh the page.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Press "Cmd + G" on Query Tool it opens the old search
>>>>>>>>>>>>> bar is it still valid
>>>>>>>>>>>>> - [image: Screenshot 2022-03-16 at 7.02.34 PM.png]
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> -
>>>>>>>>>>>>> - In case of any error, we should move the cursor to the
>>>>>>>>>>>>> error location. We are highlighting the error row but it should be scroll
>>>>>>>>>>>>> to that location in the editor.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Existing behaviour. Improvement done.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Error highlighting color should be aligned with the
>>>>>>>>>>>>> theme, check the existing color.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Error highlighting color is not cleared when running the
>>>>>>>>>>>>> successful query. Run "SELECT * from pg_class123" and then run "SELECT *
>>>>>>>>>>>>> from pg_class".
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - *ToolBar buttons*:
>>>>>>>>>>>>> - When the Save button is disabled then 'Save as'
>>>>>>>>>>>>> should be disabled as well.
>>>>>>>>>>>>>
>>>>>>>>>>>>> This is not correct. A user should be allowed to "Save as" a
>>>>>>>>>>>> file even if it is saved and save button is disabled.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Open any SQL file, change some text and click on the
>>>>>>>>>>>>> 'Save' button, No notifier message has been flashed that 'File saved
>>>>>>>>>>>>> successfully' and the button does not get disabled as well.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Format SQL not working.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Clear Query keyboard shortcut not working.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> -
>>>>>>>>>>>>> - Clicking on the 'Clear Query' menu should pop up a
>>>>>>>>>>>>> confirmation dialog 'Are you sure you wish to discard the current changes?'
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Open any SQL file, change some text, and try to open
>>>>>>>>>>>>> another file, it should pop up a confirmation dialog 'Are you sure you wish
>>>>>>>>>>>>> to discard the current changes?'
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - When clicking on the New Query Tool button it is
>>>>>>>>>>>>> not opening the new query tool window.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Shortcut Key for Replace is not correct on *Windows*
>>>>>>>>>>>>> (Tooltip showing Alt + Ctrl + F) but actual is (Shift + Ctrl + F)
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Most of the Keyboard shortcuts are not working on
>>>>>>>>>>>>> Windows at all.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - *New Connection Dialog:*
>>>>>>>>>>>>> - The close button should be right-aligned.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Unable to test further because when selecting any
>>>>>>>>>>>>> disconnected server it should pop up the password dialog to connect and
>>>>>>>>>>>>> then fetch the details like databases, users, roles.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Help buttons are disabled.
>>>>>>>>>>>>>
>>>>>>>>>>>>> The existing help button opens the query tool help. Query tool
>>>>>>>>>>>> help is already added on the toolbar.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - *Query History*:
>>>>>>>>>>>>> - For some queries like 'ROLLBACK' and 'COMMIT,' Rows
>>>>>>>>>>>>> affected shows in the negative (-1).
>>>>>>>>>>>>>
>>>>>>>>>>>>> Based on existing. I have made it blank.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - *Remove All* should warn the user before removing
>>>>>>>>>>>>> everything "Are you sure you wish to remove all the history? This will
>>>>>>>>>>>>> remove all of your query histories from this and other sessions for this
>>>>>>>>>>>>> database."
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Duration is missing. It should be there with the Date
>>>>>>>>>>>>> and Rows affected.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - *Status Bar*:
>>>>>>>>>>>>> - We should display Milliseconds as well in Query
>>>>>>>>>>>>> Complete.
>>>>>>>>>>>>>
>>>>>>>>>>>>> It will now display in <hr>:<min>:<sec>.<msec> format. Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Total Rows: *N of N, *I always observe the same, can you
>>>>>>>>>>>>> please change it to *N *only, Or am I missing some
>>>>>>>>>>>>> scenario where it is changed?
>>>>>>>>>>>>>
>>>>>>>>>>>>> We're fetching rows on demand. "X of N" says total X rows
>>>>>>>>>>>> fetched till now but total N are available.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - *Data output*:
>>>>>>>>>>>>> - Default message "No data output......" should be
>>>>>>>>>>>>> shown when there are no rows/data, check the old behavior.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Extra space in the JSON Editor, even if I resize it, its
>>>>>>>>>>>>> height is not adjusted. Check the second screenshot
>>>>>>>>>>>>> - [image: Screenshot 2022-03-17 at 11.29.21 AM.png]
>>>>>>>>>>>>> [image: Screenshot 2022-03-17 at 11.29.59
>>>>>>>>>>>>> AM.png]
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> -
>>>>>>>>>>>>> - *Explain*:
>>>>>>>>>>>>> - Old content should be cleared from the panel if we
>>>>>>>>>>>>> run the new query by clicking the play button. It should show an
>>>>>>>>>>>>> informative message, check the old behavior.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - *Macros*:
>>>>>>>>>>>>> - The close button should be right-aligned.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Help buttons are disabled.
>>>>>>>>>>>>>
>>>>>>>>>>>>> The existing help button opens the query tool help. Query tool
>>>>>>>>>>>> help is already added on the toolbar.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - *View/Edit Data*:
>>>>>>>>>>>>> - Clipboard issues.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Unable to edit table data even if the primary key is
>>>>>>>>>>>>> defined.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Select All rows is missing at the left corner of the
>>>>>>>>>>>>> 'Data Output' Panel.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Change some data and try to save if an error comes then
>>>>>>>>>>>>> Spinner is not cleared.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Filtered Rows not working. Click on the 'Filtered Rows
>>>>>>>>>>>>> ...' context menu.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Sort/Filter Dialog is missing.
>>>>>>>>>>>>>
>>>>>>>>>>>>> The sort/filter dialog is present and opens when you click the
>>>>>>>>>>>> filter button. I have removed the "Sort/Filter" menu item which does the
>>>>>>>>>>>> same thing.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Select any cell of the table content, click on any
>>>>>>>>>>>>> filter menu 'Filter by selection' or 'Exclude by selection' multiple times.
>>>>>>>>>>>>> It updates the query every time and adds the condition which is not there
>>>>>>>>>>>>> previously.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Limit (100 rows, 500 rows ...) not working. View data of
>>>>>>>>>>>>> any table having 1000+ rows and then apply the limit.
>>>>>>>>>>>>>
>>>>>>>>>>>>> I am not able to reproduce this. Works fine.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - *Themes*:
>>>>>>>>>>>>> - Check and Fix all the issues related to the theme.
>>>>>>>>>>>>> - [image: Screenshot 2022-03-17 at 1.43.01 PM.png].
>>>>>>>>>>>>> [image: Screenshot 2022-03-17
>>>>>>>>>>>>> at 1.44.10 PM.png].
>>>>>>>>>>>>> -
>>>>>>>>>>>>> - [image: Screenshot 2022-03-17 at 1.44.53 PM.png]
>>>>>>>>>>>>> [image: Screenshot 2022-03-17 at
>>>>>>>>>>>>> 1.45.54 PM.png]
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> -
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> *Code:*
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Fix pep8 issues.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Fixed.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Can we fix the *Deprecation Warnings?*
>>>>>>>>>>>>>
>>>>>>>>>>>>> I think those are coming from bootstrap. Need to check that
>>>>>>>>>>>> separately. Not related to the query tool.
>>>>>>>>>>>>
>>>>>>>>>>>>> *Note: *Code review still remains, meanwhile you can start
>>>>>>>>>>>>> fixing the above issues.
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> Forgot to mention in initial mail - I have removed dependency
>>>>>>>>>>>> on Snap.svg and have written Explain SVG codes from scratch.
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Wed, Mar 16, 2022 at 5:54 PM Aditya Toshniwal <
>>>>>>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>>> Hi,
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Attached is an updated one with few more improvements and
>>>>>>>>>>>>>> fixes.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> On Wed, Mar 16, 2022 at 1:40 PM Aditya Toshniwal <
>>>>>>>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Please find the attached patch :)
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> On Wed, Mar 16, 2022 at 12:16 PM Akshay Joshi <
>>>>>>>>>>>>>>> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Hi Aditya
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> I think you forgot to attach the patch.
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> On Tue, Mar 15, 2022 at 4:00 PM Aditya Toshniwal <
>>>>>>>>>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Hi Hackers,
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Attached is the initial patch that migrates the SQL
>>>>>>>>>>>>>>>>> Editor tool to React based. Change highlights:
>>>>>>>>>>>>>>>>> 1. Complete rewrite to React code.
>>>>>>>>>>>>>>>>> 2. UI improvements based on suggestions and requests.
>>>>>>>>>>>>>>>>> 3. Work towards stability and performance improvement.
>>>>>>>>>>>>>>>>> 4. Keep row numbers in view when scrolling horizontally.
>>>>>>>>>>>>>>>>> Fixes #3989
>>>>>>>>>>>>>>>>> 5. Fixed status bar at the bottom with useful details.
>>>>>>>>>>>>>>>>> Fixes #3253
>>>>>>>>>>>>>>>>> 6. Relocate GIS Viewer Button to the Left Side of Results
>>>>>>>>>>>>>>>>> Table. Fixed #6830
>>>>>>>>>>>>>>>>> 7. Allow to remove single history records. Refs #4113
>>>>>>>>>>>>>>>>> 8. Macros usability improvements. Ref #6969
>>>>>>>>>>>>>>>>> 9. Connection bar visibility issue. Fixes #7188
>>>>>>>>>>>>>>>>> 10. Query tool layout issues. Fixes #6725
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Please note, there are still few minor niggles at some
>>>>>>>>>>>>>>>>> places but the patch qualified to be reviewed. We will need a good amount
>>>>>>>>>>>>>>>>> of time to test this properly. So, I am sending the feature patch. JS
>>>>>>>>>>>>>>>>> test cases and documentation patches will follow soon.
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Please review.
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> [image: image.png]
>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>>>>>> Aditya Toshniwal
>>>>>>>>>>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>>>>>>>>>>>> <http://edbpostgres.com>
>>>>>>>>>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>> *Thanks & Regards*
>>>>>>>>>>>>>>>> *Akshay Joshi*
>>>>>>>>>>>>>>>> *pgAdmin Hacker | Principal Software Architect*
>>>>>>>>>>>>>>>> *EDB Postgres <http://edbpostgres.com>*
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> *Mobile: +91 976-788-8246*
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>>>> Aditya Toshniwal
>>>>>>>>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>>>>>>>>>> <http://edbpostgres.com>
>>>>>>>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> --
>>>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>>> Aditya Toshniwal
>>>>>>>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>>>>>>>>> <http://edbpostgres.com>
>>>>>>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> --
>>>>>>>>>>>>> *Thanks & Regards*
>>>>>>>>>>>>> *Akshay Joshi*
>>>>>>>>>>>>> *pgAdmin Hacker | Principal Software Architect*
>>>>>>>>>>>>> *EDB Postgres <http://edbpostgres.com>*
>>>>>>>>>>>>>
>>>>>>>>>>>>> *Mobile: +91 976-788-8246*
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> Thanks,
>>>>>>>>>>>> Aditya Toshniwal
>>>>>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>>>>>>> <http://edbpostgres.com>
>>>>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> Thanks,
>>>>>>>>>>> Aditya Toshniwal
>>>>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>>>>>> <http://edbpostgres.com>
>>>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Thanks,
>>>>>>>>>> Aditya Toshniwal
>>>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>>>>> <http://edbpostgres.com>
>>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Thanks,
>>>>>>>>> Aditya Toshniwal
>>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>>>> <http://edbpostgres.com>
>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> *Thanks & Regards*
>>>>>>>> *Akshay Joshi*
>>>>>>>> *pgAdmin Hacker | Principal Software Architect*
>>>>>>>> *EDB Postgres <http://edbpostgres.com>*
>>>>>>>>
>>>>>>>> *Mobile: +91 976-788-8246*
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Thanks,
>>>>>>> Aditya Toshniwal
>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>> <http://edbpostgres.com>
>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> *Thanks & Regards*
>>>>>> *Akshay Joshi*
>>>>>> *pgAdmin Hacker | Principal Software Architect*
>>>>>> *EDB Postgres <http://edbpostgres.com>*
>>>>>>
>>>>>> *Mobile: +91 976-788-8246*
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Thanks,
>>>>> Aditya Toshniwal
>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>> <http://edbpostgres.com>
>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>
>>>>
>>>>
>>>> --
>>>> *Thanks & Regards*
>>>> *Akshay Joshi*
>>>> *pgAdmin Hacker | Principal Software Architect*
>>>> *EDB Postgres <http://edbpostgres.com>*
>>>>
>>>> *Mobile: +91 976-788-8246*
>>>>
>>>
>>>
>>> --
>>> Thanks,
>>> Aditya Toshniwal
>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>> <http://edbpostgres.com>
>>> "Don't Complain about Heat, Plant a TREE"
>>>
>>
>>
>> --
>> *Thanks & Regards*
>> *Akshay Joshi*
>> *pgAdmin Hacker | Principal Software Architect*
>> *EDB Postgres <http://edbpostgres.com>*
>>
>> *Mobile: +91 976-788-8246*
>>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"