diff options
author | Joseph <Joseph.xu@efrei.net> | 2022-11-10 10:37:28 -0500 |
---|---|---|
committer | Joseph <Joseph.xu@efrei.net> | 2022-11-10 10:37:28 -0500 |
commit | 945821cbc842644f9d10de4ef36e8ef03d2d2253 (patch) | |
tree | 8872a2aa7df2fe992f00c32961179c2e1b4f0580 /src/exchangedb/pg_setup_partitions.c | |
parent | bd0e2aac92686fb256cc5ae2325eb64f4e571fde (diff) |
move few more functions
Diffstat (limited to 'src/exchangedb/pg_setup_partitions.c')
-rw-r--r-- | src/exchangedb/pg_setup_partitions.c | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/src/exchangedb/pg_setup_partitions.c b/src/exchangedb/pg_setup_partitions.c index 7a472ed1..6785931a 100644 --- a/src/exchangedb/pg_setup_partitions.c +++ b/src/exchangedb/pg_setup_partitions.c @@ -24,3 +24,50 @@ #include "taler_pq_lib.h" #include "pg_setup_partitions.h" #include "pg_helper.h" + +/** + * Setup partitions of already existing tables + * + * @param cls the `struct PostgresClosure` with the plugin-specific state + * @param num the number of partitions to create for each partitioned table + * @return #GNUNET_OK upon success; #GNUNET_SYSERR upon failure + */ +enum GNUNET_GenericReturnValue +TEH_PG_setup_partitions (void *cls, + uint32_t num) +{ + 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 (&num), + GNUNET_PQ_query_param_end + }; + struct GNUNET_PQ_PreparedStatement ps[] = { + GNUNET_PQ_make_prepare ("setup_partitions", + "SELECT" + " create_partitions" + " ($1);"), + GNUNET_PQ_PREPARED_STATEMENT_END + }; + struct GNUNET_PQ_ExecuteStatement es[] = { + GNUNET_PQ_make_try_execute ("SET search_path TO exchange;"), + GNUNET_PQ_EXECUTE_STATEMENT_END + }; + + conn = GNUNET_PQ_connect_with_cfg (pg->cfg, + "exchangedb-postgres", + NULL, + es, + ps); + if (NULL == conn) + return GNUNET_SYSERR; + ret = GNUNET_OK; + if (0 > GNUNET_PQ_eval_prepared_non_select (conn, + "setup_partitions", + params)) + ret = GNUNET_SYSERR; + GNUNET_PQ_disconnect (conn); + return ret; +} + |