Mercurial > getan

annotate contrib/convert-projects @ 25:155b23da504b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Bugfix and improvements in the process to move/delete entries.
author Ingo Weinzierl <ingo_weinzierl@web.de>
date Sun, 29 Aug 2010 19:56:11 +0200
parents a3fe8e4e9184
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)