View Single Post
Old 12-29-2011, 06:38 AM   #12
fei-d
Member
fei-d is on a distinguished road
 
Posts: 14
Karma: 50
Join Date: Jan 2010
Device: Sony PRS 505
So I checked again if I had installed sqlite3 and even installed it again...

Opitzs's advice seemed to help. Now cygwin at least runs the code.

But now I get another error: "Error: unable to open database "Sony_Reader/database/books.db": unable to open database file"

This is really getting frustrating...

I tried the following code:
Quote:
#!/bin/bash
OUTPUT_FILE='quotes.txt'
SQLITE='sqlite3'
AWK='awk'

#add the UTF-8 BOM to the generated file
echo -ne '\xEF\xBB\xBF' > $OUTPUT_FILE
$SQLITE Sony_Reader/database/books.db 'select b.author, b.title, a.marked_text FROM annotation a INNER JOIN books b on a.content_id=b._id' | \
$AWK -F '|' '{ print "--------------------\nAuthor: "$1"\nTitle: "$2"\n--------------------\n"$3"\n--------------------" }'| \
unix2dos >> $OUTPUT_FILE
fei-d is offline   Reply With Quote