prescript to Automator that extracts the latest Day One journal entry.

latest_dayone_entry.rb

#
# See also: https://gist.github.com/3508021
#
require 'rubygems'
require 'sqlite3'

DAYONE_JOURNAL_PATH = "~/Library/Containers/com.dayoneapp.dayone/Data/Library/Application\ Support/Journal.sqlite"

db = SQLite3::Database.new(DAYONE_JOURNAL_PATH)
row = db.execute('select Z_PK, Z_ENT, Z_OPT, ZCREATIONYEAR, ZISENTRYDELETED,ZSTARRED,ZCREATIONDATE, ZMODIFIED,ZPHOTOMODIFIED,ZENTRYTEXT, ZUUID, ZLOCATION, ZWEATHER from ZJOURNALENTRY order by Z_PK DESC limit 1')[0]

creation_date = DateTime.strptime(row[6].to_s, '%s')
creation_date = Time.parse(creation_date.to_s).strftime("%m/%d/%Y %I:%M:%S %p")

puts creation_date, row[3], row[9]