Merge lp:~syleam/wms/5.0-christophe-chauvet into lp:wms

[Christophe CHAUVET]

Fix issue when no crossdock location to migrate

[Christophe CHAUVET (christophe-chauvet)]

Ok

review: Approve

[lp:~syleam/wms/5.0-christophe-chauvet]

219. By Christophe CHAUVET on 2011-03-21

merge from lp:~syleam/wms/5.0-christophe-chauvet to fix issue with migration script

=== modified file 'wms_location/migrations/0.2.0/pre-10-update-crossdock-location.py'
--- wms_location/migrations/0.2.0/pre-10-update-crossdock-location.py	2011-03-02 22:37:03 +0000
+++ wms_location/migrations/0.2.0/pre-10-update-crossdock-location.py	2011-03-21 15:22:15 +0000
@@ -53,8 +53,8 @@
         ##
         cr.execute("""SELECT id FROM stock_location WHERE usage='crossdock'""")
         loc_ids = [x[0] for x in cr.fetchall()]
-
-        cr.execute("""UPDATE stock_location SET categ_id=%s, usage='internal' WHERE id IN %s""", (res[0], tuple(loc_ids),))
+        if loc_ids:
+            cr.execute("""UPDATE stock_location SET categ_id=%s, usage='internal' WHERE id IN %s""", (res[0], tuple(loc_ids),))