Bug 1059926 - script to migrate product data from bz db to hwcert db
Summary: script to migrate product data from bz db to hwcert db
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Hardware Certification Program
Classification: Retired
Component: Hardware Catalog
Version: 5.3
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Tony Fu
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks: 1053351
TreeView+ depends on / blocked
 
Reported: 2014-01-31 00:36 UTC by Tony Fu
Modified: 2014-03-14 04:59 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-03-14 04:59:48 UTC
Embargoed:

Attachments (Terms of Use)
script to generate spec_url data migration sql file (3.21 KB, application/x-perl)
2014-01-31 00:38 UTC, Tony Fu 		no flags Details
sql to add product field in hwcert db (69 bytes, text/plain)
2014-02-03 07:49 UTC, Tony Fu 		no flags Details
sql scrip to generate new tables for product data (178 bytes, text/plain)
2014-02-11 00:08 UTC, Tony Fu 		no flags Details
script to generate product data migration sql file (3.63 KB, application/x-perl)
2014-02-11 00:11 UTC, Tony Fu 		no flags Details
script to generate product data migration sql file (3.63 KB, application/x-perl)
2014-02-13 11:00 UTC, Tony Fu 		no flags Details
script to generate product data migration sql file (3.13 KB, application/x-perl)
2014-02-14 01:10 UTC, Tony Fu 		no flags Details
script to generate product data migration sql file (3.13 KB, application/x-perl)
2014-02-14 03:30 UTC, Tony Fu 		no flags Details
Show Obsolete (5) View All

Description Tony Fu 2014-01-31 00:36:22 UTC 
Description of problem:


As part of the data migration for public view, we need to move product field from bz db to hwcert db.
Comment 1 Tony Fu 2014-01-31 00:38:42 UTC 
Created attachment 857673 [details]
script to generate spec_url data migration sql file

Usage: perl field_migration.pl product

Result: a new product.sql file is generated on current dir.
Comment 2 Tony Fu 2014-02-03 07:49:32 UTC 
Created attachment 858438 [details]
sql to add product field in hwcert db
Comment 3 Tony Fu 2014-02-04 09:08:12 UTC 
change this bug's status to post, will open a separate bug for data audit.
Comment 4 Tony Fu 2014-02-11 00:08:43 UTC 
Created attachment 861627 [details]
sql scrip to generate new tables for product data

after discussing with other developers, we have decided to use product_id instead of a string for product in cert_records table
Comment 5 Tony Fu 2014-02-11 00:11:48 UTC 
Created attachment 861628 [details]
script to generate product data migration sql file
Comment 6 Tony Fu 2014-02-13 11:00:26 UTC 
Created attachment 862732 [details]
script to generate product data migration sql file
Comment 7 Tony Fu 2014-02-14 01:10:11 UTC 
Created attachment 863036 [details]
script to generate product data migration sql file
Comment 8 Tony Fu 2014-02-14 03:30:22 UTC 
Created attachment 863078 [details]
script to generate product data migration sql file
Comment 9 Tony Fu 2014-03-14 04:59:48 UTC 
verified on live
Note You need to log in before you can comment on or make changes to this bug.