ILIAS\Exercise\Settings\SettingsDBRepository Class Reference

Collaboration diagram for ILIAS\Exercise\Settings\SettingsDBRepository:

Public Member Functions
	__construct (protected ilDBInterface $db, protected InternalDataService $data)
	create (Settings $settings)
	update (Settings $settings)
	getByObjId (int $obj_id)
	delete (int $obj_id)

Protected Member Functions
	getSettingsFromRecord (array $rec)

Detailed Description

Definition at line 26 of file SettingsDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Exercise\Settings\SettingsDBRepository::__construct	(	protected ilDBInterface	$db,
		protected InternalDataService	$data
	)

Definition at line 28 of file SettingsDBRepository.php.

      {
    }

Member Function Documentation

create()

ILIAS\Exercise\Settings\SettingsDBRepository::create

(

Settings

$settings

)

Definition at line 34 of file SettingsDBRepository.php.

References ILIAS\Exercise\Settings\Settings\getCertificateVisibility(), ILIAS\Exercise\Settings\Settings\getCompletionBySubmission(), ILIAS\Exercise\Settings\Settings\getInstruction(), ILIAS\Exercise\Settings\Settings\getNrMandatoryRandom(), ILIAS\Exercise\Settings\Settings\getObjId(), ILIAS\Exercise\Settings\Settings\getPassMode(), ILIAS\Exercise\Settings\Settings\getPassNr(), ILIAS\Exercise\Settings\Settings\getShowSubmissions(), ILIAS\Exercise\Settings\Settings\getTimeStamp(), ILIAS\Exercise\Settings\Settings\getTutorFeedback(), and ILIAS\Repository\int().

                                              : void
    {
        $this->db->insert("exc_data", [
            "obj_id" => ["integer", $settings->getObjId()],
            "instruction" => ["clob", $settings->getInstruction()],
            "time_stamp" => ["integer", $settings->getTimeStamp()],
            "pass_mode" => ["text", $settings->getPassMode()],
            "nr_mandatory_random" => ["integer", $settings->getNrMandatoryRandom()],
            "pass_nr" => ["text", $settings->getPassNr()],
            "show_submissions" => ["integer", (int) $settings->getShowSubmissions()],
            'compl_by_submission' => ["integer", (int) $settings->getCompletionBySubmission()],
            "certificate_visibility" => ["integer", $settings->getCertificateVisibility()],
            "tfeedback" => ["integer", $settings->getTutorFeedback()]
        ]);
    }

Here is the call graph for this function:

delete()

ILIAS\Exercise\Settings\SettingsDBRepository::delete

(

int

$obj_id

)

Definition at line 83 of file SettingsDBRepository.php.

                                       : void
    {
        $this->db->manipulateF(
            "DELETE FROM exc_data WHERE obj_id = %s",
            ["integer"],
            [$obj_id]
        );
    }

getByObjId()

ILIAS\Exercise\Settings\SettingsDBRepository::getByObjId

(

int

$obj_id

)

Definition at line 67 of file SettingsDBRepository.php.

References ILIAS\Exercise\Settings\SettingsDBRepository\getSettingsFromRecord(), and null.

                                           : ?Settings
    {
        $set = $this->db->queryF(
            "SELECT * FROM exc_data WHERE obj_id = %s",
            ["integer"],
            [$obj_id]
        );

        $rec = $this->db->fetchAssoc($set);
        if ($rec !== false) {
            return $this->getSettingsFromRecord($rec);
        }

        return null;
    }

Here is the call graph for this function:

getSettingsFromRecord()

ILIAS\Exercise\Settings\SettingsDBRepository::getSettingsFromRecord ( array  $rec )

protected

Definition at line 92 of file SettingsDBRepository.php.

Referenced by ILIAS\Exercise\Settings\SettingsDBRepository\getByObjId().

                                                        : Settings
    {
        return $this->data->settings(
            (int) $rec['obj_id'],
            $rec['instruction'],
            (int) $rec['time_stamp'],
            $rec['pass_mode'],
            (int) $rec['nr_mandatory_random'],
            (int) $rec['pass_nr'],
            (bool) $rec['show_submissions'],
            (bool) $rec['compl_by_submission'],
            (int) $rec['certificate_visibility'],
            (int) $rec['tfeedback']
        );
    }

Here is the caller graph for this function:

update()

ILIAS\Exercise\Settings\SettingsDBRepository::update

(

Settings

$settings

)

Definition at line 50 of file SettingsDBRepository.php.

References ILIAS\Exercise\Settings\Settings\getCertificateVisibility(), ILIAS\Exercise\Settings\Settings\getCompletionBySubmission(), ILIAS\Exercise\Settings\Settings\getInstruction(), ILIAS\Exercise\Settings\Settings\getNrMandatoryRandom(), ILIAS\Exercise\Settings\Settings\getObjId(), ILIAS\Exercise\Settings\Settings\getPassMode(), ILIAS\Exercise\Settings\Settings\getPassNr(), ILIAS\Exercise\Settings\Settings\getShowSubmissions(), ILIAS\Exercise\Settings\Settings\getTimeStamp(), ILIAS\Exercise\Settings\Settings\getTutorFeedback(), and ILIAS\Repository\int().

                                              : void
    {
        $this->db->update("exc_data", [
            "instruction" => ["clob", $settings->getInstruction()],
            "time_stamp" => ["integer", $settings->getTimeStamp()],
            "pass_mode" => ["text", $settings->getPassMode()],
            "nr_mandatory_random" => ["integer", $settings->getNrMandatoryRandom()],
            "pass_nr" => ["text", $settings->getPassNr()],
            "show_submissions" => ["integer", (int) $settings->getShowSubmissions()],
            'compl_by_submission' => ["integer", (int) $settings->getCompletionBySubmission()],
            "certificate_visibility" => ["integer", $settings->getCertificateVisibility()],
            "tfeedback" => ["integer", $settings->getTutorFeedback()]
        ], [
            "obj_id" => ["integer", $settings->getObjId()]
        ]);
    }

Here is the call graph for this function:

---

The documentation for this class was generated from the following file:

• components/ILIAS/Exercise/Settings/SettingsDBRepository.php