1/* 2** Zabbix 3** Copyright (C) 2001-2021 Zabbix SIA 4** 5** This program is free software; you can redistribute it and/or modify 6** it under the terms of the GNU General Public License as published by 7** the Free Software Foundation; either version 2 of the License, or 8** (at your option) any later version. 9** 10** This program is distributed in the hope that it will be useful, 11** but WITHOUT ANY WARRANTY; without even the implied warranty of 12** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13** GNU General Public License for more details. 14** 15** You should have received a copy of the GNU General Public License 16** along with this program; if not, write to the Free Software 17** Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. 18**/ 19 20package oracle 21 22import ( 23 "context" 24 25 "zabbix.com/pkg/zbxerr" 26) 27 28func databasesDiscoveryHandler(ctx context.Context, conn OraClient, params map[string]string, 29 _ ...string) (interface{}, error) { 30 var lld string 31 32 row, err := conn.QueryRow(ctx, ` 33 SELECT 34 JSON_ARRAYAGG( 35 JSON_OBJECT( 36 '{#DBNAME}' VALUE NAME, 37 '{#TYPE}' VALUE DECODE(CDB, 'YES', 'CDB', 'No-CDB') 38 ) 39 ) LLD 40 FROM 41 V$DATABASE 42 `) 43 if err != nil { 44 return nil, zbxerr.ErrorCannotFetchData.Wrap(err) 45 } 46 47 err = row.Scan(&lld) 48 if err != nil { 49 return nil, zbxerr.ErrorCannotFetchData.Wrap(err) 50 } 51 52 if lld == "" { 53 lld = "[]" 54 } 55 56 return lld, nil 57} 58