Added search by name

[familyTree.git] / familyTree / askQuestion.py

diff --git a/familyTree/askQuestion.py b/familyTree/askQuestion.py
index 179888c62ab38b357a019de984fdad3bc27066db..364f08888f0e1cdf4e1050b36bc298f70ad660dd 100755 (executable)
--- a/familyTree/askQuestion.py
+++ b/familyTree/askQuestion.py
@@ -77,7 +77,16 @@ def print_age_count(row,newLine):
                         + link + newLine
        else:
                return print_row(row,newLine)
-       
+
+
+def print_name_count(row,newLine):
+       if newLine=='<br>':
+               script = "name.py?name=" + row[0]
+               link = link_Template.substitute(script =\
+                       script, text = row[0])
+               return str(row[1]) + " people called "+link + newLine
+       else:
+               return print_row(row,newLine)   
 
 def print_tagged_name(relationship,row,newLine):
        if row[0]==None:
@@ -227,8 +236,23 @@ def count_names(newLine):
        +" GROUP BY firstName"\
        +" ORDER BY count(*) DESC;"
 
-       out = print_query(s,(),newLine)
-       
+       out = ''
+       for row in run_query(s,()):
+               out = out + print_name_count(row,newLine)
+
+       return out
+
+def people_with_name(name,newLine):
+       s = "SELECT Name, ID"\
+       +" FROM people"\
+       +" WHERE Name LIKE ?;"
+
+       out = ''
+
+       t = (name + '%',)
+
+       for row in run_query(s,t):
+               out = out + name_html(row,newLine) + newLine
 
        return out