MantisBT

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0004721ACheckerReportpublic2011-02-04 14:212011-02-04 14:28
Reportercindy 
Assigned Tocindy 
PriorityhighSeverityminorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.1 
Target VersionSVNFixed in VersionSVN 
Summary0004721: Stopped saving the question answers with "no decision" into database
DescriptionThis 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.
TagsNo tags attached.
SVN Revision#490
Attached Files

- Relationships

-  Notes
(0005044)
cindy (administrator)
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

- Issue History
Date Modified Username Field Change
2011-02-04 14:21 cindy New Issue
2011-02-04 14:21 cindy Status new => assigned
2011-02-04 14:21 cindy Assigned To => cindy
2011-02-04 14:28 cindy SVN Revision# => 490
2011-02-04 14:28 cindy Note Added: 0005044
2011-02-04 14:28 cindy Status assigned => resolved
2011-02-04 14:28 cindy Fixed in Version => SVN
2011-02-04 14:28 cindy Resolution open => fixed


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker