/** * {@inheritdoc} */ public function read() { if (null === $this->file) { return []; } return ['id' => $this->file->id()->id(), 'created_on' => $this->file->createdOn(), 'mime_type' => $this->file->mimeType()->mimeType(), 'file_name' => $this->file->name()->filename(), 'updated_on' => $this->file->updatedOn()]; }
/** * Prepares the insert SQL with the file given. * * @param File $aFile The file */ private function insert(File $aFile) { $sql = 'INSERT INTO file (id, name, extension, mime_type, created_on, updated_on) VALUES (:id, :name, :extension, :mimeType, :createdOn, :updatedOn)'; $this->execute($sql, ['id' => $aFile->id()->id(), 'name' => $aFile->name()->name(), 'extension' => $aFile->name()->extension(), 'mimeType' => $aFile->mimeType(), 'createdOn' => $aFile->createdOn()->format(self::DATE_FORMAT), 'updatedOn' => $aFile->updatedOn()->format(self::DATE_FORMAT)]); }