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 Catalog | Assignee: | XINSUN <xisun> | ||||||||||
Status: | CLOSED CURRENTRELEASE | QA Contact: | Yu Shao <yshao> | ||||||||||
Severity: | medium | Docs Contact: | |||||||||||
Priority: | medium | ||||||||||||
Version: | 5 | CC: | 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
XINSUN
2008-04-21 17:46:19 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
@@ -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 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.
> 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.
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
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 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 Created attachment 304300 [details]
The new clean patch
patch looks good to me nicho. Noura Please commit this change to CVS and set the status to MODIFIED. tested and run good |