from sqlite3 import *
import datetime, time
import email.utils
from optparse import OptionParser
import os.path
import os
import sys
import simplejson
import re

if __name__ == "__main__" :

    parser = OptionParser()

    (options, args) = parser.parse_args()
    
    conn = connect(args[0])
    conn.row_factory = Row
    curs = conn.cursor()
    
    names = {}
    
    curs.execute("select tt.text as text from tweet_tweet as tt left join tweet_user as tu on tt.user = tu.rowid where tt.text like \"%ENMI09%\" order by tt.created_at_ts asc;")
    
    regexp = re.compile("\@(\w+)")
    
    for row in curs:
        text = row["text"]
        for m in regexp.finditer(text):
            names[m.group(1)]=m.group(1)
    
    
    print repr(names.keys())
    print repr(len(names.keys()))
            
        
