/**
* {@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)]);
}