Hi Yunti, Did you read about model level validation <https://docs.djangoproject.com/en/1.8/ref/models/instances/#validating-objects>? Calling model_instance.full_clean() triggers validation but it's not implicitly called when you save an instance.
For your date case you'll have to include a layer that feeds Django models with datetime.date objects from your string representation. That's what Django forms do under the hood using the DATE_INPUT_FORMAT setting <https://docs.djangoproject.com/en/1.8/ref/settings/#date-input-formats>. I would suggest you define Model form for your models and use them to perform conversion and validation of your scrapped data. Simon Le mercredi 21 octobre 2015 13:49:08 UTC-4, Yunti a écrit : > > I have a django project where I want to save web scraped data to the > database via the django ORM- which will be used in the django app. > > The data is currently in the form of JSON -> converted to python dict via > json.loads > > I setup my model with the narrowest/ most constrained field type possible > - (e.g. DecimalField with decimal_places=2 and max_digits=4 for prices) > > I naively tried to save the data/values from the relevant keys in the JSON > directly to the relevant model field, however, this raised errors due to > data format. > > It looks like data entered via a form is converted to the relevant python > object in the form validation - e.g. a date string '24 May 2015' is > converted to a datetime object and the date format validated. > > None of this appears to happen when saving directly to a model? (would be > good to have my understanding here confirmed?) and so saving '24 May 2015' > directly to a DateField in a model produces a format error. > > What validation (if any) does Django do when saving to a database directly > via the ORM? - Does it just rely on the type checking in the database (so > for sqlite this would be nothing but would for postgres)? > > Thanks. > > > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/dee046d5-46f8-4517-bb49-5e6906a4b369%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
