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

Bug 1059044

Summary: script to migrate spec url 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
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 04:59:22 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 spec_url data migration sql file
none
sql to add spec_url field in hwcert db
none
script to generate spec_url data migration sql file none

Description Tony Fu 2014-01-29 04:03:50 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:33:35 UTC
Created attachment 857672 [details]
script to generate spec_url data migration sql file

Usage: perl field_migration.pl spec_url

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

Comment 2 Tony Fu 2014-02-03 07:45:24 UTC
Created attachment 858437 [details]
sql to add spec_url field in hwcert db

Comment 3 Tony Fu 2014-02-03 07:46:27 UTC
data migration, show.cgi and process.cgi code changes have been done on web2.

Comment 4 Tony Fu 2014-02-04 09:07:08 UTC
change this bug's status to post, will open a separate bug for spec_url data audit.

Comment 5 Tony Fu 2014-02-14 03:09:07 UTC
Created attachment 863075 [details]
script to generate spec_url data migration sql file

Comment 6 Feng Wang 2014-03-04 06:58:37 UTC
verified on partner.

Comment 7 Tony Fu 2014-03-14 04:59:22 UTC
verified on live.