commit 0c8aea6cd1d4ec89d388972fbb204732fdc31132 Author: Sathyanarayanan Gunasekaran gsathya.ceg@gmail.com Date: Thu Sep 27 13:16:39 2012 +0530
make lookup and country parameters case insensitive --- pyonionoo/database.py | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/pyonionoo/database.py b/pyonionoo/database.py index 797ad2c..058db95 100644 --- a/pyonionoo/database.py +++ b/pyonionoo/database.py @@ -42,14 +42,14 @@ summary_schema = """ id INTEGER PRIMARY KEY, type TEXT, nickname TEXT, -fingerprint TEXT, -hashed_fingerprint TEXT, +fingerprint TEXT collate NOCASE, +hashed_fingerprint TEXT collate NOCASE, running BOOLEAN, time_published TEXT, or_port TEXT, dir_port TEXT, consensus_weight INTEGER, -country_code TEXT, +country_code TEXT collate NOCASE, hostname TEXT, time_lookup TEXT, flags TEXT,