builder.c File Reference

---

Detailed Description

generic postgres backend query builder

Author:

Copyright (C) 2001 Linas Vepstas <linas@linas.org>

compiles data types into sql queries

Note: Postgres documentation states that the maximum length of a query is 8192 bytes, and that longer queries are ignored ...

TBD hack alert XXX FIXME: -- check for buffer overflow at end of each setter

Definition in file builder.c.

#include <glib.h>
#include <string.h>
#include "util.h"
#include "perr.h"
#include "escape.h"
#include "builder.h"

Go to the source code of this file.

#define	_GNU_SOURCE
#define	INITIAL_BUFSZ   16300
SqlBuilder *	sql_builder_new (void)
void	sql_builder_destroy (SqlBuilder *b)
SqlBuilder *	sql_builder_copy (SqlBuilder *orig)
void	sql_builder_table (SqlBuilder *b, const gchar *tablename, SqlBuilderQType qt)
void	sql_builder_set_str (SqlBuilder *b, const gchar *tag, const gchar *val)
void	sql_builder_set_char (SqlBuilder *b, const gchar *tag, gchar val)
void	sql_builder_set_date (SqlBuilder *b, const gchar *tag, time_t ts)
void	sql_builder_set_double (SqlBuilder *b, const gchar *tag, double flt)
void	sql_builder_set_int64 (SqlBuilder *b, const gchar *tag, gint64 nval)
void	sql_builder_set_int32 (SqlBuilder *b, const gchar *tag, gint32 nval)
void	sql_builder_where_str (SqlBuilder *b, const gchar *tag, const gchar *val, const gchar *op)
void	sql_builder_where_int32 (SqlBuilder *b, const gchar *tag, gint32 val, const gchar *op)
const gchar *	sql_builder_query (SqlBuilder *b)