Commit manually in django

Question

Is there a better way to do the following in a django Model method? The following looks quite verbose, as I could do the same in the SQL shell with one line:

class ItemMaster(models.Model):
    ...

    @classmethod
    @transaction.commit_manually
    def update_imdb_rank(self):
        '''
        Update all ranks from the IMDbEntry table
        '''
        cursor = connection.cursor()
        cursor.execute("UPDATE main_itemmaster i JOIN mturk_imdbentry m USING (imdb_url) SET i.imdb_rank=m.imdb_rank")
        transaction.commit()

Do you have a foreign key from main.ItemMaster to mturk.IMDBEntry or vice versa? And is it based on imdb_url? — schillingt
– schillingt, Commented Jul 8, 2015 at 1:30
There's not a foreign key on either, they'll just be the same. — David542
– David542, Commented Jul 8, 2015 at 1:38
If you were hoping to use the ORM, then you won't be able to unless you add a FK or a generic foreign key relationship between the two. — schillingt
– schillingt, Commented Jul 8, 2015 at 1:41

Incognos · Accepted Answer · 2015-07-08 01:39:01Z

2

You can use the with statement to reduce verbosity if you wish:

class ItemMaster(models.Model):
    ...

    @classmethod
    def update_imdb_rank(self):
        with transaction.atomic():
            cursor = connection.cursor()
            cursor.execute("UPDATE main_itemmaster i JOIN mturk_imdbentry m USING (imdb_url) SET i.imdb_rank=m.imdb_rank")

answered Jul 8, 2015 at 1:39

Incognos

2,0011 gold badge18 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Commit manually in django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related