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

---
 odb/query-dynamic.hxx | 43 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 43 insertions(+)

(limited to 'odb/query-dynamic.hxx')

diff --git a/odb/query-dynamic.hxx b/odb/query-dynamic.hxx
index a2779b1..132e0c0 100644
--- a/odb/query-dynamic.hxx
+++ b/odb/query-dynamic.hxx
@@ -135,6 +135,8 @@ namespace odb
         op_not_null,    // is_not_null ()
 
         op_in,          // in(), data is the number of arguments
+        op_like,        // like(pattern)
+        op_like_escape, // like(pattern, escape)
 
         op_eq,          // ==
         op_ne,          // !=
@@ -415,6 +417,47 @@ namespace odb
     query_base
     in_range (I begin, I end) const;
 
+    // like
+    //
+  public:
+    query_base
+    like (const T& pattern) const
+    {
+      return like (val_bind<T> (pattern));
+    }
+
+    query_base
+    like (val_bind<T> pattern) const;
+
+    template <typename T2>
+    query_base
+    like (val_bind<T2> pattern) const
+    {
+      return like (val_bind<T> (T (pattern.val)));
+    }
+
+    query_base
+    like (ref_bind<T> pattern) const;
+
+    query_base
+    like (const T& pattern, const T& escape) const
+    {
+      return like (val_bind<T> (pattern), escape);
+    }
+
+    query_base
+    like (val_bind<T> pattern, const T& escape) const;
+
+    template <typename T2>
+    query_base
+    like (val_bind<T2> pattern, const T& escape) const
+    {
+      return like (val_bind<T> (T (pattern.val)), escape);
+    }
+
+    query_base
+    like (ref_bind<T> pattern, const T& escape) const;
+
     // ==
     //
   public:
-- 
cgit v1.1