Project

General

Profile

Necessary Maintenance #7787

Documentation needed for TimeTracker

Added by Marc Paterno almost 6 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
-
Start date:
02/05/2015
Due date:
% Done:

100%

Estimated time:
Spent time:
Scope:
Internal
Experiment:
-
SSI Package:
Duration:

Description

The art wiki at https://cdcvs.fnal.gov/redmine/projects/art/wiki should grow a new page describing how to use TimeTracker. This should include:

  1. How to configure the service
  2. Output showing the schema of the database table(s) involved
  3. An example sqlite3 command-line execution that dumps all the data to standard output
  4. An example sqlite3 command-line execution that uses some SQL to select data for only some specified module
  5. An example sqlite3 command-line execution that shows some use of SQL aggregate functions (e.g. avg)

We should also have pointers to the SQLite documentation online, and to relevant ROOT documentation (maybe https://root.cern.ch/root/html/TSQLServer.html), and Python documentation (https://docs.python.org/2/library/sqlite3.html).

History

#1 Updated by Christopher Green almost 6 years ago

  • Status changed from New to Accepted

#2 Updated by Kyle Knoepfel almost 6 years ago

  • Assignee set to Kyle Knoepfel
  • % Done changed from 0 to 30

Service configuration and database schemas documented here.

#3 Updated by Kyle Knoepfel over 5 years ago

  • Status changed from Accepted to Resolved
  • % Done changed from 30 to 100

SQLite help is now documented here, which is linked from the main art Wikipage.

#4 Updated by Kyle Knoepfel over 5 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF