Re: [pgAdmin][RM4139] Drag and drop object names in Query Editor from Browser Tree

Hi,

On Wed, Jun 26, 2019 at 4:51 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Hi
>
> On Wed, Jun 26, 2019 at 2:24 AM Aditya Toshniwal <
> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>
>> Hi Hackers,
>>
>> Attached is the patch to allow tree nodes to be dragged and dropped in
>> query editor wherever you take the drop cursor. The drop text will be fully
>> qualified and double quoted if required.
>> For functions/procedures it will drop the the label stripping away the
>> parameter names, with empty pair of round brackets. It will also set the
>> focus cursor inside the brackets if there were params otherwiser to the end
>> of text.
>> For adding a node type, you need to register it in browser.js along with
>> a callback function which will return drop text along with cursor
>> positioning and selection. Currently, I have registered for "table
>> partition type sequence package view mview foreign_table edbvar schema
>> column edbfunc function edbproc procedure".
>>
>> Please note, the drag design customisation is not supported in IE.
>>
>
> I think for functions/procedures, we should include placeholders for the
> parameters, so the user has a hint about what they need to fill in to
> complete the call.
>
I can fill in the parameter names same as tree node, with cursor selection
on all the params ?

>
> Also; shouldn't there be a doc update?
>
Yeah :/
Should there be any screenshots ?

>
> Thanks.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

--
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"