public function testStatics() { $datastore = new MockQlDataStore(); $connection = new MockPdoConnection(); $connection->config(); $datastore->setConnection($connection); $collection = MockQlDao::collection(); $this->assertInstanceOf(MockQlDao::class, $collection->createNewDao()); $collection = MockQlDao::collection(['name' => 'Test']); $this->assertInstanceOf(MockQlDao::class, $collection->createNewDao()); $this->assertEquals('SELECT mock_ql_daos.* FROM mock_ql_daos WHERE name = "Test"', QueryAssembler::stringify($collection->getQuery())); $resolver = new DalResolver(); $resolver->boot(); $resolver->addDataStore('mockql', $datastore); $connection->setResolver($resolver); $username = uniqid('TEST'); $u = new MockQlDao(); $u->username = $username; $u->display = 'Test One'; $u->boolTest = true; $u->save(); // save again to ensure no query is made $u->save(); $mocks = MockQlDao::collection(['username' => $username]); $this->assertCount(1, $mocks); foreach (MockQlDao::each(['username' => $username]) as $usr) { $this->assertInstanceOf(MockQlDao::class, $usr); } $preloaded = MockQlDao::loadWhere(['username' => $username]); $this->assertCount(1, $preloaded); $u2 = new MockQlDao(); $u2->username = '******'; $u2->display = 'Test One'; $u2->save(); try { $msg = null; MockQlDao::loadOneWhere(['display' => 'Test One']); } catch (\Exception $e) { $msg = $e->getMessage(); } $this->assertEquals("Multiple Objects were located when trying to load one", $msg); $u2Test = MockQlDao::loadOneWhere(['username' => 'Tester']); $this->assertEquals($u2->username, $u2Test->username); $this->assertNull(MockQlDao::loadOneWhere(['username' => 'Missing'])); $u->delete(); $u2->delete(); $resolver->shutdown(); }
public function testQueried() { Dao::setDalResolver(new DalResolver()); $datastore = new MockQlDataStore(); $connection = new MockPdoConnection(); $connection->config(); $datastore->setConnection($connection); MockQlDao::getDalResolver()->addDataStore('mockql', $datastore); $connection->setResolver(MockQlDao::getDalResolver()); $u = new MockQlDao(); $datastore->getConnection()->connect()->runQuery("TRUNCATE " . $u->getTableName()); $collection = MockQlDao::collection(); $this->assertNull($collection->min('id')); $this->assertNull($collection->max('id')); $this->assertNull($collection->avg('id')); $this->assertNull($collection->sum('id')); $this->assertEmpty($collection->distinct('username')); $u->display = 'queried'; $u->username = '******'; $u->id = 1; $u->save(); $u->markDaoAsLoaded(false); $u->username = '******'; $u->id = 2; $u->save(); $u->markDaoAsLoaded(false); $u->username = '******'; $u->id = 5; $u->save(); $u->markDaoAsLoaded(false); $u->username = '******'; $u->id = 8; $u->save(); $this->assertEquals(4, $collection->count()); $this->assertEquals(1, $collection->min('id')); $this->assertEquals(8, $collection->max('id')); $this->assertEquals(4, $collection->avg('id')); $this->assertEquals(16, $collection->sum('id')); $this->assertEquals(["Test", "User", "Testing"], array_values($collection->distinct('username'))); $collection->loadWhere(['username' => 'Test']); $this->assertCount(2, $collection); $collection = MockQlDao::collection(['username' => 'Test']); $this->assertCount(2, $collection->getRawArray()); $first = MockQlDao::collection(['username' => 'Test'])->first(); $this->assertInstanceOf(MockQlDao::class, $first); $first = MockQlDao::collection(['username' => 'NotExisting'])->first('abc'); $this->assertEquals('abc', $first); $count = MockQlDao::collection(['username' => 'NotExisting'])->orderBy('username')->count(); $this->assertEquals(0, $count); $col = MockQlDao::collection(['username' => 'Test'])->limit(10); $first = $col->first(); $this->assertTrue($col->hasClause('LIMIT')); $limit = $col->getClause('LIMIT'); if ($limit instanceof LimitClause) { $this->assertEquals(10, $limit->getLimit()->getValue()); } $this->assertInstanceOf(MockQlDao::class, $first); $col = MockQlDao::collection(['username' => 'Test'])->load(); $this->assertCount(2, $collection); $first = $col->first(); $this->assertInstanceOf(MockQlDao::class, $first); $countCollection = MockQlDao::collection(); $countCollection->limit(1); $this->assertEquals(1, $countCollection->count()); $countCollection->limit(0); $this->assertEquals(0, $countCollection->count()); $datastore->getConnection()->runQuery("TRUNCATE " . $u->getTableName()); Dao::unsetDalResolver(); }