Bug 476995

Summary: FEAT: HwCert catalog should log the cert's event.
Product: [Retired] Red Hat Hardware Certification Program Reporter: XINSUN <xisun>
Component: Hardware CatalogAssignee: Susan Denham <sdenham>
Status: CLOSED CURRENTRELEASE QA Contact: Yu Shao <yshao>
Severity: medium Docs Contact:
Priority: low    
Version: 5.2CC: averma, rlandry, sdenham, wshen, xiqin, yshao
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
URL: http://hardware.redhat.com
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-06-23 02:20:37 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description XINSUN 2008-12-18 15:21:24 UTC
Currently, catalog just log some cert's events in the two type method:
1.Log the change in the ship_to_rh info and Large_Agree with comment.
2.Log review action in the cert_rpm_event(check package,process testplan):

mysql> select distinct(activity) from  cert_rpm_event;
+----------------------+
| activity             |
+----------------------+
| addtestplan          | 
| change-content       | 
| Frozen               | 
| generatetestplan     | 
| Melted               | 
| required_32bits      | 
| required_64bits      | 
| bits32               | 
| bits64               | 
| addnewtestplanitem   | 
| check                | 
| uncheck              | 
| result_64bits        | 
| name                 | 
| result_32bits        | 
+----------------------+
15 rows in set (0.30 sec)

===============================================================================

mysql> desc cert_rpm_event;
+----------+---------------+------+-----+-------------------+----------------+
| Field    | Type          | Null | Key | Default           | Extra          |
+----------+---------------+------+-----+-------------------+----------------+
| id       | mediumint(9)  | NO   | PRI | NULL              | auto_increment | 
| rpm_id   | mediumint(9)  | YES  | MUL | NULL              |                | 
| mod_time | timestamp     | NO   |     | CURRENT_TIMESTAMP |                | 
| comment  | text          | YES  |     | NULL              |                | 
| activity | varchar(1000) | YES  |     | NULL              |                | 
| cert_id  | mediumint(9)  | YES  | MUL | NULL              |                | 
| modifier | mediumint(9)  | YES  |     | NULL              |                | 
+----------+---------------+------+-----+-------------------+----------------+
7 rows in set (0.00 sec)


We should revisit this above table and try to use "cert_log_event" table to log all cert's event.

Comment 4 Wei Shen 2011-06-23 02:20:37 UTC
this has been fixed