#include <string.h>
#include <unistd.h>
+#include "build-config.h"
#include "hash.h"
#include "keydb.h"
#include "keyid.h"
PQclear(result);
snprintf(statement, 1023,
- "DELETE FROM onak_keys WHERE keyid = '%" PRIX64 "'",
+ "DELETE FROM onak_sigs WHERE signee = '%" PRIX64 "'",
keyid);
result = PQexec(dbconn, statement);
PQclear(result);
snprintf(statement, 1023,
- "DELETE FROM onak_sigs WHERE signee = '%" PRIX64 "'",
+ "DELETE FROM onak_uids WHERE keyid = '%" PRIX64 "'",
keyid);
result = PQexec(dbconn, statement);
PQclear(result);
snprintf(statement, 1023,
- "DELETE FROM onak_uids WHERE keyid = '%" PRIX64 "'",
+ "DELETE FROM onak_keys WHERE keyid = '%" PRIX64 "'",
keyid);
result = PQexec(dbconn, statement);
} else if (PQresultStatus(result) != PGRES_TUPLES_OK) {
* Include the basic keydb routines.
*/
#define NEED_UPDATEKEYS 1
+#define NEED_GET 1
#define NEED_GET_FP 1
#include "keydb.c"
* this file are called in order to allow the DB to be initialized ready
* for access.
*/
-struct onak_dbctx *keydb_pg_init(struct onak_db_config *dbcfg, bool readonly)
+struct onak_dbctx *keydb_pg_init(struct onak_db_config *dbcfg,
+ __unused bool readonly)
{
struct onak_dbctx *dbctx;
PGconn *dbconn;
dbctx->cleanupdb = pg_cleanupdb;
dbctx->starttrans = pg_starttrans;
dbctx->endtrans = pg_endtrans;
- dbctx->fetch_key_id = pg_fetch_key_id;
+ dbctx->fetch_key = generic_fetch_key;
dbctx->fetch_key_fp = generic_fetch_key_fp;
+ dbctx->fetch_key_id = pg_fetch_key_id;
dbctx->fetch_key_text = pg_fetch_key_text;
dbctx->store_key = pg_store_key;
dbctx->update_keys = generic_update_keys;