0
290
ViewsClean previous data django
I have a JSONField in my model and I wasn't able to clean the initial import on my resource so the data imported were treated as strings instead of lists. When I export the data it looks like this:
The ones below are the previous data from the initial import-export without a custom JSONWidget. The ones above are the data that was cleaned.
How can I then fix the current JSONField with the string and convert it to a list?
·
Santiago Trujillo
1 answers
Answer question0
Presumably you want to clean the values in the database, so that they are standardised to empty list. If so, there are a few ways you could do this:
- A straight
UPDATEcommand via SQL (example) - If you can run
./manage.py shellyou should be able to filter the entries and correct the data. - If you can run
django-admincommands, write a script which filters and corrects the data, then use the django-extensions runscript command. - Create a data migration
Please correct me if I have misunderstood what you are aiming to do.
·
Santiago Trujillo
Report
Answer question