Mercurial > getan

annotate scripts/convert-projects @ 488:463894654d77 3.0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Prepares for release 3.0 rename getan-eval.py to getan-report. rename getan-report.py to getan-day-report installed getan-report as script. installed getan-day-report as script. set python_requires to >=3.4
author Magnus Schieder <mschieder@intevation.de>
date Fri, 29 Jun 2018 19:47:01 +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)