Bug 1061026 - script to migrate category data from bz db to hwcert db
Summary: script to migrate category 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-02-04 09:16 UTC by Tony Fu
Modified: 2014-03-14 05:01 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-03-14 05:01:09 UTC
Embargoed:


Attachments (Terms of Use)
sql script to change db schema for cert_records.category field (70 bytes, text/plain)
2014-02-04 09:18 UTC, Tony Fu
no flags Details
script to generate category data migration sql file (3.16 KB, application/x-perl)
2014-02-04 09:20 UTC, Tony Fu
no flags Details

Description Tony Fu 2014-02-04 09:16:33 UTC
Description of problem:

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


Additional info:
Although category value should be saved in models table, we still need this field in cert_records table to save category value before a model record has been created in models table.  It can happen when a user input a new model, which won't be added into models table until the cert has become public (I discussed it with Rob and doing that we can avoid adding invalid models into models table)

Comment 1 Tony Fu 2014-02-04 09:18:45 UTC
Created attachment 858983 [details]
sql script to change db schema for cert_records.category field

Comment 2 Tony Fu 2014-02-04 09:20:58 UTC
Created attachment 858984 [details]
script to generate category data migration sql file

Usage: perl field_migration.pl category

Comment 3 Feng Wang 2014-03-04 06:59:49 UTC
verified on partner.

Comment 4 Tony Fu 2014-03-14 05:01:09 UTC
verified on live


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