Django. Update data in db. Easy question

Question

Ok! I have this model:

class my(models.Model):
    name = models.TextField()
    description = models.TextField()
    created = models.DateTimeField()
    def __unicode__(self):
       return self.name

I'm gettin data to this model from mssql database and saving it. Something like this.

mysql_name='somedata'           #this data come from some connection with mssql
mssql_description='somedata'    #this data come from some connection with mssql
mssql_created='somedata'        #this data come from some connection with mssql

i'm creating field in my MySQL database and saving

mymodel=my(name=mysql_name, description=mssql_description, created=mssql_created)

mymodel.save()

Now it is in my database. I'm doing this in loop so it fill my database.

Then i need check the data in remote MSSQL server by using timestamp. I made SQL request So i'm getting only updated data. End I have to overwrite old data.

Question is how to overvrite old data? I'm little bit confuse.

could it be like this?

   mymodel=my.objects.get(name=mysql_Name)
   mymodel.description=new_updated_description
   mymodel.save

but if i do not have this field at all?....

I have to chek if i have it in my databse? How....?

Ignacio Vazquez-Abrams · Accepted Answer · 2010-07-11 02:24:16Z

1

As long as the same PK is used, the row will be overwritten. It is easiest to get() the existing row, modify the fields, and save() it.

answered Jul 11, 2010 at 2:24

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Davor Lucic · Accepted Answer · 2010-07-11 09:49:24Z

0

You can use get_or_create on your models manager as a shortcut to create new instance of the model or to update the existing one. See docs for examples.

answered Jul 11, 2010 at 9:49

Davor Lucic

29.5k9 gold badges68 silver badges77 bronze badges

Collectives™ on Stack Overflow

Django. Update data in db. Easy question

i'm creating field in my MySQL database and saving

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

i'm creating field in my MySQL database and saving

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related