aboutsummaryrefslogtreecommitdiff
path: root/doc.go
diff options
context:
space:
mode:
authorDavid Anderson <dave@natulte.net>2015-08-20 23:08:48 -0700
committerDavid Anderson <dave@natulte.net>2015-08-21 13:39:50 -0700
commitcf8fa0af80e0d227c79ef2b4635e8d0d77432275 (patch)
treeaa5d09e0d949847240ef50f3da2ad1b99f5cefe2 /doc.go
parentMerge pull request #228 from whiter4bbit/added_icu_support (diff)
downloadgolite-cf8fa0af80e0d227c79ef2b4635e8d0d77432275.tar.gz
golite-cf8fa0af80e0d227c79ef2b4635e8d0d77432275.tar.xz
Implement support for passing Go functions as custom functions to SQLite.
Fixes #226.
Diffstat (limited to 'doc.go')
-rw-r--r--doc.go23
1 files changed, 20 insertions, 3 deletions
diff --git a/doc.go b/doc.go
index 51364c3..a45d852 100644
--- a/doc.go
+++ b/doc.go
@@ -33,7 +33,7 @@ extension for Regexp matcher operation.
#include <string.h>
#include <stdio.h>
#include <sqlite3ext.h>
-
+
SQLITE_EXTENSION_INIT1
static void regexp_func(sqlite3_context *context, int argc, sqlite3_value **argv) {
if (argc >= 2) {
@@ -44,7 +44,7 @@ extension for Regexp matcher operation.
int vec[500];
int n, rc;
pcre* re = pcre_compile(pattern, 0, &errstr, &erroff, NULL);
- rc = pcre_exec(re, NULL, target, strlen(target), 0, 0, vec, 500);
+ rc = pcre_exec(re, NULL, target, strlen(target), 0, 0, vec, 500);
if (rc <= 0) {
sqlite3_result_error(context, errstr, 0);
return;
@@ -52,7 +52,7 @@ extension for Regexp matcher operation.
sqlite3_result_int(context, 1);
}
}
-
+
#ifdef _WIN32
__declspec(dllexport)
#endif
@@ -91,5 +91,22 @@ you need to hook ConnectHook and get the SQLiteConn.
},
})
+Go SQlite3 Extensions
+
+If you want to register Go functions as SQLite extension functions,
+call RegisterFunction from ConnectHook.
+
+ regex = func(re, s string) (bool, error) {
+ return regexp.MatchString(re, s)
+ }
+ sql.Register("sqlite3_with_go_func",
+ &sqlite3.SQLiteDriver{
+ ConnectHook: func(conn *sqlite3.SQLiteConn) error {
+ return conn.RegisterFunc("regex", regex, true)
+ },
+ })
+
+See the documentation of RegisterFunc for more details.
+
*/
package sqlite3