public function testInsertDuplicateUserData() { ob_start(); $myDb = DBMaker::create('botspacetest'); Database::clearDB(); $db = Database::getDB('botspacetest', 'C:\\xampp\\myConfig.ini'); $beforeCount = count(UserDataDB::getUserDataBy()); $userDataCopy = UserDataDB::getUserDataRowSetsBy('userDataId', 1); $userDataCopy = $userDataCopy[0]; $s1 = new UserData($userDataCopy); $insertedUserData = UserDataDB::addUserData($s1); $this->assertGreaterThan(0, $insertedUserData->getErrorCount(), 'Duplicate attempt should return with an error'); $afterCount = count(UserDataDB::getUserDataBy()); $this->assertEquals($afterCount, $beforeCount, 'The database should have the same number of elements after the insertion attempt'); ob_get_clean(); }
public static function getUserDataValuesBy($column, $type = null, $value = null) { $userDataRows = UserDataDB::getUserDataRowSetsBy($type, $value); return UserDataDB::getUserDataValues($userDataRows, $column); }
public function testUpdateUserData() { $myDB = DBMaker::create('botspacetest'); Database::clearDB(); $db = Database::getDB('botspacetest', 'C:\\xampp\\myConfig.ini'); $testUserDataId = 1; $userDataArray = UserDataDB::getUserDataBy('userDataId', $testUserDataId); $userData = $userDataArray[0]; $params = $userData->getParameters(); $this->assertEquals($userData->getUserName(), 'jabituya', 'Before the update it should have username jabituya'); $testUserDataRowsArray = UserDataDB::getUserDataRowSetsBy('userDataId', $testUserDataId); $testUserDataRow = $testUserDataRowsArray[0]; $params['user_name'] = 'jabituya2000'; $newUserData = new UserData($params); $newUserData->setUserDataId($testUserDataId); $userData = UserDataDB::updateUserData($newUserData); $this->assertEquals($userData->getUserName(), 'jabituya2000', 'After the update it should have username jabituya2000'); $this->assertTrue(empty($userData->getErrors()), 'The updated user data should have no errors'); }