builder.h

Go to the documentation of this file.

/********************************************************************\
 * builder.h : compile SQL queries from C language data             *
 * Copyright (C) 2001 Linas Vepstas <linas@linas.org>               *
 * http://dwi.sourceforge.net                                       *
 *                                                                  *
 * This library is free software; you can redistribute it and/or    *
 * modify it under the terms of the GNU Lesser General Public       *
 * License as published by the Free Software Foundation; either     *
 * version 2.1 of the License, or (at your option) any later version.
 *                                                                  *
 * This library is distributed in the hope that it will be useful,  *
 * but WITHOUT ANY WARRANTY; without even the implied warranty of   *
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the    *
 * GNU Lesser General Public License for more details.              *
 *                                                                  *
 * You should have received a copy of the GNU Lesser General Public *
 * License along with this program; if not, contact:                *
 *                                                                  *
 * Free Software Foundation           Voice:  +1-617-542-5942       *
 * 59 Temple Place - Suite 330        Fax:    +1-617-542-2652       *
 * Boston, MA  02111-1307,  USA       gnu@gnu.org                   *
\********************************************************************/

#ifndef SQL_BUILDER_H
#define SQL_BUILDER_H

#include <time.h>

#define SQL_DBL_FMT "%24.18g"

typedef enum {
    SQL_UPDATE = 'm',
    SQL_INSERT = 'a',
    SQL_SELECT = 'q',
    SQL_DELETE = 'd'
} SqlBuilderQType;

typedef struct SqlBuilder_s SqlBuilder; 

SqlBuilder * sql_builder_new(void);
SqlBuilder * sql_builder_copy (SqlBuilder *);
void sql_builder_destroy (SqlBuilder *);

void sql_builder_table (SqlBuilder *b,
                     const gchar *tablename,
                     SqlBuilderQType qtype);

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 val);
void sql_builder_set_int64 (SqlBuilder *b, const gchar *tag, gint64 val);
void sql_builder_set_int32 (SqlBuilder *b, const gchar *tag, gint32 val);
void sql_builder_set_double(SqlBuilder *b, const gchar *tag, gdouble val);

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);

#endif /* SQL_BUILDER_H */

---