From 77df2d7165287246cb982d5a61ec92dce442b635 Mon Sep 17 00:00:00 2001 From: Sergey Mironov Date: Fri, 13 Sep 2013 10:09:15 -0400 Subject: Add hex SQL syntax for blobs, such as X'0ABC12343'. Works with sqlite. --- src/c/urweb.c | 25 ++++++++++++++++++++++++- 1 file changed, 24 insertions(+), 1 deletion(-) diff --git a/src/c/urweb.c b/src/c/urweb.c index 0b4b5846..30e4d7a6 100644 --- a/src/c/urweb.c +++ b/src/c/urweb.c @@ -2509,7 +2509,7 @@ uw_Basis_string uw_Basis_sqlifyChar(uw_context ctx, uw_Basis_char c) { char *uw_sqlsuffixBlob = "::bytea"; -uw_Basis_string uw_Basis_sqlifyBlob(uw_context ctx, uw_Basis_blob b) { +uw_Basis_string uw_Basis_sqlifyBlob_old(uw_context ctx, uw_Basis_blob b) { char *r, *s2; size_t i; @@ -2556,6 +2556,29 @@ uw_Basis_string uw_Basis_sqlifyBlob(uw_context ctx, uw_Basis_blob b) { return r; } +int uw_Xstrings = 1; + +uw_Basis_string uw_Basis_sqlifyBlob(uw_context ctx, uw_Basis_blob b) { + char *r, *s2; + size_t i; + + uw_check_heap(ctx, b.size * 2 + 3 + uw_Xstrings); + + r = s2 = ctx->heap.front; + *s2++ = 'X'; + *s2++ = '\''; + + for (i = 0; i < b.size; ++i) { + char c = b.data[i]; + sprintf(s2, "%02X", c); + s2 += 2; + } + + *s2++ = '\''; + ctx->heap.front = s2 + 1; + return r; +} + char *uw_Basis_sqlifyChannel(uw_context ctx, uw_Basis_channel chn) { int len; char *r; -- cgit v1.2.3