MantisBT - AChecker
View Issue Details
0004721ACheckerReportpublic2011-02-04 14:212018-03-08 13:31
cindy 
cindy 
highminoralways
closedfixed 
1.1 
SVNSVN 
490
0004721: Stopped saving the question answers with "no decision" into database
This will dramatically reduce the records in "user_decisions" table which in turn will speed up the SQL operations on this table.

This improvement will affect various functions from the table structure of "user_decisions", the returned html and rest error report, the backend operation on saving report records and even the web service.
No tags attached.
Issue History
2011-02-04 14:21cindyNew Issue
2011-02-04 14:21cindyStatusnew => assigned
2011-02-04 14:21cindyAssigned To => cindy
2011-02-04 14:28cindySVN Revision# => 490
2011-02-04 14:28cindyNote Added: 0005044
2011-02-04 14:28cindyStatusassigned => resolved
2011-02-04 14:28cindyFixed in Version => SVN
2011-02-04 14:28cindyResolutionopen => fixed
2018-03-08 13:31cindyStatusresolved => closed

Notes
(0005044)
cindy   
2011-02-04 14:28   
The changes include:

1. removed table field user_decisions.sequence_id
2. the sequenceID used in html and rest report is replaced by new format: lineNum_columnNum_checkID
3. do not save the initial error report and "no decision" answer, only save the "pass" and "fail" decisions.

Affected scripts:
checkacc.php
decisions.php
checker/checker_results.php
checker/index.php
documentation/web_service_api.php
include/classes/Decision.class.php
include/classes/HTMORpt.class.php
include/classes/RESTWebServiceOutput.class.php
include/classes/DAO/UserDecisionsDAO.class.php
install/db/achecker_schema.sql
install/db/achecker_upgrade_1.1_to_1.2.sql - NEW