drop_tables.c (1722B)
1 /* 2 This file is part of Challenger 3 Copyright (C) 2023 Taler Systems SA 4 5 Challenger is free software; you can redistribute it and/or modify it under the 6 terms of the GNU General Public License as published by the Free Software 7 Foundation; either version 3, or (at your option) any later version. 8 9 Challenger is distributed in the hope that it will be useful, but WITHOUT ANY 10 WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR 11 A PARTICULAR PURPOSE. See the GNU General Public License for more details. 12 13 You should have received a copy of the GNU General Public License along with 14 Challenger; see the file COPYING. If not, see <http://www.gnu.org/licenses/> 15 */ 16 /** 17 * @file src/challengerdb/drop_tables.c 18 * @brief Implementation of the drop_tables function for Postgres 19 * @author Christian Grothoff 20 */ 21 #include "platform.h" 22 #include <taler/taler_error_codes.h> 23 #include <taler/taler_dbevents.h> 24 #include <taler/taler_pq_lib.h> 25 #include "challenger-database/drop_tables.h" 26 #include "pg_helper.h" 27 28 29 enum GNUNET_GenericReturnValue 30 CHALLENGERDB_drop_tables (struct CHALLENGERDB_PostgresContext *pg) 31 { 32 struct GNUNET_PQ_Context *conn; 33 enum GNUNET_GenericReturnValue ret; 34 35 if (NULL != pg->conn) 36 { 37 GNUNET_PQ_disconnect (pg->conn); 38 pg->conn = NULL; 39 } 40 conn = GNUNET_PQ_connect_with_cfg (pg->cfg, 41 "challengerdb-postgres", 42 NULL, 43 NULL, 44 NULL); 45 if (NULL == conn) 46 return GNUNET_SYSERR; 47 ret = GNUNET_PQ_exec_sql (conn, 48 "drop"); 49 GNUNET_PQ_disconnect (conn); 50 return ret; 51 }