I haven't got a lot to go on, output-wise; here's what I ran: [EMAIL PROTECTED] intl]$ python manage.py dumpdata fuel > fuel.tmp Unable to serialize database: Decimal("0.00") is not JSON serializable
And trying a different format, a different error: [EMAIL PROTECTED] intl]$ python manage.py dumpdata --format xml fuel > fuel.xml Unable to serialize database: 'ascii' codec can't decode byte 0xe2 in position 13: ordinal not in range(128) The fuel.tmp file contains "None\n". The second reply asked "Why switch?" There's no smoking gun or nasty occurrence, but we're switching some applications from Oracle to open- source databases and are trying several. Because we need to interact both via Django applications and via direct SQL, we have been finding it much easier to shoot ourselves in the feet when we neglect to use the InnoDB storage engine and thus have no foreign-key-constraint enforcement. It also seems like Django authors (in The Book at least) favor PostgreSQL. On May 26, 8:40 pm, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > On Sun, 2007-05-27 at 08:14 +0800, Russell Keith-Magee wrote: > > On 5/27/07, Hancock, David (DHANCOCK) <[EMAIL PROTECTED]> wrote: > > > > I'd love it to be as simple as a dump-and-restore, but so far, no silver > > > bullet has emerged. Things I've tried: > > ... > > > manage.py dumpdata # chokes on Decimal(0.00) datatype, not sure how > > > to > > > load output anyway > > > If this approach is failing on Decimal(0.00), I would consider it a > > major bug. All going well, I should have a chance to look at this > > later today. > > This surprises me, too. We're testing the serialisation (and reading > back) of Decimal types in the test suite. May be some unnoticed (by me) > difference between pure using django.core.serializers and manage.py's > dumpdata, but the path looks pretty straightforward. > > Regards, > Malcolm --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---