diff src/db.cpp @ 6:76db82822e73

Implement kana fuzzy search. Implement batch print log.
author pyon@macmini
date Wed, 18 Sep 2013 18:20:40 +0900
parents fdba695b99f1
children 7ac7d28699af
line wrap: on
line diff
--- a/src/db.cpp	Sat Sep 14 08:54:47 2013 +0900
+++ b/src/db.cpp	Wed Sep 18 18:20:40 2013 +0900
@@ -1,5 +1,5 @@
 // Filename   : db.cpp
-// Last Change: 11-Sep-2013.
+// Last Change: 18-Sep-2013.
 //
 
 #include "db.h"
@@ -44,8 +44,14 @@
     wxSQLite3Database hhsdb;
     hhsdb.Open( gszFile );
 
-    wxString sql = wxT( "SELECT hhsno, kana, name, birth, addr FROM hhs_master WHERE kana = ? ORDER BY kana, birth;" ); 
-    //if ( fuzzy ) ;//*****
+    wxString sql = wxT( "SELECT hhsno, kana, name, birth, addr FROM hhs_master " );
+    if ( fuzzy ) {
+        kana = wxT("%") + kana + wxT("%");
+        sql += wxT( "WHERE kana LIKE ? ORDER BY kana, birth;" ); 
+    }
+    else {
+        sql += wxT( "WHERE kana = ? ORDER BY kana, birth;" ); 
+    }
 
     wxSQLite3Statement stmt = hhsdb.PrepareStatement( sql );
     stmt.Bind( 1, kana );