xml.c File Reference

#include "postgres.h"
#include "access/htup_details.h"
#include "access/table.h"
#include "catalog/namespace.h"
#include "catalog/pg_class.h"
#include "catalog/pg_type.h"
#include "commands/dbcommands.h"
#include "executor/spi.h"
#include "executor/tablefunc.h"
#include "fmgr.h"
#include "lib/stringinfo.h"
#include "libpq/pqformat.h"
#include "mb/pg_wchar.h"
#include "miscadmin.h"
#include "nodes/execnodes.h"
#include "nodes/miscnodes.h"
#include "nodes/nodeFuncs.h"
#include "utils/array.h"
#include "utils/builtins.h"
#include "utils/date.h"
#include "utils/datetime.h"
#include "utils/lsyscache.h"
#include "utils/rel.h"
#include "utils/syscache.h"
#include "utils/xml.h"

Include dependency graph for xml.c:

Go to the source code of this file.

Macros
#define	NO_XML_SUPPORT()
#define	NAMESPACE_XSD   "http://www.w3.org/2001/XMLSchema"
#define	NAMESPACE_XSI   "http://www.w3.org/2001/XMLSchema-instance"
#define	NAMESPACE_SQLXML   "http://standards.iso.org/iso/9075/2003/sqlxml"
#define	PG_XML_DEFAULT_VERSION   "1.0"
#define	XML_VISIBLE_SCHEMAS_EXCLUDE   "(nspname ~ '^pg_' OR nspname = 'information_schema')"
#define	XML_VISIBLE_SCHEMAS   "SELECT oid FROM pg_catalog.pg_namespace WHERE pg_catalog.has_schema_privilege (oid, 'USAGE') AND NOT " XML_VISIBLE_SCHEMAS_EXCLUDE

Functions
static void	xmldata_root_element_start (StringInfo result, const char *eltname, const char *xmlschema, const char *targetns, bool top_level)
static void	xmldata_root_element_end (StringInfo result, const char *eltname)
static StringInfo	query_to_xml_internal (const char *query, char *tablename, const char *xmlschema, bool nulls, bool tableforest, const char *targetns, bool top_level)
static const char *	map_sql_table_to_xmlschema (TupleDesc tupdesc, Oid relid, bool nulls, bool tableforest, const char *targetns)
static const char *	map_sql_schema_to_xmlschema_types (Oid nspid, List *relid_list, bool nulls, bool tableforest, const char *targetns)
static const char *	map_sql_catalog_to_xmlschema_types (List *nspid_list, bool nulls, bool tableforest, const char *targetns)
static const char *	map_sql_type_to_xml_name (Oid typeoid, int typmod)
static const char *	map_sql_typecoll_to_xmlschema_types (List *tupdesc_list)
static const char *	map_sql_type_to_xmlschema_type (Oid typeoid, int typmod)
static void	SPI_sql_row_to_xmlelement (uint64 rownum, StringInfo result, char *tablename, bool nulls, bool tableforest, const char *targetns, bool top_level)
static void	XmlTableInitOpaque (struct TableFuncScanState *state, int natts)
static void	XmlTableSetDocument (struct TableFuncScanState *state, Datum value)
static void	XmlTableSetNamespace (struct TableFuncScanState *state, const char *name, const char *uri)
static void	XmlTableSetRowFilter (struct TableFuncScanState *state, const char *path)
static void	XmlTableSetColumnFilter (struct TableFuncScanState *state, const char *path, int colnum)
static bool	XmlTableFetchRow (struct TableFuncScanState *state)
static Datum	XmlTableGetValue (struct TableFuncScanState *state, int colnum, Oid typid, int32 typmod, bool *isnull)
static void	XmlTableDestroyOpaque (struct TableFuncScanState *state)
Datum	xml_in (PG_FUNCTION_ARGS)
static char *	xml_out_internal (xmltype *x, pg_enc target_encoding)
Datum	xml_out (PG_FUNCTION_ARGS)
Datum	xml_recv (PG_FUNCTION_ARGS)
Datum	xml_send (PG_FUNCTION_ARGS)
static xmltype *	stringinfo_to_xmltype (StringInfo buf)
static xmltype *	cstring_to_xmltype (const char *string)
Datum	xmlcomment (PG_FUNCTION_ARGS)
Datum	xmltext (PG_FUNCTION_ARGS)
xmltype *	xmlconcat (List *args)
Datum	xmlconcat2 (PG_FUNCTION_ARGS)
Datum	texttoxml (PG_FUNCTION_ARGS)
Datum	xmltotext (PG_FUNCTION_ARGS)
text *	xmltotext_with_options (xmltype *data, XmlOptionType xmloption_arg, bool indent)
xmltype *	xmlelement (XmlExpr *xexpr, Datum *named_argvalue, bool *named_argnull, Datum *argvalue, bool *argnull)
xmltype *	xmlparse (text *data, XmlOptionType xmloption_arg, bool preserve_whitespace)
xmltype *	xmlpi (const char *target, text *arg, bool arg_is_null, bool *result_is_null)
xmltype *	xmlroot (xmltype *data, text *version, int standalone)
Datum	xmlvalidate (PG_FUNCTION_ARGS)
bool	xml_is_document (xmltype *arg)
char *	map_sql_identifier_to_xml_name (const char *ident, bool fully_escaped, bool escape_period)
char *	map_xml_name_to_sql_identifier (const char *name)
char *	map_sql_value_to_xml_value (Datum value, Oid type, bool xml_escape_strings)
char *	escape_xml (const char *str)
static char *	_SPI_strdup (const char *s)
static List *	query_to_oid_list (const char *query)
static List *	schema_get_xml_visible_tables (Oid nspid)
static List *	database_get_xml_visible_schemas (void)
static List *	database_get_xml_visible_tables (void)
static StringInfo	table_to_xml_internal (Oid relid, const char *xmlschema, bool nulls, bool tableforest, const char *targetns, bool top_level)
Datum	table_to_xml (PG_FUNCTION_ARGS)
Datum	query_to_xml (PG_FUNCTION_ARGS)
Datum	cursor_to_xml (PG_FUNCTION_ARGS)
Datum	table_to_xmlschema (PG_FUNCTION_ARGS)
Datum	query_to_xmlschema (PG_FUNCTION_ARGS)
Datum	cursor_to_xmlschema (PG_FUNCTION_ARGS)
Datum	table_to_xml_and_xmlschema (PG_FUNCTION_ARGS)
Datum	query_to_xml_and_xmlschema (PG_FUNCTION_ARGS)
static StringInfo	schema_to_xml_internal (Oid nspid, const char *xmlschema, bool nulls, bool tableforest, const char *targetns, bool top_level)
Datum	schema_to_xml (PG_FUNCTION_ARGS)
static void	xsd_schema_element_start (StringInfo result, const char *targetns)
static void	xsd_schema_element_end (StringInfo result)
static StringInfo	schema_to_xmlschema_internal (const char *schemaname, bool nulls, bool tableforest, const char *targetns)
Datum	schema_to_xmlschema (PG_FUNCTION_ARGS)
Datum	schema_to_xml_and_xmlschema (PG_FUNCTION_ARGS)
static StringInfo	database_to_xml_internal (const char *xmlschema, bool nulls, bool tableforest, const char *targetns)
Datum	database_to_xml (PG_FUNCTION_ARGS)
static StringInfo	database_to_xmlschema_internal (bool nulls, bool tableforest, const char *targetns)
Datum	database_to_xmlschema (PG_FUNCTION_ARGS)
Datum	database_to_xml_and_xmlschema (PG_FUNCTION_ARGS)
static char *	map_multipart_sql_identifier_to_xml_name (const char *a, const char *b, const char *c, const char *d)
Datum	xpath (PG_FUNCTION_ARGS)
Datum	xmlexists (PG_FUNCTION_ARGS)
Datum	xpath_exists (PG_FUNCTION_ARGS)
Datum	xml_is_well_formed (PG_FUNCTION_ARGS)
Datum	xml_is_well_formed_document (PG_FUNCTION_ARGS)
Datum	xml_is_well_formed_content (PG_FUNCTION_ARGS)

Variables
int	xmlbinary = XMLBINARY_BASE64
int	xmloption = XMLOPTION_CONTENT
const TableFuncRoutine	XmlTableRoutine

Macro Definition Documentation

NAMESPACE_SQLXML

#define NAMESPACE_SQLXML   "http://standards.iso.org/iso/9075/2003/sqlxml"

Definition at line 245 of file xml.c.

NAMESPACE_XSD

#define NAMESPACE_XSD   "http://www.w3.org/2001/XMLSchema"

Definition at line 243 of file xml.c.

NAMESPACE_XSI

#define NAMESPACE_XSI   "http://www.w3.org/2001/XMLSchema-instance"

Definition at line 244 of file xml.c.

NO_XML_SUPPORT

#define NO_XML_SUPPORT

(

)

Value:

    ereport(ERROR, \
            (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), \
             errmsg("unsupported XML feature"), \
             errdetail("This functionality requires the server to be built with libxml support.")))

Definition at line 235 of file xml.c.

PG_XML_DEFAULT_VERSION

#define PG_XML_DEFAULT_VERSION   "1.0"

Definition at line 301 of file xml.c.

XML_VISIBLE_SCHEMAS

#define XML_VISIBLE_SCHEMAS   "SELECT oid FROM pg_catalog.pg_namespace WHERE pg_catalog.has_schema_privilege (oid, 'USAGE') AND NOT " XML_VISIBLE_SCHEMAS_EXCLUDE

Definition at line 2849 of file xml.c.

XML_VISIBLE_SCHEMAS_EXCLUDE

#define XML_VISIBLE_SCHEMAS_EXCLUDE   "(nspname ~ '^pg_' OR nspname = 'information_schema')"

Definition at line 2847 of file xml.c.

Function Documentation

_SPI_strdup()

static char * _SPI_strdup ( const char *  s )

static

Definition at line 2740 of file xml.c.

{
    size_t      len = strlen(s) + 1;
    char       *ret = SPI_palloc(len);
 
    memcpy(ret, s, len);
    return ret;
}

References len, and SPI_palloc().

Referenced by cursor_to_xmlschema(), query_to_xml_and_xmlschema(), and query_to_xmlschema().

cstring_to_xmltype()

static xmltype * cstring_to_xmltype ( const char *  string )

static

Definition at line 474 of file xml.c.

{
    return (xmltype *) cstring_to_text(string);
}

References cstring_to_text().

Referenced by cursor_to_xmlschema(), query_to_xmlschema(), and table_to_xmlschema().

cursor_to_xml()

Datum cursor_to_xml

(

PG_FUNCTION_ARGS

)

Definition at line 2924 of file xml.c.

{
    char       *name = text_to_cstring(PG_GETARG_TEXT_PP(0));
    int32       count = PG_GETARG_INT32(1);
    bool        nulls = PG_GETARG_BOOL(2);
    bool        tableforest = PG_GETARG_BOOL(3);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(4));
 
    StringInfoData result;
    Portal      portal;
    uint64      i;
 
    initStringInfo(&result);
 
    if (!tableforest)
    {
        xmldata_root_element_start(&result, "table", NULL, targetns, true);
        appendStringInfoChar(&result, '\n');
    }
 
    SPI_connect();
    portal = SPI_cursor_find(name);
    if (portal == NULL)
        ereport(ERROR,
                (errcode(ERRCODE_UNDEFINED_CURSOR),
                 errmsg("cursor \"%s\" does not exist", name)));
 
    SPI_cursor_fetch(portal, true, count);
    for (i = 0; i < SPI_processed; i++)
        SPI_sql_row_to_xmlelement(i, &result, NULL, nulls,
                                  tableforest, targetns, true);
 
    SPI_finish();
 
    if (!tableforest)
        xmldata_root_element_end(&result, "table");
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(&result));
}

References appendStringInfoChar(), ereport, errcode(), errmsg(), ERROR, i, initStringInfo(), name, PG_GETARG_BOOL, PG_GETARG_INT32, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, SPI_connect(), SPI_cursor_fetch(), SPI_cursor_find(), SPI_finish(), SPI_processed, SPI_sql_row_to_xmlelement(), stringinfo_to_xmltype(), text_to_cstring(), xmldata_root_element_end(), and xmldata_root_element_start().

cursor_to_xmlschema()

Datum cursor_to_xmlschema

(

PG_FUNCTION_ARGS

)

Definition at line 3105 of file xml.c.

{
    char       *name = text_to_cstring(PG_GETARG_TEXT_PP(0));
    bool        nulls = PG_GETARG_BOOL(1);
    bool        tableforest = PG_GETARG_BOOL(2);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(3));
    const char *xmlschema;
    Portal      portal;
 
    SPI_connect();
    portal = SPI_cursor_find(name);
    if (portal == NULL)
        ereport(ERROR,
                (errcode(ERRCODE_UNDEFINED_CURSOR),
                 errmsg("cursor \"%s\" does not exist", name)));
    if (portal->tupDesc == NULL)
        ereport(ERROR,
                (errcode(ERRCODE_INVALID_CURSOR_STATE),
                 errmsg("portal \"%s\" does not return tuples", name)));
 
    xmlschema = _SPI_strdup(map_sql_table_to_xmlschema(portal->tupDesc,
                                                       InvalidOid, nulls,
                                                       tableforest, targetns));
    SPI_finish();
 
    PG_RETURN_XML_P(cstring_to_xmltype(xmlschema));
}

References _SPI_strdup(), cstring_to_xmltype(), ereport, errcode(), errmsg(), ERROR, InvalidOid, map_sql_table_to_xmlschema(), name, PG_GETARG_BOOL, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, SPI_connect(), SPI_cursor_find(), SPI_finish(), text_to_cstring(), and PortalData::tupDesc.

database_get_xml_visible_schemas()

static List * database_get_xml_visible_schemas ( void  )

static

Definition at line 2853 of file xml.c.

{
    return query_to_oid_list(XML_VISIBLE_SCHEMAS " ORDER BY nspname;");
}

References query_to_oid_list(), and XML_VISIBLE_SCHEMAS.

Referenced by database_to_xml_internal(), and database_to_xmlschema_internal().

database_get_xml_visible_tables()

static List * database_get_xml_visible_tables ( void  )

static

Definition at line 2860 of file xml.c.

{
    /* At the moment there is no order required here. */
    return query_to_oid_list("SELECT oid FROM pg_catalog.pg_class"
                             " WHERE relkind IN ("
                             CppAsString2(RELKIND_RELATION) ","
                             CppAsString2(RELKIND_MATVIEW) ","
                             CppAsString2(RELKIND_VIEW) ")"
                             " AND pg_catalog.has_table_privilege(pg_class.oid, 'SELECT')"
                             " AND relnamespace IN (" XML_VISIBLE_SCHEMAS ");");
}

References CppAsString2, query_to_oid_list(), and XML_VISIBLE_SCHEMAS.

Referenced by database_to_xmlschema_internal().

database_to_xml()

Datum database_to_xml

(

PG_FUNCTION_ARGS

)

Definition at line 3410 of file xml.c.

{
    bool        nulls = PG_GETARG_BOOL(0);
    bool        tableforest = PG_GETARG_BOOL(1);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(2));
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(database_to_xml_internal(NULL, nulls,
                                                                   tableforest, targetns)));
}

References database_to_xml_internal(), PG_GETARG_BOOL, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, stringinfo_to_xmltype(), and text_to_cstring().

database_to_xml_and_xmlschema()

Datum database_to_xml_and_xmlschema

(

PG_FUNCTION_ARGS

)

Definition at line 3477 of file xml.c.

{
    bool        nulls = PG_GETARG_BOOL(0);
    bool        tableforest = PG_GETARG_BOOL(1);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(2));
    StringInfo  xmlschema;
 
    xmlschema = database_to_xmlschema_internal(nulls, tableforest, targetns);
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(database_to_xml_internal(xmlschema->data,
                                                                   nulls, tableforest, targetns)));
}

References StringInfoData::data, database_to_xml_internal(), database_to_xmlschema_internal(), PG_GETARG_BOOL, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, stringinfo_to_xmltype(), and text_to_cstring().

database_to_xml_internal()

static StringInfo database_to_xml_internal ( const char *  xmlschema, bool  nulls, bool  tableforest, const char *  targetns  )

static

Definition at line 3367 of file xml.c.

{
    StringInfo  result;
    List       *nspid_list;
    ListCell   *cell;
    char       *xmlcn;
 
    xmlcn = map_sql_identifier_to_xml_name(get_database_name(MyDatabaseId),
                                           true, false);
    result = makeStringInfo();
 
    xmldata_root_element_start(result, xmlcn, xmlschema, targetns, true);
    appendStringInfoChar(result, '\n');
 
    if (xmlschema)
        appendStringInfo(result, "%s\n\n", xmlschema);
 
    SPI_connect();
 
    nspid_list = database_get_xml_visible_schemas();
 
    foreach(cell, nspid_list)
    {
        Oid         nspid = lfirst_oid(cell);
        StringInfo  subres;
 
        subres = schema_to_xml_internal(nspid, NULL, nulls,
                                        tableforest, targetns, false);
 
        appendBinaryStringInfo(result, subres->data, subres->len);
        appendStringInfoChar(result, '\n');
    }
 
    SPI_finish();
 
    xmldata_root_element_end(result, xmlcn);
 
    return result;
}

References appendBinaryStringInfo(), appendStringInfo(), appendStringInfoChar(), StringInfoData::data, database_get_xml_visible_schemas(), get_database_name(), StringInfoData::len, lfirst_oid, makeStringInfo(), map_sql_identifier_to_xml_name(), MyDatabaseId, nspid, schema_to_xml_internal(), SPI_connect(), SPI_finish(), xmldata_root_element_end(), and xmldata_root_element_start().

Referenced by database_to_xml(), and database_to_xml_and_xmlschema().

database_to_xmlschema()

Datum database_to_xmlschema

(

PG_FUNCTION_ARGS

)

Definition at line 3465 of file xml.c.

{
    bool        nulls = PG_GETARG_BOOL(0);
    bool        tableforest = PG_GETARG_BOOL(1);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(2));
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(database_to_xmlschema_internal(nulls,
                                                                         tableforest, targetns)));
}

References database_to_xmlschema_internal(), PG_GETARG_BOOL, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, stringinfo_to_xmltype(), and text_to_cstring().

database_to_xmlschema_internal()

static StringInfo database_to_xmlschema_internal ( bool  nulls, bool  tableforest, const char *  targetns  )

static

Definition at line 3422 of file xml.c.

{
    List       *relid_list;
    List       *nspid_list;
    List       *tupdesc_list;
    ListCell   *cell;
    StringInfo  result;
 
    result = makeStringInfo();
 
    xsd_schema_element_start(result, targetns);
 
    SPI_connect();
 
    relid_list = database_get_xml_visible_tables();
    nspid_list = database_get_xml_visible_schemas();
 
    tupdesc_list = NIL;
    foreach(cell, relid_list)
    {
        Relation    rel;
 
        rel = table_open(lfirst_oid(cell), AccessShareLock);
        tupdesc_list = lappend(tupdesc_list, CreateTupleDescCopy(rel->rd_att));
        table_close(rel, NoLock);
    }
 
    appendStringInfoString(result,
                           map_sql_typecoll_to_xmlschema_types(tupdesc_list));
 
    appendStringInfoString(result,
                           map_sql_catalog_to_xmlschema_types(nspid_list, nulls, tableforest, targetns));
 
    xsd_schema_element_end(result);
 
    SPI_finish();
 
    return result;
}

References AccessShareLock, appendStringInfoString(), CreateTupleDescCopy(), database_get_xml_visible_schemas(), database_get_xml_visible_tables(), lappend(), lfirst_oid, makeStringInfo(), map_sql_catalog_to_xmlschema_types(), map_sql_typecoll_to_xmlschema_types(), NIL, NoLock, RelationData::rd_att, SPI_connect(), SPI_finish(), table_close(), table_open(), xsd_schema_element_end(), and xsd_schema_element_start().

Referenced by database_to_xml_and_xmlschema(), and database_to_xmlschema().

escape_xml()

char * escape_xml

(

const char *

str

)

Definition at line 2708 of file xml.c.

{
    StringInfoData buf;
    const char *p;
 
    initStringInfo(&buf);
    for (p = str; *p; p++)
    {
        switch (*p)
        {
            case '&':
                appendStringInfoString(&buf, "&");
                break;
            case '<':
                appendStringInfoString(&buf, "&lt;");
                break;
            case '>':
                appendStringInfoString(&buf, "&gt;");
                break;
            case '\r':
                appendStringInfoString(&buf, "&#x0d;");
                break;
            default:
                appendStringInfoCharMacro(&buf, *p);
                break;
        }
    }
    return buf.data;
}

References appendStringInfoCharMacro, appendStringInfoString(), buf, initStringInfo(), and str.

Referenced by ExplainProperty(), ExplainPropertyList(), map_sql_value_to_xml_value(), and XmlTableGetValue().

map_multipart_sql_identifier_to_xml_name()

static char * map_multipart_sql_identifier_to_xml_name ( const char *  a, const char *  b, const char *  c, const char *  d  )

static

Definition at line 3496 of file xml.c.

{
    StringInfoData result;
 
    initStringInfo(&result);
 
    if (a)
        appendStringInfoString(&result,
                               map_sql_identifier_to_xml_name(a, true, true));
    if (b)
        appendStringInfo(&result, ".%s",
                         map_sql_identifier_to_xml_name(b, true, true));
    if (c)
        appendStringInfo(&result, ".%s",
                         map_sql_identifier_to_xml_name(c, true, true));
    if (d)
        appendStringInfo(&result, ".%s",
                         map_sql_identifier_to_xml_name(d, true, true));
 
    return result.data;
}

References a, appendStringInfo(), appendStringInfoString(), b, StringInfoData::data, initStringInfo(), and map_sql_identifier_to_xml_name().

Referenced by map_sql_catalog_to_xmlschema_types(), map_sql_schema_to_xmlschema_types(), map_sql_table_to_xmlschema(), and map_sql_type_to_xml_name().

map_sql_catalog_to_xmlschema_types()

static const char * map_sql_catalog_to_xmlschema_types ( List *  nspid_list, bool  nulls, bool  tableforest, const char *  targetns  )

static

Definition at line 3705 of file xml.c.

{
    char       *dbname;
    char       *xmlcn;
    char       *catalogtypename;
    StringInfoData result;
    ListCell   *cell;
 
    dbname = get_database_name(MyDatabaseId);
 
    initStringInfo(&result);
 
    xmlcn = map_sql_identifier_to_xml_name(dbname, true, false);
 
    catalogtypename = map_multipart_sql_identifier_to_xml_name("CatalogType",
                                                               dbname,
                                                               NULL,
                                                               NULL);
 
    appendStringInfo(&result,
                     "<xsd:complexType name=\"%s\">\n", catalogtypename);
    appendStringInfoString(&result,
                           "  <xsd:all>\n");
 
    foreach(cell, nspid_list)
    {
        Oid         nspid = lfirst_oid(cell);
        char       *nspname = get_namespace_name(nspid);
        char       *xmlsn = map_sql_identifier_to_xml_name(nspname, true, false);
        char       *schematypename = map_multipart_sql_identifier_to_xml_name("SchemaType",
                                                                              dbname,
                                                                              nspname,
                                                                              NULL);
 
        appendStringInfo(&result,
                         "    <xsd:element name=\"%s\" type=\"%s\"/>\n",
                         xmlsn, schematypename);
    }
 
    appendStringInfoString(&result,
                           "  </xsd:all>\n");
    appendStringInfoString(&result,
                           "</xsd:complexType>\n\n");
 
    appendStringInfo(&result,
                     "<xsd:element name=\"%s\" type=\"%s\"/>\n\n",
                     xmlcn, catalogtypename);
 
    return result.data;
}

References appendStringInfo(), appendStringInfoString(), StringInfoData::data, dbname, get_database_name(), get_namespace_name(), initStringInfo(), lfirst_oid, map_multipart_sql_identifier_to_xml_name(), map_sql_identifier_to_xml_name(), MyDatabaseId, and nspid.

Referenced by database_to_xmlschema_internal().

map_sql_identifier_to_xml_name()

char * map_sql_identifier_to_xml_name	(	const char *	ident,
		bool	fully_escaped,
		bool	escape_period
	)

Definition at line 2391 of file xml.c.

{
#ifdef USE_LIBXML
    StringInfoData buf;
    const char *p;
 
    /*
     * SQL/XML doesn't make use of this case anywhere, so it's probably a
     * mistake.
     */
    Assert(fully_escaped || !escape_period);
 
    initStringInfo(&buf);
 
    for (p = ident; *p; p += pg_mblen(p))
    {
        if (*p == ':' && (p == ident || fully_escaped))
            appendStringInfoString(&buf, "_x003A_");
        else if (*p == '_' && *(p + 1) == 'x')
            appendStringInfoString(&buf, "_x005F_");
        else if (fully_escaped && p == ident &&
                 pg_strncasecmp(p, "xml", 3) == 0)
        {
            if (*p == 'x')
                appendStringInfoString(&buf, "_x0078_");
            else
                appendStringInfoString(&buf, "_x0058_");
        }
        else if (escape_period && *p == '.')
            appendStringInfoString(&buf, "_x002E_");
        else
        {
            pg_wchar    u = sqlchar_to_unicode(p);
 
            if ((p == ident)
                ? !is_valid_xml_namefirst(u)
                : !is_valid_xml_namechar(u))
                appendStringInfo(&buf, "_x%04X_", (unsigned int) u);
            else
                appendBinaryStringInfo(&buf, p, pg_mblen(p));
        }
    }
 
    return buf.data;
#else                           /* not USE_LIBXML */
    NO_XML_SUPPORT();
    return NULL;
#endif                          /* not USE_LIBXML */
}

References appendBinaryStringInfo(), appendStringInfo(), appendStringInfoString(), Assert(), buf, ident, initStringInfo(), NO_XML_SUPPORT, pg_mblen(), and pg_strncasecmp().

Referenced by database_to_xml_internal(), map_multipart_sql_identifier_to_xml_name(), map_sql_catalog_to_xmlschema_types(), map_sql_schema_to_xmlschema_types(), map_sql_table_to_xmlschema(), query_to_xml_internal(), schema_to_xml_internal(), SPI_sql_row_to_xmlelement(), and transformXmlExpr().

map_sql_schema_to_xmlschema_types()

static const char * map_sql_schema_to_xmlschema_types ( Oid  nspid, List *  relid_list, bool  nulls, bool  tableforest, const char *  targetns  )

static

Definition at line 3632 of file xml.c.

{
    char       *dbname;
    char       *nspname;
    char       *xmlsn;
    char       *schematypename;
    StringInfoData result;
    ListCell   *cell;
 
    dbname = get_database_name(MyDatabaseId);
    nspname = get_namespace_name(nspid);
 
    initStringInfo(&result);
 
    xmlsn = map_sql_identifier_to_xml_name(nspname, true, false);
 
    schematypename = map_multipart_sql_identifier_to_xml_name("SchemaType",
                                                              dbname,
                                                              nspname,
                                                              NULL);
 
    appendStringInfo(&result,
                     "<xsd:complexType name=\"%s\">\n", schematypename);
    if (!tableforest)
        appendStringInfoString(&result,
                               "  <xsd:all>\n");
    else
        appendStringInfoString(&result,
                               "  <xsd:sequence>\n");
 
    foreach(cell, relid_list)
    {
        Oid         relid = lfirst_oid(cell);
        char       *relname = get_rel_name(relid);
        char       *xmltn = map_sql_identifier_to_xml_name(relname, true, false);
        char       *tabletypename = map_multipart_sql_identifier_to_xml_name(tableforest ? "RowType" : "TableType",
                                                                             dbname,
                                                                             nspname,
                                                                             relname);
 
        if (!tableforest)
            appendStringInfo(&result,
                             "    <xsd:element name=\"%s\" type=\"%s\"/>\n",
                             xmltn, tabletypename);
        else
            appendStringInfo(&result,
                             "    <xsd:element name=\"%s\" type=\"%s\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n",
                             xmltn, tabletypename);
    }
 
    if (!tableforest)
        appendStringInfoString(&result,
                               "  </xsd:all>\n");
    else
        appendStringInfoString(&result,
                               "  </xsd:sequence>\n");
    appendStringInfoString(&result,
                           "</xsd:complexType>\n\n");
 
    appendStringInfo(&result,
                     "<xsd:element name=\"%s\" type=\"%s\"/>\n\n",
                     xmlsn, schematypename);
 
    return result.data;
}

References appendStringInfo(), appendStringInfoString(), StringInfoData::data, dbname, get_database_name(), get_namespace_name(), get_rel_name(), initStringInfo(), lfirst_oid, map_multipart_sql_identifier_to_xml_name(), map_sql_identifier_to_xml_name(), MyDatabaseId, nspid, and relname.

Referenced by schema_to_xmlschema_internal().

map_sql_table_to_xmlschema()

static const char * map_sql_table_to_xmlschema ( TupleDesc  tupdesc, Oid  relid, bool  nulls, bool  tableforest, const char *  targetns  )

static

Definition at line 3527 of file xml.c.

{
    int         i;
    char       *xmltn;
    char       *tabletypename;
    char       *rowtypename;
    StringInfoData result;
 
    initStringInfo(&result);
 
    if (OidIsValid(relid))
    {
        HeapTuple   tuple;
        Form_pg_class reltuple;
 
        tuple = SearchSysCache1(RELOID, ObjectIdGetDatum(relid));
        if (!HeapTupleIsValid(tuple))
            elog(ERROR, "cache lookup failed for relation %u", relid);
        reltuple = (Form_pg_class) GETSTRUCT(tuple);
 
        xmltn = map_sql_identifier_to_xml_name(NameStr(reltuple->relname),
                                               true, false);
 
        tabletypename = map_multipart_sql_identifier_to_xml_name("TableType",
                                                                 get_database_name(MyDatabaseId),
                                                                 get_namespace_name(reltuple->relnamespace),
                                                                 NameStr(reltuple->relname));
 
        rowtypename = map_multipart_sql_identifier_to_xml_name("RowType",
                                                               get_database_name(MyDatabaseId),
                                                               get_namespace_name(reltuple->relnamespace),
                                                               NameStr(reltuple->relname));
 
        ReleaseSysCache(tuple);
    }
    else
    {
        if (tableforest)
            xmltn = "row";
        else
            xmltn = "table";
 
        tabletypename = "TableType";
        rowtypename = "RowType";
    }
 
    xsd_schema_element_start(&result, targetns);
 
    appendStringInfoString(&result,
                           map_sql_typecoll_to_xmlschema_types(list_make1(tupdesc)));
 
    appendStringInfo(&result,
                     "<xsd:complexType name=\"%s\">\n"
                     "  <xsd:sequence>\n",
                     rowtypename);
 
    for (i = 0; i < tupdesc->natts; i++)
    {
        Form_pg_attribute att = TupleDescAttr(tupdesc, i);
 
        if (att->attisdropped)
            continue;
        appendStringInfo(&result,
                         "    <xsd:element name=\"%s\" type=\"%s\"%s></xsd:element>\n",
                         map_sql_identifier_to_xml_name(NameStr(att->attname),
                                                        true, false),
                         map_sql_type_to_xml_name(att->atttypid, -1),
                         nulls ? " nillable=\"true\"" : " minOccurs=\"0\"");
    }
 
    appendStringInfoString(&result,
                           "  </xsd:sequence>\n"
                           "</xsd:complexType>\n\n");
 
    if (!tableforest)
    {
        appendStringInfo(&result,
                         "<xsd:complexType name=\"%s\">\n"
                         "  <xsd:sequence>\n"
                         "    <xsd:element name=\"row\" type=\"%s\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n"
                         "  </xsd:sequence>\n"
                         "</xsd:complexType>\n\n",
                         tabletypename, rowtypename);
 
        appendStringInfo(&result,
                         "<xsd:element name=\"%s\" type=\"%s\"/>\n\n",
                         xmltn, tabletypename);
    }
    else
        appendStringInfo(&result,
                         "<xsd:element name=\"%s\" type=\"%s\"/>\n\n",
                         xmltn, rowtypename);
 
    xsd_schema_element_end(&result);
 
    return result.data;
}

References appendStringInfo(), appendStringInfoString(), StringInfoData::data, elog, ERROR, get_database_name(), get_namespace_name(), GETSTRUCT(), HeapTupleIsValid, i, initStringInfo(), list_make1, map_multipart_sql_identifier_to_xml_name(), map_sql_identifier_to_xml_name(), map_sql_type_to_xml_name(), map_sql_typecoll_to_xmlschema_types(), MyDatabaseId, NameStr, TupleDescData::natts, ObjectIdGetDatum(), OidIsValid, ReleaseSysCache(), SearchSysCache1(), TupleDescAttr(), xsd_schema_element_end(), and xsd_schema_element_start().

Referenced by cursor_to_xmlschema(), query_to_xml_and_xmlschema(), query_to_xmlschema(), table_to_xml_and_xmlschema(), and table_to_xmlschema().

map_sql_type_to_xml_name()

static const char * map_sql_type_to_xml_name ( Oid  typeoid, int  typmod  )

static

Definition at line 3762 of file xml.c.

{
    StringInfoData result;
 
    initStringInfo(&result);
 
    switch (typeoid)
    {
        case BPCHAROID:
            if (typmod == -1)
                appendStringInfoString(&result, "CHAR");
            else
                appendStringInfo(&result, "CHAR_%d", typmod - VARHDRSZ);
            break;
        case VARCHAROID:
            if (typmod == -1)
                appendStringInfoString(&result, "VARCHAR");
            else
                appendStringInfo(&result, "VARCHAR_%d", typmod - VARHDRSZ);
            break;
        case NUMERICOID:
            if (typmod == -1)
                appendStringInfoString(&result, "NUMERIC");
            else
                appendStringInfo(&result, "NUMERIC_%d_%d",
                                 ((typmod - VARHDRSZ) >> 16) & 0xffff,
                                 (typmod - VARHDRSZ) & 0xffff);
            break;
        case INT4OID:
            appendStringInfoString(&result, "INTEGER");
            break;
        case INT2OID:
            appendStringInfoString(&result, "SMALLINT");
            break;
        case INT8OID:
            appendStringInfoString(&result, "BIGINT");
            break;
        case FLOAT4OID:
            appendStringInfoString(&result, "REAL");
            break;
        case FLOAT8OID:
            appendStringInfoString(&result, "DOUBLE");
            break;
        case BOOLOID:
            appendStringInfoString(&result, "BOOLEAN");
            break;
        case TIMEOID:
            if (typmod == -1)
                appendStringInfoString(&result, "TIME");
            else
                appendStringInfo(&result, "TIME_%d", typmod);
            break;
        case TIMETZOID:
            if (typmod == -1)
                appendStringInfoString(&result, "TIME_WTZ");
            else
                appendStringInfo(&result, "TIME_WTZ_%d", typmod);
            break;
        case TIMESTAMPOID:
            if (typmod == -1)
                appendStringInfoString(&result, "TIMESTAMP");
            else
                appendStringInfo(&result, "TIMESTAMP_%d", typmod);
            break;
        case TIMESTAMPTZOID:
            if (typmod == -1)
                appendStringInfoString(&result, "TIMESTAMP_WTZ");
            else
                appendStringInfo(&result, "TIMESTAMP_WTZ_%d", typmod);
            break;
        case DATEOID:
            appendStringInfoString(&result, "DATE");
            break;
        case XMLOID:
            appendStringInfoString(&result, "XML");
            break;
        default:
            {
                HeapTuple   tuple;
                Form_pg_type typtuple;
 
                tuple = SearchSysCache1(TYPEOID, ObjectIdGetDatum(typeoid));
                if (!HeapTupleIsValid(tuple))
                    elog(ERROR, "cache lookup failed for type %u", typeoid);
                typtuple = (Form_pg_type) GETSTRUCT(tuple);
 
                appendStringInfoString(&result,
                                       map_multipart_sql_identifier_to_xml_name((typtuple->typtype == TYPTYPE_DOMAIN) ? "Domain" : "UDT",
                                                                                get_database_name(MyDatabaseId),
                                                                                get_namespace_name(typtuple->typnamespace),
                                                                                NameStr(typtuple->typname)));
 
                ReleaseSysCache(tuple);
            }
    }
 
    return result.data;
}

References appendStringInfo(), appendStringInfoString(), StringInfoData::data, elog, ERROR, get_database_name(), get_namespace_name(), GETSTRUCT(), HeapTupleIsValid, initStringInfo(), map_multipart_sql_identifier_to_xml_name(), MyDatabaseId, NameStr, ObjectIdGetDatum(), ReleaseSysCache(), SearchSysCache1(), and VARHDRSZ.

Referenced by map_sql_table_to_xmlschema(), and map_sql_type_to_xmlschema_type().

map_sql_type_to_xmlschema_type()

static const char * map_sql_type_to_xmlschema_type ( Oid  typeoid, int  typmod  )

static

Definition at line 3922 of file xml.c.

{
    StringInfoData result;
    const char *typename = map_sql_type_to_xml_name(typeoid, typmod);
 
    initStringInfo(&result);
 
    if (typeoid == XMLOID)
    {
        appendStringInfoString(&result,
                               "<xsd:complexType mixed=\"true\">\n"
                               "  <xsd:sequence>\n"
                               "    <xsd:any name=\"element\" minOccurs=\"0\" maxOccurs=\"unbounded\" processContents=\"skip\"/>\n"
                               "  </xsd:sequence>\n"
                               "</xsd:complexType>\n");
    }
    else
    {
        appendStringInfo(&result,
                         "<xsd:simpleType name=\"%s\">\n", typename);
 
        switch (typeoid)
        {
            case BPCHAROID:
            case VARCHAROID:
            case TEXTOID:
                appendStringInfoString(&result,
                                       "  <xsd:restriction base=\"xsd:string\">\n");
                if (typmod != -1)
                    appendStringInfo(&result,
                                     "    <xsd:maxLength value=\"%d\"/>\n",
                                     typmod - VARHDRSZ);
                appendStringInfoString(&result, "  </xsd:restriction>\n");
                break;
 
            case BYTEAOID:
                appendStringInfo(&result,
                                 "  <xsd:restriction base=\"xsd:%s\">\n"
                                 "  </xsd:restriction>\n",
                                 xmlbinary == XMLBINARY_BASE64 ? "base64Binary" : "hexBinary");
                break;
 
            case NUMERICOID:
                if (typmod != -1)
                    appendStringInfo(&result,
                                     "  <xsd:restriction base=\"xsd:decimal\">\n"
                                     "    <xsd:totalDigits value=\"%d\"/>\n"
                                     "    <xsd:fractionDigits value=\"%d\"/>\n"
                                     "  </xsd:restriction>\n",
                                     ((typmod - VARHDRSZ) >> 16) & 0xffff,
                                     (typmod - VARHDRSZ) & 0xffff);
                break;
 
            case INT2OID:
                appendStringInfo(&result,
                                 "  <xsd:restriction base=\"xsd:short\">\n"
                                 "    <xsd:maxInclusive value=\"%d\"/>\n"
                                 "    <xsd:minInclusive value=\"%d\"/>\n"
                                 "  </xsd:restriction>\n",
                                 SHRT_MAX, SHRT_MIN);
                break;
 
            case INT4OID:
                appendStringInfo(&result,
                                 "  <xsd:restriction base=\"xsd:int\">\n"
                                 "    <xsd:maxInclusive value=\"%d\"/>\n"
                                 "    <xsd:minInclusive value=\"%d\"/>\n"
                                 "  </xsd:restriction>\n",
                                 INT_MAX, INT_MIN);
                break;
 
            case INT8OID:
                appendStringInfo(&result,
                                 "  <xsd:restriction base=\"xsd:long\">\n"
                                 "    <xsd:maxInclusive value=\"" INT64_FORMAT "\"/>\n"
                                 "    <xsd:minInclusive value=\"" INT64_FORMAT "\"/>\n"
                                 "  </xsd:restriction>\n",
                                 PG_INT64_MAX,
                                 PG_INT64_MIN);
                break;
 
            case FLOAT4OID:
                appendStringInfoString(&result,
                                       "  <xsd:restriction base=\"xsd:float\"></xsd:restriction>\n");
                break;
 
            case FLOAT8OID:
                appendStringInfoString(&result,
                                       "  <xsd:restriction base=\"xsd:double\"></xsd:restriction>\n");
                break;
 
            case BOOLOID:
                appendStringInfoString(&result,
                                       "  <xsd:restriction base=\"xsd:boolean\"></xsd:restriction>\n");
                break;
 
            case TIMEOID:
            case TIMETZOID:
                {
                    const char *tz = (typeoid == TIMETZOID ? "(\\+|-)\\p{Nd}{2}:\\p{Nd}{2}" : "");
 
                    if (typmod == -1)
                        appendStringInfo(&result,
                                         "  <xsd:restriction base=\"xsd:time\">\n"
                                         "    <xsd:pattern value=\"\\p{Nd}{2}:\\p{Nd}{2}:\\p{Nd}{2}(.\\p{Nd}+)?%s\"/>\n"
                                         "  </xsd:restriction>\n", tz);
                    else if (typmod == 0)
                        appendStringInfo(&result,
                                         "  <xsd:restriction base=\"xsd:time\">\n"
                                         "    <xsd:pattern value=\"\\p{Nd}{2}:\\p{Nd}{2}:\\p{Nd}{2}%s\"/>\n"
                                         "  </xsd:restriction>\n", tz);
                    else
                        appendStringInfo(&result,
                                         "  <xsd:restriction base=\"xsd:time\">\n"
                                         "    <xsd:pattern value=\"\\p{Nd}{2}:\\p{Nd}{2}:\\p{Nd}{2}.\\p{Nd}{%d}%s\"/>\n"
                                         "  </xsd:restriction>\n", typmod - VARHDRSZ, tz);
                    break;
                }
 
            case TIMESTAMPOID:
            case TIMESTAMPTZOID:
                {
                    const char *tz = (typeoid == TIMESTAMPTZOID ? "(\\+|-)\\p{Nd}{2}:\\p{Nd}{2}" : "");
 
                    if (typmod == -1)
                        appendStringInfo(&result,
                                         "  <xsd:restriction base=\"xsd:dateTime\">\n"
                                         "    <xsd:pattern value=\"\\p{Nd}{4}-\\p{Nd}{2}-\\p{Nd}{2}T\\p{Nd}{2}:\\p{Nd}{2}:\\p{Nd}{2}(.\\p{Nd}+)?%s\"/>\n"
                                         "  </xsd:restriction>\n", tz);
                    else if (typmod == 0)
                        appendStringInfo(&result,
                                         "  <xsd:restriction base=\"xsd:dateTime\">\n"
                                         "    <xsd:pattern value=\"\\p{Nd}{4}-\\p{Nd}{2}-\\p{Nd}{2}T\\p{Nd}{2}:\\p{Nd}{2}:\\p{Nd}{2}%s\"/>\n"
                                         "  </xsd:restriction>\n", tz);
                    else
                        appendStringInfo(&result,
                                         "  <xsd:restriction base=\"xsd:dateTime\">\n"
                                         "    <xsd:pattern value=\"\\p{Nd}{4}-\\p{Nd}{2}-\\p{Nd}{2}T\\p{Nd}{2}:\\p{Nd}{2}:\\p{Nd}{2}.\\p{Nd}{%d}%s\"/>\n"
                                         "  </xsd:restriction>\n", typmod - VARHDRSZ, tz);
                    break;
                }
 
            case DATEOID:
                appendStringInfoString(&result,
                                       "  <xsd:restriction base=\"xsd:date\">\n"
                                       "    <xsd:pattern value=\"\\p{Nd}{4}-\\p{Nd}{2}-\\p{Nd}{2}\"/>\n"
                                       "  </xsd:restriction>\n");
                break;
 
            default:
                if (get_typtype(typeoid) == TYPTYPE_DOMAIN)
                {
                    Oid         base_typeoid;
                    int32       base_typmod = -1;
 
                    base_typeoid = getBaseTypeAndTypmod(typeoid, &base_typmod);
 
                    appendStringInfo(&result,
                                     "  <xsd:restriction base=\"%s\"/>\n",
                                     map_sql_type_to_xml_name(base_typeoid, base_typmod));
                }
                break;
        }
        appendStringInfoString(&result, "</xsd:simpleType>\n");
    }
 
    return result.data;
}

References appendStringInfo(), appendStringInfoString(), StringInfoData::data, get_typtype(), getBaseTypeAndTypmod(), initStringInfo(), INT64_FORMAT, map_sql_type_to_xml_name(), PG_INT64_MAX, PG_INT64_MIN, VARHDRSZ, xmlbinary, and XMLBINARY_BASE64.

Referenced by map_sql_typecoll_to_xmlschema_types().

map_sql_typecoll_to_xmlschema_types()

static const char * map_sql_typecoll_to_xmlschema_types ( List *  tupdesc_list )

static

Definition at line 3867 of file xml.c.

{
    List       *uniquetypes = NIL;
    int         i;
    StringInfoData result;
    ListCell   *cell0;
 
    /* extract all column types used in the set of TupleDescs */
    foreach(cell0, tupdesc_list)
    {
        TupleDesc   tupdesc = (TupleDesc) lfirst(cell0);
 
        for (i = 0; i < tupdesc->natts; i++)
        {
            Form_pg_attribute att = TupleDescAttr(tupdesc, i);
 
            if (att->attisdropped)
                continue;
            uniquetypes = list_append_unique_oid(uniquetypes, att->atttypid);
        }
    }
 
    /* add base types of domains */
    foreach(cell0, uniquetypes)
    {
        Oid         typid = lfirst_oid(cell0);
        Oid         basetypid = getBaseType(typid);
 
        if (basetypid != typid)
            uniquetypes = list_append_unique_oid(uniquetypes, basetypid);
    }
 
    /* Convert to textual form */
    initStringInfo(&result);
 
    foreach(cell0, uniquetypes)
    {
        appendStringInfo(&result, "%s\n",
                         map_sql_type_to_xmlschema_type(lfirst_oid(cell0),
                                                        -1));
    }
 
    return result.data;
}

References appendStringInfo(), StringInfoData::data, getBaseType(), i, initStringInfo(), lfirst, lfirst_oid, list_append_unique_oid(), map_sql_type_to_xmlschema_type(), TupleDescData::natts, NIL, and TupleDescAttr().

Referenced by database_to_xmlschema_internal(), map_sql_table_to_xmlschema(), and schema_to_xmlschema_internal().

map_sql_value_to_xml_value()

char * map_sql_value_to_xml_value	(	Datum	value,
		Oid	type,
		bool	xml_escape_strings
	)

Definition at line 2489 of file xml.c.

{
    if (type_is_array_domain(type))
    {
        ArrayType  *array;
        Oid         elmtype;
        int16       elmlen;
        bool        elmbyval;
        char        elmalign;
        int         num_elems;
        Datum      *elem_values;
        bool       *elem_nulls;
        StringInfoData buf;
        int         i;
 
        array = DatumGetArrayTypeP(value);
        elmtype = ARR_ELEMTYPE(array);
        get_typlenbyvalalign(elmtype, &elmlen, &elmbyval, &elmalign);
 
        deconstruct_array(array, elmtype,
                          elmlen, elmbyval, elmalign,
                          &elem_values, &elem_nulls,
                          &num_elems);
 
        initStringInfo(&buf);
 
        for (i = 0; i < num_elems; i++)
        {
            if (elem_nulls[i])
                continue;
            appendStringInfoString(&buf, "<element>");
            appendStringInfoString(&buf,
                                   map_sql_value_to_xml_value(elem_values[i],
                                                              elmtype, true));
            appendStringInfoString(&buf, "</element>");
        }
 
        pfree(elem_values);
        pfree(elem_nulls);
 
        return buf.data;
    }
    else
    {
        Oid         typeOut;
        bool        isvarlena;
        char       *str;
 
        /*
         * Flatten domains; the special-case treatments below should apply to,
         * eg, domains over boolean not just boolean.
         */
        type = getBaseType(type);
 
        /*
         * Special XSD formatting for some data types
         */
        switch (type)
        {
            case BOOLOID:
                if (DatumGetBool(value))
                    return "true";
                else
                    return "false";
 
            case DATEOID:
                {
                    DateADT     date;
                    struct pg_tm tm;
                    char        buf[MAXDATELEN + 1];
 
                    date = DatumGetDateADT(value);
                    /* XSD doesn't support infinite values */
                    if (DATE_NOT_FINITE(date))
                        ereport(ERROR,
                                (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                                 errmsg("date out of range"),
                                 errdetail("XML does not support infinite date values.")));
                    j2date(date + POSTGRES_EPOCH_JDATE,
                           &(tm.tm_year), &(tm.tm_mon), &(tm.tm_mday));
                    EncodeDateOnly(&tm, USE_XSD_DATES, buf);
 
                    return pstrdup(buf);
                }
 
            case TIMESTAMPOID:
                {
                    Timestamp   timestamp;
                    struct pg_tm tm;
                    fsec_t      fsec;
                    char        buf[MAXDATELEN + 1];
 
                    timestamp = DatumGetTimestamp(value);
 
                    /* XSD doesn't support infinite values */
                    if (TIMESTAMP_NOT_FINITE(timestamp))
                        ereport(ERROR,
                                (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                                 errmsg("timestamp out of range"),
                                 errdetail("XML does not support infinite timestamp values.")));
                    else if (timestamp2tm(timestamp, NULL, &tm, &fsec, NULL, NULL) == 0)
                        EncodeDateTime(&tm, fsec, false, 0, NULL, USE_XSD_DATES, buf);
                    else
                        ereport(ERROR,
                                (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                                 errmsg("timestamp out of range")));
 
                    return pstrdup(buf);
                }
 
            case TIMESTAMPTZOID:
                {
                    TimestampTz timestamp;
                    struct pg_tm tm;
                    int         tz;
                    fsec_t      fsec;
                    const char *tzn = NULL;
                    char        buf[MAXDATELEN + 1];
 
                    timestamp = DatumGetTimestamp(value);
 
                    /* XSD doesn't support infinite values */
                    if (TIMESTAMP_NOT_FINITE(timestamp))
                        ereport(ERROR,
                                (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                                 errmsg("timestamp out of range"),
                                 errdetail("XML does not support infinite timestamp values.")));
                    else if (timestamp2tm(timestamp, &tz, &tm, &fsec, &tzn, NULL) == 0)
                        EncodeDateTime(&tm, fsec, true, tz, tzn, USE_XSD_DATES, buf);
                    else
                        ereport(ERROR,
                                (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                                 errmsg("timestamp out of range")));
 
                    return pstrdup(buf);
                }
 
#ifdef USE_LIBXML
            case BYTEAOID:
                {
                    bytea      *bstr = DatumGetByteaPP(value);
                    PgXmlErrorContext *xmlerrcxt;
                    volatile xmlBufferPtr buf = NULL;
                    volatile xmlTextWriterPtr writer = NULL;
                    char       *result;
 
                    xmlerrcxt = pg_xml_init(PG_XML_STRICTNESS_ALL);
 
                    PG_TRY();
                    {
                        buf = xmlBufferCreate();
                        if (buf == NULL || xmlerrcxt->err_occurred)
                            xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                                        "could not allocate xmlBuffer");
                        writer = xmlNewTextWriterMemory(buf, 0);
                        if (writer == NULL || xmlerrcxt->err_occurred)
                            xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                                        "could not allocate xmlTextWriter");
 
                        if (xmlbinary == XMLBINARY_BASE64)
                            xmlTextWriterWriteBase64(writer, VARDATA_ANY(bstr),
                                                     0, VARSIZE_ANY_EXHDR(bstr));
                        else
                            xmlTextWriterWriteBinHex(writer, VARDATA_ANY(bstr),
                                                     0, VARSIZE_ANY_EXHDR(bstr));
 
                        /* we MUST do this now to flush data out to the buffer */
                        xmlFreeTextWriter(writer);
                        writer = NULL;
 
                        result = pstrdup((const char *) xmlBufferContent(buf));
                    }
                    PG_CATCH();
                    {
                        if (writer)
                            xmlFreeTextWriter(writer);
                        if (buf)
                            xmlBufferFree(buf);
 
                        pg_xml_done(xmlerrcxt, true);
 
                        PG_RE_THROW();
                    }
                    PG_END_TRY();
 
                    xmlBufferFree(buf);
 
                    pg_xml_done(xmlerrcxt, false);
 
                    return result;
                }
#endif                          /* USE_LIBXML */
 
        }
 
        /*
         * otherwise, just use the type's native text representation
         */
        getTypeOutputInfo(type, &typeOut, &isvarlena);
        str = OidOutputFunctionCall(typeOut, value);
 
        /* ... exactly as-is for XML, and when escaping is not wanted */
        if (type == XMLOID || !xml_escape_strings)
            return str;
 
        /* otherwise, translate special characters as needed */
        return escape_xml(str);
    }
}

References appendStringInfoString(), ARR_ELEMTYPE, buf, DATE_NOT_FINITE, DatumGetArrayTypeP, DatumGetBool(), DatumGetByteaPP, DatumGetDateADT(), DatumGetTimestamp(), deconstruct_array(), EncodeDateOnly(), EncodeDateTime(), ereport, errcode(), errdetail(), errmsg(), ERROR, escape_xml(), get_typlenbyvalalign(), getBaseType(), getTypeOutputInfo(), i, initStringInfo(), j2date(), map_sql_value_to_xml_value(), MAXDATELEN, OidOutputFunctionCall(), pfree(), PG_CATCH, PG_END_TRY, PG_RE_THROW, PG_TRY, pg_xml_done(), pg_xml_init(), PG_XML_STRICTNESS_ALL, POSTGRES_EPOCH_JDATE, pstrdup(), str, timestamp2tm(), TIMESTAMP_NOT_FINITE, tm, pg_tm::tm_mday, pg_tm::tm_mon, pg_tm::tm_year, type, type_is_array_domain, USE_XSD_DATES, value, VARDATA_ANY, VARSIZE_ANY_EXHDR, xml_ereport(), xmlbinary, and XMLBINARY_BASE64.

Referenced by ExecEvalXmlExpr(), map_sql_value_to_xml_value(), SPI_sql_row_to_xmlelement(), and xmlelement().

map_xml_name_to_sql_identifier()

char * map_xml_name_to_sql_identifier

(

const char *

name

)

Definition at line 2447 of file xml.c.

{
    StringInfoData buf;
    const char *p;
 
    initStringInfo(&buf);
 
    for (p = name; *p; p += pg_mblen(p))
    {
        if (*p == '_' && *(p + 1) == 'x'
            && isxdigit((unsigned char) *(p + 2))
            && isxdigit((unsigned char) *(p + 3))
            && isxdigit((unsigned char) *(p + 4))
            && isxdigit((unsigned char) *(p + 5))
            && *(p + 6) == '_')
        {
            char        cbuf[MAX_UNICODE_EQUIVALENT_STRING + 1];
            unsigned int u;
 
            sscanf(p + 2, "%X", &u);
            pg_unicode_to_server(u, (unsigned char *) cbuf);
            appendStringInfoString(&buf, cbuf);
            p += 6;
        }
        else
            appendBinaryStringInfo(&buf, p, pg_mblen(p));
    }
 
    return buf.data;
}

References appendBinaryStringInfo(), appendStringInfoString(), buf, initStringInfo(), MAX_UNICODE_EQUIVALENT_STRING, name, pg_mblen(), and pg_unicode_to_server().

Referenced by get_rule_expr().

query_to_oid_list()

static List * query_to_oid_list ( const char *  query )

static

Definition at line 2797 of file xml.c.

{
    uint64      i;
    List       *list = NIL;
    int         spi_result;
 
    spi_result = SPI_execute(query, true, 0);
    if (spi_result != SPI_OK_SELECT)
        elog(ERROR, "SPI_execute returned %s for %s",
             SPI_result_code_string(spi_result), query);
 
    for (i = 0; i < SPI_processed; i++)
    {
        Datum       oid;
        bool        isnull;
 
        oid = SPI_getbinval(SPI_tuptable->vals[i],
                            SPI_tuptable->tupdesc,
                            1,
                            &isnull);
        if (!isnull)
            list = lappend_oid(list, DatumGetObjectId(oid));
    }
 
    return list;
}

References DatumGetObjectId(), elog, ERROR, i, lappend_oid(), sort-test::list, NIL, SPI_execute(), SPI_getbinval(), SPI_OK_SELECT, SPI_processed, SPI_result_code_string(), SPI_tuptable, SPITupleTable::tupdesc, and SPITupleTable::vals.

Referenced by database_get_xml_visible_schemas(), database_get_xml_visible_tables(), and schema_get_xml_visible_tables().

query_to_xml()

Datum query_to_xml

(

PG_FUNCTION_ARGS

)

Definition at line 2910 of file xml.c.

{
    char       *query = text_to_cstring(PG_GETARG_TEXT_PP(0));
    bool        nulls = PG_GETARG_BOOL(1);
    bool        tableforest = PG_GETARG_BOOL(2);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(3));
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(query_to_xml_internal(query, NULL,
                                                                NULL, nulls, tableforest,
                                                                targetns, true)));
}

References PG_GETARG_BOOL, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, query_to_xml_internal(), stringinfo_to_xmltype(), and text_to_cstring().

query_to_xml_and_xmlschema()

Datum query_to_xml_and_xmlschema

(

PG_FUNCTION_ARGS

)

Definition at line 3156 of file xml.c.

{
    char       *query = text_to_cstring(PG_GETARG_TEXT_PP(0));
    bool        nulls = PG_GETARG_BOOL(1);
    bool        tableforest = PG_GETARG_BOOL(2);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(3));
 
    const char *xmlschema;
    SPIPlanPtr  plan;
    Portal      portal;
 
    SPI_connect();
 
    if ((plan = SPI_prepare(query, 0, NULL)) == NULL)
        elog(ERROR, "SPI_prepare(\"%s\") failed", query);
 
    if ((portal = SPI_cursor_open(NULL, plan, NULL, NULL, true)) == NULL)
        elog(ERROR, "SPI_cursor_open(\"%s\") failed", query);
 
    xmlschema = _SPI_strdup(map_sql_table_to_xmlschema(portal->tupDesc,
                                                       InvalidOid, nulls, tableforest, targetns));
    SPI_cursor_close(portal);
    SPI_finish();
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(query_to_xml_internal(query, NULL,
                                                                xmlschema, nulls, tableforest,
                                                                targetns, true)));
}

References _SPI_strdup(), elog, ERROR, InvalidOid, map_sql_table_to_xmlschema(), PG_GETARG_BOOL, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, plan, query_to_xml_internal(), SPI_connect(), SPI_cursor_close(), SPI_cursor_open(), SPI_finish(), SPI_prepare(), stringinfo_to_xmltype(), text_to_cstring(), and PortalData::tupDesc.

query_to_xml_internal()

static StringInfo query_to_xml_internal ( const char *  query, char *  tablename, const char *  xmlschema, bool  nulls, bool  tableforest, const char *  targetns, bool  top_level  )

static

Definition at line 3012 of file xml.c.

{
    StringInfo  result;
    char       *xmltn;
    uint64      i;
 
    if (tablename)
        xmltn = map_sql_identifier_to_xml_name(tablename, true, false);
    else
        xmltn = "table";
 
    result = makeStringInfo();
 
    SPI_connect();
    if (SPI_execute(query, true, 0) != SPI_OK_SELECT)
        ereport(ERROR,
                (errcode(ERRCODE_DATA_EXCEPTION),
                 errmsg("invalid query")));
 
    if (!tableforest)
    {
        xmldata_root_element_start(result, xmltn, xmlschema,
                                   targetns, top_level);
        appendStringInfoChar(result, '\n');
    }
 
    if (xmlschema)
        appendStringInfo(result, "%s\n\n", xmlschema);
 
    for (i = 0; i < SPI_processed; i++)
        SPI_sql_row_to_xmlelement(i, result, tablename, nulls,
                                  tableforest, targetns, top_level);
 
    if (!tableforest)
        xmldata_root_element_end(result, xmltn);
 
    SPI_finish();
 
    return result;
}

References appendStringInfo(), appendStringInfoChar(), ereport, errcode(), errmsg(), ERROR, i, makeStringInfo(), map_sql_identifier_to_xml_name(), SPI_connect(), SPI_execute(), SPI_finish(), SPI_OK_SELECT, SPI_processed, SPI_sql_row_to_xmlelement(), xmldata_root_element_end(), and xmldata_root_element_start().

Referenced by query_to_xml(), query_to_xml_and_xmlschema(), and table_to_xml_internal().

query_to_xmlschema()

Datum query_to_xmlschema

(

PG_FUNCTION_ARGS

)

Definition at line 3076 of file xml.c.

{
    char       *query = text_to_cstring(PG_GETARG_TEXT_PP(0));
    bool        nulls = PG_GETARG_BOOL(1);
    bool        tableforest = PG_GETARG_BOOL(2);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(3));
    const char *result;
    SPIPlanPtr  plan;
    Portal      portal;
 
    SPI_connect();
 
    if ((plan = SPI_prepare(query, 0, NULL)) == NULL)
        elog(ERROR, "SPI_prepare(\"%s\") failed", query);
 
    if ((portal = SPI_cursor_open(NULL, plan, NULL, NULL, true)) == NULL)
        elog(ERROR, "SPI_cursor_open(\"%s\") failed", query);
 
    result = _SPI_strdup(map_sql_table_to_xmlschema(portal->tupDesc,
                                                    InvalidOid, nulls,
                                                    tableforest, targetns));
    SPI_cursor_close(portal);
    SPI_finish();
 
    PG_RETURN_XML_P(cstring_to_xmltype(result));
}

References _SPI_strdup(), cstring_to_xmltype(), elog, ERROR, InvalidOid, map_sql_table_to_xmlschema(), PG_GETARG_BOOL, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, plan, SPI_connect(), SPI_cursor_close(), SPI_cursor_open(), SPI_finish(), SPI_prepare(), text_to_cstring(), and PortalData::tupDesc.

schema_get_xml_visible_tables()

static List * schema_get_xml_visible_tables ( Oid  nspid )

static

Definition at line 2826 of file xml.c.

{
    StringInfoData query;
 
    initStringInfo(&query);
    appendStringInfo(&query, "SELECT oid FROM pg_catalog.pg_class"
                     " WHERE relnamespace = %u AND relkind IN ("
                     CppAsString2(RELKIND_RELATION) ","
                     CppAsString2(RELKIND_MATVIEW) ","
                     CppAsString2(RELKIND_VIEW) ")"
                     " AND pg_catalog.has_table_privilege (oid, 'SELECT')"
                     " ORDER BY relname;", nspid);
 
    return query_to_oid_list(query.data);
}

References appendStringInfo(), CppAsString2, StringInfoData::data, initStringInfo(), nspid, and query_to_oid_list().

Referenced by schema_to_xml_internal(), and schema_to_xmlschema_internal().

schema_to_xml()

Datum schema_to_xml

(

PG_FUNCTION_ARGS

)

Definition at line 3235 of file xml.c.

{
    Name        name = PG_GETARG_NAME(0);
    bool        nulls = PG_GETARG_BOOL(1);
    bool        tableforest = PG_GETARG_BOOL(2);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(3));
 
    char       *schemaname;
    Oid         nspid;
 
    schemaname = NameStr(*name);
    nspid = LookupExplicitNamespace(schemaname, false);
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(schema_to_xml_internal(nspid, NULL,
                                                                 nulls, tableforest, targetns, true)));
}

References LookupExplicitNamespace(), name, NameStr, nspid, PG_GETARG_BOOL, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, schema_to_xml_internal(), stringinfo_to_xmltype(), and text_to_cstring().

schema_to_xml_and_xmlschema()

Datum schema_to_xml_and_xmlschema

(

PG_FUNCTION_ARGS

)

Definition at line 3339 of file xml.c.

{
    Name        name = PG_GETARG_NAME(0);
    bool        nulls = PG_GETARG_BOOL(1);
    bool        tableforest = PG_GETARG_BOOL(2);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(3));
    char       *schemaname;
    Oid         nspid;
    StringInfo  xmlschema;
 
    schemaname = NameStr(*name);
    nspid = LookupExplicitNamespace(schemaname, false);
 
    xmlschema = schema_to_xmlschema_internal(schemaname, nulls,
                                             tableforest, targetns);
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(schema_to_xml_internal(nspid,
                                                                 xmlschema->data, nulls,
                                                                 tableforest, targetns, true)));
}

References StringInfoData::data, LookupExplicitNamespace(), name, NameStr, nspid, PG_GETARG_BOOL, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, schema_to_xml_internal(), schema_to_xmlschema_internal(), stringinfo_to_xmltype(), and text_to_cstring().

schema_to_xml_internal()

static StringInfo schema_to_xml_internal ( Oid  nspid, const char *  xmlschema, bool  nulls, bool  tableforest, const char *  targetns, bool  top_level  )

static

Definition at line 3192 of file xml.c.

{
    StringInfo  result;
    char       *xmlsn;
    List       *relid_list;
    ListCell   *cell;
 
    xmlsn = map_sql_identifier_to_xml_name(get_namespace_name(nspid),
                                           true, false);
    result = makeStringInfo();
 
    xmldata_root_element_start(result, xmlsn, xmlschema, targetns, top_level);
    appendStringInfoChar(result, '\n');
 
    if (xmlschema)
        appendStringInfo(result, "%s\n\n", xmlschema);
 
    SPI_connect();
 
    relid_list = schema_get_xml_visible_tables(nspid);
 
    foreach(cell, relid_list)
    {
        Oid         relid = lfirst_oid(cell);
        StringInfo  subres;
 
        subres = table_to_xml_internal(relid, NULL, nulls, tableforest,
                                       targetns, false);
 
        appendBinaryStringInfo(result, subres->data, subres->len);
        appendStringInfoChar(result, '\n');
    }
 
    SPI_finish();
 
    xmldata_root_element_end(result, xmlsn);
 
    return result;
}

References appendBinaryStringInfo(), appendStringInfo(), appendStringInfoChar(), StringInfoData::data, get_namespace_name(), StringInfoData::len, lfirst_oid, makeStringInfo(), map_sql_identifier_to_xml_name(), nspid, schema_get_xml_visible_tables(), SPI_connect(), SPI_finish(), table_to_xml_internal(), xmldata_root_element_end(), and xmldata_root_element_start().

Referenced by database_to_xml_internal(), schema_to_xml(), and schema_to_xml_and_xmlschema().

schema_to_xmlschema()

Datum schema_to_xmlschema

(

PG_FUNCTION_ARGS

)

Definition at line 3326 of file xml.c.

{
    Name        name = PG_GETARG_NAME(0);
    bool        nulls = PG_GETARG_BOOL(1);
    bool        tableforest = PG_GETARG_BOOL(2);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(3));
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(schema_to_xmlschema_internal(NameStr(*name),
                                                                       nulls, tableforest, targetns)));
}

References name, NameStr, PG_GETARG_BOOL, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, schema_to_xmlschema_internal(), stringinfo_to_xmltype(), and text_to_cstring().

schema_to_xmlschema_internal()

static StringInfo schema_to_xmlschema_internal ( const char *  schemaname, bool  nulls, bool  tableforest, const char *  targetns  )

static

Definition at line 3281 of file xml.c.

{
    Oid         nspid;
    List       *relid_list;
    List       *tupdesc_list;
    ListCell   *cell;
    StringInfo  result;
 
    result = makeStringInfo();
 
    nspid = LookupExplicitNamespace(schemaname, false);
 
    xsd_schema_element_start(result, targetns);
 
    SPI_connect();
 
    relid_list = schema_get_xml_visible_tables(nspid);
 
    tupdesc_list = NIL;
    foreach(cell, relid_list)
    {
        Relation    rel;
 
        rel = table_open(lfirst_oid(cell), AccessShareLock);
        tupdesc_list = lappend(tupdesc_list, CreateTupleDescCopy(rel->rd_att));
        table_close(rel, NoLock);
    }
 
    appendStringInfoString(result,
                           map_sql_typecoll_to_xmlschema_types(tupdesc_list));
 
    appendStringInfoString(result,
                           map_sql_schema_to_xmlschema_types(nspid, relid_list,
                                                             nulls, tableforest, targetns));
 
    xsd_schema_element_end(result);
 
    SPI_finish();
 
    return result;
}

References AccessShareLock, appendStringInfoString(), CreateTupleDescCopy(), lappend(), lfirst_oid, LookupExplicitNamespace(), makeStringInfo(), map_sql_schema_to_xmlschema_types(), map_sql_typecoll_to_xmlschema_types(), NIL, NoLock, nspid, RelationData::rd_att, schema_get_xml_visible_tables(), SPI_connect(), SPI_finish(), table_close(), table_open(), xsd_schema_element_end(), and xsd_schema_element_start().

Referenced by schema_to_xml_and_xmlschema(), and schema_to_xmlschema().

SPI_sql_row_to_xmlelement()

static void SPI_sql_row_to_xmlelement ( uint64  rownum, StringInfo  result, char *  tablename, bool  nulls, bool  tableforest, const char *  targetns, bool  top_level  )

static

Definition at line 4097 of file xml.c.

{
    int         i;
    char       *xmltn;
 
    if (tablename)
        xmltn = map_sql_identifier_to_xml_name(tablename, true, false);
    else
    {
        if (tableforest)
            xmltn = "row";
        else
            xmltn = "table";
    }
 
    if (tableforest)
        xmldata_root_element_start(result, xmltn, NULL, targetns, top_level);
    else
        appendStringInfoString(result, "<row>\n");
 
    for (i = 1; i <= SPI_tuptable->tupdesc->natts; i++)
    {
        char       *colname;
        Datum       colval;
        bool        isnull;
 
        colname = map_sql_identifier_to_xml_name(SPI_fname(SPI_tuptable->tupdesc, i),
                                                 true, false);
        colval = SPI_getbinval(SPI_tuptable->vals[rownum],
                               SPI_tuptable->tupdesc,
                               i,
                               &isnull);
        if (isnull)
        {
            if (nulls)
                appendStringInfo(result, "  <%s xsi:nil=\"true\"/>\n", colname);
        }
        else
            appendStringInfo(result, "  <%s>%s</%s>\n",
                             colname,
                             map_sql_value_to_xml_value(colval,
                                                        SPI_gettypeid(SPI_tuptable->tupdesc, i), true),
                             colname);
    }
 
    if (tableforest)
    {
        xmldata_root_element_end(result, xmltn);
        appendStringInfoChar(result, '\n');
    }
    else
        appendStringInfoString(result, "</row>\n\n");
}

References appendStringInfo(), appendStringInfoChar(), appendStringInfoString(), i, map_sql_identifier_to_xml_name(), map_sql_value_to_xml_value(), TupleDescData::natts, SPI_fname(), SPI_getbinval(), SPI_gettypeid(), SPI_tuptable, SPITupleTable::tupdesc, SPITupleTable::vals, xmldata_root_element_end(), and xmldata_root_element_start().

Referenced by cursor_to_xml(), and query_to_xml_internal().

stringinfo_to_xmltype()

static xmltype * stringinfo_to_xmltype ( StringInfo  buf )

static

Definition at line 467 of file xml.c.

{
    return (xmltype *) cstring_to_text_with_len(buf->data, buf->len);
}

References buf, and cstring_to_text_with_len().

Referenced by cursor_to_xml(), database_to_xml(), database_to_xml_and_xmlschema(), database_to_xmlschema(), query_to_xml(), query_to_xml_and_xmlschema(), schema_to_xml(), schema_to_xml_and_xmlschema(), schema_to_xmlschema(), table_to_xml(), table_to_xml_and_xmlschema(), xmlcomment(), xmlconcat(), xmlpi(), and xmlroot().

table_to_xml()

Datum table_to_xml

(

PG_FUNCTION_ARGS

)

Definition at line 2896 of file xml.c.

{
    Oid         relid = PG_GETARG_OID(0);
    bool        nulls = PG_GETARG_BOOL(1);
    bool        tableforest = PG_GETARG_BOOL(2);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(3));
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(table_to_xml_internal(relid, NULL,
                                                                nulls, tableforest,
                                                                targetns, true)));
}

References PG_GETARG_BOOL, PG_GETARG_OID, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, stringinfo_to_xmltype(), table_to_xml_internal(), and text_to_cstring().

table_to_xml_and_xmlschema()

Datum table_to_xml_and_xmlschema

(

PG_FUNCTION_ARGS

)

Definition at line 3135 of file xml.c.

{
    Oid         relid = PG_GETARG_OID(0);
    bool        nulls = PG_GETARG_BOOL(1);
    bool        tableforest = PG_GETARG_BOOL(2);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(3));
    Relation    rel;
    const char *xmlschema;
 
    rel = table_open(relid, AccessShareLock);
    xmlschema = map_sql_table_to_xmlschema(rel->rd_att, relid, nulls,
                                           tableforest, targetns);
    table_close(rel, NoLock);
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(table_to_xml_internal(relid,
                                                                xmlschema, nulls, tableforest,
                                                                targetns, true)));
}

References AccessShareLock, map_sql_table_to_xmlschema(), NoLock, PG_GETARG_BOOL, PG_GETARG_OID, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, RelationData::rd_att, stringinfo_to_xmltype(), table_close(), table_open(), table_to_xml_internal(), and text_to_cstring().

table_to_xml_internal()

static StringInfo table_to_xml_internal ( Oid  relid, const char *  xmlschema, bool  nulls, bool  tableforest, const char *  targetns, bool  top_level  )

static

Definition at line 2879 of file xml.c.

{
    StringInfoData query;
 
    initStringInfo(&query);
    appendStringInfo(&query, "SELECT * FROM %s",
                     DatumGetCString(DirectFunctionCall1(regclassout,
                                                         ObjectIdGetDatum(relid))));
    return query_to_xml_internal(query.data, get_rel_name(relid),
                                 xmlschema, nulls, tableforest,
                                 targetns, top_level);
}

References appendStringInfo(), StringInfoData::data, DatumGetCString(), DirectFunctionCall1, get_rel_name(), initStringInfo(), ObjectIdGetDatum(), query_to_xml_internal(), and regclassout().

Referenced by schema_to_xml_internal(), table_to_xml(), and table_to_xml_and_xmlschema().

table_to_xmlschema()

Datum table_to_xmlschema

(

PG_FUNCTION_ARGS

)

Definition at line 3057 of file xml.c.

{
    Oid         relid = PG_GETARG_OID(0);
    bool        nulls = PG_GETARG_BOOL(1);
    bool        tableforest = PG_GETARG_BOOL(2);
    const char *targetns = text_to_cstring(PG_GETARG_TEXT_PP(3));
    const char *result;
    Relation    rel;
 
    rel = table_open(relid, AccessShareLock);
    result = map_sql_table_to_xmlschema(rel->rd_att, relid, nulls,
                                        tableforest, targetns);
    table_close(rel, NoLock);
 
    PG_RETURN_XML_P(cstring_to_xmltype(result));
}

References AccessShareLock, cstring_to_xmltype(), map_sql_table_to_xmlschema(), NoLock, PG_GETARG_BOOL, PG_GETARG_OID, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, RelationData::rd_att, table_close(), table_open(), and text_to_cstring().

texttoxml()

Datum texttoxml

(

PG_FUNCTION_ARGS

)

Definition at line 637 of file xml.c.

{
    text       *data = PG_GETARG_TEXT_PP(0);
 
    PG_RETURN_XML_P(xmlparse(data, xmloption, true));
}

References data, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, xmloption, and xmlparse().

xml_in()

Datum xml_in

(

PG_FUNCTION_ARGS

)

Definition at line 273 of file xml.c.

{
#ifdef USE_LIBXML
    char       *s = PG_GETARG_CSTRING(0);
    xmltype    *vardata;
    xmlDocPtr   doc;
 
    /* Build the result object. */
    vardata = (xmltype *) cstring_to_text(s);
 
    /*
     * Parse the data to check if it is well-formed XML data.
     *
     * Note: we don't need to worry about whether a soft error is detected.
     */
    doc = xml_parse(vardata, xmloption, true, GetDatabaseEncoding(),
                    NULL, NULL, fcinfo->context);
    if (doc != NULL)
        xmlFreeDoc(doc);
 
    PG_RETURN_XML_P(vardata);
#else
    NO_XML_SUPPORT();
    return 0;
#endif
}

References cstring_to_text(), GetDatabaseEncoding(), NO_XML_SUPPORT, PG_GETARG_CSTRING, PG_RETURN_XML_P, and xmloption.

xml_is_document()

bool xml_is_document

(

xmltype *

arg

)

Definition at line 1124 of file xml.c.

{
#ifdef USE_LIBXML
    xmlDocPtr   doc;
    ErrorSaveContext escontext = {T_ErrorSaveContext};
 
    /*
     * We'll report "true" if no soft error is reported by xml_parse().
     */
    doc = xml_parse((text *) arg, XMLOPTION_DOCUMENT, true,
                    GetDatabaseEncoding(), NULL, NULL, (Node *) &escontext);
    if (doc)
        xmlFreeDoc(doc);
 
    return !escontext.error_occurred;
#else                           /* not USE_LIBXML */
    NO_XML_SUPPORT();
    return false;
#endif                          /* not USE_LIBXML */
}

References arg, ErrorSaveContext::error_occurred, GetDatabaseEncoding(), NO_XML_SUPPORT, and XMLOPTION_DOCUMENT.

Referenced by ExecEvalXmlExpr().

xml_is_well_formed()

Datum xml_is_well_formed

(

PG_FUNCTION_ARGS

)

Definition at line 4620 of file xml.c.

{
#ifdef USE_LIBXML
    text       *data = PG_GETARG_TEXT_PP(0);
 
    PG_RETURN_BOOL(wellformed_xml(data, xmloption));
#else
    NO_XML_SUPPORT();
    return 0;
#endif                          /* not USE_LIBXML */
}

References data, NO_XML_SUPPORT, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, and xmloption.

xml_is_well_formed_content()

Datum xml_is_well_formed_content

(

PG_FUNCTION_ARGS

)

Definition at line 4646 of file xml.c.

{
#ifdef USE_LIBXML
    text       *data = PG_GETARG_TEXT_PP(0);
 
    PG_RETURN_BOOL(wellformed_xml(data, XMLOPTION_CONTENT));
#else
    NO_XML_SUPPORT();
    return 0;
#endif                          /* not USE_LIBXML */
}

References data, NO_XML_SUPPORT, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, and XMLOPTION_CONTENT.

xml_is_well_formed_document()

Datum xml_is_well_formed_document

(

PG_FUNCTION_ARGS

)

Definition at line 4633 of file xml.c.

{
#ifdef USE_LIBXML
    text       *data = PG_GETARG_TEXT_PP(0);
 
    PG_RETURN_BOOL(wellformed_xml(data, XMLOPTION_DOCUMENT));
#else
    NO_XML_SUPPORT();
    return 0;
#endif                          /* not USE_LIBXML */
}

References data, NO_XML_SUPPORT, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, and XMLOPTION_DOCUMENT.

xml_out()

Datum xml_out

(

PG_FUNCTION_ARGS

)

Definition at line 356 of file xml.c.

{
    xmltype    *x = PG_GETARG_XML_P(0);
 
    /*
     * xml_out removes the encoding property in all cases.  This is because we
     * cannot control from here whether the datum will be converted to a
     * different client encoding, so we'd do more harm than good by including
     * it.
     */
    PG_RETURN_CSTRING(xml_out_internal(x, 0));
}

References PG_GETARG_XML_P, PG_RETURN_CSTRING, x, and xml_out_internal().

xml_out_internal()

static char * xml_out_internal ( xmltype *  x, pg_enc  target_encoding  )

static

Definition at line 312 of file xml.c.

{
    char       *str = text_to_cstring((text *) x);
 
#ifdef USE_LIBXML
    size_t      len = strlen(str);
    xmlChar    *version;
    int         standalone;
    int         res_code;
 
    if ((res_code = parse_xml_decl((xmlChar *) str,
                                   &len, &version, NULL, &standalone)) == 0)
    {
        StringInfoData buf;
 
        initStringInfo(&buf);
 
        if (!print_xml_decl(&buf, version, target_encoding, standalone))
        {
            /*
             * If we are not going to produce an XML declaration, eat a single
             * newline in the original string to prevent empty first lines in
             * the output.
             */
            if (*(str + len) == '\n')
                len += 1;
        }
        appendStringInfoString(&buf, str + len);
 
        pfree(str);
 
        return buf.data;
    }
 
    ereport(WARNING,
            errcode(ERRCODE_DATA_CORRUPTED),
            errmsg_internal("could not parse XML declaration in stored value"),
            errdetail_for_xml_code(res_code));
#endif
    return str;
}

References appendStringInfoString(), buf, ereport, errcode(), ERRCODE_DATA_CORRUPTED, errmsg_internal(), initStringInfo(), len, pfree(), str, text_to_cstring(), WARNING, and x.

Referenced by xml_out(), xml_send(), and XmlTableSetDocument().

xml_recv()

Datum xml_recv

(

PG_FUNCTION_ARGS

)

Definition at line 371 of file xml.c.

{
#ifdef USE_LIBXML
    StringInfo  buf = (StringInfo) PG_GETARG_POINTER(0);
    xmltype    *result;
    char       *str;
    char       *newstr;
    int         nbytes;
    xmlDocPtr   doc;
    xmlChar    *encodingStr = NULL;
    int         encoding;
 
    /*
     * Read the data in raw format. We don't know yet what the encoding is, as
     * that information is embedded in the xml declaration; so we have to
     * parse that before converting to server encoding.
     */
    nbytes = buf->len - buf->cursor;
    str = (char *) pq_getmsgbytes(buf, nbytes);
 
    /*
     * We need a null-terminated string to pass to parse_xml_decl().  Rather
     * than make a separate copy, make the temporary result one byte bigger
     * than it needs to be.
     */
    result = palloc(nbytes + 1 + VARHDRSZ);
    SET_VARSIZE(result, nbytes + VARHDRSZ);
    memcpy(VARDATA(result), str, nbytes);
    str = VARDATA(result);
    str[nbytes] = '\0';
 
    parse_xml_decl((const xmlChar *) str, NULL, NULL, &encodingStr, NULL);
 
    /*
     * If encoding wasn't explicitly specified in the XML header, treat it as
     * UTF-8, as that's the default in XML. This is different from xml_in(),
     * where the input has to go through the normal client to server encoding
     * conversion.
     */
    encoding = encodingStr ? xmlChar_to_encoding(encodingStr) : PG_UTF8;
 
    /*
     * Parse the data to check if it is well-formed XML data.  Assume that
     * xml_parse will throw ERROR if not.
     */
    doc = xml_parse(result, xmloption, true, encoding, NULL, NULL, NULL);
    xmlFreeDoc(doc);
 
    /* Now that we know what we're dealing with, convert to server encoding */
    newstr = pg_any_to_server(str, nbytes, encoding);
 
    if (newstr != str)
    {
        pfree(result);
        result = (xmltype *) cstring_to_text(newstr);
        pfree(newstr);
    }
 
    PG_RETURN_XML_P(result);
#else
    NO_XML_SUPPORT();
    return 0;
#endif
}

References buf, cstring_to_text(), encoding, NO_XML_SUPPORT, palloc(), pfree(), pg_any_to_server(), PG_GETARG_POINTER, PG_RETURN_XML_P, PG_UTF8, pq_getmsgbytes(), SET_VARSIZE, str, VARDATA, VARHDRSZ, and xmloption.

xml_send()

Datum xml_send

(

PG_FUNCTION_ARGS

)

Definition at line 438 of file xml.c.

{
    xmltype    *x = PG_GETARG_XML_P(0);
    char       *outval;
    StringInfoData buf;
 
    /*
     * xml_out_internal doesn't convert the encoding, it just prints the right
     * declaration. pq_sendtext will do the conversion.
     */
    outval = xml_out_internal(x, pg_get_client_encoding());
 
    pq_begintypsend(&buf);
    pq_sendtext(&buf, outval, strlen(outval));
    pfree(outval);
    PG_RETURN_BYTEA_P(pq_endtypsend(&buf));
}

References buf, pfree(), pg_get_client_encoding(), PG_GETARG_XML_P, PG_RETURN_BYTEA_P, pq_begintypsend(), pq_endtypsend(), pq_sendtext(), x, and xml_out_internal().

xmlcomment()

Datum xmlcomment

(

PG_FUNCTION_ARGS

)

Definition at line 491 of file xml.c.

{
#ifdef USE_LIBXML
    text       *arg = PG_GETARG_TEXT_PP(0);
    char       *argdata = VARDATA_ANY(arg);
    int         len = VARSIZE_ANY_EXHDR(arg);
    StringInfoData buf;
    int         i;
 
    /* check for "--" in string or "-" at the end */
    for (i = 1; i < len; i++)
    {
        if (argdata[i] == '-' && argdata[i - 1] == '-')
            ereport(ERROR,
                    (errcode(ERRCODE_INVALID_XML_COMMENT),
                     errmsg("invalid XML comment")));
    }
    if (len > 0 && argdata[len - 1] == '-')
        ereport(ERROR,
                (errcode(ERRCODE_INVALID_XML_COMMENT),
                 errmsg("invalid XML comment")));
 
    initStringInfo(&buf);
    appendStringInfoString(&buf, "<!--");
    appendStringInfoText(&buf, arg);
    appendStringInfoString(&buf, "-->");
 
    PG_RETURN_XML_P(stringinfo_to_xmltype(&buf));
#else
    NO_XML_SUPPORT();
    return 0;
#endif
}

References appendStringInfoString(), appendStringInfoText(), arg, buf, ereport, errcode(), errmsg(), ERROR, i, initStringInfo(), len, NO_XML_SUPPORT, PG_GETARG_TEXT_PP, PG_RETURN_XML_P, stringinfo_to_xmltype(), VARDATA_ANY, and VARSIZE_ANY_EXHDR.

xmlconcat()

xmltype * xmlconcat

(

List *

args

)

Definition at line 553 of file xml.c.

{
#ifdef USE_LIBXML
    int         global_standalone = 1;
    xmlChar    *global_version = NULL;
    bool        global_version_no_value = false;
    StringInfoData buf;
    ListCell   *v;
 
    initStringInfo(&buf);
    foreach(v, args)
    {
        xmltype    *x = DatumGetXmlP(PointerGetDatum(lfirst(v)));
        size_t      len;
        xmlChar    *version;
        int         standalone;
        char       *str;
 
        len = VARSIZE(x) - VARHDRSZ;
        str = text_to_cstring((text *) x);
 
        parse_xml_decl((xmlChar *) str, &len, &version, NULL, &standalone);
 
        if (standalone == 0 && global_standalone == 1)
            global_standalone = 0;
        if (standalone < 0)
            global_standalone = -1;
 
        if (!version)
            global_version_no_value = true;
        else if (!global_version)
            global_version = version;
        else if (xmlStrcmp(version, global_version) != 0)
            global_version_no_value = true;
 
        appendStringInfoString(&buf, str + len);
        pfree(str);
    }
 
    if (!global_version_no_value || global_standalone >= 0)
    {
        StringInfoData buf2;
 
        initStringInfo(&buf2);
 
        print_xml_decl(&buf2,
                       (!global_version_no_value) ? global_version : NULL,
                       0,
                       global_standalone);
 
        appendBinaryStringInfo(&buf2, buf.data, buf.len);
        buf = buf2;
    }
 
    return stringinfo_to_xmltype(&buf);
#else
    NO_XML_SUPPORT();
    return NULL;
#endif
}

References appendBinaryStringInfo(), appendStringInfoString(), generate_unaccent_rules::args, buf, DatumGetXmlP(), initStringInfo(), len, lfirst, NO_XML_SUPPORT, pfree(), PointerGetDatum(), str, stringinfo_to_xmltype(), text_to_cstring(), VARHDRSZ, VARSIZE, and x.

Referenced by ExecEvalXmlExpr(), and xmlconcat2().

xmlconcat2()

Datum xmlconcat2

(

PG_FUNCTION_ARGS

)

Definition at line 619 of file xml.c.

{
    if (PG_ARGISNULL(0))
    {
        if (PG_ARGISNULL(1))
            PG_RETURN_NULL();
        else
            PG_RETURN_XML_P(PG_GETARG_XML_P(1));
    }
    else if (PG_ARGISNULL(1))
        PG_RETURN_XML_P(PG_GETARG_XML_P(0));
    else
        PG_RETURN_XML_P(xmlconcat(list_make2(PG_GETARG_XML_P(0),
                                             PG_GETARG_XML_P(1))));
}

References list_make2, PG_ARGISNULL, PG_GETARG_XML_P, PG_RETURN_NULL, PG_RETURN_XML_P, and xmlconcat().

xmldata_root_element_end()

static void xmldata_root_element_end ( StringInfo  result, const char *  eltname  )

static

Definition at line 3005 of file xml.c.

{
    appendStringInfo(result, "</%s>\n", eltname);
}

References appendStringInfo().

Referenced by cursor_to_xml(), database_to_xml_internal(), query_to_xml_internal(), schema_to_xml_internal(), and SPI_sql_row_to_xmlelement().

xmldata_root_element_start()

static void xmldata_root_element_start ( StringInfo  result, const char *  eltname, const char *  xmlschema, const char *  targetns, bool  top_level  )

static

Definition at line 2978 of file xml.c.

{
    /* This isn't really wrong but currently makes no sense. */
    Assert(top_level || !xmlschema);
 
    appendStringInfo(result, "<%s", eltname);
    if (top_level)
    {
        appendStringInfoString(result, " xmlns:xsi=\"" NAMESPACE_XSI "\"");
        if (strlen(targetns) > 0)
            appendStringInfo(result, " xmlns=\"%s\"", targetns);
    }
    if (xmlschema)
    {
        /* FIXME: better targets */
        if (strlen(targetns) > 0)
            appendStringInfo(result, " xsi:schemaLocation=\"%s #\"", targetns);
        else
            appendStringInfoString(result, " xsi:noNamespaceSchemaLocation=\"#\"");
    }
    appendStringInfoString(result, ">\n");
}

References appendStringInfo(), appendStringInfoString(), Assert(), and NAMESPACE_XSI.

Referenced by cursor_to_xml(), database_to_xml_internal(), query_to_xml_internal(), schema_to_xml_internal(), and SPI_sql_row_to_xmlelement().

xmlelement()

xmltype * xmlelement	(	XmlExpr *	xexpr,
		Datum *	named_argvalue,
		bool *	named_argnull,
		Datum *	argvalue,
		bool *	argnull
	)

Definition at line 864 of file xml.c.

{
#ifdef USE_LIBXML
    xmltype    *result;
    List       *named_arg_strings;
    List       *arg_strings;
    int         i;
    ListCell   *arg;
    ListCell   *narg;
    PgXmlErrorContext *xmlerrcxt;
    volatile xmlBufferPtr buf = NULL;
    volatile xmlTextWriterPtr writer = NULL;
 
    /*
     * All arguments are already evaluated, and their values are passed in the
     * named_argvalue/named_argnull or argvalue/argnull arrays.  This avoids
     * issues if one of the arguments involves a call to some other function
     * or subsystem that wants to use libxml on its own terms.  We examine the
     * original XmlExpr to identify the numbers and types of the arguments.
     */
    named_arg_strings = NIL;
    i = 0;
    foreach(arg, xexpr->named_args)
    {
        Expr       *e = (Expr *) lfirst(arg);
        char       *str;
 
        if (named_argnull[i])
            str = NULL;
        else
            str = map_sql_value_to_xml_value(named_argvalue[i],
                                             exprType((Node *) e),
                                             false);
        named_arg_strings = lappend(named_arg_strings, str);
        i++;
    }
 
    arg_strings = NIL;
    i = 0;
    foreach(arg, xexpr->args)
    {
        Expr       *e = (Expr *) lfirst(arg);
        char       *str;
 
        /* here we can just forget NULL elements immediately */
        if (!argnull[i])
        {
            str = map_sql_value_to_xml_value(argvalue[i],
                                             exprType((Node *) e),
                                             true);
            arg_strings = lappend(arg_strings, str);
        }
        i++;
    }
 
    xmlerrcxt = pg_xml_init(PG_XML_STRICTNESS_ALL);
 
    PG_TRY();
    {
        buf = xmlBufferCreate();
        if (buf == NULL || xmlerrcxt->err_occurred)
            xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                        "could not allocate xmlBuffer");
        writer = xmlNewTextWriterMemory(buf, 0);
        if (writer == NULL || xmlerrcxt->err_occurred)
            xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                        "could not allocate xmlTextWriter");
 
        xmlTextWriterStartElement(writer, (xmlChar *) xexpr->name);
 
        forboth(arg, named_arg_strings, narg, xexpr->arg_names)
        {
            char       *str = (char *) lfirst(arg);
            char       *argname = strVal(lfirst(narg));
 
            if (str)
                xmlTextWriterWriteAttribute(writer,
                                            (xmlChar *) argname,
                                            (xmlChar *) str);
        }
 
        foreach(arg, arg_strings)
        {
            char       *str = (char *) lfirst(arg);
 
            xmlTextWriterWriteRaw(writer, (xmlChar *) str);
        }
 
        xmlTextWriterEndElement(writer);
 
        /* we MUST do this now to flush data out to the buffer ... */
        xmlFreeTextWriter(writer);
        writer = NULL;
 
        result = xmlBuffer_to_xmltype(buf);
    }
    PG_CATCH();
    {
        if (writer)
            xmlFreeTextWriter(writer);
        if (buf)
            xmlBufferFree(buf);
 
        pg_xml_done(xmlerrcxt, true);
 
        PG_RE_THROW();
    }
    PG_END_TRY();
 
    xmlBufferFree(buf);
 
    pg_xml_done(xmlerrcxt, false);
 
    return result;
#else
    NO_XML_SUPPORT();
    return NULL;
#endif
}

References arg, XmlExpr::args, buf, ERROR, exprType(), forboth, i, lappend(), lfirst, map_sql_value_to_xml_value(), XmlExpr::named_args, NIL, NO_XML_SUPPORT, PG_CATCH, PG_END_TRY, PG_RE_THROW, PG_TRY, pg_xml_done(), pg_xml_init(), PG_XML_STRICTNESS_ALL, str, strVal, and xml_ereport().

Referenced by ExecEvalXmlExpr().

xmlexists()

Datum xmlexists

(

PG_FUNCTION_ARGS

)

Definition at line 4555 of file xml.c.

{
#ifdef USE_LIBXML
    text       *xpath_expr_text = PG_GETARG_TEXT_PP(0);
    xmltype    *data = PG_GETARG_XML_P(1);
    int         res_nitems;
 
    xpath_internal(xpath_expr_text, data, NULL,
                   &res_nitems, NULL);
 
    PG_RETURN_BOOL(res_nitems > 0);
#else
    NO_XML_SUPPORT();
    return 0;
#endif
}

References data, NO_XML_SUPPORT, PG_GETARG_TEXT_PP, PG_GETARG_XML_P, and PG_RETURN_BOOL.

xmlparse()

xmltype * xmlparse	(	text *	data,
		XmlOptionType	xmloption_arg,
		bool	preserve_whitespace
	)

Definition at line 988 of file xml.c.

{
#ifdef USE_LIBXML
    xmlDocPtr   doc;
 
    doc = xml_parse(data, xmloption_arg, preserve_whitespace,
                    GetDatabaseEncoding(), NULL, NULL, NULL);
    xmlFreeDoc(doc);
 
    return (xmltype *) data;
#else
    NO_XML_SUPPORT();
    return NULL;
#endif
}

References data, GetDatabaseEncoding(), and NO_XML_SUPPORT.

Referenced by ExecEvalXmlExpr(), and texttoxml().

xmlpi()

xmltype * xmlpi	(	const char *	target,
		text *	arg,
		bool	arg_is_null,
		bool *	result_is_null
	)

Definition at line 1006 of file xml.c.

{
#ifdef USE_LIBXML
    xmltype    *result;
    StringInfoData buf;
 
    if (pg_strcasecmp(target, "xml") == 0)
        ereport(ERROR,
                (errcode(ERRCODE_INVALID_XML_PROCESSING_INSTRUCTION),
                 errmsg("invalid XML processing instruction"),
                 errdetail("XML processing instruction target name cannot be \"%s\".", target)));
 
    /*
     * Following the SQL standard, the null check comes after the syntax check
     * above.
     */
    *result_is_null = arg_is_null;
    if (*result_is_null)
        return NULL;
 
    initStringInfo(&buf);
 
    appendStringInfo(&buf, "<?%s", target);
 
    if (arg != NULL)
    {
        char       *string;
 
        string = text_to_cstring(arg);
        if (strstr(string, "?>") != NULL)
            ereport(ERROR,
                    (errcode(ERRCODE_INVALID_XML_PROCESSING_INSTRUCTION),
                     errmsg("invalid XML processing instruction"),
                     errdetail("XML processing instruction cannot contain \"?>\".")));
 
        appendStringInfoChar(&buf, ' ');
        appendStringInfoString(&buf, string + strspn(string, " "));
        pfree(string);
    }
    appendStringInfoString(&buf, "?>");
 
    result = stringinfo_to_xmltype(&buf);
    pfree(buf.data);
    return result;
#else
    NO_XML_SUPPORT();
    return NULL;
#endif
}

References appendStringInfo(), appendStringInfoChar(), appendStringInfoString(), arg, buf, ereport, errcode(), errdetail(), errmsg(), ERROR, initStringInfo(), NO_XML_SUPPORT, pfree(), pg_strcasecmp(), stringinfo_to_xmltype(), and text_to_cstring().

Referenced by ExecEvalXmlExpr().

xmlroot()

xmltype * xmlroot	(	xmltype *	data,
		text *	version,
		int	standalone
	)

Definition at line 1058 of file xml.c.

{
#ifdef USE_LIBXML
    char       *str;
    size_t      len;
    xmlChar    *orig_version;
    int         orig_standalone;
    StringInfoData buf;
 
    len = VARSIZE(data) - VARHDRSZ;
    str = text_to_cstring((text *) data);
 
    parse_xml_decl((xmlChar *) str, &len, &orig_version, NULL, &orig_standalone);
 
    if (version)
        orig_version = xml_text2xmlChar(version);
    else
        orig_version = NULL;
 
    switch (standalone)
    {
        case XML_STANDALONE_YES:
            orig_standalone = 1;
            break;
        case XML_STANDALONE_NO:
            orig_standalone = 0;
            break;
        case XML_STANDALONE_NO_VALUE:
            orig_standalone = -1;
            break;
        case XML_STANDALONE_OMITTED:
            /* leave original value */
            break;
    }
 
    initStringInfo(&buf);
    print_xml_decl(&buf, orig_version, 0, orig_standalone);
    appendStringInfoString(&buf, str + len);
 
    return stringinfo_to_xmltype(&buf);
#else
    NO_XML_SUPPORT();
    return NULL;
#endif
}

References appendStringInfoString(), buf, data, initStringInfo(), len, NO_XML_SUPPORT, str, stringinfo_to_xmltype(), text_to_cstring(), VARHDRSZ, VARSIZE, XML_STANDALONE_NO, XML_STANDALONE_NO_VALUE, XML_STANDALONE_OMITTED, and XML_STANDALONE_YES.

Referenced by ExecEvalXmlExpr().

XmlTableDestroyOpaque()

static void XmlTableDestroyOpaque ( struct TableFuncScanState *  state )

static

Definition at line 5090 of file xml.c.

{
#ifdef USE_LIBXML
    XmlTableBuilderData *xtCxt;
 
    xtCxt = GetXmlTableBuilderPrivateData(state, "XmlTableDestroyOpaque");
 
    /* Propagate our own error context to libxml2 */
    xmlSetStructuredErrorFunc(xtCxt->xmlerrcxt, xml_errorHandler);
 
    if (xtCxt->xpathscomp != NULL)
    {
        int         i;
 
        for (i = 0; i < xtCxt->natts; i++)
            if (xtCxt->xpathscomp[i] != NULL)
                xmlXPathFreeCompExpr(xtCxt->xpathscomp[i]);
    }
 
    if (xtCxt->xpathobj != NULL)
        xmlXPathFreeObject(xtCxt->xpathobj);
    if (xtCxt->xpathcomp != NULL)
        xmlXPathFreeCompExpr(xtCxt->xpathcomp);
    if (xtCxt->xpathcxt != NULL)
        xmlXPathFreeContext(xtCxt->xpathcxt);
    if (xtCxt->doc != NULL)
        xmlFreeDoc(xtCxt->doc);
    if (xtCxt->ctxt != NULL)
        xmlFreeParserCtxt(xtCxt->ctxt);
 
    pg_xml_done(xtCxt->xmlerrcxt, true);
 
    /* not valid anymore */
    xtCxt->magic = 0;
    state->opaque = NULL;
 
#else
    NO_XML_SUPPORT();
#endif                          /* not USE_LIBXML */
}

References i, NO_XML_SUPPORT, and pg_xml_done().

XmlTableFetchRow()

static bool XmlTableFetchRow ( struct TableFuncScanState *  state )

static

Definition at line 4893 of file xml.c.

{
#ifdef USE_LIBXML
    XmlTableBuilderData *xtCxt;
 
    xtCxt = GetXmlTableBuilderPrivateData(state, "XmlTableFetchRow");
 
    /* Propagate our own error context to libxml2 */
    xmlSetStructuredErrorFunc(xtCxt->xmlerrcxt, xml_errorHandler);
 
    if (xtCxt->xpathobj == NULL)
    {
        xtCxt->xpathobj = xmlXPathCompiledEval(xtCxt->xpathcomp, xtCxt->xpathcxt);
        if (xtCxt->xpathobj == NULL || xtCxt->xmlerrcxt->err_occurred)
            xml_ereport(xtCxt->xmlerrcxt, ERROR, ERRCODE_INVALID_ARGUMENT_FOR_XQUERY,
                        "could not create XPath object");
 
        xtCxt->row_count = 0;
    }
 
    if (xtCxt->xpathobj->type == XPATH_NODESET)
    {
        if (xtCxt->xpathobj->nodesetval != NULL)
        {
            if (xtCxt->row_count++ < xtCxt->xpathobj->nodesetval->nodeNr)
                return true;
        }
    }
 
    return false;
#else
    NO_XML_SUPPORT();
    return false;
#endif                          /* not USE_LIBXML */
}

References ERROR, NO_XML_SUPPORT, and xml_ereport().

XmlTableGetValue()

static Datum XmlTableGetValue ( struct TableFuncScanState *  state, int  colnum, Oid  typid, int32  typmod, bool *  isnull  )

static

Definition at line 4938 of file xml.c.

{
#ifdef USE_LIBXML
    Datum       result = (Datum) 0;
    XmlTableBuilderData *xtCxt;
    volatile xmlXPathObjectPtr xpathobj = NULL;
 
    xtCxt = GetXmlTableBuilderPrivateData(state, "XmlTableGetValue");
 
    Assert(xtCxt->xpathobj &&
           xtCxt->xpathobj->type == XPATH_NODESET &&
           xtCxt->xpathobj->nodesetval != NULL);
 
    /* Propagate our own error context to libxml2 */
    xmlSetStructuredErrorFunc(xtCxt->xmlerrcxt, xml_errorHandler);
 
    *isnull = false;
 
    Assert(xtCxt->xpathscomp[colnum] != NULL);
 
    PG_TRY();
    {
        xmlNodePtr  cur;
        char       *cstr = NULL;
 
        /* Set current node as entry point for XPath evaluation */
        cur = xtCxt->xpathobj->nodesetval->nodeTab[xtCxt->row_count - 1];
        xtCxt->xpathcxt->node = cur;
 
        /* Evaluate column path */
        xpathobj = xmlXPathCompiledEval(xtCxt->xpathscomp[colnum], xtCxt->xpathcxt);
        if (xpathobj == NULL || xtCxt->xmlerrcxt->err_occurred)
            xml_ereport(xtCxt->xmlerrcxt, ERROR, ERRCODE_INVALID_ARGUMENT_FOR_XQUERY,
                        "could not create XPath object");
 
        /*
         * There are four possible cases, depending on the number of nodes
         * returned by the XPath expression and the type of the target column:
         * a) XPath returns no nodes.  b) The target type is XML (return all
         * as XML).  For non-XML return types:  c) One node (return content).
         * d) Multiple nodes (error).
         */
        if (xpathobj->type == XPATH_NODESET)
        {
            int         count = 0;
 
            if (xpathobj->nodesetval != NULL)
                count = xpathobj->nodesetval->nodeNr;
 
            if (xpathobj->nodesetval == NULL || count == 0)
            {
                *isnull = true;
            }
            else
            {
                if (typid == XMLOID)
                {
                    text       *textstr;
                    StringInfoData str;
 
                    /* Concatenate serialized values */
                    initStringInfo(&str);
                    for (int i = 0; i < count; i++)
                    {
                        textstr =
                            xml_xmlnodetoxmltype(xpathobj->nodesetval->nodeTab[i],
                                                 xtCxt->xmlerrcxt);
 
                        appendStringInfoText(&str, textstr);
                    }
                    cstr = str.data;
                }
                else
                {
                    xmlChar    *str;
 
                    if (count > 1)
                        ereport(ERROR,
                                (errcode(ERRCODE_CARDINALITY_VIOLATION),
                                 errmsg("more than one value returned by column XPath expression")));
 
                    str = xmlXPathCastNodeSetToString(xpathobj->nodesetval);
                    cstr = str ? xml_pstrdup_and_free(str) : "";
                }
            }
        }
        else if (xpathobj->type == XPATH_STRING)
        {
            /* Content should be escaped when target will be XML */
            if (typid == XMLOID)
                cstr = escape_xml((char *) xpathobj->stringval);
            else
                cstr = (char *) xpathobj->stringval;
        }
        else if (xpathobj->type == XPATH_BOOLEAN)
        {
            char        typcategory;
            bool        typispreferred;
            xmlChar    *str;
 
            /* Allow implicit casting from boolean to numbers */
            get_type_category_preferred(typid, &typcategory, &typispreferred);
 
            if (typcategory != TYPCATEGORY_NUMERIC)
                str = xmlXPathCastBooleanToString(xpathobj->boolval);
            else
                str = xmlXPathCastNumberToString(xmlXPathCastBooleanToNumber(xpathobj->boolval));
 
            cstr = xml_pstrdup_and_free(str);
        }
        else if (xpathobj->type == XPATH_NUMBER)
        {
            xmlChar    *str;
 
            str = xmlXPathCastNumberToString(xpathobj->floatval);
            cstr = xml_pstrdup_and_free(str);
        }
        else
            elog(ERROR, "unexpected XPath object type %u", xpathobj->type);
 
        /*
         * By here, either cstr contains the result value, or the isnull flag
         * has been set.
         */
        Assert(cstr || *isnull);
 
        if (!*isnull)
            result = InputFunctionCall(&state->in_functions[colnum],
                                       cstr,
                                       state->typioparams[colnum],
                                       typmod);
    }
    PG_FINALLY();
    {
        if (xpathobj != NULL)
            xmlXPathFreeObject(xpathobj);
    }
    PG_END_TRY();
 
    return result;
#else
    NO_XML_SUPPORT();
    return 0;
#endif                          /* not USE_LIBXML */
}

References appendStringInfoText(), Assert(), cur, elog, ereport, errcode(), errmsg(), ERROR, escape_xml(), get_type_category_preferred(), i, initStringInfo(), InputFunctionCall(), NO_XML_SUPPORT, PG_END_TRY, PG_FINALLY, PG_TRY, str, and xml_ereport().

XmlTableInitOpaque()

static void XmlTableInitOpaque ( struct TableFuncScanState *  state, int  natts  )

static

Definition at line 4695 of file xml.c.

{
#ifdef USE_LIBXML
    volatile xmlParserCtxtPtr ctxt = NULL;
    XmlTableBuilderData *xtCxt;
    PgXmlErrorContext *xmlerrcxt;
 
    xtCxt = palloc0(sizeof(XmlTableBuilderData));
    xtCxt->magic = XMLTABLE_CONTEXT_MAGIC;
    xtCxt->natts = natts;
    xtCxt->xpathscomp = palloc0(sizeof(xmlXPathCompExprPtr) * natts);
 
    xmlerrcxt = pg_xml_init(PG_XML_STRICTNESS_ALL);
 
    PG_TRY();
    {
        xmlInitParser();
 
        ctxt = xmlNewParserCtxt();
        if (ctxt == NULL || xmlerrcxt->err_occurred)
            xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                        "could not allocate parser context");
    }
    PG_CATCH();
    {
        if (ctxt != NULL)
            xmlFreeParserCtxt(ctxt);
 
        pg_xml_done(xmlerrcxt, true);
 
        PG_RE_THROW();
    }
    PG_END_TRY();
 
    xtCxt->xmlerrcxt = xmlerrcxt;
    xtCxt->ctxt = ctxt;
 
    state->opaque = xtCxt;
#else
    NO_XML_SUPPORT();
#endif                          /* not USE_LIBXML */
}

References ERROR, NO_XML_SUPPORT, palloc0(), PG_CATCH, PG_END_TRY, PG_RE_THROW, PG_TRY, pg_xml_done(), pg_xml_init(), PG_XML_STRICTNESS_ALL, and xml_ereport().

XmlTableSetColumnFilter()

static void XmlTableSetColumnFilter ( struct TableFuncScanState *  state, const char *  path, int  colnum  )

static

Definition at line 4858 of file xml.c.

{
#ifdef USE_LIBXML
    XmlTableBuilderData *xtCxt;
    xmlChar    *xstr;
 
    Assert(PointerIsValid(path));
 
    xtCxt = GetXmlTableBuilderPrivateData(state, "XmlTableSetColumnFilter");
 
    if (*path == '\0')
        ereport(ERROR,
                (errcode(ERRCODE_INVALID_ARGUMENT_FOR_XQUERY),
                 errmsg("column path filter must not be empty string")));
 
    xstr = pg_xmlCharStrndup(path, strlen(path));
 
    /* We require XmlTableSetDocument to have been done already */
    Assert(xtCxt->xpathcxt != NULL);
 
    xtCxt->xpathscomp[colnum] = xmlXPathCtxtCompile(xtCxt->xpathcxt, xstr);
    if (xtCxt->xpathscomp[colnum] == NULL || xtCxt->xmlerrcxt->err_occurred)
        xml_ereport(xtCxt->xmlerrcxt, ERROR, ERRCODE_INVALID_ARGUMENT_FOR_XQUERY,
                    "invalid XPath expression");
#else
    NO_XML_SUPPORT();
#endif                          /* not USE_LIBXML */
}

References Assert(), ereport, errcode(), errmsg(), ERROR, NO_XML_SUPPORT, PointerIsValid, and xml_ereport().

XmlTableSetDocument()

static void XmlTableSetDocument ( struct TableFuncScanState *  state, Datum  value  )

static

Definition at line 4743 of file xml.c.

{
#ifdef USE_LIBXML
    XmlTableBuilderData *xtCxt;
    xmltype    *xmlval = DatumGetXmlP(value);
    char       *str;
    xmlChar    *xstr;
    int         length;
    volatile xmlDocPtr doc = NULL;
    volatile xmlXPathContextPtr xpathcxt = NULL;
 
    xtCxt = GetXmlTableBuilderPrivateData(state, "XmlTableSetDocument");
 
    /*
     * Use out function for casting to string (remove encoding property). See
     * comment in xml_out.
     */
    str = xml_out_internal(xmlval, 0);
 
    length = strlen(str);
    xstr = pg_xmlCharStrndup(str, length);
 
    PG_TRY();
    {
        doc = xmlCtxtReadMemory(xtCxt->ctxt, (char *) xstr, length, NULL, NULL, 0);
        if (doc == NULL || xtCxt->xmlerrcxt->err_occurred)
            xml_ereport(xtCxt->xmlerrcxt, ERROR, ERRCODE_INVALID_XML_DOCUMENT,
                        "could not parse XML document");
        xpathcxt = xmlXPathNewContext(doc);
        if (xpathcxt == NULL || xtCxt->xmlerrcxt->err_occurred)
            xml_ereport(xtCxt->xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                        "could not allocate XPath context");
        xpathcxt->node = (xmlNodePtr) doc;
    }
    PG_CATCH();
    {
        if (xpathcxt != NULL)
            xmlXPathFreeContext(xpathcxt);
        if (doc != NULL)
            xmlFreeDoc(doc);
 
        PG_RE_THROW();
    }
    PG_END_TRY();
 
    xtCxt->doc = doc;
    xtCxt->xpathcxt = xpathcxt;
#else
    NO_XML_SUPPORT();
#endif                          /* not USE_LIBXML */
}

References DatumGetXmlP(), ERROR, NO_XML_SUPPORT, PG_CATCH, PG_END_TRY, PG_RE_THROW, PG_TRY, str, value, xml_ereport(), and xml_out_internal().

XmlTableSetNamespace()

static void XmlTableSetNamespace ( struct TableFuncScanState *  state, const char *  name, const char *  uri  )

static

Definition at line 4800 of file xml.c.

{
#ifdef USE_LIBXML
    XmlTableBuilderData *xtCxt;
 
    if (name == NULL)
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                 errmsg("DEFAULT namespace is not supported")));
    xtCxt = GetXmlTableBuilderPrivateData(state, "XmlTableSetNamespace");
 
    if (xmlXPathRegisterNs(xtCxt->xpathcxt,
                           pg_xmlCharStrndup(name, strlen(name)),
                           pg_xmlCharStrndup(uri, strlen(uri))))
        xml_ereport(xtCxt->xmlerrcxt, ERROR, ERRCODE_INVALID_ARGUMENT_FOR_XQUERY,
                    "could not set XML namespace");
#else
    NO_XML_SUPPORT();
#endif                          /* not USE_LIBXML */
}

References ereport, errcode(), errmsg(), ERROR, name, NO_XML_SUPPORT, and xml_ereport().

XmlTableSetRowFilter()

static void XmlTableSetRowFilter ( struct TableFuncScanState *  state, const char *  path  )

static

Definition at line 4826 of file xml.c.

{
#ifdef USE_LIBXML
    XmlTableBuilderData *xtCxt;
    xmlChar    *xstr;
 
    xtCxt = GetXmlTableBuilderPrivateData(state, "XmlTableSetRowFilter");
 
    if (*path == '\0')
        ereport(ERROR,
                (errcode(ERRCODE_INVALID_ARGUMENT_FOR_XQUERY),
                 errmsg("row path filter must not be empty string")));
 
    xstr = pg_xmlCharStrndup(path, strlen(path));
 
    /* We require XmlTableSetDocument to have been done already */
    Assert(xtCxt->xpathcxt != NULL);
 
    xtCxt->xpathcomp = xmlXPathCtxtCompile(xtCxt->xpathcxt, xstr);
    if (xtCxt->xpathcomp == NULL || xtCxt->xmlerrcxt->err_occurred)
        xml_ereport(xtCxt->xmlerrcxt, ERROR, ERRCODE_INVALID_ARGUMENT_FOR_XQUERY,
                    "invalid XPath expression");
#else
    NO_XML_SUPPORT();
#endif                          /* not USE_LIBXML */
}

References Assert(), ereport, errcode(), errmsg(), ERROR, NO_XML_SUPPORT, and xml_ereport().

xmltext()

Datum xmltext

(

PG_FUNCTION_ARGS

)

Definition at line 527 of file xml.c.

{
#ifdef USE_LIBXML
    text       *arg = PG_GETARG_TEXT_PP(0);
    text       *result;
    xmlChar    *xmlbuf = NULL;
 
    xmlbuf = xmlEncodeSpecialChars(NULL, xml_text2xmlChar(arg));
 
    Assert(xmlbuf);
 
    result = cstring_to_text_with_len((const char *) xmlbuf, xmlStrlen(xmlbuf));
    xmlFree(xmlbuf);
    PG_RETURN_XML_P(result);
#else
    NO_XML_SUPPORT();
    return 0;
#endif                          /* not USE_LIBXML */
}

References arg, Assert(), cstring_to_text_with_len(), NO_XML_SUPPORT, PG_GETARG_TEXT_PP, and PG_RETURN_XML_P.

xmltotext()

Datum xmltotext

(

PG_FUNCTION_ARGS

)

Definition at line 646 of file xml.c.

{
    xmltype    *data = PG_GETARG_XML_P(0);
 
    /* It's actually binary compatible. */
    PG_RETURN_TEXT_P((text *) data);
}

References data, PG_GETARG_XML_P, and PG_RETURN_TEXT_P.

xmltotext_with_options()

text * xmltotext_with_options	(	xmltype *	data,
		XmlOptionType	xmloption_arg,
		bool	indent
	)

Definition at line 656 of file xml.c.

{
#ifdef USE_LIBXML
    text       *volatile result;
    xmlDocPtr   doc;
    XmlOptionType parsed_xmloptiontype;
    xmlNodePtr  content_nodes;
    volatile xmlBufferPtr buf = NULL;
    volatile xmlSaveCtxtPtr ctxt = NULL;
    ErrorSaveContext escontext = {T_ErrorSaveContext};
    PgXmlErrorContext *xmlerrcxt;
#endif
 
    if (xmloption_arg != XMLOPTION_DOCUMENT && !indent)
    {
        /*
         * We don't actually need to do anything, so just return the
         * binary-compatible input.  For backwards-compatibility reasons,
         * allow such cases to succeed even without USE_LIBXML.
         */
        return (text *) data;
    }
 
#ifdef USE_LIBXML
 
    /*
     * Parse the input according to the xmloption.
     *
     * preserve_whitespace is set to false in case we are indenting, otherwise
     * libxml2 will fail to indent elements that have whitespace between them.
     */
    doc = xml_parse(data, xmloption_arg, !indent, GetDatabaseEncoding(),
                    &parsed_xmloptiontype, &content_nodes,
                    (Node *) &escontext);
    if (doc == NULL || escontext.error_occurred)
    {
        if (doc)
            xmlFreeDoc(doc);
        /* A soft error must be failure to conform to XMLOPTION_DOCUMENT */
        ereport(ERROR,
                (errcode(ERRCODE_NOT_AN_XML_DOCUMENT),
                 errmsg("not an XML document")));
    }
 
    /* If we weren't asked to indent, we're done. */
    if (!indent)
    {
        xmlFreeDoc(doc);
        return (text *) data;
    }
 
    /* Otherwise, we gotta spin up some error handling. */
    xmlerrcxt = pg_xml_init(PG_XML_STRICTNESS_ALL);
 
    PG_TRY();
    {
        size_t      decl_len = 0;
 
        /* The serialized data will go into this buffer. */
        buf = xmlBufferCreate();
 
        if (buf == NULL || xmlerrcxt->err_occurred)
            xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                        "could not allocate xmlBuffer");
 
        /* Detect whether there's an XML declaration */
        parse_xml_decl(xml_text2xmlChar(data), &decl_len, NULL, NULL, NULL);
 
        /*
         * Emit declaration only if the input had one.  Note: some versions of
         * xmlSaveToBuffer leak memory if a non-null encoding argument is
         * passed, so don't do that.  We don't want any encoding conversion
         * anyway.
         */
        if (decl_len == 0)
            ctxt = xmlSaveToBuffer(buf, NULL,
                                   XML_SAVE_NO_DECL | XML_SAVE_FORMAT);
        else
            ctxt = xmlSaveToBuffer(buf, NULL,
                                   XML_SAVE_FORMAT);
 
        if (ctxt == NULL || xmlerrcxt->err_occurred)
            xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                        "could not allocate xmlSaveCtxt");
 
        if (parsed_xmloptiontype == XMLOPTION_DOCUMENT)
        {
            /* If it's a document, saving is easy. */
            if (xmlSaveDoc(ctxt, doc) == -1 || xmlerrcxt->err_occurred)
                xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                            "could not save document to xmlBuffer");
        }
        else if (content_nodes != NULL)
        {
            /*
             * Deal with the case where we have non-singly-rooted XML.
             * libxml's dump functions don't work well for that without help.
             * We build a fake root node that serves as a container for the
             * content nodes, and then iterate over the nodes.
             */
            xmlNodePtr  root;
            xmlNodePtr  oldroot;
            xmlNodePtr  newline;
 
            root = xmlNewNode(NULL, (const xmlChar *) "content-root");
            if (root == NULL || xmlerrcxt->err_occurred)
                xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                            "could not allocate xml node");
 
            /*
             * This attaches root to doc, so we need not free it separately...
             * but instead, we have to free the old root if there was one.
             */
            oldroot = xmlDocSetRootElement(doc, root);
            if (oldroot != NULL)
                xmlFreeNode(oldroot);
 
            xmlAddChildList(root, content_nodes);
 
            /*
             * We use this node to insert newlines in the dump.  Note: in at
             * least some libxml versions, xmlNewDocText would not attach the
             * node to the document even if we passed it.  Therefore, manage
             * freeing of this node manually, and pass NULL here to make sure
             * there's not a dangling link.
             */
            newline = xmlNewDocText(NULL, (const xmlChar *) "\n");
            if (newline == NULL || xmlerrcxt->err_occurred)
                xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                            "could not allocate xml node");
 
            for (xmlNodePtr node = root->children; node; node = node->next)
            {
                /* insert newlines between nodes */
                if (node->type != XML_TEXT_NODE && node->prev != NULL)
                {
                    if (xmlSaveTree(ctxt, newline) == -1 || xmlerrcxt->err_occurred)
                    {
                        xmlFreeNode(newline);
                        xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                                    "could not save newline to xmlBuffer");
                    }
                }
 
                if (xmlSaveTree(ctxt, node) == -1 || xmlerrcxt->err_occurred)
                {
                    xmlFreeNode(newline);
                    xml_ereport(xmlerrcxt, ERROR, ERRCODE_OUT_OF_MEMORY,
                                "could not save content to xmlBuffer");
                }
            }
 
            xmlFreeNode(newline);
        }
 
        if (xmlSaveClose(ctxt) == -1 || xmlerrcxt->err_occurred)
        {
            ctxt = NULL;        /* don't try to close it again */
            xml_ereport(xmlerrcxt, ERROR, ERRCODE_INTERNAL_ERROR,
                        "could not close xmlSaveCtxtPtr");
        }
 
        /*
         * xmlDocContentDumpOutput may add a trailing newline, so remove that.
         */
        if (xmloption_arg == XMLOPTION_DOCUMENT)
        {
            const char *str = (const char *) xmlBufferContent(buf);
            int         len = xmlBufferLength(buf);
 
            while (len > 0 && (str[len - 1] == '\n' ||
                               str[len - 1] == '\r'))
                len--;
 
            result = cstring_to_text_with_len(str, len);
        }
        else
            result = (text *) xmlBuffer_to_xmltype(buf);
    }
    PG_CATCH();
    {
        if (ctxt)
            xmlSaveClose(ctxt);
        if (buf)
            xmlBufferFree(buf);
        if (doc)
            xmlFreeDoc(doc);
 
        pg_xml_done(xmlerrcxt, true);
 
        PG_RE_THROW();
    }
    PG_END_TRY();
 
    xmlBufferFree(buf);
    xmlFreeDoc(doc);
 
    pg_xml_done(xmlerrcxt, false);
 
    return result;
#else
    NO_XML_SUPPORT();
    return NULL;
#endif
}

References buf, cstring_to_text_with_len(), data, ereport, errcode(), errmsg(), ERROR, ErrorSaveContext::error_occurred, GetDatabaseEncoding(), len, newline, NO_XML_SUPPORT, PG_CATCH, PG_END_TRY, PG_RE_THROW, PG_TRY, pg_xml_done(), pg_xml_init(), PG_XML_STRICTNESS_ALL, root, str, xml_ereport(), and XMLOPTION_DOCUMENT.

Referenced by ExecEvalXmlExpr().

xmlvalidate()

Datum xmlvalidate

(

PG_FUNCTION_ARGS

)

Definition at line 1114 of file xml.c.

{
    ereport(ERROR,
            (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
             errmsg("xmlvalidate is not implemented")));
    return 0;
}

References ereport, errcode(), errmsg(), and ERROR.

xpath()

Datum xpath

(

PG_FUNCTION_ARGS

)

Definition at line 4532 of file xml.c.

{
#ifdef USE_LIBXML
    text       *xpath_expr_text = PG_GETARG_TEXT_PP(0);
    xmltype    *data = PG_GETARG_XML_P(1);
    ArrayType  *namespaces = PG_GETARG_ARRAYTYPE_P(2);
    ArrayBuildState *astate;
 
    astate = initArrayResult(XMLOID, CurrentMemoryContext, true);
    xpath_internal(xpath_expr_text, data, namespaces,
                   NULL, astate);
    PG_RETURN_DATUM(makeArrayResult(astate, CurrentMemoryContext));
#else
    NO_XML_SUPPORT();
    return 0;
#endif
}

References CurrentMemoryContext, data, initArrayResult(), makeArrayResult(), NO_XML_SUPPORT, PG_GETARG_ARRAYTYPE_P, PG_GETARG_TEXT_PP, PG_GETARG_XML_P, and PG_RETURN_DATUM.

Referenced by pgxml_xpath(), xpath_bool(), xpath_list(), xpath_nodeset(), xpath_number(), and xpath_string().

xpath_exists()

Datum xpath_exists

(

PG_FUNCTION_ARGS

)

Definition at line 4578 of file xml.c.

{
#ifdef USE_LIBXML
    text       *xpath_expr_text = PG_GETARG_TEXT_PP(0);
    xmltype    *data = PG_GETARG_XML_P(1);
    ArrayType  *namespaces = PG_GETARG_ARRAYTYPE_P(2);
    int         res_nitems;
 
    xpath_internal(xpath_expr_text, data, namespaces,
                   &res_nitems, NULL);
 
    PG_RETURN_BOOL(res_nitems > 0);
#else
    NO_XML_SUPPORT();
    return 0;
#endif
}

References data, NO_XML_SUPPORT, PG_GETARG_ARRAYTYPE_P, PG_GETARG_TEXT_PP, PG_GETARG_XML_P, and PG_RETURN_BOOL.

xsd_schema_element_end()

static void xsd_schema_element_end ( StringInfo  result )

static

Definition at line 3274 of file xml.c.

{
    appendStringInfoString(result, "</xsd:schema>");
}

References appendStringInfoString().

Referenced by database_to_xmlschema_internal(), map_sql_table_to_xmlschema(), and schema_to_xmlschema_internal().

xsd_schema_element_start()

static void xsd_schema_element_start ( StringInfo  result, const char *  targetns  )

static

Definition at line 3257 of file xml.c.

{
    appendStringInfoString(result,
                           "<xsd:schema\n"
                           "    xmlns:xsd=\"" NAMESPACE_XSD "\"");
    if (strlen(targetns) > 0)
        appendStringInfo(result,
                         "\n"
                         "    targetNamespace=\"%s\"\n"
                         "    elementFormDefault=\"qualified\"",
                         targetns);
    appendStringInfoString(result,
                           ">\n\n");
}

References appendStringInfo(), appendStringInfoString(), and NAMESPACE_XSD.

Referenced by database_to_xmlschema_internal(), map_sql_table_to_xmlschema(), and schema_to_xmlschema_internal().

Variable Documentation

xmlbinary

int xmlbinary = XMLBINARY_BASE64

Definition at line 109 of file xml.c.

Referenced by map_sql_type_to_xmlschema_type(), and map_sql_value_to_xml_value().

xmloption

int xmloption = XMLOPTION_CONTENT

Definition at line 110 of file xml.c.

Referenced by texttoxml(), xml_in(), xml_is_well_formed(), and xml_recv().

XmlTableRoutine

const TableFuncRoutine XmlTableRoutine

Initial value:

=
{
    .InitOpaque = XmlTableInitOpaque,
    .SetDocument = XmlTableSetDocument,
    .SetNamespace = XmlTableSetNamespace,
    .SetRowFilter = XmlTableSetRowFilter,
    .SetColumnFilter = XmlTableSetColumnFilter,
    .FetchRow = XmlTableFetchRow,
    .GetValue = XmlTableGetValue,
    .DestroyOpaque = XmlTableDestroyOpaque
}

Definition at line 223 of file xml.c.

Referenced by ExecInitTableFuncScan().