Bug 476995 - FEAT: HwCert catalog should log the cert's event.
FEAT: HwCert catalog should log the cert's event.
Status: CLOSED CURRENTRELEASE
Product: Red Hat Hardware Certification Program
Classification: Red Hat
Component: Hardware Catalog (Show other bugs)
5.2
All Linux
low Severity medium
: ---
: ---
Assigned To: Susan Denham
Yu Shao
http://hardware.redhat.com
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2008-12-18 10:21 EST by XINSUN
Modified: 2011-06-22 22:20 EDT (History)
6 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2011-06-22 22:20:37 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description XINSUN 2008-12-18 10:21:24 EST
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-22 22:20:37 EDT
this has been fixed

Note You need to log in before you can comment on or make changes to this bug.