Re: Added variable macro for generic db objects

Hi Ashesh,

PFA updated patch for generic variable macro as per Neel's suggestion, now
it will take collection instead of single key/value pair.

For example,

options_collection = [
{*name*: 'Option-1', *value*: 'Value-1'},
{*name*: 'Option-2', *value*: 'Value-2'},
{*name*: 'Option-3', *value*: 'Value-3'},
]

*Way to use in template:*

VARIABLE.SET(conn, object_type, object_name, options_collection)
VARIABLE.UNSET(conn, object_type, object_name, options_collection)

*Result:*
ALTER DB_OBJ TEST
SET (Option-1=Value-1, Option-2=Value-2, Option-3=Value-3);

ALTER DB_OBJ TEST
RESET (Option-1,Option-2,Option-3);

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Tue, Feb 2, 2016 at 7:46 PM, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
wrote:

> Thanks - checked in!
>
> --
>
> Thanks & Regards,
>
> Ashesh Vashi
> EnterpriseDB INDIA: Enterprise PostgreSQL Company
> <http://www.enterprisedb.com>
>
>
> *http://www.linkedin.com/in/asheshvashi*
> <http://www.linkedin.com/in/asheshvashi>
>
> On Tue, Feb 2, 2016 at 6:31 PM, Murtuza Zabuawala <
> murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>
>> Hi,
>>
>> PFA updated patch, I missed adding parentheses in previous patch for
>> UNSET macro .
>>
>> Thanks.
>>
>> --
>> Regards,
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>> On Tue, Feb 2, 2016 at 5:49 PM, Murtuza Zabuawala <
>> murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>>
>>> Hi,
>>>
>>> PFA patch to add another generic macro for variable control, previously
>>> written macro was specific to database node and not usable with other db
>>> objects.
>>>
>>> *How to use:*
>>> VARIABLE.SET(conn, object_type, object_name, variable_name, value)
>>> VARIABLE.UNSET(conn, object_type, object_name, variable_name)
>>>
>>>
>>> --
>>> Regards,
>>> Murtuza Zabuawala
>>> EnterpriseDB: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>
>>
>>
>> --
>> Sent via pgadmin-hackers mailing list (pgadmin-hackers(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgadmin-hackers
>>
>>
>