/******************************************************************************
 * $Id$
 *
 * Project:  MapServer
 * Purpose:  PostGIS CONNECTIONTYPE support.
 * Author:   Paul Ramsey <pramsey@cleverelephant.ca>
 *           Dave Blasby <dblasby@gmail.com>
 *
 ******************************************************************************
 * Copyright (c) 2010 Paul Ramsey
 * Copyright (c) 2002 Refractions Research
 *
 * Permission is hereby granted, free of charge, to any person obtaining a
 * copy of this software and associated documentation files (the "Software"),
 * to deal in the Software without restriction, including without limitation
 * the rights to use, copy, modify, merge, publish, distribute, sublicense,
 * and/or sell copies of the Software, and to permit persons to whom the
 * Software is furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in
 * all copies of this Software or works derived from this Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS
 * OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL
 * THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
 * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
 * DEALINGS IN THE SOFTWARE.
 ****************************************************************************/

#ifdef USE_POSTGIS

#include "libpq-fe.h"
#include <string>

#ifndef LITTLE_ENDIAN
#define LITTLE_ENDIAN 1
#endif
#ifndef BIG_ENDIAN
#define BIG_ENDIAN 2
#endif

/* HEX = 16, BASE64 = 64, RAW = 256*/
#define TRANSFER_ENCODING 256

/* Substitution token for box hackery */
#define BOXTOKEN "!BOX!"
#define BOXTOKENLENGTH 5

/*
** msPostGISLayerInfo
**
** Specific information needed for managing this layer.
*/
typedef struct {
  std::string sql{};        /* SQL query to send to database */
  PGconn *pgconn = nullptr; /* Connection to database */
  long rownum = 0; /* What row is the next to be read (for random access) */
  PGresult *pgresult = nullptr; /* For fetching rows from the database */
  std::string uid{};  /* Name of user-specified unique identifier, if set */
  std::string srid{}; /* Name of user-specified SRID: zero-length => calculate;
                         non-zero => use this value! */
  std::string
      geomcolumn{}; /* Specified geometry column, eg "THEGEOM from thetable" */
  std::string fromsource{}; /* Specified record source, ed "thegeom from
                               THETABLE" or "thegeom from (SELECT..) AS FOO" */
  int endian = 0;           /* Endianness of the mapserver host */
  int version = 0;          /* PostGIS version of the database */
  int paging = 0;  /* Driver handling of pagination, enabled by default */
  int force2d = 0; /* Pass geometry through ST_Force2D */
} msPostGISLayerInfo;

/*
** Utility structure for handling the WKB returned by the database while
** reading.
*/
typedef struct {
  char *wkb;          /* Pointer to front of WKB */
  char *ptr;          /* Pointer to current write point */
  size_t size;        /* Size of allocated space */
  const int *typemap; /* Look-up array to valid OGC types */
} wkbObj;

/*
** All the WKB type numbers from the OGC
*/
typedef enum {
  WKB_POINT = 1,
  WKB_LINESTRING = 2,
  WKB_POLYGON = 3,
  WKB_MULTIPOINT = 4,
  WKB_MULTILINESTRING = 5,
  WKB_MULTIPOLYGON = 6,
  WKB_GEOMETRYCOLLECTION = 7,
  WKB_CIRCULARSTRING = 8,
  WKB_COMPOUNDCURVE = 9,
  WKB_CURVEPOLYGON = 10,
  WKB_MULTICURVE = 11,
  WKB_MULTISURFACE = 12
} wkb_typenum;

/*
** See below.
*/
#define WKB_TYPE_COUNT 16

/*
** Map the WKB type numbers returned by PostGIS < 2.0 to the
** valid OGC numbers
*/
static const int wkb_postgis15[WKB_TYPE_COUNT] = {0,
                                                  WKB_POINT,
                                                  WKB_LINESTRING,
                                                  WKB_POLYGON,
                                                  WKB_MULTIPOINT,
                                                  WKB_MULTILINESTRING,
                                                  WKB_MULTIPOLYGON,
                                                  WKB_GEOMETRYCOLLECTION,
                                                  WKB_CIRCULARSTRING,
                                                  WKB_COMPOUNDCURVE,
                                                  0,
                                                  0,
                                                  0,
                                                  WKB_CURVEPOLYGON,
                                                  WKB_MULTICURVE,
                                                  WKB_MULTISURFACE};

/*
** Map the WKB type numbers returned by PostGIS >= 2.0 to the
** valid OGC numbers
*/
static const int wkb_postgis20[WKB_TYPE_COUNT] = {0,
                                                  WKB_POINT,
                                                  WKB_LINESTRING,
                                                  WKB_POLYGON,
                                                  WKB_MULTIPOINT,
                                                  WKB_MULTILINESTRING,
                                                  WKB_MULTIPOLYGON,
                                                  WKB_GEOMETRYCOLLECTION,
                                                  WKB_CIRCULARSTRING,
                                                  WKB_COMPOUNDCURVE,
                                                  WKB_CURVEPOLYGON,
                                                  WKB_MULTICURVE,
                                                  WKB_MULTISURFACE,
                                                  0,
                                                  0,
                                                  0};

#endif /* USE_POSTGIS */
