*
* Copyright 2000 by PostgreSQL Global Development Group
*
- * $Header: /cvsroot/pgsql/src/bin/psql/common.c,v 1.47 2002/10/15 02:24:16 tgl Exp $
+ * $Header: /cvsroot/pgsql/src/bin/psql/common.c,v 1.64 2003/06/12 08:15:28 momjian Exp $
*/
#include "postgres_fe.h"
-
#include "common.h"
#include <errno.h>
#include "print.h"
#include "mainloop.h"
+
+/* Workarounds for Windows */
+/* Probably to be moved up the source tree in the future, perhaps to be replaced by
+ * more specific checks like configure-style HAVE_GETTIMEOFDAY macros.
+ */
+#ifndef WIN32
+
+typedef struct timeval TimevalStruct;
+#define GETTIMEOFDAY(T) gettimeofday(T, NULL)
+#define DIFF_MSEC(T, U) ((((T)->tv_sec - (U)->tv_sec) * 1000000.0 + (T)->tv_usec - (U)->tv_usec) / 1000.0)
+
+#else
+
+typedef struct _timeb TimevalStruct;
+#define GETTIMEOFDAY(T) _ftime(T)
+#define DIFF_MSEC(T, U) ((((T)->time - (U)->time) * 1000.0 + (T)->millitm - (U)->millitm))
+
+#endif
+
extern bool prompt_state;
/*
/* Direct signals */
#ifndef WIN32
- if (pset.queryFoutPipe)
- pqsignal(SIGPIPE, SIG_IGN);
- else
- pqsignal(SIGPIPE, SIG_DFL);
+ pqsignal(SIGPIPE, pset.queryFoutPipe ? SIG_IGN : SIG_DFL);
#endif
return status;
/*
- * for backend INFO, WARNING, ERROR
+ * for backend Notice messages (INFO, WARNING, etc)
*/
void
NoticeProcessor(void *arg, const char *message)
* so. We use write() to print to stdout because it's better to use simple
* facilities in a signal handler.
*/
-PGconn *cancelConn;
-volatile bool cancel_pressed;
+static PGconn *volatile cancelConn = NULL;
+
+volatile bool cancel_pressed = false;
+
#ifndef WIN32
#endif /* not WIN32 */
+
+/* ConnectionUp
+ *
+ * Returns whether our backend connection is still there.
+ */
+static bool
+ConnectionUp()
+{
+ return PQstatus(pset.db) != CONNECTION_BAD;
+}
+
+
+
+/* CheckConnection
+ *
+ * Verify that we still have a good connection to the backend, and if not,
+ * see if it can be restored.
+ *
+ * Returns true if either the connection was still there, or it could be
+ * restored successfully; false otherwise. If, however, there was no
+ * connection and the session is non-interactive, this will exit the program
+ * with a code of EXIT_BADCONN.
+ */
+static bool
+CheckConnection()
+{
+ bool OK;
+
+ OK = ConnectionUp();
+ if (!OK)
+ {
+ if (!pset.cur_cmd_interactive)
+ {
+ psql_error("connection to server was lost\n");
+ exit(EXIT_BADCONN);
+ }
+
+ fputs(gettext("The connection to the server was lost. Attempting reset: "), stderr);
+ PQreset(pset.db);
+ OK = ConnectionUp();
+ if (!OK)
+ {
+ fputs(gettext("Failed.\n"), stderr);
+ PQfinish(pset.db);
+ pset.db = NULL;
+ ResetCancelConn();
+ SetVariable(pset.vars, "DBNAME", NULL);
+ SetVariable(pset.vars, "HOST", NULL);
+ SetVariable(pset.vars, "PORT", NULL);
+ SetVariable(pset.vars, "USER", NULL);
+ SetVariable(pset.vars, "ENCODING", NULL);
+ }
+ else
+ fputs(gettext("Succeeded.\n"), stderr);
+ }
+
+ return OK;
+}
+
+
+
+/*
+ * SetCancelConn
+ *
+ * Set cancelConn to point to the current database connection.
+ */
+static void SetCancelConn(void)
+{
+ cancelConn = pset.db;
+}
+
+
+/*
+ * ResetCancelConn
+ *
+ * Set cancelConn to NULL. I don't know what this means exactly, but it saves
+ * having to export the variable.
+ */
+void ResetCancelConn(void)
+{
+ cancelConn = NULL;
+}
+
+
+/*
+ * AcceptResult
+ *
+ * Checks whether a result is valid, giving an error message if necessary;
+ * (re)sets copy_in_state and cancelConn as needed, and ensures that the
+ * connection to the backend is still up.
+ *
+ * Returns true for valid result, false for error state.
+ */
+static bool
+AcceptResult(const PGresult *result)
+{
+ bool OK = true;
+
+ ResetCancelConn();
+
+ if (!result)
+ {
+ OK = false;
+ }
+ else switch (PQresultStatus(result))
+ {
+ case PGRES_COPY_IN:
+ copy_in_state = true;
+ break;
+
+ case PGRES_COMMAND_OK:
+ case PGRES_TUPLES_OK:
+ /* Fine, do nothing */
+ break;
+
+ case PGRES_COPY_OUT:
+ /* keep cancel connection for copy out state */
+ SetCancelConn();
+ break;
+
+ default:
+ OK = false;
+ break;
+ }
+
+ if (!OK)
+ {
+ CheckConnection();
+ psql_error("%s", PQerrorMessage(pset.db));
+ }
+
+ return OK;
+}
+
+
+
/*
* PSQLexec
*
{
PGresult *res = NULL;
PGresult *newres;
- const char *var;
+ int echo_hidden;
ExecStatusType rstatus;
if (!pset.db)
return NULL;
}
- var = GetVariable(pset.vars, "ECHO_HIDDEN");
- if (var)
+ echo_hidden = SwitchVariable(pset.vars, "ECHO_HIDDEN", "noexec", NULL);
+ if (echo_hidden != var_notset)
{
printf("********* QUERY **********\n"
"%s\n"
"**************************\n\n", query);
fflush(stdout);
- }
- if (var && strcmp(var, "noexec") == 0)
+ if (echo_hidden == 1)
return NULL;
+ }
- cancelConn = pset.db;
- if (PQsendQuery(pset.db, query))
+ /* discard any uneaten results of past queries */
+ while ((newres = PQgetResult(pset.db)) != NULL)
+ PQclear(newres);
+
+ SetCancelConn();
+ if (!PQsendQuery(pset.db, query))
{
- while ((newres = PQgetResult(pset.db)) != NULL)
+ psql_error("%s", PQerrorMessage(pset.db));
+ ResetCancelConn();
+ return NULL;
+ }
+
+ rstatus = PGRES_EMPTY_QUERY;
+
+ while (rstatus != PGRES_COPY_IN &&
+ rstatus != PGRES_COPY_OUT &&
+ (newres = PQgetResult(pset.db)))
{
- if (ignore_command_ok &&
- PQresultStatus(newres) == PGRES_COMMAND_OK)
+ rstatus = PQresultStatus(newres);
+ if (!ignore_command_ok || rstatus != PGRES_COMMAND_OK)
{
- PQclear(newres);
- continue;
- }
- PQclear(res);
+ PGresult *tempRes = res;
res = newres;
+ newres = tempRes;
}
+ PQclear(newres);
}
- rstatus = PQresultStatus(res);
- /* keep cancel connection for copy out state */
- if (rstatus != PGRES_COPY_OUT)
- cancelConn = NULL;
- if (rstatus == PGRES_COPY_IN)
- copy_in_state = true;
-
- if (res && (rstatus == PGRES_COMMAND_OK ||
- rstatus == PGRES_TUPLES_OK ||
- rstatus == PGRES_COPY_IN ||
- rstatus == PGRES_COPY_OUT))
- return res;
- else
+
+ if (!AcceptResult(res) && res)
{
- psql_error("%s", PQerrorMessage(pset.db));
PQclear(res);
-
- if (PQstatus(pset.db) == CONNECTION_BAD)
- {
- if (!pset.cur_cmd_interactive)
- {
- psql_error("connection to server was lost\n");
- exit(EXIT_BADCONN);
- }
- fputs(gettext("The connection to the server was lost. Attempting reset: "), stderr);
- PQreset(pset.db);
- if (PQstatus(pset.db) == CONNECTION_BAD)
- {
- fputs(gettext("Failed.\n"), stderr);
- PQfinish(pset.db);
- pset.db = NULL;
- SetVariable(pset.vars, "DBNAME", NULL);
- SetVariable(pset.vars, "HOST", NULL);
- SetVariable(pset.vars, "PORT", NULL);
- SetVariable(pset.vars, "USER", NULL);
- SetVariable(pset.vars, "ENCODING", NULL);
- }
- else
- fputs(gettext("Succeeded.\n"), stderr);
+ res = NULL;
}
- return NULL;
- }
+ return res;
}
/*
- * SendQuery: send the query string to the backend
- * (and print out results)
- *
- * Note: This is the "front door" way to send a query. That is, use it to
- * send queries actually entered by the user. These queries will be subject to
- * single step mode.
- * To send "back door" queries (generated by slash commands, etc.) in a
- * controlled way, use PSQLexec().
+ * PrintNotifications: check for asynchronous notifications, and print them out
*
- * Returns true if the query executed successfully, false otherwise.
*/
-bool
-SendQuery(const char *query)
+static void
+PrintNotifications(void)
{
- bool success = false;
- PGresult *results;
PGnotify *notify;
-#ifndef WIN32
- struct timeval before,
- after;
-#else
- struct _timeb before,
- after;
-#endif
-
- if (!pset.db)
- {
- psql_error("You are currently not connected to a database.\n");
- return false;
- }
- if (GetVariableBool(pset.vars, "SINGLESTEP"))
- {
- char buf[3];
-
- printf(gettext("***(Single step mode: Verify query)*********************************************\n"
- "%s\n"
- "***(press return to proceed or enter x and return to cancel)********************\n"),
- query);
- fflush(stdout);
- if (fgets(buf, sizeof(buf), stdin) != NULL)
- if (buf[0] == 'x')
- return false;
- }
- else
+ while ((notify = PQnotifies(pset.db)))
{
- const char *var = GetVariable(pset.vars, "ECHO");
-
- if (var && strncmp(var, "queries", strlen(var)) == 0)
- puts(query);
+ fprintf(pset.queryFout, gettext("Asynchronous NOTIFY '%s' from backend with pid %d received.\n"),
+ notify->relname, notify->be_pid);
+ PQfreemem(notify);
+ fflush(pset.queryFout);
}
+}
- cancelConn = pset.db;
-
-#ifndef WIN32
- if (pset.timing)
- gettimeofday(&before, NULL);
- results = PQexec(pset.db, query);
- if (pset.timing)
- gettimeofday(&after, NULL);
-#else
- if (pset.timing)
- _ftime(&before);
- results = PQexec(pset.db, query);
- if (pset.timing)
- _ftime(&after);
-#endif
-
- if (PQresultStatus(results) == PGRES_COPY_IN)
- copy_in_state = true;
- /* keep cancel connection for copy out state */
- if (PQresultStatus(results) != PGRES_COPY_OUT)
- cancelConn = NULL;
- if (results == NULL)
- {
- fputs(PQerrorMessage(pset.db), pset.queryFout);
- success = false;
- }
- else
- {
- switch (PQresultStatus(results))
- {
- case PGRES_TUPLES_OK:
+/*
+ * PrintQueryTuples: assuming query result is OK, print its tuples
+ *
+ * Returns true if successful, false otherwise.
+ */
+static bool
+PrintQueryTuples(const PGresult *results)
+{
/* write output to \g argument, if any */
if (pset.gfname)
{
{
pset.queryFout = queryFout_copy;
pset.queryFoutPipe = queryFoutPipe_copy;
- success = false;
- break;
+ return false;
}
printQuery(results, &pset.popt, pset.queryFout);
free(pset.gfname);
pset.gfname = NULL;
-
- success = true;
}
else
{
printQuery(results, &pset.popt, pset.queryFout);
- success = true;
}
+
+ return true;
+}
+
+
+
+/*
+ * PrintQueryResults: analyze query results and print them out
+ *
+ * Note: Utility function for use by SendQuery() only.
+ *
+ * Returns true if the query executed successfully, false otherwise.
+ */
+static bool
+PrintQueryResults(PGresult *results,
+ const TimevalStruct *before,
+ const TimevalStruct *after)
+{
+ bool success = false;
+
+ if (!results)
+ return false;
+
+ switch (PQresultStatus(results))
+ {
+ case PGRES_TUPLES_OK:
+ success = PrintQueryTuples(results);
break;
case PGRES_EMPTY_QUERY:
success = true;
success = true;
sprintf(buf, "%u", (unsigned int) PQoidValue(results));
if (!QUIET())
- fprintf(pset.queryFout, "%s\n", PQcmdStatus(results));
+ {
+ if (pset.popt.topt.format == PRINT_HTML)
+ {
+ fputs("<p>", pset.queryFout);
+ html_escaped_print(PQcmdStatus(results), pset.queryFout);
+ fputs("</p>\n", pset.queryFout);
+ }
+ else
+ {
+ fprintf(pset.queryFout, "%s\n", PQcmdStatus(results));
+ }
+ }
SetVariable(pset.vars, "LASTOID", buf);
break;
}
pset.cur_cmd_interactive ? get_prompt(PROMPT_COPY) : NULL);
break;
- case PGRES_NONFATAL_ERROR:
- case PGRES_FATAL_ERROR:
- case PGRES_BAD_RESPONSE:
- success = false;
- psql_error("%s", PQerrorMessage(pset.db));
+ default:
break;
}
fflush(pset.queryFout);
- if (PQstatus(pset.db) == CONNECTION_BAD)
- {
- if (!pset.cur_cmd_interactive)
- {
- psql_error("connection to server was lost\n");
- exit(EXIT_BADCONN);
- }
- fputs(gettext("The connection to the server was lost. Attempting reset: "), stderr);
- PQreset(pset.db);
- if (PQstatus(pset.db) == CONNECTION_BAD)
- {
- fputs(gettext("Failed.\n"), stderr);
- PQfinish(pset.db);
- PQclear(results);
- pset.db = NULL;
- SetVariable(pset.vars, "DBNAME", NULL);
- SetVariable(pset.vars, "HOST", NULL);
- SetVariable(pset.vars, "PORT", NULL);
- SetVariable(pset.vars, "USER", NULL);
- SetVariable(pset.vars, "ENCODING", NULL);
- return false;
- }
- else
- fputs(gettext("Succeeded.\n"), stderr);
- }
-
- /* check for asynchronous notification returns */
- while ((notify = PQnotifies(pset.db)) != NULL)
- {
- fprintf(pset.queryFout, gettext("Asynchronous NOTIFY '%s' from backend with pid %d received.\n"),
- notify->relname, notify->be_pid);
- free(notify);
- fflush(pset.queryFout);
- }
-
- if (results)
- PQclear(results);
- }
+ if (!CheckConnection()) return false;
/* Possible microtiming output */
if (pset.timing && success)
-#ifndef WIN32
- printf(gettext("Time: %.2f ms\n"),
- ((after.tv_sec - before.tv_sec) * 1000000.0 + after.tv_usec - before.tv_usec) / 1000.0);
-#else
- printf(gettext("Time: %.2f ms\n"),
- ((after.time - before.time) * 1000.0 + after.millitm - before.millitm));
-#endif
+ printf(gettext("Time: %.2f ms\n"), DIFF_MSEC(after, before));
return success;
}
+
+
+
+/*
+ * SendQuery: send the query string to the backend
+ * (and print out results)
+ *
+ * Note: This is the "front door" way to send a query. That is, use it to
+ * send queries actually entered by the user. These queries will be subject to
+ * single step mode.
+ * To send "back door" queries (generated by slash commands, etc.) in a
+ * controlled way, use PSQLexec().
+ *
+ * Returns true if the query executed successfully, false otherwise.
+ */
+bool
+SendQuery(const char *query)
+{
+ PGresult *results;
+ TimevalStruct before, after;
+ bool OK;
+
+ if (!pset.db)
+ {
+ psql_error("You are currently not connected to a database.\n");
+ return false;
+ }
+
+ if (GetVariableBool(pset.vars, "SINGLESTEP"))
+ {
+ char buf[3];
+
+ printf(gettext("***(Single step mode: Verify query)*********************************************\n"
+ "%s\n"
+ "***(press return to proceed or enter x and return to cancel)********************\n"),
+ query);
+ fflush(stdout);
+ if (fgets(buf, sizeof(buf), stdin) != NULL)
+ if (buf[0] == 'x')
+ return false;
+ }
+ else if (VariableEquals(pset.vars, "ECHO", "queries"))
+ puts(query);
+
+ SetCancelConn();
+
+ if (pset.timing)
+ GETTIMEOFDAY(&before);
+ results = PQexec(pset.db, query);
+ if (pset.timing)
+ GETTIMEOFDAY(&after);
+
+ OK = (AcceptResult(results) && PrintQueryResults(results, &before, &after));
+ PQclear(results);
+
+ PrintNotifications();
+ return OK;
+}
+
+
+char parse_char(char **buf)
+{
+ long l;
+
+ l = strtol(*buf, buf, 0);
+ --*buf;
+ return (char)l;
+}
+
+
projects / postgresql / blobdiff