Re: Appending new data to existing field of Json data type

On 10/29/2014 01:06 AM, VENKTESH GUTTEDAR wrote:
> Ya agreed thats not legal JSON, that was typing mistake sorry for that,
>
> let me make you clear what i need exactly,
>
> I have table named (exampleTable) with json field as (example_list), and
> when i say
> SELECT * FROM exampleTable;
>
> id | example_list
> ---+----------------------------------------------
> 2 | {"abc":[ { "a":"b","c":"d" } ] }
>
>
> And this data i am inserting through DJango view by writing the
> following statement
>
> test = ExampleTable(id = 2, example_list = {"abc" : [ { "a":"b","c":"d"
> } ] })
> test.save()
>
> now i want to append { "e":"f", "g":"h" } to example_list by specifying
> the id.
> and after appending the data should be stored in the following way :
> After appending,
> for example if i say :
> SELECT * FROM exampleTable;
> i should get this.
>
> id | example_list
> ---+--------------------------------------------------------
> 2 | {"abc":[ { "a":"b","c":"d" }, { "e":"f", "g":"h" } ] }
>
> Hope your clear now.
>
> So now Guide me to append it through Python Djnago View. or through raw
> sql query.

If it where me I would bring the data into the view and do the work
there in Python using dicts and lists. There is a Python module out
there that make this easier to do:

https://pypi.python.org/pypi/django-jsonfield

>

> --
> Regards :
> Venktesh Guttedar.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com