Proyectos de Subversion Moodle

Rev

Rev 1 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 1 Rev 1441
Línea 421... Línea 421...
421
            $updatesql = "UPDATE {context} ct, {context_temp} temp
421
            $updatesql = "UPDATE {context} ct, {context_temp} temp
422
                             SET ct.path = temp.path,
422
                             SET ct.path = temp.path,
423
                                 ct.depth = temp.depth,
423
                                 ct.depth = temp.depth,
424
                                 ct.locked = temp.locked
424
                                 ct.locked = temp.locked
425
                           WHERE ct.id = temp.id";
425
                           WHERE ct.id = temp.id";
426
        } else if ($dbfamily == 'oracle') {
-
 
427
            $updatesql = "UPDATE {context} ct
-
 
428
                             SET (ct.path, ct.depth, ct.locked) =
-
 
429
                                 (SELECT temp.path, temp.depth, temp.locked
-
 
430
                                    FROM {context_temp} temp
-
 
431
                                   WHERE temp.id=ct.id)
-
 
432
                           WHERE EXISTS (SELECT 'x'
-
 
433
                                           FROM {context_temp} temp
-
 
434
                                           WHERE temp.id = ct.id)";
-
 
435
        } else if ($dbfamily == 'postgres' || $dbfamily == 'mssql') {
426
        } else if ($dbfamily == 'postgres' || $dbfamily == 'mssql') {
436
            $updatesql = "UPDATE {context}
427
            $updatesql = "UPDATE {context}
437
                             SET path = temp.path,
428
                             SET path = temp.path,
438
                                 depth = temp.depth,
429
                                 depth = temp.depth,
439
                                 locked = temp.locked
430
                                 locked = temp.locked
440
                            FROM {context_temp} temp
431
                            FROM {context_temp} temp
441
                           WHERE temp.id={context}.id";
432
                           WHERE temp.id={context}.id";
442
        } else {
433
        } else {
443
            // Sqlite and others.
-
 
444
            $updatesql = "UPDATE {context}
-
 
445
                             SET path = (SELECT path FROM {context_temp} WHERE id = {context}.id),
-
 
446
                                 depth = (SELECT depth FROM {context_temp} WHERE id = {context}.id),
434
            throw new \core\exception\coding_exception("Unsupported database family: {$dbfamily}");
447
                                 locked = (SELECT locked FROM {context_temp} WHERE id = {context}.id)
-
 
448
                             WHERE id IN (SELECT id FROM {context_temp})";
-
 
449
        }
435
        }
Línea 450... Línea 436...
450
 
436
 
451
        $DB->execute($updatesql);
437
        $DB->execute($updatesql);