diff options
author | Christian Grothoff <christian@grothoff.org> | 2022-12-30 14:41:16 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2022-12-30 14:41:16 +0100 |
commit | 94fbb1c211a8c3d8d43c76d91f369de1c0a4615f (patch) | |
tree | 7af8c5404ad9df8c112c53b5bc46b6c45d0c34d2 /src/exchangedb/pg_insert_kyc_attributes.c | |
parent | c002f458ce3d532b633d345427e713a81239e108 (diff) | |
download | exchange-94fbb1c211a8c3d8d43c76d91f369de1c0a4615f.tar.xz |
-basic insert logic of new DB API
Diffstat (limited to 'src/exchangedb/pg_insert_kyc_attributes.c')
-rw-r--r-- | src/exchangedb/pg_insert_kyc_attributes.c | 32 |
1 files changed, 30 insertions, 2 deletions
diff --git a/src/exchangedb/pg_insert_kyc_attributes.c b/src/exchangedb/pg_insert_kyc_attributes.c index 5714e2aa7..fd90950fd 100644 --- a/src/exchangedb/pg_insert_kyc_attributes.c +++ b/src/exchangedb/pg_insert_kyc_attributes.c @@ -38,6 +38,34 @@ TEH_PG_insert_kyc_attributes ( size_t enc_attributes_size, const void *enc_attributes) { - GNUNET_break (0); // FIXME: not implemeted! - return GNUNET_DB_STATUS_HARD_ERROR; + struct PostgresClosure *pg = cls; + struct GNUNET_PQ_QueryParam params[] = { + GNUNET_PQ_query_param_auto_from_type (h_payto), + GNUNET_PQ_query_param_auto_from_type (kyc_prox), + GNUNET_PQ_query_param_string (provider_section), + (NULL == birthdate) + ? GNUNET_PQ_query_param_null () + : GNUNET_PQ_query_param_string (birthdate), + GNUNET_PQ_query_param_timestamp (&collection_time), + GNUNET_PQ_query_param_timestamp (&expiration_time), + GNUNET_PQ_query_param_fixed_size (enc_attributes, + enc_attributes_size), + GNUNET_PQ_query_param_end + }; + + PREPARE (pg, + "insert_kyc_attributes", + "INSERT INTO kyc_attributes " + "(h_payto" + ",kyc_prox" + ",provider" + ",birthdate" + ",collection_time" + ",expiration_time" + ",encrypted_attributes" + ") VALUES " + "($1, $2, $3, $4, $5, $6, $7);"); + return GNUNET_PQ_eval_prepared_non_select (pg->conn, + "insert_kyc_attributes", + params); } |