pgAdmin CLI pending bugs

[adityatoshniwal]

Couple of issues:

1. If I run the command python setup.py set-prefs aditya.toshniwal14@gmail.com "browser:processes:process_retain_days=true" then it is success. Here, process retain days is a number.

2. Login with an internal user for some email and run the below cmd. Then go to UI and open the preferences dialog. App crashes. I think we should logout the user if it is inactive.
   python setup.py update-user [aditya.toshniwal14@gmail.com](mailto:aditya.toshniwal14@gmail.com) --nonadmin --inactive --json --no-console

[yogeshmahajan-1903]

Some more issues -
1.Tool tip for query tool shows query tool:logical_operator_new_line. Expected is - sqleditor:editor:logical_operator_new_line in preferences dialogue.
2.Tools tips are missing for drop downs in preferences dialogue.
3.If user provides boolean value 'false', preference setting is NOT updated.(Fixed with #6058)
4.CLI tool does not work in Desktop as default SQLITE_PATH taken is /var/lib/pgadmin/pgadmin4.db. Also no option to provide sqlite path value.

[pravesh-sharma]

1. I tried adding a user using CLI on Rocky 9, but it gives the below error. However, it works with the pip wheel package (macOS).

2. When trying pgadmin4-cli on the pip wheel package it is not working.

Issue number 1 can be ignored as we need to run the script as root user.

[adityatoshniwal]

Some more issues - 1.Tool tip for query tool shows query tool:logical_operator_new_line. Expected is - sqleditor:editor:logical_operator_new_line in preferences dialogue. 2.Tools tips are missing for drop downs in preferences dialogue. 3.If user provides boolean value 'false', preference setting is NOT updated.(Fixed with #6058) 4.CLI tool does not work in Desktop as default SQLITE_PATH taken is /var/lib/pgadmin/pgadmin4.db. Also no option to provide sqlite path value.

I suggest we should have tooltips on labels and not input controls. Having a tooltip on input is not a good UX.

[pravesh-sharma]

Reopening for testing

[khushboovashi]

Closing the issue.

I have created new issue for #7346 for the pending Preference validation issue.