public function setUp() { $this->deps = Test\Factory::managerNoteDefault(); if ($this->deps->connector->engine != 'sqlite') { return $this->markTestSkipped(); } }
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 function setUp() { $this->deps = Test\Factory::managerNoteDefault(); if ($this->deps->connector->engine == 'sqlite') { $this->deps->connector->execAll(["CREATE TABLE test_embed_one_parent(id INTEGER PRIMARY KEY AUTOINCREMENT, child TEXT)", "CREATE TABLE test_embed_many_parent(id INTEGER PRIMARY KEY AUTOINCREMENT, children TEXT)"]); } elseif ($this->deps->connector->engine == 'mysql') { $this->deps->connector->execAll(["CREATE TABLE test_embed_one_parent(id INT PRIMARY KEY AUTO_INCREMENT, child TEXT)", "CREATE TABLE test_embed_many_parent(id INT PRIMARY KEY AUTO_INCREMENT, children TEXT)"]); } // To test against either mysql or sqlite, we need to encode as well. $embed = new Type\Embed($this->deps->mapper); $encoder = new Type\Encoder('serialize', 'unserialize', $embed); $this->deps->mapper->addTypeHandler($encoder, 'embed'); }
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(); } }