ILIAS\WebDAV\Mount\RepositoryDB Class Reference

Inheritance diagram for ILIAS\WebDAV\Mount\RepositoryDB:

Collaboration diagram for ILIAS\WebDAV\Mount\RepositoryDB:

Public Member Functions
	__construct (protected ilDBInterface $db)
	createMountInstructionsDocumentEntry (Document $document)
	getNextMountInstructionsDocumentId ()
	getHighestSortingNumber ()
	getMountInstructionsDocumentById (int $id)
	getMountInstructionsByLanguage (string $language)
	getAllMountInstructions ()
	doMountInstructionsExistByLanguage (string $language)
	updateMountInstructions (Document $document)
	updateSortingValueById (int $id, int $a_new_sorting_value)
	deleteMountInstructionsById (int $id)
	createMountInstructionsDocumentEntry (Document $document)
	getNextMountInstructionsDocumentId ()
	getHighestSortingNumber ()
	getMountInstructionsDocumentById (int $id)
	getMountInstructionsByLanguage (string $language)
	getAllMountInstructions ()
	doMountInstructionsExistByLanguage (string $language)
	updateMountInstructions (Document $document)
	updateSortingValueById (int $id, int $a_new_sorting_value)
	deleteMountInstructionsById (int $id)

Data Fields
const string	TABLE_MOUNT_INSTRUCTIONS = 'webdav_instructions'

Protected Member Functions
	buildDocumentFromDatabaseRecord (array $result)

Detailed Description

Definition at line 26 of file RepositoryDB.php.

Constructor & Destructor Documentation

__construct()

ILIAS\WebDAV\Mount\RepositoryDB::__construct

(

protected ilDBInterface

$db

)

Definition at line 30 of file RepositoryDB.php.

    {
    }

Member Function Documentation

buildDocumentFromDatabaseRecord()

ILIAS\WebDAV\Mount\RepositoryDB::buildDocumentFromDatabaseRecord ( array  $result )

protected

Definition at line 165 of file RepositoryDB.php.

                                                                     : Document
    {
        return new Document(
            (int) $result['id'],
            $result['title'],
            $result['uploaded_instructions'],
            $result['processed_instructions'],
            $result['lng'],
            $result['creation_ts'],
            $result['modification_ts'],
            (int) $result['owner_usr_id'],
            (int) $result['last_modification_usr_id'],
            (int) $result['sorting']
        );
    }

Referenced by ILIAS\WebDAV\Mount\RepositoryDB\getAllMountInstructions(), ILIAS\WebDAV\Mount\RepositoryDB\getMountInstructionsByLanguage(), and ILIAS\WebDAV\Mount\RepositoryDB\getMountInstructionsDocumentById().

Here is the caller graph for this function:

createMountInstructionsDocumentEntry()

ILIAS\WebDAV\Mount\RepositoryDB::createMountInstructionsDocumentEntry

(

Document

$document

)

Implements ILIAS\WebDAV\Mount\Repository.

Definition at line 34 of file RepositoryDB.php.

                                                                            : void
    {
        $this->db->insert(
            self::TABLE_MOUNT_INSTRUCTIONS,
            [
                'id' => ['int', $document->getId()],
                'title' => ['text', $document->getTitle()],
                'uploaded_instructions' => ['clob', $document->getUploadedInstructions()],
                'processed_instructions' => ['clob', $document->getProcessedInstructions()],
                'lng' => ['text', $document->getLanguage()],
                'creation_ts' => ['timestamp', $document->getCreationTs()],
                'modification_ts' => ['timestamp', $document->getModificationTs()],
                'owner_usr_id' => ['int', $document->getOwnerUsrId()],
                'last_modification_usr_id' => ['int', $document->getLastModificationUsrId()],
                'sorting' => ['int', $document->getSorting()],
            ]
        );
    }

References ILIAS\WebDAV\Mount\Document\getCreationTs(), ILIAS\WebDAV\Mount\Document\getId(), ILIAS\WebDAV\Mount\Document\getLanguage(), ILIAS\WebDAV\Mount\Document\getLastModificationUsrId(), ILIAS\WebDAV\Mount\Document\getModificationTs(), ILIAS\WebDAV\Mount\Document\getOwnerUsrId(), ILIAS\WebDAV\Mount\Document\getProcessedInstructions(), ILIAS\WebDAV\Mount\Document\getSorting(), ILIAS\WebDAV\Mount\Document\getTitle(), and ILIAS\WebDAV\Mount\Document\getUploadedInstructions().

Here is the call graph for this function:

deleteMountInstructionsById()

ILIAS\WebDAV\Mount\RepositoryDB::deleteMountInstructionsById

(

int

$id

)

Implements ILIAS\WebDAV\Mount\Repository.

Definition at line 157 of file RepositoryDB.php.

                                                        : void
    {
        $query = "DELETE FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS)
            . ' WHERE id=' . $this->db->quote($id, 'integer');
 
        $this->db->manipulate($query);
    }

References $id.

doMountInstructionsExistByLanguage()

ILIAS\WebDAV\Mount\RepositoryDB::doMountInstructionsExistByLanguage

(

string

$language

)

Implements ILIAS\WebDAV\Mount\Repository.

Definition at line 114 of file RepositoryDB.php.

                                                                        : int
    {
        $query = "SELECT id FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS)
            . " WHERE lng=" . $this->db->quote($language, 'text');
 
        $result = $this->db->query($query);
        $record = $this->db->fetchAssoc($result);
 
        return ($record === null ? 0 : (int) $record['id']);
    }

getAllMountInstructions()

ILIAS\WebDAV\Mount\RepositoryDB::getAllMountInstructions

(

)

Implements ILIAS\WebDAV\Mount\Repository.

Definition at line 101 of file RepositoryDB.php.

                                             : array
    {
        $query = "SELECT * FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS) . " ORDER BY sorting";
        $result = $this->db->query($query);
 
        $document_list = [];
        while ($record = $this->db->fetchAssoc($result)) {
            $document_list[] = $this->buildDocumentFromDatabaseRecord($record);
        }
 
        return $document_list;
    }

References ILIAS\WebDAV\Mount\RepositoryDB\buildDocumentFromDatabaseRecord().

Here is the call graph for this function:

getHighestSortingNumber()

ILIAS\WebDAV\Mount\RepositoryDB::getHighestSortingNumber

(

)

Implements ILIAS\WebDAV\Mount\Repository.

Definition at line 62 of file RepositoryDB.php.

                                             : int
    {
        $query = "SELECT max(sorting) as max_sort FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS);
        $result = $this->db->query($query);
 
        $row = $this->db->fetchAssoc($result);
        return isset($row) && !is_null($row['max_sort']) ? (int) $row['max_sort'] : 0;
    }

References ILIAS\Repository\int().

Here is the call graph for this function:

getMountInstructionsByLanguage()

ILIAS\WebDAV\Mount\RepositoryDB::getMountInstructionsByLanguage

(

string

$language

)

Implements ILIAS\WebDAV\Mount\Repository.

Definition at line 86 of file RepositoryDB.php.

                                                                    : Document
    {
        $query = "SELECT * FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS)
            . " WHERE lng=" . $this->db->quote($language, 'text');
 
        $result = $this->db->query($query);
        $record = $this->db->fetchAssoc($result);
 
        if (!$record) {
            throw new InvalidArgumentException("Document for the language $language not found");
        }
 
        return $this->buildDocumentFromDatabaseRecord($record);
    }

References ILIAS\WebDAV\Mount\RepositoryDB\buildDocumentFromDatabaseRecord().

Here is the call graph for this function:

getMountInstructionsDocumentById()

ILIAS\WebDAV\Mount\RepositoryDB::getMountInstructionsDocumentById

(

int

$id

)

Implements ILIAS\WebDAV\Mount\Repository.

Definition at line 71 of file RepositoryDB.php.

                                                             : Document
    {
        $query = "SELECT * FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS)
            . " WHERE id=" . $this->db->quote($id, 'int');
 
        $result = $this->db->query($query);
        $record = $this->db->fetchAssoc($result);
 
        if (!$record) {
            throw new InvalidArgumentException("Document with the id $id not found");
        }
 
        return $this->buildDocumentFromDatabaseRecord($record);
    }

References $id, and ILIAS\WebDAV\Mount\RepositoryDB\buildDocumentFromDatabaseRecord().

Here is the call graph for this function:

getNextMountInstructionsDocumentId()

ILIAS\WebDAV\Mount\RepositoryDB::getNextMountInstructionsDocumentId

(

)

Implements ILIAS\WebDAV\Mount\Repository.

Definition at line 53 of file RepositoryDB.php.

                                                        : int
    {
        if (!$this->db->sequenceExists(self::TABLE_MOUNT_INSTRUCTIONS)) {
            $this->db->createSequence(self::TABLE_MOUNT_INSTRUCTIONS);
        }
 
        return $this->db->nextId(self::TABLE_MOUNT_INSTRUCTIONS);
    }

updateMountInstructions()

ILIAS\WebDAV\Mount\RepositoryDB::updateMountInstructions

(

Document

$document

)

Implements ILIAS\WebDAV\Mount\Repository.

Definition at line 125 of file RepositoryDB.php.

                                                               : void
    {
        $this->db->update(
            self::TABLE_MOUNT_INSTRUCTIONS,
            [
                'title' => ['text', $document->getTitle()],
                'lng' => ['text', $document->getLanguage()],
                'creation_ts' => ['timestamp', $document->getCreationTs()],
                'modification_ts' => ['timestamp', $document->getModificationTs()],
                'owner_usr_id' => ['int', $document->getOwnerUsrId()],
                'last_modification_usr_id' => ['int', $document->getLastModificationUsrId()],
                'sorting' => ['int', $document->getSorting()],
            ],
            [
                'id' => ['int', $document->getId()],
            ]
        );
    }

References ILIAS\WebDAV\Mount\Document\getCreationTs(), ILIAS\WebDAV\Mount\Document\getId(), ILIAS\WebDAV\Mount\Document\getLanguage(), ILIAS\WebDAV\Mount\Document\getLastModificationUsrId(), ILIAS\WebDAV\Mount\Document\getModificationTs(), ILIAS\WebDAV\Mount\Document\getOwnerUsrId(), ILIAS\WebDAV\Mount\Document\getSorting(), and ILIAS\WebDAV\Mount\Document\getTitle().

Here is the call graph for this function:

updateSortingValueById()

ILIAS\WebDAV\Mount\RepositoryDB::updateSortingValueById	(	int	$id,
		int	$a_new_sorting_value
	)

Implements ILIAS\WebDAV\Mount\Repository.

Definition at line 144 of file RepositoryDB.php.

                                                                             : void
    {
        $this->db->update(
            self::TABLE_MOUNT_INSTRUCTIONS,
            [
                'sorting' => ['int', $a_new_sorting_value],
            ],
            [
                'id' => ['int', $id],
            ]
        );
    }

References $id.

Field Documentation

TABLE_MOUNT_INSTRUCTIONS

const string ILIAS\WebDAV\Mount\RepositoryDB::TABLE_MOUNT_INSTRUCTIONS = 'webdav_instructions'

Definition at line 28 of file RepositoryDB.php.

---

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

• components/ILIAS/WebDAV/src/Mount/RepositoryDB.php