X-Git-Url: https://vcs.fsf.org/?p=exim.git;a=blobdiff_plain;f=src%2Fsrc%2Flookups%2Fsqlite.c;h=51d28c2cae3f01ca36a7a5c806aa2335116d0a05;hp=e679973b30e002d4d87142960e05589b4b181adc;hb=298849d8ea217fd104d167f5233bd11240b3ddae;hpb=6545de78cb822ab5db97a2f16fe7a42cc9488bd8 diff --git a/src/src/lookups/sqlite.c b/src/src/lookups/sqlite.c index e679973b3..51d28c2ca 100644 --- a/src/src/lookups/sqlite.c +++ b/src/src/lookups/sqlite.c @@ -1,10 +1,8 @@ -/* $Cambridge: exim/src/src/lookups/sqlite.c,v 1.5 2009/11/16 19:50:38 nm4 Exp $ */ - /************************************************* * Exim - an Internet mail transport agent * *************************************************/ -/* Copyright (c) University of Cambridge 1995 - 2009 */ +/* Copyright (c) University of Cambridge 1995 - 2018 */ /* See the file NOTICE for conditions of use and distribution. */ #include "../exim.h" @@ -20,16 +18,18 @@ /* See local README for interface description. */ static void * -sqlite_open(uschar *filename, uschar **errmsg) +sqlite_open(const uschar * filename, uschar ** errmsg) { sqlite3 *db = NULL; int ret; -ret = sqlite3_open((char *)filename, &db); -if (ret != 0) +if (!filename || !*filename) filename = sqlite_dbfile; +if (*filename != '/') + *errmsg = US"absolute file name expected for \"sqlite\" lookup"; +else if ((ret = sqlite3_open(CCS filename, &db)) != 0) { *errmsg = (void *)sqlite3_errmsg(db); - debug_printf("Error opening database: %s\n", *errmsg); + DEBUG(D_lookup) debug_printf_indent("Error opening database: %s\n", *errmsg); } sqlite3_busy_timeout(db, 1000 * sqlite_lock_timeout); @@ -43,61 +43,51 @@ return db; /* See local README for interface description. */ -struct strbuf { - uschar *string; - int size; - int len; -}; - -static int sqlite_callback(void *arg, int argc, char **argv, char **azColName) +static int +sqlite_callback(void *arg, int argc, char **argv, char **azColName) { -struct strbuf *res = arg; -int i; +gstring * res = *(gstring **)arg; /* For second and subsequent results, insert \n */ -if (res->string != NULL) - res->string = string_cat(res->string, &res->size, &res->len, US"\n", 1); +if (res) + res = string_catn(res, US"\n", 1); if (argc > 1) { /* For multiple fields, include the field name too */ - for (i = 0; i < argc; i++) + for (int i = 0; i < argc; i++) { uschar *value = US((argv[i] != NULL)? argv[i]:""); - res->string = lf_quote(US azColName[i], value, Ustrlen(value), res->string, - &res->size, &res->len); + res = lf_quote(US azColName[i], value, Ustrlen(value), res); } } else - { - res->string = string_append(res->string, &res->size, &res->len, 1, - (argv[0] != NULL)? argv[0]:""); - } + res = string_cat(res, argv[0] ? US argv[0] : US ""); -res->string[res->len] = 0; +*(gstring **)arg = res; return 0; } static int -sqlite_find(void *handle, uschar *filename, uschar *query, int length, - uschar **result, uschar **errmsg, BOOL *do_cache) +sqlite_find(void * handle, const uschar * filename, const uschar * query, + int length, uschar ** result, uschar ** errmsg, uint * do_cache) { int ret; -struct strbuf res = { NULL, 0, 0 }; +gstring * res = NULL; -ret = sqlite3_exec(handle, (char *)query, sqlite_callback, &res, (char **)errmsg); +ret = sqlite3_exec(handle, CS query, sqlite_callback, &res, (char **)errmsg); if (ret != SQLITE_OK) { - debug_printf("sqlite3_exec failed: %s\n", *errmsg); + debug_printf_indent("sqlite3_exec failed: %s\n", *errmsg); return FAIL; } -if (res.string == NULL) *do_cache = FALSE; +if (!res) *do_cache = 0; -*result = res.string; +*result = string_from_gstring(res); return OK; } @@ -143,7 +133,7 @@ if (opt != NULL) return NULL; /* No options recognized */ while ((c = *t++) != 0) if (c == '\'') count++; if (count == 0) return s; -t = quoted = store_get(Ustrlen(s) + count + 1); +t = quoted = store_get(Ustrlen(s) + count + 1, is_tainted(s)); while ((c = *s++) != 0) {