function testParametersAreAssignedToSqlCommand()
{
$SqlCommand = new SqlCommand();
$parameters = new Parameters();
$p1 = new Parameter('n1', 'v1');
$parameters->Add($p1);
$parameters->Add(new Parameter('n2', 'v2'));
$SqlCommand->SetParameters($parameters);
$newParam = new Parameter('n3', 'v3');
$SqlCommand->AddParameter($newParam);
$this->assertNotNull($parameters, 'Parameters object null');
$this->assertNotNull($SqlCommand->Parameters, 'SqlCommand::parameters is null');
$this->assertEquals(3, $SqlCommand->Parameters->Count());
$this->assertEquals($parameters->Items(0), $SqlCommand->Parameters->Items(0));
$this->assertEquals($parameters->Items(1), $SqlCommand->Parameters->Items(1));
$this->assertNotNull($SqlCommand->Parameters->Items(2), 'Last parameter object null');
$this->assertEquals(3, $parameters->Count());
$this->assertEquals($newParam, $SqlCommand->Parameters->Items(2));
}
function testDatabaseQueryLoadsValuesInCorrectOrder()
{
$name1 = 'paramName1';
$val1 = 'value1';
$name2 = 'paramName2';
$val2 = 'value2';
$cn = new FakeDBConnection();
$db = new Database($cn);
$p1 = new Parameter($name1, $val1);
$p2 = new Parameter($name2, $val2);
$parameters = new Parameters();
$parameters->Add($p1);
$parameters->Add($p2);
$command = new SqlCommand("SELECT * FROM sometable WHERE col1 = @{$name1} AND col2 = @{$name2}");
$command->SetParameters($parameters);
$adapter = new Mdb2CommandAdapter($command);
$vals = $adapter->GetValues();
$this->assertEquals(2, count($vals));
$this->assertEquals($val1, $vals[$name1]);
$this->assertEquals($val2, $vals[$name2]);
$this->assertEquals("SELECT * FROM sometable WHERE col1 = :{$name1} AND col2 = :{$name2}", $adapter->GetQuery());
}
// and there is no config file for this folder
// Display the first file
if ($Config->FileID == 0 && $Config->CurrentWorkingDirectory != $Config->CurrentBrowsingDirectory && !$Config->UsePageIntroductionInSubFolders) {
$Config->FileID = 1;
}
$FilesToDisplay = $Config->FilesPerPage;
if (!$Config->ShowMultipleFiles) {
$FilesToDisplay = 1;
}
$aItemHistory = array();
$FileDisplay = "";
$FileList = "";
// Create a parameters class to manage querystring values
$Params = new Parameters();
$Params->DefineCollection($_GET);
$Params->Add("fpp", $Config->FilesPerPage);
$Params->Remove("smf");
if ($Config->FolderIDs == "") {
$Params->Remove("did");
}
$FileCounter = 0;
// Build the file listing
while (list(, $CurrentFileCollection) = each($FileCollections)) {
// Get the sorted files
$Files = $CurrentFileCollection->GetFiles($Config->SortBy, $Config->SortDirection, $ThumbnailCollection);
if (count($Files) > 0) {
$FileList .= "<h2>" . $CurrentFileCollection->Name . "</h2>\r\n <ul class=\"List Files\">";
$RootPath = substr(CurrentWebPath(), 0, strlen(CurrentWebPath()) - 1);
$CurrentPath = $RootPath . "/" . BuildLiteralPath($Config->FolderNavigator);
for ($j = 0; $j < count($Files); $j++) {
$FileCounter += 1;
