Mercurial > mercurial > hgweb_searcher03.cgi
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 );