Re: Patterns / Best practice for automated data refreshes

[ALJ]

Hi Shawn,

Thanks for that. I'll have a look at using models then.

Cheers

ALJ

On Sep 26, 7:32 pm, Shawn Milochik  wrote:
> If you're updating a database created by Django, I recommend that your import 
> script import your Django models and update them with the data. Otherwise you 
> run the risk of running SQL that breaks your Django app (or worse, causes it 
> to run with corrupted data and no errors).
>
> I'd do something with cron (or Celery), use the XLRD module to read the Excel 
> into Python data structures (dictionaries and lists), then use that data to 
> update the models.
>
> Shawn

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Re: Patterns / Best practice for automated data refreshes

[Shawn Milochik]

If you're updating a database created by Django, I recommend that your import 
script import your Django models and update them with the data. Otherwise you 
run the risk of running SQL that breaks your Django app (or worse, causes it to 
run with corrupted data and no errors).

I'd do something with cron (or Celery), use the XLRD module to read the Excel 
into Python data structures (dictionaries and lists), then use that data to 
update the models.

Shawn

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.