From 0247c6063c5dc9e592e48fc85c807893d8b34033 Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Tue, 17 Dec 2019 19:02:53 -0500 Subject: Separate dbBindText wrappers to allow for transient --- unscoop.c | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'unscoop.c') diff --git a/unscoop.c b/unscoop.c index c4e9d33..6fd8c28 100644 --- a/unscoop.c +++ b/unscoop.c @@ -210,9 +210,9 @@ static void bindMatch( sqlite3_stmt *stmt, const char *param, const char *str, regmatch_t match ) { if (match.rm_so < 0) { - dbBindText(stmt, param, NULL, -1); + dbBindNull(stmt, param); } else { - dbBindText(stmt, param, &str[match.rm_so], match.rm_eo - match.rm_so); + dbBindTextLen(stmt, param, &str[match.rm_so], match.rm_eo - match.rm_so); } } @@ -245,8 +245,8 @@ static void prepareInsert(sqlite3 *db) { AND names.host = coalesce(:host, '*'); ); insertEvent = dbPrepare(db, SQLITE_PREPARE_PERSISTENT, InsertEvent); - paramNetwork = sqlite3_bind_parameter_index(insertEvent, ":network"); - paramContext = sqlite3_bind_parameter_index(insertEvent, ":context"); + paramNetwork = dbParam(insertEvent, ":network"); + paramContext = dbParam(insertEvent, ":context"); } static void @@ -348,12 +348,12 @@ int main(int argc, char *argv[]) { sqlite3_stmt *insertContext = dbPrepare( db, SQLITE_PREPARE_PERSISTENT, InsertContext ); - dbBindText(insertContext, ":network", network, -1); - dbBindText(insertContext, ":context", context, -1); + dbBindText(insertContext, ":network", network); + dbBindText(insertContext, ":context", context); prepareInsert(db); - dbBindText(insertEvent, ":network", network, -1); - dbBindText(insertEvent, ":context", context, -1); + dbBindText(insertEvent, ":network", network); + dbBindText(insertEvent, ":context", context); size_t sizeTotal = 0; size_t sizeRead = 0; -- cgit 1.4.1