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 |