Subversion Repositories SmartDukaan

Rev

Rev 35250 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 35250 Rev 35265
Line 28... Line 28...
28 
        Session session = sessionFactory.getCurrentSession();
 28 
        Session session = sessionFactory.getCurrentSession();
29 
 
 29 
 
30 
        ensureColumnExists(session);
 30 
        ensureColumnExists(session);
31 
        ensureIndexExists(session);
 31 
        ensureIndexExists(session);
32 
 
 32 
 
33 
        int totalUpdated = 0;
 33 
        int totalUpdated = 1;
34 
        while (true) {
 34 
        while (true) {
35 
            // Build the mapping subquery limited to batchSize
 35 
            // Build the mapping subquery limited to batchSize
36 
            String mappingCte =
 36 
            String mappingCte =
37 
                    "SELECT wi.id AS target_id, (" +
 37 
                    "SELECT wi.id AS target_id, (" +
38 
                    "  SELECT orig.id FROM warehouse.inventoryItem orig " +
 38 
                    "  SELECT orig.id FROM warehouse.inventoryItem orig " +