GNUnet  0.20.0
plugin_namecache_postgres.c File Reference

postgres-based namecache backend More...

Include dependency graph for plugin_namecache_postgres.c:

Go to the source code of this file.

Data Structures

struct  Plugin
 Handle for a plugin. More...
 

Macros

#define LOG(kind, ...)   GNUNET_log_from (kind, "namecache-postgres", __VA_ARGS__)
 

Functions

static enum GNUNET_GenericReturnValue database_setup (struct Plugin *plugin)
 Initialize the database connections and associated data structures (create tables and indices as needed as well). More...
 
static void namecache_postgres_expire_blocks (struct Plugin *plugin)
 Removes any expired block. More...
 
static void delete_old_block (struct Plugin *plugin, const struct GNUNET_HashCode *query, struct GNUNET_TIME_Absolute expiration_time)
 Delete older block in the datastore. More...
 
static enum GNUNET_GenericReturnValue namecache_postgres_cache_block (void *cls, const struct GNUNET_GNSRECORD_Block *block)
 Cache a block in the datastore. More...
 
static enum GNUNET_GenericReturnValue namecache_postgres_lookup_block (void *cls, const struct GNUNET_HashCode *query, GNUNET_NAMECACHE_BlockCallback iter, void *iter_cls)
 Get the block for a particular zone and label in the datastore. More...
 
static void database_shutdown (struct Plugin *plugin)
 Shutdown database connection and associate data structures. More...
 
void * libgnunet_plugin_namecache_postgres_init (void *cls)
 Entry point for the plugin. More...
 
void * libgnunet_plugin_namecache_postgres_done (void *cls)
 Exit point from the plugin. More...
 

Detailed Description

postgres-based namecache backend

Author
Christian Grothoff

Definition in file plugin_namecache_postgres.c.

Macro Definition Documentation

◆ LOG

#define LOG (   kind,
  ... 
)    GNUNET_log_from (kind, "namecache-postgres", __VA_ARGS__)

Definition at line 34 of file plugin_namecache_postgres.c.

Function Documentation

◆ database_setup()

static enum GNUNET_GenericReturnValue database_setup ( struct Plugin plugin)
static

Initialize the database connections and associated data structures (create tables and indices as needed as well).

Parameters
pluginthe plugin context (state for this module)
Returns
GNUNET_OK on success

Definition at line 1 of file plugin_namecache_postgres.c.

61 {
62  struct GNUNET_PQ_PreparedStatement ps[] = {
63  GNUNET_PQ_make_prepare ("cache_block",
64  "INSERT INTO namecache.ns096blocks"
65  " (query, block, expiration_time)"
66  " VALUES"
67  " ($1, $2, $3)"),
68  GNUNET_PQ_make_prepare ("expire_blocks",
69  "DELETE FROM namecache.ns096blocks"
70  " WHERE expiration_time<$1"),
71  GNUNET_PQ_make_prepare ("delete_block",
72  "DELETE FROM namecache.ns096blocks"
73  " WHERE query=$1 AND expiration_time<=$2"),
74  GNUNET_PQ_make_prepare ("lookup_block",
75  "SELECT block"
76  " FROM namecache.ns096blocks"
77  " WHERE query=$1"
78  " ORDER BY expiration_time DESC LIMIT 1"),
80  };
81 
83  "namecache-postgres",
84  "namecache-",
85  NULL,
86  ps);
87  if (NULL == plugin->dbh)
88  return GNUNET_SYSERR;
89  return GNUNET_OK;
90 }
struct TestcasePlugin * plugin
The process handle to the testbed service.
struct GNUNET_PQ_Context * GNUNET_PQ_connect_with_cfg(const struct GNUNET_CONFIGURATION_Handle *cfg, const char *section, const char *load_path_suffix, const struct GNUNET_PQ_ExecuteStatement *es, const struct GNUNET_PQ_PreparedStatement *ps)
Connect to a postgres database using the configuration option "CONFIG" in section.
Definition: pq_connect.c:619
struct GNUNET_PQ_PreparedStatement GNUNET_PQ_make_prepare(const char *name, const char *sql)
Create a struct GNUNET_PQ_PreparedStatement.
Definition: pq_prepare.c:30
#define GNUNET_PQ_PREPARED_STATEMENT_END
Terminator for prepared statement list.
@ GNUNET_OK
@ GNUNET_SYSERR
Information needed to prepare a list of SQL statements using GNUNET_PQ_prepare_statements().

Referenced by libgnunet_plugin_namecache_postgres_init().

Here is the caller graph for this function:

◆ namecache_postgres_expire_blocks()

static void namecache_postgres_expire_blocks ( struct Plugin plugin)
static

Removes any expired block.

Parameters
pluginthe plugin

Definition at line 99 of file plugin_namecache_postgres.c.

100 {
102  struct GNUNET_PQ_QueryParam params[] = {
105  };
107 
109  "expire_blocks",
110  params);
112 }
static int res
GNUNET_DB_QueryStatus
Status code returned from functions running database commands.
Definition: gnunet_db_lib.h:37
@ GNUNET_DB_STATUS_HARD_ERROR
A hard error occurred, retrying will not help.
Definition: gnunet_db_lib.h:41
struct GNUNET_PQ_QueryParam GNUNET_PQ_query_param_absolute_time(const struct GNUNET_TIME_Absolute *x)
Generate query parameter for an absolute time value.
#define GNUNET_PQ_query_param_end
End of query parameter specification.
enum GNUNET_DB_QueryStatus GNUNET_PQ_eval_prepared_non_select(struct GNUNET_PQ_Context *db, const char *statement_name, const struct GNUNET_PQ_QueryParam *params)
Execute a named prepared statement that is NOT a SELECT statement in connection using the given param...
Definition: pq_eval.c:135
#define GNUNET_break(cond)
Use this for internal assertion violations that are not fatal (can be handled) but should not occur.
struct GNUNET_TIME_Absolute GNUNET_TIME_absolute_get(void)
Get the current time.
Definition: time.c:111
Description of a DB query parameter.
Definition: gnunet_pq_lib.h:83
Time for absolute times used by GNUnet, in microseconds.

References GNUNET_break, GNUNET_DB_STATUS_HARD_ERROR, GNUNET_PQ_eval_prepared_non_select(), GNUNET_PQ_query_param_absolute_time(), GNUNET_PQ_query_param_end, GNUNET_TIME_absolute_get(), plugin, and res.

Here is the call graph for this function:

◆ delete_old_block()

static void delete_old_block ( struct Plugin plugin,
const struct GNUNET_HashCode query,
struct GNUNET_TIME_Absolute  expiration_time 
)
static

Delete older block in the datastore.

Parameters
pluginthe plugin
queryquery for the block
expiration_timehow old does the block have to be for deletion

Definition at line 123 of file plugin_namecache_postgres.c.

126 {
127  struct GNUNET_PQ_QueryParam params[] = {
129  GNUNET_PQ_query_param_absolute_time (&expiration_time),
131  };
133 
135  "delete_block",
136  params);
138 }
#define GNUNET_PQ_query_param_auto_from_type(x)
Generate fixed-size query parameter with size determined by variable type.

References GNUNET_break, GNUNET_DB_STATUS_HARD_ERROR, GNUNET_PQ_eval_prepared_non_select(), GNUNET_PQ_query_param_absolute_time(), GNUNET_PQ_query_param_auto_from_type, GNUNET_PQ_query_param_end, plugin, and res.

Here is the call graph for this function:

◆ namecache_postgres_cache_block()

static enum GNUNET_GenericReturnValue namecache_postgres_cache_block ( void *  cls,
const struct GNUNET_GNSRECORD_Block block 
)
static

Cache a block in the datastore.

Parameters
clsclosure (internal context for the plugin)
blockblock to cache
Returns
GNUNET_OK on success, else GNUNET_SYSERR

Definition at line 123 of file plugin_namecache_postgres.c.

151 {
152  struct Plugin *plugin = cls;
153  struct GNUNET_HashCode query;
154  size_t block_size = GNUNET_GNSRECORD_block_get_size (block);
155  struct GNUNET_TIME_Absolute exp;
157  struct GNUNET_PQ_QueryParam params[] = {
159  GNUNET_PQ_query_param_fixed_size (block, block_size),
162  };
164 
167  &query);
168  if (block_size > 64 * 65536)
169  {
170  GNUNET_break (0);
171  return GNUNET_SYSERR;
172  }
174  &query,
175  exp);
176 
178  "cache_block",
179  params);
180  if (0 > res)
181  return GNUNET_SYSERR;
182  return GNUNET_OK;
183 }
struct GNUNET_PQ_QueryParam GNUNET_PQ_query_param_fixed_size(const void *ptr, size_t ptr_size)
Generate query parameter for a buffer ptr of ptr_size bytes.
size_t GNUNET_GNSRECORD_block_get_size(const struct GNUNET_GNSRECORD_Block *block)
Returns the length of this block in bytes.
enum GNUNET_GenericReturnValue GNUNET_GNSRECORD_query_from_block(const struct GNUNET_GNSRECORD_Block *block, struct GNUNET_HashCode *query)
Builds the query hash from a block.
struct GNUNET_TIME_Absolute GNUNET_GNSRECORD_block_get_expiration(const struct GNUNET_GNSRECORD_Block *block)
Returns the expiration of a block.
static void delete_old_block(struct Plugin *plugin, const struct GNUNET_HashCode *query, struct GNUNET_TIME_Absolute expiration_time)
Delete older block in the datastore.
static void namecache_postgres_expire_blocks(struct Plugin *plugin)
Removes any expired block.
A 512-bit hashcode.
Handle for a plugin.
Definition: block.c:38

Referenced by libgnunet_plugin_namecache_postgres_init().

Here is the caller graph for this function:

◆ namecache_postgres_lookup_block()

static enum GNUNET_GenericReturnValue namecache_postgres_lookup_block ( void *  cls,
const struct GNUNET_HashCode query,
GNUNET_NAMECACHE_BlockCallback  iter,
void *  iter_cls 
)
static

Get the block for a particular zone and label in the datastore.

Will return at most one result to the iterator.

Parameters
clsclosure (internal context for the plugin)
queryhash of public key derived from the zone and the label
iterfunction to call with the result
iter_clsclosure for iter
Returns
GNUNET_OK on success, GNUNET_NO if there were no results, GNUNET_SYSERR on error

Definition at line 123 of file plugin_namecache_postgres.c.

201 {
202  struct Plugin *plugin = cls;
203  size_t bsize;
204  struct GNUNET_GNSRECORD_Block *block;
205  struct GNUNET_PQ_QueryParam params[] = {
208  };
209  struct GNUNET_PQ_ResultSpec rs[] = {
211  (void **) &block,
212  &bsize),
214  };
216 
218  "lookup_block",
219  params,
220  rs);
221  if (0 > res)
222  {
224  "Failing lookup block in namecache (postgres error)\n");
225  return GNUNET_SYSERR;
226  }
228  {
229  /* no result */
231  "Ending iteration (no more results)\n");
232  return GNUNET_NO;
233  }
234  if ((bsize < sizeof(*block)))
235  {
236  GNUNET_break (0);
238  "Failing lookup (corrupt block)\n");
240  return GNUNET_SYSERR;
241  }
242  iter (iter_cls,
243  block);
245  return GNUNET_OK;
246 }
static unsigned int bsize
@ GNUNET_DB_STATUS_SUCCESS_NO_RESULTS
The transaction succeeded, but yielded zero results.
Definition: gnunet_db_lib.h:55
enum GNUNET_DB_QueryStatus GNUNET_PQ_eval_prepared_singleton_select(struct GNUNET_PQ_Context *db, const char *statement_name, const struct GNUNET_PQ_QueryParam *params, struct GNUNET_PQ_ResultSpec *rs)
Execute a named prepared statement that is a SELECT statement which must return a single result in co...
Definition: pq_eval.c:199
struct GNUNET_PQ_ResultSpec GNUNET_PQ_result_spec_variable_size(const char *name, void **dst, size_t *sptr)
Variable-size result expected.
void GNUNET_PQ_cleanup_result(struct GNUNET_PQ_ResultSpec *rs)
Free all memory that was allocated in rs during GNUNET_PQ_extract_result().
Definition: pq.c:139
#define GNUNET_PQ_result_spec_end
End of result parameter specification.
@ GNUNET_NO
@ GNUNET_ERROR_TYPE_WARNING
@ GNUNET_ERROR_TYPE_DEBUG
#define LOG(kind,...)
Description of a DB result cell.

Referenced by libgnunet_plugin_namecache_postgres_init().

Here is the caller graph for this function:

◆ database_shutdown()

static void database_shutdown ( struct Plugin plugin)
static

Shutdown database connection and associate data structures.

Parameters
pluginthe plugin context (state for this module)

Definition at line 256 of file plugin_namecache_postgres.c.

257 {
259  plugin->dbh = NULL;
260 }
void GNUNET_PQ_disconnect(struct GNUNET_PQ_Context *db)
Disconnect from the database, destroying the prepared statements and releasing other associated resou...
Definition: pq_connect.c:684

References GNUNET_PQ_disconnect(), and plugin.

Referenced by libgnunet_plugin_namecache_postgres_done(), and libgnunet_plugin_namecache_postgres_init().

Here is the call graph for this function:
Here is the caller graph for this function:

◆ libgnunet_plugin_namecache_postgres_init()

void* libgnunet_plugin_namecache_postgres_init ( void *  cls)

Entry point for the plugin.

Parameters
clsthe struct GNUNET_NAMECACHE_PluginEnvironment *
Returns
NULL on error, otherwise the plugin context

Definition at line 270 of file plugin_namecache_postgres.c.

271 {
272  static struct Plugin plugin;
273  const struct GNUNET_CONFIGURATION_Handle *cfg = cls;
275 
276  if (NULL != plugin.cfg)
277  return NULL; /* can only initialize once! */
278  memset (&plugin, 0, sizeof(struct Plugin));
279  plugin.cfg = cfg;
280  if (GNUNET_OK != database_setup (&plugin))
281  {
283  return NULL;
284  }
286  api->cls = &plugin;
290  "Postgres namecache plugin running\n");
291  return api;
292 }
static const struct GNUNET_CONFIGURATION_Handle * cfg
Configuration we are using.
Definition: gnunet-abd.c:36
@ GNUNET_ERROR_TYPE_INFO
#define GNUNET_new(type)
Allocate a struct or union of the given type.
static enum GNUNET_GenericReturnValue database_setup(struct Plugin *plugin)
Initialize the database connections and associated data structures (create tables and indices as need...
static enum GNUNET_GenericReturnValue namecache_postgres_cache_block(void *cls, const struct GNUNET_GNSRECORD_Block *block)
Cache a block in the datastore.
static void database_shutdown(struct Plugin *plugin)
Shutdown database connection and associate data structures.
static enum GNUNET_GenericReturnValue namecache_postgres_lookup_block(void *cls, const struct GNUNET_HashCode *query, GNUNET_NAMECACHE_BlockCallback iter, void *iter_cls)
Get the block for a particular zone and label in the datastore.
struct returned by the initialization function of the plugin
int(* lookup_block)(void *cls, const struct GNUNET_HashCode *query, GNUNET_NAMECACHE_BlockCallback iter, void *iter_cls)
Get the block for a particular zone and label in the datastore.
int(* cache_block)(void *cls, const struct GNUNET_GNSRECORD_Block *block)
Cache a block in the datastore.
void * cls
Closure to pass to all plugin functions.

References GNUNET_NAMECACHE_PluginFunctions::cache_block, cfg, GNUNET_NAMECACHE_PluginFunctions::cls, database_setup(), database_shutdown(), GNUNET_ERROR_TYPE_INFO, GNUNET_new, GNUNET_OK, LOG, GNUNET_NAMECACHE_PluginFunctions::lookup_block, namecache_postgres_cache_block(), namecache_postgres_lookup_block(), and plugin.

Here is the call graph for this function:

◆ libgnunet_plugin_namecache_postgres_done()

void* libgnunet_plugin_namecache_postgres_done ( void *  cls)

Exit point from the plugin.

Parameters
clsthe plugin context (as returned by "init")
Returns
always NULL

Definition at line 302 of file plugin_namecache_postgres.c.

303 {
305  struct Plugin *plugin = api->cls;
306 
308  plugin->cfg = NULL;
309  GNUNET_free (api);
311  "Postgres namecache plugin is finished\n");
312  return NULL;
313 }
#define GNUNET_free(ptr)
Wrapper around free.
void * cls
Closure for all of the callbacks.
struct GNUNET_BLOCK_PluginFunctions * api
Plugin API.
Definition: block.c:47

References Plugin::api, GNUNET_BLOCK_PluginFunctions::cls, GNUNET_NAMECACHE_PluginFunctions::cls, database_shutdown(), GNUNET_ERROR_TYPE_DEBUG, GNUNET_free, LOG, and plugin.

Here is the call graph for this function: