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);