From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | VENKTESH GUTTEDAR <venkteshguttedar(at)gmail(dot)com> |
Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Appending new data to existing field of Json data type |
Date: | 2014-10-30 14:21:49 |
Message-ID: | 5452497D.9010106@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/29/2014 11:26 PM, VENKTESH GUTTEDAR wrote:
> @Adrian Klaver, Thanks for this idea but still m really confused with
> how to update the json filed in the DB. is there any way to update the
> json field in the DB through view.?
Sure, how you would normally update a value. Assuming id is unique:
id2 = ExampleTable.objects.get(id=2)
id2.example_list
You now have the example_list and you can do what you want with it. What
that is depends on what field type you have declared example_list in
your model? That is why I suggested the jsonfield in a previous post, it
automatically converts Python data structures into JSON and the reverse.
Then:
id2.save()
In your Django project I would crank up:
python manage.py shell
and work with the model directly to see what is happening.
>
> --
> Regards :
> Venktesh Guttedar.
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-10-30 14:39:35 | Re: Appending new data to existing field of Json data type |
Previous Message | Tom Lane | 2014-10-30 14:16:35 | Re: Unexpected planner behavior with *_pattern_ops index matching |