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