From Fedora Project Wiki

(another hook)
No edit summary
Line 48: Line 48:
#** delete_table to handle deleting views
#** delete_table to handle deleting views
#** bug_check_can_change_field to prevent changing values in views
#** bug_check_can_change_field to prevent changing values in views
#* Issues
#** Relating a field back to the view seems hard to do. May need to rely on people not adding view columns to the update list.
# Extension to create recursive blocks / depends on view
# Extension to create recursive blocks / depends on view
#* With use WITH RECURSIVE which works at least in recent Postres versions and is part of the ANSI standard.
#* With use WITH RECURSIVE which works at least in recent Postres versions and is part of the ANSI standard.
#* Hooks needed
#* Hooks needed
#** db_schema_abstract_schema to extend the default schema
#** db_schema_abstract_schema to extend the default schema
#* Issues
#** Probably need to create a new object class for this table and then use object columns to add the new columns so that Bugzilla can use them.
# Extension to allow aliased by as a query operator.
# Extension to allow aliased by as a query operator.
#* Works like match any word handling a list of alias regular expressions and transforming to a list of bug ids.
#* Works like match any word handling a list of alias regular expressions and transforming to a list of bug ids.

Revision as of 08:15, 15 December 2010

Bruno Wolff

I'm a bit of a libre software hobbyist.

I like to play with shiny new (or recycled) toys and am willing figure out why things aren't working when I run into problems.

This makes Fedora a good fit for me.

Contact

Activities within Fedora

Quotable

Draft Documentation

Bugzilla Extension development

The plan is to support recursive blocking / depends on queries in bugzilla and allow the use of aliases in such queries. The 4.0 version of bugzilla is being target because it supports more hooks, allowing this to be done as an extension (probably) without core code changes. 4.0 is currently in release status. It is unknown when Red Hat would upgrade their bugzilla to 4.0.

Extension info

  1. Extension to handle read only views
    • Hooks needed
      • _get_create_table_ddl to handle creating views
      • delete_table to handle deleting views
      • bug_check_can_change_field to prevent changing values in views
    • Issues
      • Relating a field back to the view seems hard to do. May need to rely on people not adding view columns to the update list.
  2. Extension to create recursive blocks / depends on view
    • With use WITH RECURSIVE which works at least in recent Postres versions and is part of the ANSI standard.
    • Hooks needed
      • db_schema_abstract_schema to extend the default schema
    • Issues
      • Probably need to create a new object class for this table and then use object columns to add the new columns so that Bugzilla can use them.
  3. Extension to allow aliased by as a query operator.
    • Works like match any word handling a list of alias regular expressions and transforming to a list of bug ids.
    • Will use a sub select. That may restrict usage by some databases (probably fairly ones at this point), but is part of the ANSI standard.
    • Hooks needed
      • search_operator_field_override

Status

  • A plan for how to implement the feature has been developed.
    • A set of extension needed to implement this plan have been scoped out.
    • The plan has not been verified to make sure it is implementable as currently designed.
  • A 4.0 test environment has been set up locally.

Mockup for QA - Tracking bug queries

Queries for finding bugs that directly block a tracking bug that are closed but not verified

F14

F15

Retrieved from "https://fedoraproject.org/w/index.php?title=User:Bruno&oldid=211639"