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
}