Method readData

lib/Datasource/LocalCsv.php:77–143

* Read the Data * @param $option * @return array available options of the data source * @throws NotFoundException * @throws \OCP\Files\NotPermittedException */

($option)

     * @throws \OCP\Files\NotPermittedException
     */
    public function readData($option): array
    {
        $error = 0;
        $file = $this->rootFolder->getUserFolder($option['user_id'])->get($option['link']);
        $cache = $this->getCacheMetadata($option, $file->getMTime());
        if ($cache['notModified'] === true) {
            return [
                'header' => [],
                'dimensions' => [],
                'data' => [],
                'error' => $error,
                'cache' => $cache,
            ];
        }

        $rows = str_getcsv($file->getContent(), "\n");

        // remove x number of rows from the beginning
        if (isset($option['offset']) and is_numeric($option['offset'])) {
            $rows = array_slice($rows, $option['offset']);
        }

        $selectedColumns = array();
        if (isset($option['columns']) && strlen($option['columns']) > 0) {
            $selectedColumns = str_getcsv($option['columns'], ',');
        }

        // get the delimiter by reading the first row
        $delimiter = $this->detectDelimiter($rows[0]);

        // the first row will define the column headers, even if it is not a real header
        // trim removes any leading or ending spaces
        $header = array_map('trim', str_getcsv($rows[0], $delimiter));

        // if the data has a real header, remove the first row
        if (!isset($option['hasHeader']) or $option['hasHeader'] !== 'false') {
            $rows = array_slice($rows, 1);
        }

        $data = array();
        if (count($selectedColumns) !== 0) {
            // if only a subset of columns or fixed column values are set, they are replaced here
            $header = $this->minimizeRow($selectedColumns, $header);
            foreach ($rows as $row) {
                $data[] = $this->minimizeRow($selectedColumns, array_map('trim', str_getcsv($row, $delimiter)));
            }
        } else {
            foreach ($rows as $row) {
                $columns = array_map('trim', str_getcsv($row, $delimiter));
                if (count($columns) === 1) {
                    $columns[2] = end($columns);
                    $columns[1] = null;
                    $columns[0] = null;
                }
                $data[] = $columns;
            }
        }
        unset($rows);