From c0b4a0b316d5c9bef7b8708d94d226c60e107f97 Mon Sep 17 00:00:00 2001 From: Aki Tuomi Date: Thu, 30 Jul 2015 20:13:10 +0300 Subject: [PATCH] Add search records/comments to gOracle backend --- modules/goraclebackend/goraclebackend.cc | 2 ++ 1 file changed, 2 insertions(+) diff --git a/modules/goraclebackend/goraclebackend.cc b/modules/goraclebackend/goraclebackend.cc index b45a5ced88..6ae4c87855 100644 --- a/modules/goraclebackend/goraclebackend.cc +++ b/modules/goraclebackend/goraclebackend.cc @@ -140,6 +140,8 @@ public: declare(suffix, "insert-comment-query", "", "INSERT INTO comments (id, domain_id, name, type, modified_at, account, \"comment\") VALUES (comments_id_sequence.nextval, :domain_id, :qname, :qtype, :modified_at, :account, :content)"); declare(suffix, "delete-comment-rrset-query", "", "DELETE FROM comments WHERE domain_id=:domain_id AND name=:qname AND type=:qtype"); declare(suffix, "delete-comments-query", "", "DELETE FROM comments WHERE domain_id=:domain_id"); + declare(suffix, "search-records-query", "", record_query+" name LIKE :value OR content LIKE :value2 LIMIT :limit"); + declare(suffix, "search-comments-query", "", "SELECT domain_id,name,type,modified_at,account,comment FROM comments WHERE name LIKE :value OR comment LIKE :value2 LIMIT :limit"); } -- 2.47.2