diff options
Diffstat (limited to 'src/exchangedb')
| -rw-r--r-- | src/exchangedb/pg_iterate_kyc_reference.c | 11 | ||||
| -rw-r--r-- | src/exchangedb/pg_select_kyc_attributes.c | 16 |
2 files changed, 15 insertions, 12 deletions
diff --git a/src/exchangedb/pg_iterate_kyc_reference.c b/src/exchangedb/pg_iterate_kyc_reference.c index ee67eb13c..686dbc5ed 100644 --- a/src/exchangedb/pg_iterate_kyc_reference.c +++ b/src/exchangedb/pg_iterate_kyc_reference.c @@ -121,9 +121,10 @@ TEH_PG_iterate_kyc_reference ( ",provider_legitimization_id" " FROM legitimization_processes" " WHERE h_payto=$1;"); - return GNUNET_PQ_eval_prepared_multi_select (pg->conn, - "iterate_kyc_reference", - params, - &iterate_kyc_reference_cb, - &ic); + return GNUNET_PQ_eval_prepared_multi_select ( + pg->conn, + "iterate_kyc_reference", + params, + &iterate_kyc_reference_cb, + &ic); } diff --git a/src/exchangedb/pg_select_kyc_attributes.c b/src/exchangedb/pg_select_kyc_attributes.c index 99ac43b3e..5a5e99a35 100644 --- a/src/exchangedb/pg_select_kyc_attributes.c +++ b/src/exchangedb/pg_select_kyc_attributes.c @@ -81,7 +81,7 @@ get_attributes_cb (void *cls, void *enc_attributes; char *provider; struct GNUNET_PQ_ResultSpec rs[] = { - GNUNET_PQ_result_spec_string ("provider", + GNUNET_PQ_result_spec_string ("provider_name", &provider), GNUNET_PQ_result_spec_timestamp ("collection_time", &collection_time), @@ -138,12 +138,14 @@ TEH_PG_select_kyc_attributes ( PREPARE (pg, "select_kyc_attributes", "SELECT " - " provider" - ",collection_time" - ",expiration_time" - ",encrypted_attributes" - " FROM kyc_attributes" - " WHERE h_payto=$1"); + " lp.provider_name" + ",ka.collection_time" + ",ka.expiration_time" + ",ka.encrypted_attributes" + " FROM kyc_attributes ka" + " JOIN legitimization_processes lp" + " USING (legitimization_process_serial_id)" + " WHERE ka.h_payto=$1"); qs = GNUNET_PQ_eval_prepared_multi_select ( pg->conn, "select_kyc_attributes", |