00001 /* 00002 * $Id$ 00003 * 00004 * PostgreSQL Database Driver for SER 00005 * 00006 * Portions Copyright (C) 2001-2003 FhG FOKUS 00007 * Copyright (C) 2003 August.Net Services, LLC 00008 * Portions Copyright (C) 2005-2008 iptelorg GmbH 00009 * 00010 * This file is part of SER, a free SIP server. 00011 * 00012 * SER is free software; you can redistribute it and/or modify it under the 00013 * terms of the GNU General Public License as published by the Free Software 00014 * Foundation; either version 2 of the License, or (at your option) any later 00015 * version 00016 * 00017 * For a license to use the ser software under conditions other than those 00018 * described here, or to purchase support for this software, please contact 00019 * iptel.org by e-mail at the following addresses: info@iptel.org 00020 * 00021 * SER is distributed in the hope that it will be useful, but WITHOUT ANY 00022 * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS 00023 * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more 00024 * details. 00025 * 00026 * You should have received a copy of the GNU General Public License along 00027 * with this program; if not, write to the Free Software Foundation, Inc., 59 00028 * Temple Place, Suite 330, Boston, MA 02111-1307 USA 00029 */ 00030 00031 #ifndef _PG_SQL_H 00032 #define _PG_SQL_H 00033 00043 #include "../../lib/srdb2/db_cmd.h" 00044 #include "../../str.h" 00045 00046 00058 int build_update_sql(str* sql_cmd, db_cmd_t* cmd); 00059 00060 00071 int build_insert_sql(str* sql_cmd, db_cmd_t* cmd); 00072 00073 00085 int build_delete_sql(str* sql_cmd, db_cmd_t* cmd); 00086 00087 00099 int build_select_sql(str* sql_cmd, db_cmd_t* cmd); 00100 00101 00102 /* Builds SQL query used to obtain the list of supported field types. 00103 * This function builds a special SQL query that is used to obtain the list 00104 * of supported field type from the server's system catalogs. 00105 */ 00106 int build_select_oid_sql(str* sql_cmd); 00107 00108 00114 int build_timestamp_format_sql(str* sql_cmd); 00115 00118 #endif /* _PG_SQL_H */
1.7.1