public function testLsd() { $datastore = new MockQlDataStore(); $connection = new MockPdoConnection(); $connection->config(); $datastore->setConnection($connection); $connection->connect(); $resolver = new DalResolver(); $resolver->addDataStore('mockql', $datastore); $resolver->boot(); $resolver->enablePerformanceMetrics(); $connection->setResolver($resolver); $dao = new MockQlDao(); $dao->username = time() . 'user'; $dao->display = 'User ' . date("Y-m-d"); $dao->boolTest = true; $datastore->save($dao); $dao->username = '******'; $dao->display = 'Brooke'; $dao->boolTest = false; $datastore->save($dao); $dao->username = '******'; $datastore->load($dao); $this->assertEquals('test 1', $dao->username); $this->assertEquals(0, $dao->boolTest); $dao->display = 'Save 2'; $datastore->save($dao); $staticLoad = MockQlDao::loadById($dao->id); $this->assertEquals($dao->username, $staticLoad->username); $datastore->delete($dao); $metrics = $resolver->getPerformanceMetrics(); $resolver->disablePerformanceMetrics(); $this->assertCount(6, $metrics); $resolver->shutdown(); }
public function testGetData() { $dao = new MockQlDao(); $datastore = new MockQlDataStore(); $connection = new MockAbstractQlDataConnection(); $datastore->setConnection($connection); $datastore->getData(QueryBuilder::select()->from($dao->getTableName())); $this->assertEquals('SELECT * FROM `mock_ql_daos`', $connection->getExecutedQuery()); }
public function testNoDataStore() { $resolver = new DalResolver(); $resolver->boot(); $mock = new MockQlDao(); $this->setExpectedException('\\Packaged\\Dal\\Exceptions\\DalResolver\\DataStoreNotFoundException'); $mock->getDataStore(); }
public function testDynamicTable() { $dao = new MockQlDao(); $dao->setTableName('random3'); $collection = $dao->getCollection(); $this->assertEquals("SELECT random3.* FROM random3", QueryAssembler::stringify($collection)); $collection = $dao->getCollection(['X' => 'y']); $this->assertEquals('SELECT random3.* FROM random3 WHERE X = "y"', QueryAssembler::stringify($collection)); }