User Story
As user or maintainer of the platform, I would like to get some statistics about the data available in the database:
- Number of experiments
- Number of experiment tasks
Solution
Data Retrieval
The data can be easily retrieved by adding two new methods to the ExperimentDAOImpl class. Each method can run a simple SELECT COUNT(*) FROM tablename SQL query for the two tables Experiments and ExperimentTasks, expectively. (SQL Schema)
Access
The gerbil web service should provide a new method statistics returning the two counts:
{
"experiments": 13,
"experiment_tasks": 42,
}
User Story
As user or maintainer of the platform, I would like to get some statistics about the data available in the database:
Solution
Data Retrieval
The data can be easily retrieved by adding two new methods to the
ExperimentDAOImplclass. Each method can run a simpleSELECT COUNT(*) FROM tablenameSQL query for the two tablesExperimentsandExperimentTasks, expectively. (SQL Schema)Access
The gerbil web service should provide a new method
statisticsreturning the two counts:{ "experiments": 13, "experiment_tasks": 42, }