Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1059928

Summary: script to migrate status data from bz db to hwcert db
Product: [Retired] Red Hat Hardware Certification Program Reporter: Tony Fu <tfu>
Component: Hardware CatalogAssignee: Tony Fu <tfu>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 5.3CC: fwang, hwcert-catalog, rlandry
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-03-14 05:00:16 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1053351    
Attachments:
Description Flags
script to generate status data migration sql file
none
script to generate status data migration sql file
none
sql to add status field in hwcert db
none
script to generate status data migration sql file
none
script to generate status data migration sql file
none
script to generate status data migration sql file
none
script to generate status data migration sql file none

Description Tony Fu 2014-01-31 00:44:17 UTC
Description of problem:


As part of the data migration for public view, we need to move spec url field from bz db to hwcert db.

Comment 1 Tony Fu 2014-01-31 00:47:35 UTC
Created attachment 857675 [details]
script to generate status data migration sql file

Usage: perl field_migration.pl status

Result: a new status.sql file is generated on current dir.

Comment 2 Tony Fu 2014-01-31 06:25:46 UTC
Created attachment 857715 [details]
script to generate status data migration sql file

after talking with Rob, we need a separate script to migrate status which need special treatment.

Comment 3 Rob Landry 2014-01-31 17:41:12 UTC
Comment on attachment 857715 [details]
script to generate status data migration sql file

Please add some commentary for the functions.  Specifically in the areas about the parent bugs and the status changes.  The point is for a developer who is unfamiliar with the current behavior of status to understand why these are present.

Comment 4 Tony Fu 2014-02-03 07:51:32 UTC
Created attachment 858439 [details]
sql to add status field in hwcert db

Comment 5 Tony Fu 2014-02-05 07:42:16 UTC
Created attachment 859505 [details]
script to generate status data migration sql file

fixed a bug in previous script

Comment 6 Tony Fu 2014-02-14 03:19:06 UTC
Created attachment 863076 [details]
script to generate status data migration sql file

Comment 7 Tony Fu 2014-02-24 06:59:09 UTC
Created attachment 866876 [details]
script to generate status data migration sql file

Comment 8 Tony Fu 2014-02-27 12:49:59 UTC
Created attachment 868506 [details]
script to generate status data migration sql file

Comment 9 Feng Wang 2014-03-04 06:59:23 UTC
verified on partner.

Comment 10 Tony Fu 2014-03-14 05:00:16 UTC
verified on live