exchange

Base system with REST service to issue digital coins, run by the payment service provider
Log | Files | Refs | Submodules | README | LICENSE

create_tables.c (2562B)

      1 /*
      2    This file is part of TALER
      3    Copyright (C) 2022 Taler Systems SA
      4 
      5    TALER 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    TALER 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    TALER; see the file COPYING.  If not, see <http://www.gnu.org/licenses/>
     15  */
     16 /**
     17  * @file exchangedb/create_tables.c
     18  * @brief Implementation of the create_tables function for Postgres
     19  * @author Christian Grothoff
     20  */
     21 #include "taler/taler_pq_lib.h"
     22 #include "exchange-database/create_tables.h"
     23 #include "helper.h"
     24 
     25 
     26 enum GNUNET_GenericReturnValue
     27 TALER_EXCHANGEDB_create_tables (struct TALER_EXCHANGEDB_PostgresContext *pg,
     28                                 bool support_partitions,
     29                                 uint32_t num_partitions)
     30 {
     31   struct GNUNET_PQ_Context *conn;
     32   enum GNUNET_GenericReturnValue ret;
     33   struct GNUNET_PQ_QueryParam params[] = {
     34     support_partitions
     35     ? GNUNET_PQ_query_param_uint32 (&num_partitions)
     36     : GNUNET_PQ_query_param_null (),
     37     GNUNET_PQ_query_param_end
     38   };
     39   struct GNUNET_PQ_ExecuteStatement es[] = {
     40     GNUNET_PQ_make_try_execute ("SET search_path TO exchange;"),
     41     GNUNET_PQ_EXECUTE_STATEMENT_END
     42   };
     43 
     44   conn = GNUNET_PQ_connect_with_cfg (pg->cfg,
     45                                      "exchangedb-postgres",
     46                                      "exchange-",
     47                                      es,
     48                                      NULL);
     49   if (NULL == conn)
     50     return GNUNET_SYSERR;
     51   ret = GNUNET_PQ_exec_sql (conn,
     52                             "procedures");
     53   GNUNET_break (GNUNET_OK == ret);
     54   if (GNUNET_OK == ret)
     55   {
     56     struct GNUNET_PQ_Context *tconn;
     57 
     58     tconn = pg->conn;
     59     pg->prep_gen++;
     60     pg->conn = conn;
     61     PREPARE (pg,
     62              "create_tables",
     63              "SELECT"
     64              " exchange_do_create_tables"
     65              " ($1::INTEGER);");
     66     pg->conn = tconn;
     67     if (0 >
     68         GNUNET_PQ_eval_prepared_non_select (conn,
     69                                             "create_tables",
     70                                             params))
     71     {
     72       GNUNET_break (0);
     73       ret = GNUNET_SYSERR;
     74     }
     75   }
     76   GNUNET_PQ_disconnect (conn);
     77   return ret;
     78 }