teichmann@1: #!/usr/bin/awk -f
teichmann@1: 
teichmann@1: # Convert classic worklog projects file to SQL statements for inseration in the getan database.
teichmann@1: # USAGE:
teichmann@1: # ./convert-projects </PATH/TO/projects | sqlite3 time.db
teichmann@1: 
teichmann@1: BEGIN { FS=":"; }
teichmann@1: 
teichmann@1: /[^# \t]/ {
teichmann@1:     printf "INSERT INTO projects (key, description) VALUES ('%s', '%s');\n", $1, $2;
teichmann@1: }