public function getDirectoryId(array $parts, string $cabin) : int
{
$part = \array_shift($parts);
$parent = $this->db->cell('SELECT
directoryid
FROM
airship_dirs
WHERE
parent IS NULL
AND name = ?
AND cabin = ?', $part, $cabin);
if (empty($parent)) {
throw new FileNotFound();
}
foreach ($parts as $part) {
$parent = $this->db->cell('SELECT
*
FROM
airship_dirs
WHERE
name = ?
AND parent = ?
AND cabin = ?', $part, $parent, $cabin);
if (empty($parent)) {
throw new FileNotFound();
}
}
return $parent;
}