printtup.c 7.1 KB
Newer Older
1 2 3
/*-------------------------------------------------------------------------
 *
 * printtup.c--
4 5
 *	  Routines to print out tuples to the destination (binary or non-binary
 *	  portals, frontend/interactive backend, etc.).
6 7 8 9 10
 *
 * Copyright (c) 1994, Regents of the University of California
 *
 *
 * IDENTIFICATION
11
 *	  $Header: /cvsroot/pgsql/src/backend/access/common/printtup.c,v 1.32 1998/08/19 02:00:54 momjian Exp $
12 13 14 15
 *
 *-------------------------------------------------------------------------
 */

16
#include <string.h>
M
Marc G. Fournier 已提交
17
#include <postgres.h>
18

19 20 21
#include <fmgr.h>
#include <access/heapam.h>
#include <access/printtup.h>
M
Marc G. Fournier 已提交
22 23 24
#include <catalog/pg_type.h>
#include <libpq/libpq.h>
#include <utils/syscache.h>
M
Marc G. Fournier 已提交
25

26
#ifdef MULTIBYTE
M
 
Marc G. Fournier 已提交
27
#include <mb/pg_wchar.h>
28 29
#endif

30
/* ----------------------------------------------------------------
31
 *		printtup / debugtup support
32 33 34 35
 * ----------------------------------------------------------------
 */

/* ----------------
36
 *		typtoout - used by printtup and debugtup
37 38 39 40 41
 * ----------------
 */
Oid
typtoout(Oid type)
{
42
	HeapTuple	typeTuple;
43 44 45 46 47 48

	typeTuple = SearchSysCacheTuple(TYPOID,
									ObjectIdGetDatum(type),
									0, 0, 0);

	if (HeapTupleIsValid(typeTuple))
49
		return ((Oid) ((TypeTupleForm) GETSTRUCT(typeTuple))->typoutput);
50

51
	elog(ERROR, "typtoout: Cache lookup of type %d failed", type);
52
	return (InvalidOid);
53 54 55 56 57
}

Oid
gettypelem(Oid type)
{
58
	HeapTuple	typeTuple;
59 60 61 62 63 64

	typeTuple = SearchSysCacheTuple(TYPOID,
									ObjectIdGetDatum(type),
									0, 0, 0);

	if (HeapTupleIsValid(typeTuple))
65
		return ((Oid) ((TypeTupleForm) GETSTRUCT(typeTuple))->typelem);
66

67
	elog(ERROR, "typtoout: Cache lookup of type %d failed", type);
68
	return (InvalidOid);
69 70 71
}

/* ----------------
72
 *		printtup
73 74 75 76 77
 * ----------------
 */
void
printtup(HeapTuple tuple, TupleDesc typeinfo)
{
78 79 80
	int			i,
				j,
				k;
81 82
	char	   *outputstr;
	Datum		attr;
83 84
	bool		isnull;
	Oid			typoutput;
85
#ifdef MULTIBYTE
86 87
	unsigned char *p;
#endif
88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104

	/* ----------------
	 *	tell the frontend to expect new tuple data
	 * ----------------
	 */
	pq_putnchar("D", 1);

	/* ----------------
	 *	send a bitmap of which attributes are null
	 * ----------------
	 */
	j = 0;
	k = 1 << 7;
	for (i = 0; i < tuple->t_natts;)
	{
		i++;					/* heap_getattr is a macro, so no
								 * increment */
105
		attr = heap_getattr(tuple, i, typeinfo, &isnull);
106 107 108 109 110 111 112 113 114
		if (!isnull)
			j |= k;
		k >>= 1;
		if (!(i & 7))
		{
			pq_putint(j, 1);
			j = 0;
			k = 1 << 7;
		}
115
	}
116 117 118 119 120 121 122 123 124
	if (i & 7)
		pq_putint(j, 1);

	/* ----------------
	 *	send the attributes of this tuple
	 * ----------------
	 */
	for (i = 0; i < tuple->t_natts; ++i)
	{
125
		attr = heap_getattr(tuple, i + 1, typeinfo, &isnull);
126 127 128 129 130
		typoutput = typtoout((Oid) typeinfo->attrs[i]->atttypid);

		if (!isnull && OidIsValid(typoutput))
		{
			outputstr = fmgr(typoutput, attr,
131
							 gettypelem(typeinfo->attrs[i]->atttypid),
132
							 typeinfo->attrs[i]->atttypmod);
133
#ifdef MULTIBYTE
134 135 136 137
			p = pg_server_to_client(outputstr, strlen(outputstr));
			pq_putint(strlen(p) + VARHDRSZ, VARHDRSZ);
			pq_putnchar(p, strlen(p));
#else
138
			pq_putint(strlen(outputstr) + VARHDRSZ, VARHDRSZ);
139
			pq_putnchar(outputstr, strlen(outputstr));
140
#endif
141 142
			pfree(outputstr);
		}
143 144 145 146
	}
}

/* ----------------
147
 *		printatt
148 149 150 151
 * ----------------
 */
static void
printatt(unsigned attributeId,
152 153
		 AttributeTupleForm attributeP,
		 char *value)
154
{
B
Bruce Momjian 已提交
155
	printf("\t%2d: %s%s%s%s\t(typeid = %u, len = %d, typmod = %d, byval = %c)\n",
156 157 158 159 160 161 162
		   attributeId,
		   attributeP->attname.data,
		   value != NULL ? " = \"" : "",
		   value != NULL ? value : "",
		   value != NULL ? "\"" : "",
		   (unsigned int) (attributeP->atttypid),
		   attributeP->attlen,
B
Bruce Momjian 已提交
163
		   attributeP->atttypmod,
164
		   attributeP->attbyval ? 't' : 'f');
165 166 167
}

/* ----------------
168
 *		showatts
169 170 171 172 173
 * ----------------
 */
void
showatts(char *name, TupleDesc tupleDesc)
{
174 175
	int			i;
	int			natts = tupleDesc->natts;
176
	AttributeTupleForm *attinfo = tupleDesc->attrs;
177

178 179 180 181
	puts(name);
	for (i = 0; i < natts; ++i)
		printatt((unsigned) i + 1, attinfo[i], (char *) NULL);
	printf("\t----\n");
182 183 184
}

/* ----------------
185
 *		debugtup
186 187 188 189 190
 * ----------------
 */
void
debugtup(HeapTuple tuple, TupleDesc typeinfo)
{
191 192
	int			i;
	Datum		attr;
193
	char	   *value;
194 195
	bool		isnull;
	Oid			typoutput;
196 197 198

	for (i = 0; i < tuple->t_natts; ++i)
	{
199
		attr = heap_getattr(tuple, i + 1, typeinfo, &isnull);
200 201 202 203 204
		typoutput = typtoout((Oid) typeinfo->attrs[i]->atttypid);

		if (!isnull && OidIsValid(typoutput))
		{
			value = fmgr(typoutput, attr,
205
						 gettypelem(typeinfo->attrs[i]->atttypid),
206
						 typeinfo->attrs[i]->atttypmod);
207 208 209
			printatt((unsigned) i + 1, typeinfo->attrs[i], value);
			pfree(value);
		}
210
	}
211
	printf("\t----\n");
212 213 214
}

/* ----------------
215 216 217 218
 *		printtup_internal
 *		Protocol expects either T, D, C, E, or N.
 *		We use a different data prefix, e.g. 'B' instead of 'D' to
 *		indicate a tuple in internal (binary) form.
219
 *
220
 *		This is same as printtup, except we don't use the typout func.
221 222 223 224 225
 * ----------------
 */
void
printtup_internal(HeapTuple tuple, TupleDesc typeinfo)
{
226 227 228
	int			i,
				j,
				k;
229
	Datum		attr;
230
	bool		isnull;
231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247

	/* ----------------
	 *	tell the frontend to expect new tuple data
	 * ----------------
	 */
	pq_putnchar("B", 1);

	/* ----------------
	 *	send a bitmap of which attributes are null
	 * ----------------
	 */
	j = 0;
	k = 1 << 7;
	for (i = 0; i < tuple->t_natts;)
	{
		i++;					/* heap_getattr is a macro, so no
								 * increment */
248
		attr = heap_getattr(tuple, i, typeinfo, &isnull);
249 250 251 252 253 254 255 256 257
		if (!isnull)
			j |= k;
		k >>= 1;
		if (!(i & 7))
		{
			pq_putint(j, 1);
			j = 0;
			k = 1 << 7;
		}
258
	}
259 260 261 262 263 264 265
	if (i & 7)
		pq_putint(j, 1);

	/* ----------------
	 *	send the attributes of this tuple
	 * ----------------
	 */
266
#ifdef IPORTAL_DEBUG
267
	fprintf(stderr, "sending tuple with %d atts\n", tuple->t_natts);
268
#endif
269 270
	for (i = 0; i < tuple->t_natts; ++i)
	{
271
		int32		len = typeinfo->attrs[i]->attlen;
272

273
		attr = heap_getattr(tuple, i + 1, typeinfo, &isnull);
274
		if (!isnull)
275
		{
276 277 278 279 280 281
			/* # of bytes, and opaque data */
			if (len == -1)
			{
				/* variable length, assume a varlena structure */
				len = VARSIZE(attr) - VARHDRSZ;

282
#ifdef MULTIBYTE
283 284
				pq_putncharlen(VARDATA(attr), len);
#else
B
Bruce Momjian 已提交
285
				pq_putint(len, VARHDRSZ);
286
				pq_putnchar(VARDATA(attr), len);
287
#endif
288 289
#ifdef IPORTAL_DEBUG
				{
290
					char	   *d = VARDATA(attr);
291 292 293 294

					fprintf(stderr, "length %d data %x%x%x%x\n",
							len, *d, *(d + 1), *(d + 2), *(d + 3));
				}
295
#endif
296 297 298 299 300 301
			}
			else
			{
				/* fixed size */
				if (typeinfo->attrs[i]->attbyval)
				{
302 303 304
					int8		i8;
					int16		i16;
					int32		i32;
305 306 307 308

					pq_putint(len, sizeof(int32));
					switch (len)
					{
309 310 311 312 313 314 315 316 317 318 319 320
						case sizeof(int8):
							i8 = DatumGetChar(attr);
							pq_putnchar((char *) &i8, len);
							break;
						case sizeof(int16):
							i16 = DatumGetInt16(attr);
							pq_putnchar((char *) &i16, len);
							break;
						case sizeof(int32):
							i32 = DatumGetInt32(attr);
							pq_putnchar((char *) &i32, len);
							break;
321
					}
322
#ifdef IPORTAL_DEBUG
323
					fprintf(stderr, "byval length %d data %d\n", len, attr);
324
#endif
325 326 327 328
				}
				else
				{
					pq_putint(len, sizeof(int32));
329
					pq_putnchar(DatumGetPointer(attr), len);
330
#ifdef IPORTAL_DEBUG
331
					fprintf(stderr, "byref length %d data %x\n", len,
332
							DatumGetPointer(attr));
333
#endif
334 335
				}
			}
336 337 338
		}
	}
}