view contrib/convert-projects @ 100:8f433e3c2f21

Allow to pass entries to the DeleteEntryState By default DeleteEntryState uses the selected entries if no entry is passes to the constructor. This allows to reuse the state class for single entry deletion
author Björn Ricks <bjoern.ricks@intevation.de>
date Mon, 12 Sep 2011 14:05:34 +0200
parents a3fe8e4e9184
children
line wrap: on
line source
#!/usr/bin/awk -f

# Convert classic worklog projects file to SQL statements for inseration in the getan database.
# USAGE:
# ./convert-projects </PATH/TO/projects | sqlite3 time.db

BEGIN { FS=":"; }

/[^# \t]/ {
    printf "INSERT INTO projects (key, description) VALUES ('%s', '%s');\n", $1, $2;
}
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)