[Codestriker-commits] CVS update: codestriker/lib/Codestriker/Model File.pm
Brought to you by:
sits
From: <si...@us...> - 2005-07-14 09:54:34
|
Created Codestriker topic at: http://codestriker.sourceforge.net/cgi-bin/codestriker.pl?topic=2729126&action=view User: sits Date: 05/07/14 02:54:16 Modified: lib/Codestriker/Model File.pm Log: Remove nested select so SQL Server works again. Index: File.pm =================================================================== RCS file: /cvsroot/codestriker/codestriker/lib/Codestriker/Model/File.pm,v retrieving revision 1.23 retrieving revision 1.24 diff -u -r1.23 -r1.24 --- File.pm 18 Sep 2004 00:54:19 -0000 1.23 +++ File.pm 14 Jul 2005 09:54:15 -0000 1.24 @@ -113,14 +113,21 @@ # Store the results in the referenced arrays. if ($success) { my @data; + my @sequence; while (@data = $select_file->fetchrow_array()) { push @$filename_array_ref, $data[0]; push @$revision_array_ref, $data[1]; push @$offset_array_ref, $data[2]; push @$binary_array_ref, $data[3]; + push @sequence, $data[4]; + } + $select_file->finish(); + # This has to be called outside the loop above, as SQL Server + # doesn't allow nested selects... gggrrrr. + foreach my $file_id (@sequence) { # Now get the number of lines affected in this file - my $numchanges = Codestriker::Model::Delta->get_delta_size($topicid, $data[4]); + my $numchanges = Codestriker::Model::Delta->get_delta_size($topicid, $file_id); push @$numchanges_array_ref, $numchanges; } |