pq_exec.c File Reference

functions to execute plain SQL statements (PostGres) More...

#include "platform.h"
#include "pq.h"

Include dependency graph for pq_exec.c:

Go to the source code of this file.

Functions
struct GNUNET_PQ_ExecuteStatement	GNUNET_PQ_make_execute (const char *sql)
	Create a struct GNUNET_PQ_ExecuteStatement where errors are fatal. More...
struct GNUNET_PQ_ExecuteStatement	GNUNET_PQ_make_try_execute (const char *sql)
	Create a struct GNUNET_PQ_ExecuteStatement where errors should be tolerated. More...
enum GNUNET_GenericReturnValue	GNUNET_PQ_exec_statements (struct GNUNET_PQ_Context *db, const struct GNUNET_PQ_ExecuteStatement *es)
	Request execution of an array of statements es from Postgres. More...

Detailed Description

functions to execute plain SQL statements (PostGres)

Author

Christian Grothoff

Definition in file pq_exec.c.

Function Documentation

GNUNET_PQ_make_execute()

struct GNUNET_PQ_ExecuteStatement GNUNET_PQ_make_execute

(

const char *

sql

)

Create a struct GNUNET_PQ_ExecuteStatement where errors are fatal.

Parameters

sql	actual SQL statement

Returns

initialized struct

Definition at line 30 of file pq_exec.c.

{
  struct GNUNET_PQ_ExecuteStatement es = {
    .sql = sql,
    .ignore_errors = GNUNET_NO
  };
 
  return es;
}

References GNUNET_NO, and GNUNET_PQ_ExecuteStatement::sql.

Referenced by postgres_plugin_drop().

Here is the caller graph for this function:

GNUNET_PQ_make_try_execute()

struct GNUNET_PQ_ExecuteStatement GNUNET_PQ_make_try_execute

(

const char *

sql

)

Create a struct GNUNET_PQ_ExecuteStatement where errors should be tolerated.

Parameters

sql	actual SQL statement

Returns

initialized struct

Definition at line 42 of file pq_exec.c.

{
  struct GNUNET_PQ_ExecuteStatement es = {
    .sql = sql,
    .ignore_errors = GNUNET_YES
  };
 
  return es;
}

References GNUNET_YES, and GNUNET_PQ_ExecuteStatement::sql.

Referenced by database_connect(), namestore_postgres_begin_tx(), namestore_postgres_commit_tx(), and namestore_postgres_rollback_tx().

Here is the caller graph for this function:

GNUNET_PQ_exec_statements()

enum GNUNET_GenericReturnValue GNUNET_PQ_exec_statements	(	struct GNUNET_PQ_Context *	db,
		const struct GNUNET_PQ_ExecuteStatement *	es
	)

Request execution of an array of statements es from Postgres.

Parameters

db	database to execute the statements in
es	GNUNET_PQ_PREPARED_STATEMENT_END-terminated array of prepared statements.

Returns

GNUNET_OK on success (modulo statements where errors can be ignored) GNUNET_SYSERR on error

Definition at line 54 of file pq_exec.c.

{
  for (unsigned int i = 0; NULL != es[i].sql; i++)
  {
    PGresult *result;
 
    GNUNET_log (GNUNET_ERROR_TYPE_DEBUG,
                "Running statement `%s' on %p\n",
                es[i].sql,
                db);
    result = PQexec (db->conn,
                     es[i].sql);
    GNUNET_log (GNUNET_ERROR_TYPE_DEBUG,
                "Running statement `%s' on %p finished (%s)\n",
                es[i].sql,
                db,
                PQresStatus (PQresultStatus (result)));
    if ((GNUNET_NO == es[i].ignore_errors) &&
        (PGRES_COMMAND_OK != PQresultStatus (result)))
    {
      GNUNET_log_from (GNUNET_ERROR_TYPE_ERROR,
                       "pq",
                       "Failed to execute `%s': %s/%s/%s/%s/%s",
                       es[i].sql,
                       PQresultErrorField (result,
                                           PG_DIAG_MESSAGE_PRIMARY),
                       PQresultErrorField (result,
                                           PG_DIAG_MESSAGE_DETAIL),
                       PQresultErrorMessage (result),
                       PQresStatus (PQresultStatus (result)),
                       PQerrorMessage (db->conn));
      PQclear (result);
      return GNUNET_SYSERR;
    }
    PQclear (result);
  }
  return GNUNET_OK;
}

References db, GNUNET_ERROR_TYPE_DEBUG, GNUNET_ERROR_TYPE_ERROR, GNUNET_log, GNUNET_log_from, GNUNET_NO, GNUNET_OK, GNUNET_SYSERR, GNUNET_PQ_ExecuteStatement::ignore_errors, result, and GNUNET_PQ_ExecuteStatement::sql.

Referenced by GNUNET_PQ_reconnect(), namestore_postgres_begin_tx(), namestore_postgres_commit_tx(), namestore_postgres_rollback_tx(), and postgres_plugin_drop().

Here is the caller graph for this function: