search evernote notes by keywords in title

evernote-search.py

#!/usr/bin/python

#search evernote notes keywords in title

import sqlite3

def main(endbfile, keywords):
    conn = sqlite3.connect(endbfile)
    cursor = conn.cursor()
    sql = """SELECT title, date_created, date_updated, source_url, uid
 FROM note_attr WHERE is_deleted=0 """
    #AND title like ? COLLATE NOCASE"""

    for keyword in keywords:
        sql = sql + ' AND title like "%%%s%%"' % keyword

    rs = cursor.execute(sql)
    if not rs:
        print("No note found.")
    else:
        for row in rs:
            data = { 'title': row[0],
                     'date_created': row[1],
                     'date_updated': row[2],
                     'url': row[3],
                     'uid': row[4] }
            try:
                print("%(uid)s: %(title)s\n    %(url)s" % data)
            except UnicodeEncodeError:
                pass
            #print row

if __name__ == '__main__':
    import sys
    endbfile = "/mnt/d/Programs/Evernote4/Databases/bamanzi.exb"
    main(endbfile, sys.argv[1:])

# vim:tabstop=8 softtabstop=4 expandtab