Mercurial > mercurial > hgweb_searcher03.cgi

comparison src/db.cpp @ 6:76db82822e73

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Implement kana fuzzy search. Implement batch print log.
author pyon@macmini
date Wed, 18 Sep 2013 18:20:40 +0900
parents fdba695b99f1
children 7ac7d28699af
comparison
equal deleted inserted replaced
5:bc2e2b304095 6:76db82822e73
1 // Filename : db.cpp 1 // Filename : db.cpp
2 // Last Change: 11-Sep-2013. 2 // Last Change: 18-Sep-2013.
3 // 3 //
4 4
5 #include "db.h" 5 #include "db.h"
6 #include "wx/wxsqlite3.h" 6 #include "wx/wxsqlite3.h"
7 7
42 42
43 wxString gszFile = wxGetCwd() + wxFILE_SEP_PATH + wxT("db") + wxFILE_SEP_PATH + wxT("hhs.db"); 43 wxString gszFile = wxGetCwd() + wxFILE_SEP_PATH + wxT("db") + wxFILE_SEP_PATH + wxT("hhs.db");
44 wxSQLite3Database hhsdb; 44 wxSQLite3Database hhsdb;
45 hhsdb.Open( gszFile ); 45 hhsdb.Open( gszFile );
46 46
47 wxString sql = wxT( "SELECT hhsno, kana, name, birth, addr FROM hhs_master WHERE kana = ? ORDER BY kana, birth;" ); 47 wxString sql = wxT( "SELECT hhsno, kana, name, birth, addr FROM hhs_master " );
48 //if ( fuzzy ) ;//***** 48 if ( fuzzy ) {
49 kana = wxT("%") + kana + wxT("%");
50 sql += wxT( "WHERE kana LIKE ? ORDER BY kana, birth;" );
51 }
52 else {
53 sql += wxT( "WHERE kana = ? ORDER BY kana, birth;" );
54 }
49 55
50 wxSQLite3Statement stmt = hhsdb.PrepareStatement( sql ); 56 wxSQLite3Statement stmt = hhsdb.PrepareStatement( sql );
51 stmt.Bind( 1, kana ); 57 stmt.Bind( 1, kana );
52 wxSQLite3ResultSet q = stmt.ExecuteQuery(); 58 wxSQLite3ResultSet q = stmt.ExecuteQuery();
53 59