asseco-voice / laravel-json-query-builder Goto Github PK

   public function getModelColumns(): array
    {
        $table = $this->model->getTable();
        $connection = $this->model->getConnection();

        if (Cache::has(self::CACHE_PREFIX . $table)) {
            return Cache::get(self::CACHE_PREFIX . $table);
        }

        $columns = $connection->getSchemaBuilder()->getColumnListing($table);
        $modelColumns = [];

        $this->registerEnumTypeForDoctrine($connection);

        try {
            foreach ($columns as $column) {
                $modelColumns[$column] = $connection->getSchemaBuilder()->getColumnType($table, $column);
            }
        } catch (Exception $e) {
            // leave model columns as an empty array and cache it.
        }

        Cache::put(self::CACHE_PREFIX . $table, $modelColumns, self::CACHE_TTL);

        return $modelColumns;
    }

    /**
     * Having 'enum' in table definition will throw Doctrine error because it is not defined in their types.
     * Registering it manually.
     */
    protected function registerEnumTypeForDoctrine($connection): void
    {

        if (!class_exists('Doctrine\DBAL\Driver\AbstractSQLiteDriver')) {
            return;
        }

        $connection
            ->getDoctrineSchemaManager()
            ->getDatabasePlatform()
            ->registerDoctrineTypeMapping('enum', 'string');
    }