Changeset 163:a1304a86b5d2

Timestamp:

08/23/07 13:25:06 (15 months ago)

Author:

Tarek Ziad?? <tarek@…>

Message:

merged

Location:

xap

Files:

• doc/indexer.txt (modified) (1 diff)
• model.py (modified) (3 diffs)
• searcher.py (modified) (3 diffs)

xap/doc/indexer.txt

@@ -143 +143 @@
     []
 
+statistics
+==========
+
+We can also do a bit of statistics::
+
+
+

xap/model.py

@@ -7 +7 @@
 
 
-index_data = Table('index_data', metadata,
+index_data = Table('xap_index_data', metadata,
                    Column('docid', String(10)),
                    Column('data', TEXT()))
@@ -17 +17 @@
     pass
 
-remove_data = Table('remove_data', metadata,
+remove_data = Table('xap_remove_data', metadata,
                    Column('docid', String(10)),)
 
@@ -26 +26 @@
     pass
 
+statistics = Table('xap_statistics', metadata,
+                   Column('query', String(200)),
+                   Column('count', Integer))
 
+try:
+    statistics.create()
+except exceptions.SQLError:
+    # already exists
+    pass
+
+

xap/searcher.py

@@ +1 @@
+#!/usr/bin/python
+# -*- coding: UTF-8 -*-
+#
+# Copyright (c) 2007 Tarek Ziadé
+#
+# Authors:
+#   Tarek Ziadé <tarek@ziade.org>
+#
+# This program is free software; you can redistribute it and/or
+# modify it under the terms of the GNU General Public License
+# as published by the Free Software Foundation; either version 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+""" Searcher
+"""
+
 import os
 import logging
@@ -5 +29 @@
 from tokenizer import tokenize
 from settings import DB_FILE
+from model import statistics
 
 def read_only():
@@ -63 +88 @@
     logging.debug('searching for "%s" is over' % query)
 
+    stat = statistics.select(statistics.c.query==query).execute().fetchone()
+
+    if stat is not None:
+        count = stat.count
+        stat.close()
+        statistics.update(statistics.c.query==query).execute(count=count+1)
+    else:
+        statistics.insert().execute(query=query, count=1)
+
     return (_extract_uid(el) for el in res)
 
+def query_stats(query):
+    """will return stats"""
+    stat = statistics.select(statistics.c.query==query).execute().fetchone()
+    if stat is None:
+        return 0
+    return stat.count
 
+def query_suggestions(query):
+    """will return suggestions on search"""
+    return statistics.select(statistics.c.query.like(query+'%')).execute()
+