echo 'Test Max Length validation (' . $field->maxCharacters . ')... ';
try {
$field->validate(str_repeat('a', 51));
echo '<span style="color:red">FAIL</span>' . PHP_EOL . PHP_EOL;
} catch (FileMakerValidationException $ex) {
echo '<span style="color:green">SUCCESS</span> ' . PHP_EOL . PHP_EOL;
}
echo "------------------------------------------" . PHP_EOL;
echo " Test Find object's main methods" . PHP_EOL;
echo "------------------------------------------" . PHP_EOL;
echo 'Test FindAll command... ';
$find = $fm->newFindAllCommand($layout->getName());
$result = $find->execute();
echo 'Found ' . $result->getFetchCount() . ' Expected 100...' . ($result->getFetchCount() == 100 ? '<span style="color:green">SUCCESS</span>' : '<span style="color:red">FAIL</span>') . PHP_EOL . PHP_EOL;
echo 'Test FindAny command... ';
$find = $fm->newFindAnyCommand($layout->getName());
$result = $find->execute();
echo 'Found ' . $result->getFetchCount() . ' Expected 1...' . ($result->getFetchCount() == 1 ? '<span style="color:green">SUCCESS</span>' : '<span style="color:red">FAIL</span>') . PHP_EOL . PHP_EOL;
echo 'Test creating Find object from FileMaker... ';
$find = $fm->newFindCommand($layout->getName());
echo '<span style="color:green">SUCCESS</span>' . PHP_EOL . PHP_EOL;
echo 'Test adding preCommandScript... ';
$find->setPreCommandScript('create sample data');
echo '<span style="color:green">SUCCESS</span>' . PHP_EOL . PHP_EOL;
echo 'Test adding find criterion... ';
$find->addFindCriterion('id', 1);
$find->addFindCriterion('text_field', '=="record #2"');
echo '<span style="color:green">SUCCESS</span>' . PHP_EOL . PHP_EOL;
echo 'Test setting logical operator... ';
$find->setLogicalOperator(FileMaker::FIND_OR);
echo '<span style="color:green">SUCCESS</span>' . PHP_EOL . PHP_EOL;
/**
* Sets up the fixture, for example, opens a network connection.
* This method is called before a test is executed.
*/
protected function setUp()
{
$this->fm = new FileMaker($GLOBALS['DB_FILE'], $GLOBALS['DB_HOST'], $GLOBALS['DB_USER'], $GLOBALS['DB_PASSWD']);
//$this->fm->newPerformScriptCommand('sample', "create sample data", 50)->execute();
$this->record = $this->fm->newFindAnyCommand('sample')->execute()->getFirstRecord();
}
