# HG changeset patch # User Björn Ricks # Date 1358419192 -3600 # Node ID 4f1c53bd8ba1f8e94e06b981524120ab783a6531 # Parent 737e6936987396bc0c26410d3e80461b0bd64148 Remove whitespace diff -r 737e69369873 -r 4f1c53bd8ba1 getan/contrib/zeiterfassung.py --- a/getan/contrib/zeiterfassung.py Thu Dec 13 16:00:32 2012 +0100 +++ b/getan/contrib/zeiterfassung.py Thu Jan 17 11:39:52 2013 +0100 @@ -55,22 +55,22 @@ ''' WEEK_ENTRIES = ''' -SELECT - date(start_time) AS t, - sum(strftime('%s', stop_time) - strftime('%s', start_time)), +SELECT + date(start_time) AS t, + sum(strftime('%s', stop_time) - strftime('%s', start_time)), 'no description' AS description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND (strftime('%Y', start_time) ) = :year AND (description IS NULL or length(description) = 0) -- trim() function is missing AND (strftime('%W', start_time) = :week OR strftime('%W', stop_time) = :week) GROUP BY round(julianday(start_time)) UNION SELECT date(start_time) AS s, strftime('%s', stop_time) - strftime('%s', start_time), description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND (strftime('%Y', start_time) ) = :year AND description IS NOT NULL AND length(description) > 0 AND (strftime('%W', start_time) = :week OR strftime('%W', stop_time) = :week) @@ -78,38 +78,38 @@ ''' ENTRIES = ''' -SELECT - date(start_time), - sum(strftime('%s', stop_time) - strftime('%s', start_time)), +SELECT + date(start_time), + sum(strftime('%s', stop_time) - strftime('%s', start_time)), 'no description' AS description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND (description IS NULL or length(description) = 0) -- trim() function is missing GROUP BY round(julianday(start_time)) UNION SELECT date(start_time), strftime('%s', stop_time) - strftime('%s', start_time), description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND description IS NOT NULL AND length(description) > 0 ''' ENTRIES_YEAR = ''' -SELECT - date(start_time), - sum(strftime('%s', stop_time) - strftime('%s', start_time)), +SELECT + date(start_time), + sum(strftime('%s', stop_time) - strftime('%s', start_time)), 'no description' AS description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND (description IS NULL or length(description) = 0) -- trim() function is missing GROUP BY round(julianday(start_time)) UNION SELECT date(start_time), strftime('%s', stop_time) - strftime('%s', start_time), description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND (strftime('%Y', start_time) ) = :year AND description IS NOT NULL AND length(description) > 0 ''' @@ -242,7 +242,7 @@ if row or empty_proj: print "# project: %s (%s)" % (project, proj_desc) while row: - d = date(*map(int, row[0].split('-'))) + d = date(*map(int, row[0].split('-'))) t = max(60, row[1]) c = row[2] total_proj += t