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
)
