Django 1.2
mod_wsgi
Python 2.6.6
When I create an object of a model of a table, what is the best way to
update two columns? I can update one easily, but not two of them. I
also noted the model, does not list the third key, at least that I can
recognize.
What am I asking is what constructs should be use -- pointer to code
sample(s) to update two columns in one row or all rows?
This code does not work the way I want it to:
def save_dr_read_range(cycle_num, read_range_in, load_date,
updating_user, max_read_range_in, errors, update_ok):
try:
read_range_obj = DrReadRange(cycle=cycle_num, \
reading_width_days=read_range_in, \
creation_date=load_date, \
created_by=str(updating_user), \
max_read_width=max_read_range_in)
read_range_obj.save()
del read_range_obj
except IntegrityError as e:
errors.append('Error: modifying read range table ' + e)
update_ok = False
except:
e = sys.exc_info()[1]
errors.append('Error: ' + str(e) + ' occurred')
update_ok = False
return errors, update_ok
tnx
cmn
Model:
from django.db import models
class DrReadRange(models.Model):
cycle = models.IntegerField(primary_key=True)
reading_width_days = models.IntegerField(primary_key=True)
creation_date = models.DateField(primary_key=False)
created_by = models.CharField(max_length=30)
max_read_width = models.IntegerField(null=True, blank=True)
class Meta:
db_table = u'dr_read_range'
SQL that created the table:
CREATE TABLE `dr_read_range` (
`cycle` smallint(6) NOT NULL default '0',
`reading_width_days` int(11) NOT NULL default '0',
`creation_date` date NOT NULL,
`created_by` char(10) NOT NULL default 'amr',
`max_read_width` smallint(6) default '3',
PRIMARY KEY (`cycle`,`reading_width_days`,`creation_date`),
KEY `creation_date_ix1` (`creation_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='holds daily reads
range';
SE
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
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.
