From b580f1548ff335a0e1fa004fc6626486535c94e1 Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Thu, 21 Feb 2013 11:07:25 +0200
Subject: Add support for pattern matching (SQL LIKE)

---
 odb/sqlite/query-dynamic.cxx | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'odb/sqlite/query-dynamic.cxx')

diff --git a/odb/sqlite/query-dynamic.cxx b/odb/sqlite/query-dynamic.cxx
index aeeb841..343e42c 100644
--- a/odb/sqlite/query-dynamic.cxx
+++ b/odb/sqlite/query-dynamic.cxx
@@ -110,6 +110,22 @@ namespace odb
           q += ")";
           break;
         }
+      case part::op_like:
+        {
+          translate (q, s, p - 2); // column
+          q += "LIKE";
+          translate (q, s, p - 1); // pattern
+          break;
+        }
+      case part::op_like_escape:
+        {
+          translate (q, s, p - 3); // column
+          q += "LIKE";
+          translate (q, s, p - 2); // pattern
+          q += "ESCAPE";
+          translate (q, s, p - 1); // escape
+          break;
+        }
       case part::op_eq:
       case part::op_ne:
       case part::op_lt:
-- 
cgit v1.1