Skip to content

Instantly share code, notes, and snippets.

@orangeclover
Created May 26, 2012 07:28
Show Gist options
  • Select an option

  • Save orangeclover/2792771 to your computer and use it in GitHub Desktop.

Select an option

Save orangeclover/2792771 to your computer and use it in GitHub Desktop.
GroovyでEvernoteをごにょごにょする方法
@Grab('org.xerial:sqlite-jdbc:[3.7.2,)')
@GrabConfig(systemClassLoader=true)
import groovy.sql.Sql
Class.forName("org.sqlite.SQLite")
sql = Sql.newInstance("jdbc:sqlite:C:/Users/orangeclover/AppData/Local/Evernote/Evernote/Databases/orangeclover.exb", "org.sqlite.JDBC")
sql.eachRow("SELECT title,source_url FROM note_attr WHERE notebook COLLATE NOCASE LIKE '201204' AND (tags LIKE '%Groovy%' OR tags LIKE '%G*%');"){
println "[ ${it.source_url}:title=${it.title}]"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment