Bug 443461

Summary: FEAT: Match the new db schema of bz3.0 [2. TABLE bugs]
Product: [Retired] Red Hat Hardware Certification Program Reporter: XINSUN <xisun>
Component: Hardware CatalogAssignee: XINSUN <xisun>
Status: CLOSED CURRENTRELEASE QA Contact: Yu Shao <yshao>
Severity: medium Docs Contact:
Priority: medium    
Version: 5CC: bxu, dkl, efeng, kbaker, nelhawar, rlandry, tfu, xiqin, ykun, yshao
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: 3.2rh-20080801.1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2008-08-04 17:56:19 UTC Type: ---
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: 443456    
Attachments:
Description Flags
The patch to fix the "rename the cust_facing,devel_whiteboard,fixed_in,internal_whiteboard,qa_whiteboard "
none
Patch Improve:
none
Patch improve:
none
The new clean patch none

Description XINSUN 2008-04-21 17:46:19 UTC
2. Relate to TABLE bugs  need to change.

Comment 1 XINSUN 2008-04-23 02:04:28 UTC
Created attachment 303408 [details]
The patch to fix the "rename the cust_facing,devel_whiteboard,fixed_in,internal_whiteboard,qa_whiteboard "

2.1 rename the
cust_facing,devel_whiteboard,fixed_in,internal_whiteboard,qa_whiteboard      
       Added :	    FIELD      bugs.cf_internal_whiteboard,
			       bugs.cf_devel_whiteboard,
			       bugs.cf_qa_whiteboard,
			       bugs.cf_fixed_in, 
			       bugs.cf_cust_facing
	Removed :   FIELD      bugs.cust_facing,
			       bugs.devel_whiteboard,
			       bugs.fixed_in,
			       bugs.internal_whiteboard,
			       bugs.qa_whiteboard

Comment 2 Rob Landry 2008-04-23 19:03:18 UTC
@@ -257,8 +257,7 @@ an "is_active" leaked into this patch
@@ -273,8 +272,7 @@ ditto
@@ -643,8 +643,7 @@

status_whiteboard didn't change?

@@ -1156,7 +1155,7 @@ parent_fixed_in doesn't really have to change; it's ok to
do so for consistancy but then we also need to search for all uses of
parent_fixed_in and verify they are all updated as well.

@@ -302,7 +302,7 @@ as above, all parent_ fields are internal to the sql not
directly in the field names.

@@ -483,11 +483,11 @@ ditto



Comment 3 XINSUN 2008-04-25 10:00:14 UTC
Created attachment 303768 [details]
Patch Improve:

1.Remove the "is_active" which was leaked into this patch.
2.Agree with Rob on "parent_fixed_in doesn't really have to change" and restore
the "parent_fixed_in.
3.Add some changes for post.cgi.

Comment 4 Noura El hawary 2008-04-28 03:38:32 UTC
> status_whiteboard didn't change?
> 

status_whiteboard deosn't change as it is not a custom field it exists as a main
database field in the upstream bugs database schema and not something that was
created or customized by redhat like the fields:
cust_facing,devel_whiteboard,fixed_in,internal_whiteboard,qa_whiteboard

those now require cf_* for custom field to be added to the front of the column name.

Comment 5 XINSUN 2008-04-29 10:10:40 UTC
Created attachment 304089 [details]
Patch improve:

1.Add the field: cust_facing 
2.Add the file for search function: query.cgi,
template/en/default/search/form_advanced.html.tmpl

Please review,
Nicho

Comment 6 Noura El hawary 2008-05-01 03:06:11 UTC
Hi nicho,

there are few places in the hwcert code that still has the custom field names
without cf_* specially in the templates. you can use something like this command
to check those places that are still not changes after you apply your patch:

# grep -rn devel_whiteboard .

also one question: Is the following template :
template/en/default/search/form_hwcert.html.tmpl
used in hwcert ? is there a search page or functionality in hwcert that will
involve those cf_* fields? 

Thanks,
Noura


Comment 7 XINSUN 2008-05-01 08:41:40 UTC
Hi Noura,
Thanks  for your feedback. :)
template/en/default/search/form_hwcert.html.tmpl is not used in hwcert, I can
remove it from repo. The search page or functionality in hwcert that will
involve those cf_* fields were fixed in that patch, I will paste a new clean
patch  for it.
Those few places which still have the custom field names without cf_* work well
because I use  $var->{bug->devel_whiteboard} in Bugzilla/Bug.pm. but for the
consistency of naming, I changed them and add these changes in the new clean
patch too. I have tested this patch and it works well.

Nicho

Comment 8 XINSUN 2008-05-01 08:42:24 UTC
Created attachment 304300 [details]
The new clean patch

Comment 9 Noura El hawary 2008-05-01 13:14:31 UTC
patch looks good to me nicho.

Noura

Comment 10 Rob Landry 2008-07-17 21:02:12 UTC
Please commit this change to CVS and set the status to MODIFIED.

Comment 11 eric_liu 2008-08-01 11:19:02 UTC
tested and run good