Bug 1053334

Summary: Using hwcert db data only for public view
Product: [Retired] Red Hat Hardware Certification Program Reporter: Tony Fu <tfu>
Component: Hardware CatalogAssignee: Junhui Wang <junwang>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 5.3CC: hwcert-catalog, hzhang, junwang, tfu, yshao
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:28:25 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: 1053340, 1053351, 1054566, 1058650, 1063107, 1063125, 1065633    
Bug Blocks: 1045330    

Description Tony Fu 2014-01-15 03:50:50 UTC
Description of problem:



At the moment, catalog will need to fetch data from both bz database and hwcert database for most of actions and it can cause some performance issues.  We need to shift this to use data from hwcert database only eventually.

This bug is a tracker of using hwcert db data only for public view.

Comment 1 Tony Fu 2014-01-15 03:51:38 UTC
Further details

http://hwcert.pad.engineering.redhat.com/catalog-bz-separation

Comment 2 Huan Zhang 2014-01-15 08:28:44 UTC
In my opinion:
We should do the following steps:
1. db schema design
2. use ORM framework
3. compose utility methods(CRUD)
4. call those ORM CRUD from cigs
5. add switch for old db/new db

@tfu,
What do you think?

Comment 3 Tony Fu 2014-01-16 04:50:53 UTC
(In reply to Huan Zhang from comment #2)
> In my opinion:
> We should do the following steps:
> 1. db schema design
> 2. use ORM framework
> 3. compose utility methods(CRUD)
> 4. call those ORM CRUD from cigs
> 5. add switch for old db/new db
> 
> @tfu,
> What do you think?

I think introduce ORM for this release is a bit risk IMHO.  We probably need to do some prove of concept stuff before we can move it to production.

Comment 4 Tony Fu 2014-03-14 05:28:25 UTC
verified on live.