public function setUp()
{
parent::setUp();
$this->deps = Test\Factory::managerNoteDefault();
$this->manager = $this->deps->manager;
TableBuilder::create($this->deps->connector, $this->deps->mapper, [MappedFieldNameLeft::class, MappedFieldNameAssoc::class, MappedFieldNameRight::class]);
}
public static function managerArraysModelCustom($map)
{
$mapper = new \Amiss\Mapper\Arrays($map);
$config = ['date' => ['dbTimeZone' => 'UTC', 'appTimeZone' => 'UTC']];
$deps = (object) ['mapper' => $mapper];
$mapper->typeHandlers = \Amiss\Sql\Factory::createTypeHandlers($config);
$deps = self::managerNoteDefault($deps);
TableBuilder::create($deps->connector, $mapper, array_keys($map));
return $deps;
}
public function setUp()
{
$this->db = new \PDOK\Connector('sqlite::memory:');
$this->mapper = $this->createDefaultMapper();
$this->manager = new \Amiss\Sql\Manager($this->db, $this->mapper);
$this->manager->relators = \Amiss\Sql\Factory::createRelators();
foreach ([Demo\Artist::class, Demo\ArtistType::class] as $c) {
TableBuilder::create($this->manager->connector, $this->mapper, $c);
}
$this->manager->connector->exec("INSERT INTO artist (artistId, artistTypeId) VALUES(1, 1)");
$this->manager->connector->exec("INSERT INTO artist (artistId, artistTypeId) VALUES(2, 1)");
$this->manager->connector->exec("INSERT INTO artist_type (artistTypeId) VALUES(1)");
}
public function setUp()
{
$this->db = new \PDOK\Connector('sqlite::memory:');
$this->mapper = $this->createDefaultMapper();
$this->manager = new \Amiss\Sql\Manager($this->db, $this->mapper);
$this->manager->relators = \Amiss\Sql\Factory::createRelators();
foreach ($this->mapper->mappings as $class => $meta) {
TableBuilder::create($this->manager->connector, $this->mapper, $class);
}
$this->manager->connector->exec("INSERT INTO test_child(id, parentId) VALUES(1, 1)");
$this->manager->connector->exec("INSERT INTO test_child(id, parentId) VALUES(2, 1)");
$this->manager->connector->exec("INSERT INTO test_parent(id, grandParentId) VALUES(1, 1)");
$this->manager->connector->exec("INSERT INTO test_grand_parent(id) VALUES(1)");
$this->db->queries = 0;
}
public function setUp()
{
$this->deps = Test\Factory::managerNoteDefault();
$this->manager = $this->deps->manager;
$this->ns = 'Amiss\\Demo\\AssocDifferentFieldColumn';
$tb = TableBuilder::create($this->manager->connector, $this->manager->mapper, [$this->ns . '\\Event', $this->ns . '\\Artist', $this->ns . '\\EventArtist']);
$manager = $this->manager;
$manager->insertTable($this->ns . '\\Event', ['id' => 1, 'name' => 'event1']);
$manager->insertTable($this->ns . '\\Event', ['id' => 2, 'name' => 'event2']);
$manager->insertTable($this->ns . '\\Event', ['id' => 3, 'name' => 'event3']);
$manager->insertTable($this->ns . '\\Artist', ['id' => 1, 'name' => 'artist1']);
$manager->insertTable($this->ns . '\\Artist', ['id' => 2, 'name' => 'artist2']);
$manager->insertTable($this->ns . '\\Artist', ['id' => 3, 'name' => 'artist3']);
$manager->insertTable($this->ns . '\\EventArtist', ['eventId' => 1, 'artistId' => 1]);
$manager->insertTable($this->ns . '\\EventArtist', ['eventId' => 1, 'artistId' => 2]);
$manager->insertTable($this->ns . '\\EventArtist', ['eventId' => 2, 'artistId' => 2]);
$manager->insertTable($this->ns . '\\EventArtist', ['eventId' => 2, 'artistId' => 3]);
}
public function testCreateTable()
{
$deps = Test\Factory::managerNoteDefault();
$deps->mapper->addTypeHandler(new \Amiss\Sql\Type\Autoinc(), 'autoinc');
$deps->mapper->defaultTableNameTranslator = function ($name) {
return 'test_' . $name;
};
try {
\Amiss\Demo\Active\DemoRecord::_reset();
\Amiss\Demo\Active\DemoRecord::setManager($deps->manager);
TableBuilder::create($deps->connector, $deps->mapper, Demo\Active\EventRecord::class);
$er = new Demo\Active\EventRecord();
$er->name = 'foo bar';
$er->slug = 'foobar';
$er->save();
$this->assertTrue(true);
} finally {
\Amiss\Demo\Active\DemoRecord::_reset();
}
}
/**
* @group tablebuilder
*/
public function testCreateTableFailsWhenConnectorIsNotPDOKConnector()
{
$this->deps->connector = new \PDO('sqlite::memory:');
if (version_compare(PHP_VERSION, "7.0.0-dev") >= 0) {
$this->setExpectedException('TypeError');
} else {
$this->setExpectedException('PHPUnit_Framework_Error');
}
TableBuilder::create($this->deps->connector, $this->deps->mapper, __NAMESPACE__ . '\\TestNoFieldsCreate');
}
