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 "fmt" 25) 26 27const ( 28 pingFailed = 0 29 pingOk = 1 30) 31 32// pingHandler queries 'SELECT 1 FROM DUAL' and returns pingOk if a connection is alive or pingFailed otherwise. 33func pingHandler(ctx context.Context, conn OraClient, params map[string]string, _ ...string) (interface{}, error) { 34 var res int 35 36 row, err := conn.QueryRow(ctx, fmt.Sprintf("SELECT %d FROM DUAL", pingOk)) 37 if err != nil { 38 return pingFailed, nil 39 } 40 41 err = row.Scan(&res) 42 43 if err != nil || res != pingOk { 44 return pingFailed, nil 45 } 46 47 return pingOk, nil 48} 49