to_csv

#!/usr/bin/env zsh

BASE=${0%/*}
SQLITE=/usr/bin/sqlite3

echo "Extracting from OmniFocus"
$BASE/of-store --debug --out=$BASE/finished.db
$BASE/kanban-fetch --debug --out=$BASE/inprogress.db

echo "Exporting to tasks.csv"
$SQLITE $BASE/finished.db <<!
.headers on
.mode csv
.output tasks.csv
select * from tasks;
!

echo "Exporting to projects.csv"
$SQLITE $BASE/finished.db <<!
.headers on
.mode csv
.output projects.csv
select * from projects;
!

echo "Exporting to kanban.csv"
$SQLITE $BASE/inprogress.db <<!
.headers on
.mode csv
.output kanban.csv
select * from projects;
!