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

Bug 1062107

Summary: script to migrate version data from bz db to hwcert db
Product: [Retired] Red Hat Hardware Certification Program Reporter: Tony Fu <tfu>
Component: Hardware CatalogAssignee: hwcert-catalog
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 5.3CC: 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 05:01:50 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
sql script to change db schema for version
none
script to generate version data migration sql file
none
sql script to change db schema for version
none
script to generate version data migration sql file
none
sql script to change db schema
none
script to generate version data migration sql file
none
script to generate version data migration sql file
none
script to generate version data migration sql file
none
script to generate version data migration sql file none

Description Tony Fu 2014-02-06 07:22:27 UTC 
Description of problem:

As part of the data migration for public view, we need to move version field from bz db to hwcert db.
Comment 1 Tony Fu 2014-02-06 07:26:49 UTC 
Created attachment 860026 [details]
sql script to change db schema for version
Comment 2 Tony Fu 2014-02-06 07:27:56 UTC 
Created attachment 860027 [details]
script to generate version data migration sql file
Comment 3 Tony Fu 2014-02-11 07:48:53 UTC 
Created attachment 861708 [details]
sql script to change db schema for version

after discussed it with other team members, we decide to add two new fields - one for major version and one for minor version.
Comment 4 Tony Fu 2014-02-11 07:49:41 UTC 
Created attachment 861709 [details]
script to generate version data migration sql file
Comment 5 Tony Fu 2014-02-13 10:52:06 UTC 
Created attachment 862716 [details]
sql script to change db schema
Comment 6 Tony Fu 2014-02-13 10:54:18 UTC 
Created attachment 862728 [details]
script to generate version data migration sql file
Comment 7 Tony Fu 2014-02-14 01:11:36 UTC 
Created attachment 863038 [details]
script to generate version data migration sql file
Comment 8 Tony Fu 2014-02-14 03:25:29 UTC 
Created attachment 863077 [details]
script to generate version data migration sql file
Comment 9 Tony Fu 2014-02-26 08:57:24 UTC 
Created attachment 867866 [details]
script to generate version data migration sql file
Comment 10 Tony Fu 2014-03-14 05:01:50 UTC 
verified on live