eZ\Publish\Core\FieldType\User\UserStorage\Gateway\LegacyStorage::fetchUserSettings PHP Method

fetchUserSettings() protected method

Naturally this would be a RIGHT OUTER JOIN, but this is not supported by ezcDatabase nor by databases like SQLite
protected fetchUserSettings ( mixed $userId ) : array
$userId mixed
return array
    protected function fetchUserSettings($userId)
    {
        $query = $this->dbHandler->createSelectQuery();
        $query->select($this->dbHandler->quoteColumn('is_enabled', 'ezuser_setting'), $this->dbHandler->quoteColumn('max_login', 'ezuser_setting'))->from($this->dbHandler->quoteTable('ezuser_setting'))->where($query->expr->eq($this->dbHandler->quoteColumn('user_id', 'ezuser_setting'), $query->bindValue($userId)));
        $stmt = $query->prepare();
        $stmt->execute();
        $rows = $stmt->fetchAll(\PDO::FETCH_ASSOC);
        return isset($rows[0]) ? $this->convertColumnsToProperties($rows[0]) : array();
    }