Mercurial > getan

annotate scripts/convert-projects @ 416:857d76de4a2f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Version: bumped to 2.0.dev0 * Switches to a development release version conforming to PEP 440.
author Bernhard Reiter <bernhard@intevation.de>
date Wed, 03 May 2017 14:06:35 +0200
parents 20fde79f8e12
children
rev   line source
1
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
1 #!/usr/bin/awk -f
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
2
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
3 # Convert classic worklog projects file to SQL statements for inseration in the getan database.
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
4 # USAGE:
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
5 # ./convert-projects </PATH/TO/projects | sqlite3 time.db
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
6
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
7 BEGIN { FS=":"; }
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
8
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
9 /[^# \t]/ {
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
10 printf "INSERT INTO projects (key, description) VALUES ('%s', '%s');\n", $1, $2;
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
11 }
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)