aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/pg_insert_kyc_attributes.c
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2022-12-30 14:41:16 +0100
committerChristian Grothoff <christian@grothoff.org>2022-12-30 14:41:16 +0100
commit94fbb1c211a8c3d8d43c76d91f369de1c0a4615f (patch)
tree7af8c5404ad9df8c112c53b5bc46b6c45d0c34d2 /src/exchangedb/pg_insert_kyc_attributes.c
parentc002f458ce3d532b633d345427e713a81239e108 (diff)
downloadexchange-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.c32
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);
}