C:\Users\hoge\AppData\Local\Evernote test 201411

selectFromEverNote.groovy

@Grab('org.xerial:sqlite-jdbc:[3.7.2,)')
@GrabConfig(systemClassLoader=true)
import groovy.sql.Sql

def home = args[0]
def tag = args[1]
def date = args[2]
 
Class.forName("org.sqlite.SQLite")
 
sql = Sql.newInstance("jdbc:sqlite:${home}/Evernote/Evernote/Databases/orangeclover.exb", "org.sqlite.JDBC")
sql.eachRow("SELECT title,source_url FROM note_attr WHERE notebook COLLATE NOCASE LIKE '${date}' AND (tags LIKE '%${tag}%');"){
    println "[ ${it.source_url}:title=${it.title}]"
}