On Thu, Mar 10, 2011 at 5:46 PM, octopusgrabbus
<old_road_f...@verizon.net> wrote:
> I'm confused as to how this code isn't using the model?
>
> Here's the model I'm using. The table is in a MySQL database.
> class CsRemove(models.Model):
> action = models.CharField(max_length=3, db_column='Action') #
> Field name made lowercase.
> endpointid = models.IntegerField(primary_key=True,
> db_column='EndpointId') # Field name made lowercase.
> devicetype = models.IntegerField(primary_key=True,
> db_column='DeviceType') # Field name made lowercase.
> channelnumber = models.IntegerField(primary_key=True,
> db_column='ChannelNumber') # Field name made lowercase.
> actiondate = models.DateField(primary_key=True,
> db_column='ActionDate') # Field name made lowercase.
> class Meta:
> db_table = u'cs_remove'
>
> Here's the code extract.
>
> This date, not a datetime, format works fine in other python code, and
> it is a string in the form 2011-03-08 format.
It 'works in other code' - talking directly to mysql though, right,
using mysqldb and not using django's ORM? You are no longer using
mysqldb, you are using django's ORM, and you must obey it's rules, not
mysql's.
Truthfully, if you are using django's ORM, you should be using the
objects it expects, eg date or datetime. Your date format, I can't
tell whether it is 'Y-m-d' or 'Y-d-m'. Using the proper python objects
would resolve ambiguity.
>
> try:
> temp_ept_id =
> CsRemove.objects.get(endpointid=requested_serial_number)
> errors.append('Endpoint and channel
> already queued for removal.')
>
>
> except ObjectDoesNotExist:
> # element was not found - it is OK to add
> to cs_remove
>
> load_date = '0000-00-00'
This isn't a valid date. MySQL will accept it just fine, but it isn't
valid in many other databases, and its not valid in django.
>
> inv_obj = \
> CsRemove(action='R', \
>
> endpointid=request.POST.get('inv_id'), \
>
> devicetype=request.POST.get('ept_type'), \
>
> channelnumber=request.POST.get('ept_ch'), \
> actiondate=load_date)
>
> inv_obj.save(force_insert=True)
> errors.append('Endpoint ID queued for
> customer synch removal')
>
>
>
--
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
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
