pgRouting
pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality.
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Pages
postgres_connection.c
Go to the documentation of this file.
1 /*PGR-GNU*****************************************************************
2 File: postgres_connection.c
3 
4 Copyright (c) 2015 Celia Virginia Vergara Castillo
5 vicky_vergara@hotmail.com
6 
7 ------
8 
9 This program is free software; you can redistribute it and/or modify
10 it under the terms of the GNU General Public License as published by
11 the Free Software Foundation; either version 2 of the License, or
12 (at your option) any later version.
13 
14 This program is distributed in the hope that it will be useful,
15 but WITHOUT ANY WARRANTY; without even the implied warranty of
16 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 GNU General Public License for more details.
18 
19 You should have received a copy of the GNU General Public License
20 along with this program; if not, write to the Free Software
21 Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
22 
23 ********************************************************************PGR-GNU*/
24 
25 #include <postgres.h>
26 #include "catalog/pg_type.h"
27 #include "executor/spi.h"
28 
29 
30 // #define DEBUG
31 #include "./debug_macro.h"
32 #include "./postgres_connection.h"
33 
34 void
35 pgr_send_error(int errcode) {
36  switch (errcode) {
37  case 1:
38  elog(ERROR, "Unexpected point(s) with same pid but different"
39  " edge/fraction/side combination found.");
40  break;
41  case 2:
42  elog(ERROR, "Internal: Unexpected mismatch "
43  "count and sequence number on results");
44  break;
45  default:
46  elog(ERROR, "Unknown exception");
47  }
48 }
49 
50 
51 char*
52 pgr_text2char(text *in) {
53  char *out = palloc(VARSIZE(in));
54 
55  memcpy(out, VARDATA(in), VARSIZE(in) - VARHDRSZ);
56  out[VARSIZE(in) - VARHDRSZ] = '\0';
57  return out;
58 }
59 
60 
61 // http://www.postgresql.org/docs/9.4/static/spi-spi-finish.html
62 void
64  PGR_DBG("Disconnecting SPI");
65  int code = SPI_OK_FINISH;
66  code = SPI_finish();
67  if (code != SPI_OK_FINISH) { // SPI_ERROR_UNCONNECTED
68  elog(ERROR, "There was no connection to SPI");
69  }
70 }
71 
72 void
74  PGR_DBG("Connecting to SPI");
75  int SPIcode;
76  SPIcode = SPI_connect();
77  if (SPIcode != SPI_OK_CONNECT) {
78  elog(ERROR, "Couldn't open a connection to SPI");
79  }
80 }
81 
82 SPIPlanPtr
83 pgr_SPI_prepare(char* sql) {
84  PGR_DBG("Preparing Plan");
85  SPIPlanPtr SPIplan;
86  SPIplan = SPI_prepare(sql, 0, NULL);
87  if (SPIplan == NULL) {
88  elog(ERROR, "Couldn't create query plan via SPI: %s", sql);
89  }
90  return SPIplan;
91 }
92 
93 Portal
94 pgr_SPI_cursor_open(SPIPlanPtr SPIplan) {
95  PGR_DBG("Opening Portal");
96  Portal SPIportal;
97  SPIportal = SPI_cursor_open(NULL, SPIplan, NULL, NULL, true);
98  if (SPIportal == NULL) {
99  elog(ERROR, "SPI_cursor_open returns NULL");
100  }
101  return SPIportal;
102 }
#define PGR_DBG(...)
Definition: debug_macro.h:33
void pgr_SPI_finish(void)
void pgr_send_error(int errcode)
void pgr_SPI_connect(void)
Portal pgr_SPI_cursor_open(SPIPlanPtr SPIplan)
char * pgr_text2char(text *in)
SPIPlanPtr pgr_SPI_prepare(char *sql)