Zabbix

/*

** Zabbix

** Copyright (C) 2001-2025 Zabbix SIA

**

** This program is free software; you can redistribute it and/or modify

** it under the terms of the GNU General Public License as published by

** the Free Software Foundation; either version 2 of the License, or

** (at your option) any later version.

**

** This program is distributed in the hope that it will be useful,

** but WITHOUT ANY WARRANTY; without even the implied warranty of

** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

** GNU General Public License for more details.

**

** You should have received a copy of the GNU General Public License

** along with this program; if not, write to the Free Software

** Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

**/

​

package oracle

​

import (

    "context"

    "strings"

​

    "golang.zabbix.com/sdk/errs"

    "golang.zabbix.com/sdk/zbxerr"

)

​

const (

    temp          = "TEMPORARY"

    perm          = "PERMANENT"

    undo          = "UNDO"

    defaultPERMTS = "USERS"

    defaultTEMPTS = "TEMP"

)

​

func tablespacesHandler(ctx context.Context, conn OraClient, params map[string]string,

    _ ...string) (interface{}, error) {

    var tablespaces string

​

    query, args, err := getTablespacesQuery(params)

    if err != nil {

        return nil, errs.Wrap(err, "failed to retrieve tablespace query")

    }

​

    row, err := conn.QueryRow(ctx, query, args...)

    if err != nil {

        return nil, errs.WrapConst(err, zbxerr.ErrorCannotFetchData)

    }

​

    err = row.Scan(&tablespaces)

    if err != nil {

        return nil, errs.WrapConst(err, zbxerr.ErrorCannotFetchData)

    }

​

    // Add leading zeros for floats: ".03" -> "0.03".

    // Oracle JSON functions are not RFC 4627 compliant.

    // There should be a better way to do that, but I haven't come up with it ¯\_(ツ)_/¯

    tablespaces = strings.ReplaceAll(tablespaces, "\":.", "\":0.")

​

    return tablespaces, nil

}

​

func getTablespacesQuery(params map[string]string) (string, []any, error) {

    ts := params["Tablespace"]

    t := params["Type"]

​

    if ts == "" && t == "" {

        return getFullQuery(), nil, nil

    }

​

    var err error

    ts, t, err = prepValues(ts, t)

    if err != nil {

        return "", nil, errs.WrapConst(err, zbxerr.ErrorInvalidParams)

    }

​

    switch t {

    case perm, undo:

        return getPermQueryPart(), []any{ts}, nil

    case temp:

        return getTempQueryPart(), []any{ts}, nil

    default:

        return "", nil, errs.Wrapf(zbxerr.ErrorInvalidParams, "incorrect table-space type %s", t)

    }

}

​

func prepValues(ts, t string) (outTableSpace string, outType string, err error) {

    if ts != "" && t != "" {

        return ts, t, nil