bs

#!/bin/bash

# Del.icio.us search script
DB=/home/enrique/bookmark-search/bookmarks.sqlite

PATTERN="$1"

if [ "${PATTERN}" != "" ]
then
 sqlite3 "${DB}" '.mode lines' 'select title,url,tags,datetime(add_date, '\''unixepoch'\'') as date,comment from links where
  tags like '\'"${PATTERN}"\'' or
  tags like '\'"${PATTERN}"',%'\'' or
  tags like '\''%,'"${PATTERN}"',%'\'' or
  tags like '\''%,'"${PATTERN}"\''
  order by date desc;' | less
else
 read -p "url: " -e URL
 ID=$(sqlite3 "${DB}" "select id from links where url='${URL}';")

 if [ -n "${ID}" ]
 then
  TITLE=$(sqlite3 "${DB}" "select title from links where id=${ID}")
  TAGS=$(sqlite3 "${DB}" "select tags from links where id=${ID}")
  COMMENT=$(sqlite3 "${DB}" "select comment from links where id=${ID}")
 fi
 read -p "title: " -i "${TITLE}" -e TITLE
 read -p "tags: " -i "${TAGS}" -e TAGS
 read -p "comment: " -i "${COMMENT}" -e COMMENT

 TITLE=$(echo "${TITLE}" | sed -e "s/'/''/g")
 TAGS=$(echo "${TAGS}" | sed -e "s/'/''/g")
 COMMENT=$(echo "${COMMENT}" | sed -e "s/'/''/g")

 if [ -n "${ID}" ]
 then
  sqlite3 "${DB}" "update links set title='${TITLE}', tags='${TAGS}', comment='${COMMENT}', add_date='$(date +%s)' where id=${ID}"
 else
  sqlite3 "${DB}" "insert into links (url,title,tags,comment,add_date) values ('${URL}','${TITLE}','${TAGS}','${COMMENT}','$(date +%s)')"
 fi
fi