diff options
author | Joseph <Joseph.xu@efrei.net> | 2022-11-08 11:40:47 -0500 |
---|---|---|
committer | Joseph <Joseph.xu@efrei.net> | 2022-11-08 11:40:47 -0500 |
commit | bd0e2aac92686fb256cc5ae2325eb64f4e571fde (patch) | |
tree | af2428f08846e1a6bc2ceb23aebdc337f358fdc3 /src/exchangedb/pg_create_shard_tables.c | |
parent | f51e8a7150bee920f1bd3649c053b341419795c1 (diff) | |
download | exchange-bd0e2aac92686fb256cc5ae2325eb64f4e571fde.tar.xz |
move functions need to recheck insert_aggregation_tracking
Diffstat (limited to 'src/exchangedb/pg_create_shard_tables.c')
-rw-r--r-- | src/exchangedb/pg_create_shard_tables.c | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/src/exchangedb/pg_create_shard_tables.c b/src/exchangedb/pg_create_shard_tables.c new file mode 100644 index 000000000..4fb6940f9 --- /dev/null +++ b/src/exchangedb/pg_create_shard_tables.c @@ -0,0 +1,66 @@ +/* + This file is part of TALER + Copyright (C) 2022 Taler Systems SA + + TALER 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 3, or (at your option) any later version. + + TALER 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 + TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> + */ +/** + * @file exchangedb/pg_create_shard_tables.c + * @brief Implementation of the create_shard_tables function for Postgres + * @author Christian Grothoff + */ +#include "platform.h" +#include "taler_error_codes.h" +#include "taler_dbevents.h" +#include "taler_pq_lib.h" +#include "pg_create_shard_tables.h" +#include "pg_helper.h" + + +enum GNUNET_GenericReturnValue +TEH_PG_create_shard_tables (void *cls, + uint32_t idx) +{ + struct PostgresClosure *pg = cls; + struct GNUNET_PQ_Context *conn; + enum GNUNET_GenericReturnValue ret = GNUNET_OK; + struct GNUNET_PQ_QueryParam params[] = { + GNUNET_PQ_query_param_uint32 (&idx), + GNUNET_PQ_query_param_end + }; + struct GNUNET_PQ_ExecuteStatement es[] = { + GNUNET_PQ_make_try_execute ("SET search_path TO exchange;"), + GNUNET_PQ_EXECUTE_STATEMENT_END + }; + + struct GNUNET_PQ_PreparedStatement ps[] = { + GNUNET_PQ_make_prepare ("create_shard_tables", + "SELECT" + " setup_shard" + " ($1);"), + GNUNET_PQ_PREPARED_STATEMENT_END + }; + + conn = GNUNET_PQ_connect_with_cfg (pg->cfg, + "exchangedb-postgres", + "shard-", + es, + ps); + if (NULL == conn) + return GNUNET_SYSERR; + if (0 > GNUNET_PQ_eval_prepared_non_select (conn, + "create_shard_tables", + params)) + ret = GNUNET_SYSERR; + GNUNET_PQ_disconnect (conn); + return ret; +} |