Kannel: Open Source WAP and SMS gateway  $Revision: 5037 $
dbpool_sqlite.c
Go to the documentation of this file.
1 /* ====================================================================
2  * The Kannel Software License, Version 1.0
3  *
4  * Copyright (c) 2001-2016 Kannel Group
5  * Copyright (c) 1998-2001 WapIT Ltd.
6  * All rights reserved.
7  *
8  * Redistribution and use in source and binary forms, with or without
9  * modification, are permitted provided that the following conditions
10  * are met:
11  *
12  * 1. Redistributions of source code must retain the above copyright
13  * notice, this list of conditions and the following disclaimer.
14  *
15  * 2. Redistributions in binary form must reproduce the above copyright
16  * notice, this list of conditions and the following disclaimer in
17  * the documentation and/or other materials provided with the
18  * distribution.
19  *
20  * 3. The end-user documentation included with the redistribution,
21  * if any, must include the following acknowledgment:
22  * "This product includes software developed by the
23  * Kannel Group (http://www.kannel.org/)."
24  * Alternately, this acknowledgment may appear in the software itself,
25  * if and wherever such third-party acknowledgments normally appear.
26  *
27  * 4. The names "Kannel" and "Kannel Group" must not be used to
28  * endorse or promote products derived from this software without
29  * prior written permission. For written permission, please
30  * contact org@kannel.org.
31  *
32  * 5. Products derived from this software may not be called "Kannel",
33  * nor may "Kannel" appear in their name, without prior written
34  * permission of the Kannel Group.
35  *
36  * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
37  * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
38  * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
39  * DISCLAIMED. IN NO EVENT SHALL THE KANNEL GROUP OR ITS CONTRIBUTORS
40  * BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY,
41  * OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT
42  * OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR
43  * BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
44  * WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE
45  * OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
46  * EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
47  * ====================================================================
48  *
49  * This software consists of voluntary contributions made by many
50  * individuals on behalf of the Kannel Group. For more information on
51  * the Kannel Group, please see <http://www.kannel.org/>.
52  *
53  * Portions of this software are based upon software originally written at
54  * WapIT Ltd., Helsinki, Finland for the Kannel project.
55  */
56 
57 /*
58  * dbpool_sqlite.c - implement SQLite operations for generic database connection pool
59  *
60  * Stipe Tolj <stolj@wapme.de>
61  */
62 
63 #ifdef HAVE_SQLITE
64 #include <sqlite.h>
65 
66 static void *sqlite_open_conn(const DBConf *db_conf)
67 {
68  sqlite *db = NULL;
69  SQLiteConf *conf = db_conf->sqlite; /* make compiler happy */
70  char *errmsg = 0;
71 
72  /* sanity check */
73  if (conf == NULL)
74  return NULL;
75 
76  if ((db = sqlite_open(octstr_get_cstr(conf->file), 0, &errmsg)) == NULL) {
77  error(0, "SQLite: can not open database file `%s'!",
78  octstr_get_cstr(conf->file));
79  error(0, "SQLite: %s", errmsg);
80  goto failed;
81  }
82  if (conf->lock_timeout > 0) {
83  info(0, "SQLite: Setting lock timeout to %ld", conf->lock_timeout);
84  sqlite_busy_timeout(db, conf->lock_timeout);
85  }
86  info(0, "SQLite: Opened database file `%s'.", octstr_get_cstr(conf->file));
87  info(0, "SQLite: library version %s.", sqlite_version);
88 
89  return db;
90 
91 failed:
92  return NULL;
93 }
94 
95 static void sqlite_close_conn(void *conn)
96 {
97  if (conn == NULL)
98  return;
99 
100  sqlite_close((sqlite*) conn);
101 }
102 
103 static int sqlite_check_conn(void *conn)
104 {
105  if (conn == NULL)
106  return -1;
107 
108  /* XXX there is no such construct in SQLite?! */
109 
110  return 0;
111 }
112 
113 static void sqlite_conf_destroy(DBConf *db_conf)
114 {
115  SQLiteConf *conf = db_conf->sqlite;
116 
117  octstr_destroy(conf->file);
118 
119  gw_free(conf);
120  gw_free(db_conf);
121 }
122 
123 static struct db_ops sqlite_ops = {
124  .open = sqlite_open_conn,
125  .close = sqlite_close_conn,
126  .check = sqlite_check_conn,
127  .conf_destroy = sqlite_conf_destroy
128 };
129 
130 #endif /* HAVE_SQLITE */
131 
void error(int err, const char *fmt,...)
Definition: log.c:612
void info(int err, const char *fmt,...)
Definition: log.c:636
#define octstr_get_cstr(ostr)
Definition: octstr.h:233
void octstr_destroy(Octstr *ostr)
Definition: octstr.c:322
Definition: dbpool.h:164
Octstr * file
Definition: dbpool.h:128
int lock_timeout
Definition: dbpool.h:129
void *(* open)(const DBConf *conf)
Definition: dbpool_p.h:73
SQLiteConf * sqlite
Definition: dbpool.h:169
See file LICENSE for details about the license agreement for using, modifying, copying or deriving work from this software.