Re: Forcing autocomplete on keypress

Hi Zac,

You can raise a feature request here
https://github.com/pgadmin-org/pgadmin4/issues/new if you have any
improvement suggestions.

On Wed, Dec 4, 2024 at 10:13 AM Zac Warham <cazwarham(at)hotmail(dot)com> wrote:

> Thank you for the advice Aditya. I managed to get it working by adding an
> extra line in my docker entrypoint although it does slow the process down a
> little when launching the container
>
> python3 /usr/local/lib/python3.10/dist-packages/pgadmin4/setup.py
> load-servers
> "/usr/local/lib/python3.10/dist-packages/pgadmin4/servers.json"
> python3 /usr/local/lib/python3.10/dist-packages/pgadmin4/setup.py
> set-prefs pgadmin4(at)pgadmin(dot)org
> sqleditor:auto_completion:autocomplete_on_key_press=true
>
> My concerns with overriding the preference file path was that I then have
> to manage the ownership permissions of the file that is created which is
> tedious as we run various different users in production.
>
> Thank you for pointing me in the right direction though!
> ------------------------------
> *From:* Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
> *Sent:* Tuesday, 3 December 2024 7:53 PM
> *To:* Zac Warham <cazwarham(at)hotmail(dot)com>
> *Cc:* pgadmin-support(at)lists(dot)postgresql(dot)org <
> pgadmin-support(at)lists(dot)postgresql(dot)org>
> *Subject:* Re: Forcing autocomplete on keypress
>
> Hi Zac,
>
> You can use PGADMIN_PREFERENCES_JSON_FILE in
> https://www.pgadmin.org/docs/pgadmin4/8.13/container_deployment.html
>
> On Wed, Dec 4, 2024 at 12:45 AM Zac Warham <cazwarham(at)hotmail(dot)com> wrote:
>
> We have a docker setup for pgadmin and we want to force autocomplete on
> keypress at launch (not through the preferences) using an environment
> variable or config of some sort. I tried modifying the file at
> https://github.com/pgadmin-org/pgadmin4/blob/master/web/pgadmin/tools/sqleditor/utils/query_tool_preferences.py#L792 and
> replacing False with True and this works but then breaks postgres in other
> ways. Is there a proper way of doing this beyond modifying this file?
>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
> <https://www.enterprisedb.com/>
> "Don't Complain about Heat, Plant a TREE"
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"