protected function setUp() { $fetcher = ProjectBuild::fetcher(); $blogResourceDefinition = ProjectBuild::blogResourceDefinition(); $blogSelectBuilder = ProjectBuild::blogSelectBuilder(); Build::addFilteringBuilderStrategy(new RegexFilteringBuilderStrategy(), 20); $this->criteriaFactory = Build::criteriaFactory(); $this->identifierEngine = Build::identifierEngine($fetcher); $this->identifierEngine->add('blog', $blogResourceDefinition, $blogSelectBuilder); }
#!/usr/bin/env php <?php require __DIR__ . '/../../../vendor/autoload.php'; use Gnugat\PommSearchEngine\Test\Fixtures\Project\ProjectBuild; $config = ProjectBuild::config(); $command = 'psql'; $connectionOptions = "-h {$config['host']} -p {$config['port']} -U {$config['username']}"; if (isset($config['password'])) { $command = "PGPASSWORD={$config['password']} {$command}"; } else { $connectionOptions .= '-w'; } exec("{$command} -c 'DROP DATABASE {$config['database']};' {$connectionOptions} >> /dev/null 2>&1"); exec("{$command} -c 'CREATE DATABASE {$config['database']};' {$connectionOptions}"); $queryManager = ProjectBuild::queryManager(); $queryManager->query(<<<SQL CREATE TABLE author ( id INT NOT NULL PRIMARY KEY, name TEXT NOT NULL UNIQUE ) SQL ); $queryManager->query("INSERT INTO author VALUES (1, 'Nate')"); $queryManager->query("INSERT INTO author VALUES (2, 'Nicolas')"); $queryManager->query("INSERT INTO author VALUES (3, 'Lorel')"); $queryManager->query(<<<SQL CREATE TABLE blog ( id INT NOT NULL PRIMARY KEY, title TEXT NOT NULL UNIQUE, author_id INT NOT NULL REFERENCES author(id) ON DELETE CASCADE )