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