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(); }