Subversion Repositories DevTools

Rev

Rev 4697 | Rev 6383 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 4697 Rev 6116
Line 514... Line 514...
514 
 
 514 
 
515 
            #
 515 
            #
516 
            #   Create SQL fragment for the insert
 516 
            #   Create SQL fragment for the insert
517 
            #
 517 
            #
518 
            $eCount++;
 518 
            $eCount++;
- 
 
 519 
            my $quoteFname = $fname;
- 
 
 520 
            $quoteFname =~ s~'~''~g;
519 
            my $entry = " INTO release_manager.release_components ( pv_id, file_name, file_path, byte_size, crc_cksum, crc_modcrc ) " .
 521 
            my $entry = " INTO release_manager.release_components ( pv_id, file_name, file_path, byte_size, crc_cksum, crc_modcrc ) " .
520 
                        " VALUES ( $opt_pvid, '$fname', '$fpath',$fsize , '$fmd5', '')";
 522 
                        " VALUES ( $opt_pvid, '$quoteFname', '$fpath',$fsize , '$fmd5', '')";
521 
            $updateRmFilesData .= $entry;
 523 
            $updateRmFilesData .= $entry;
522 
 
 524 
 
523 
            # The size of the aggregation is key to performance
 525 
            # The size of the aggregation is key to performance
524 
            # Too big is as bad as too small
 526 
            # Too big is as bad as too small
525 
            if (length($updateRmFilesData) > 10000)
 527 
            if (length($updateRmFilesData) > 10000)
Line 551... Line 553...
551 
{
 553 
{
552 
    if (length($updateRmFilesData) > 0)
 554 
    if (length($updateRmFilesData) > 0)
553 
    {
 555 
    {
554 
        executeRmQuery(
 556 
        executeRmQuery(
555 
            'updateRmFilesInsert',
 557 
            'updateRmFilesInsert',
556 
            'INSERT ALL' .$updateRmFilesData . ' SELECT 1 FROM DUAL'
 558 
            'INSERT ALL' . $updateRmFilesData . ' SELECT 1 FROM DUAL'
557 
            );
 559 
            );
558 
 
 560 
 
559 
        $updateRmFilesData = "";
561 
        $updateRmFilesData = "";
560 
    }
 562 
    }
561 
}
 563 
}