| # -*- Mode: perl; indent-tabs-mode: nil -*- |
| # |
| # The contents of this file are subject to the Mozilla Public |
| # License Version 1.1 (the "License"); you may not use this file |
| # except in compliance with the License. You may obtain a copy of |
| # the License at http://www.mozilla.org/MPL/ |
| # |
| # Software distributed under the License is distributed on an "AS |
| # IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or |
| # implied. See the License for the specific language governing |
| # rights and limitations under the License. |
| # |
| # The Original Code is the Bugzilla Bug Tracking System. |
| # |
| # The Initial Developer of the Original Code is Everything Solved, Inc. |
| # Portions created by the Initial Developer are Copyright (C) 2010 the |
| # Initial Developer. All Rights Reserved. |
| # |
| # Contributor(s): |
| # Max Kanat-Alexander <mkanat@bugzilla.org> |
| |
| |
| # These are constants used by Bugzilla::Test::Search. |
| # See the comment at the top of that package for a general overview |
| # of how the search test works, and how the constants are used. |
| # More detailed information on each constant is available in the comments |
| # in this file. |
| package Bugzilla::Test::Search::Constants; |
| use base qw(Exporter); |
| use Bugzilla::Constants; |
| use Bugzilla::Util qw(generate_random_password); |
| |
| our @EXPORT = qw( |
| ATTACHMENT_FIELDS |
| BROKEN_NOT |
| COLUMN_TRANSLATION |
| COMMENT_FIELDS |
| CUSTOM_FIELDS |
| CUSTOM_SEARCH_TESTS |
| FIELD_SIZE |
| FIELD_SUBSTR_SIZE |
| FLAG_FIELDS |
| INJECTION_BROKEN_FIELD |
| INJECTION_BROKEN_OPERATOR |
| INJECTION_TESTS |
| KNOWN_BROKEN |
| NUM_BUGS |
| NUM_SEARCH_TESTS |
| SKIP_FIELDS |
| SPECIAL_PARAM_TESTS |
| SUBSTR_NO_FIELD_ADD |
| SUBSTR_SIZE |
| TESTS |
| TESTS_PER_RUN |
| USER_FIELDS |
| ); |
| |
| # Bug 1 is designed to be found by all the "equals" tests. It has |
| # multiple values for several fields where other fields only have |
| # one value. |
| # |
| # Bug 2 and 3 have a dependency relationship with Bug 1, |
| # but show up in "not equals" tests. We do use bug 2 in multiple-value |
| # tests. |
| # |
| # Bug 4 should never show up in any equals test, and has no relationship |
| # with any other bug. However, it does have all its fields set. |
| # |
| # Bug 5 only has values set for mandatory fields, to expose problems |
| # that happen with "not equals" tests failing to catch bugs that don't |
| # have a value set at all. |
| # |
| # Bug 6 is a clone of Bug 1, but is in a group that the searcher isn't |
| # in. |
| use constant NUM_BUGS => 6; |
| |
| # How many tests there are for each operator/field combination other |
| # than the "contains" tests. |
| use constant NUM_SEARCH_TESTS => 3; |
| # This is how many tests get run for each field/operator. |
| use constant TESTS_PER_RUN => NUM_SEARCH_TESTS + NUM_BUGS; |
| |
| # This is how many random characters we generate for most fields' names. |
| # (Some fields can't be this long, though, so they have custom lengths |
| # in Bugzilla::Test::Search). |
| use constant FIELD_SIZE => 30; |
| |
| # These are the custom fields that are created if the BZ_MODIFY_DATABASE_TESTS |
| # environment variable is set. |
| use constant CUSTOM_FIELDS => { |
| FIELD_TYPE_FREETEXT, 'cf_freetext', |
| FIELD_TYPE_SINGLE_SELECT, 'cf_single_select', |
| FIELD_TYPE_MULTI_SELECT, 'cf_multi_select', |
| FIELD_TYPE_TEXTAREA, 'cf_textarea', |
| FIELD_TYPE_DATETIME, 'cf_datetime', |
| FIELD_TYPE_BUG_ID, 'cf_bugid', |
| }; |
| |
| # This translates fielddefs names into Search column names. |
| use constant COLUMN_TRANSLATION => { |
| creation_ts => 'opendate', |
| delta_ts => 'changeddate', |
| work_time => 'actual_time', |
| }; |
| |
| # Make comment field names to their Bugzilla::Comment accessor. |
| use constant COMMENT_FIELDS => { |
| longdesc => 'body', |
| commenter => 'author', |
| 'longdescs.isprivate' => 'is_private', |
| }; |
| |
| # Same as above, for Bugzilla::Attachment. |
| use constant ATTACHMENT_FIELDS => { |
| mimetype => 'contenttype', |
| submitter => 'attacher', |
| thedata => 'data', |
| }; |
| |
| # Same, for Bugzilla::Flag. |
| use constant FLAG_FIELDS => { |
| 'flagtypes.name' => 'name', |
| 'setters.login_name' => 'setter', |
| 'requestees.login_name' => 'requestee', |
| }; |
| |
| # These are fields that we don't test. Test::More will mark these |
| # "TODO & SKIP", and not run tests for them at all. |
| # |
| # We don't support days_elapsed or owner_idle_time yet. |
| use constant SKIP_FIELDS => qw( |
| owner_idle_time |
| days_elapsed |
| ); |
| |
| # All the fields that represent users. |
| use constant USER_FIELDS => qw( |
| assigned_to |
| cc |
| reporter |
| qa_contact |
| commenter |
| attachments.submitter |
| setters.login_name |
| requestees.login_name |
| ); |
| |
| # For the "substr"-type searches, how short of a substring should |
| # we use? The goal is to be shorter than the full string, but |
| # long enough to still be globally unique. |
| use constant SUBSTR_SIZE => 20; |
| # However, for some fields, we use a different size. |
| use constant FIELD_SUBSTR_SIZE => { |
| alias => 11, |
| # Just the month and day. |
| deadline => -5, |
| creation_ts => -8, |
| delta_ts => -8, |
| percentage_complete => 1, |
| work_time => 3, |
| remaining_time => 3, |
| target_milestone => 15, |
| longdesc => 25, |
| # Just the hour and minute. |
| FIELD_TYPE_DATETIME, -5, |
| }; |
| |
| # For most fields, we add the length of the name of the field plus |
| # the SUBSTR_SIZE specified above to determine how large of a substring |
| # we're going to use. However, for some fields, it doesn't make sense to |
| # add in their field name this way. |
| use constant SUBSTR_NO_FIELD_ADD => FIELD_TYPE_DATETIME, qw( |
| target_milestone remaining_time percentage_complete work_time |
| attachments.mimetype attachments.submitter attachments.filename |
| attachments.description flagtypes.name |
| ); |
| |
| ################ |
| # Known Broken # |
| ################ |
| |
| # See the KNOWN_BROKEN constant for a general description of these |
| # "_BROKEN" constants. |
| |
| # Shared between greaterthan and greaterthaneq. |
| # |
| # As with other fields, longdescs greaterthan matches if any comment |
| # matches (which might be OK). |
| # |
| # Same for keywords, and cc. Logically, all of these might |
| # be OK, but it makes the operation not the logical reverse of |
| # lessthaneq. What we're really saying here by marking these broken |
| # is that there ought to be some way of searching "all ccs" vs "any cc" |
| # (and same for the other fields). |
| use constant GREATERTHAN_BROKEN => ( |
| cc => { contains => [1] }, |
| ); |
| |
| # allwords and allwordssubstr have these broken tests in common. |
| # |
| # allwordssubstr on cc fields matches against a single cc, |
| # instead of matching against all ccs on a bug. |
| use constant ALLWORDS_BROKEN => ( |
| cc => { contains => [1] }, |
| ); |
| |
| # Fields that don't generally work at all with changed* searches, but |
| # probably should. |
| use constant CHANGED_BROKEN => ( |
| classification => { contains => [1] }, |
| commenter => { contains => [1] }, |
| percentage_complete => { contains => [1] }, |
| 'requestees.login_name' => { contains => [1] }, |
| 'setters.login_name' => { contains => [1] }, |
| delta_ts => { contains => [1] }, |
| ); |
| |
| # These are additional broken tests that changedfrom and changedto |
| # have in common. |
| use constant CHANGED_VALUE_BROKEN => ( |
| bug_group => { contains => [1] }, |
| cc => { contains => [1] }, |
| estimated_time => { contains => [1] }, |
| 'flagtypes.name' => { contains => [1] }, |
| keywords => { contains => [1] }, |
| 'longdescs.count' => { search => 1 }, |
| FIELD_TYPE_MULTI_SELECT, { contains => [1] }, |
| ); |
| |
| |
| # Any test listed in KNOWN_BROKEN gets marked TODO by Test::More |
| # (using some complex code in Bugzilla::Test::Seach::FieldTest). |
| # This means that if you run the test under "prove -v", these tests will |
| # still show up as "not ok", but the test suite results won't show them |
| # as a failure. |
| # |
| # This constant contains operators as keys, which point to hashes. The hashes |
| # have field names as keys. Each field name points to a hash describing |
| # how that field/operator combination is broken. The "contains" |
| # array specifies that that particular "contains" test is expected |
| # to fail. If "search" is set to 1, then we expect the creation of the |
| # Bugzilla::Search object to fail. |
| # |
| # To allow handling custom fields, you can also use the field type as a key |
| # instead of the field name. Specifying explicit field names always overrides |
| # specifying a field type. |
| # |
| # Sometimes the operators have multiple tests, and one of them works |
| # while the other fails. In this case, we have a special override for |
| # "operator-value", which uniquely identifies tests. |
| use constant KNOWN_BROKEN => { |
| "equals-%group.<1-bug_group>%" => { |
| commenter => { contains => [1,2,3,4,5] }, |
| }, |
| |
| greaterthan => { GREATERTHAN_BROKEN }, |
| greaterthaneq => { GREATERTHAN_BROKEN }, |
| |
| 'allwordssubstr-<1>' => { ALLWORDS_BROKEN }, |
| 'allwords-<1>' => { |
| ALLWORDS_BROKEN, |
| }, |
| |
| # setters.login_name and requestees.login name aren't tracked individually |
| # in bugs_activity, so can't be searched using this method. |
| # |
| # percentage_complete isn't tracked in bugs_activity (and it would be |
| # really hard to track). However, it adds a 0=0 term instead of using |
| # the changed* charts or simply denying them. |
| # |
| # delta_ts changedbefore/after should probably search for bugs based |
| # on their delta_ts. |
| # |
| # creation_ts changedbefore/after should search for bug creation dates. |
| # |
| # The commenter field changedbefore/after should search for comment |
| # creation dates. |
| # |
| # classification isn't being tracked properly in bugs_activity, I think. |
| # |
| # attach_data.thedata should search when attachments were created and |
| # who they were created by. |
| 'changedbefore' => { |
| CHANGED_BROKEN, |
| 'attach_data.thedata' => { contains => [1] }, |
| }, |
| 'changedafter' => { |
| 'attach_data.thedata' => { contains => [2,3,4] }, |
| classification => { contains => [2,3,4] }, |
| commenter => { contains => [2,3,4] }, |
| delta_ts => { contains => [2,3,4] }, |
| percentage_complete => { contains => [2,3,4] }, |
| 'requestees.login_name' => { contains => [2,3,4] }, |
| 'setters.login_name' => { contains => [2,3,4] }, |
| }, |
| changedfrom => { |
| CHANGED_BROKEN, |
| CHANGED_VALUE_BROKEN, |
| # All fields should have a way to search for "changing |
| # from a blank value" probably. |
| blocked => { contains => [3,4,5], no_criteria => 1 }, |
| dependson => { contains => [2,4,5], no_criteria => 1 }, |
| work_time => { contains => [1] }, |
| FIELD_TYPE_BUG_ID, { contains => [5], no_criteria => 1 }, |
| }, |
| # changeto doesn't find remaining_time changes (possibly due to us not |
| # tracking that data properly). |
| # |
| # multi-valued fields are stored as comma-separated strings, so you |
| # can't do changedfrom/to on them. |
| # |
| # Perhaps commenter can either tell you who the last commenter was, |
| # or if somebody commented at a given time (combined with other |
| # charts). |
| # |
| # longdesc changedto/from doesn't do anything; maybe it should. |
| # Same for attach_data.thedata. |
| changedto => { |
| CHANGED_BROKEN, |
| CHANGED_VALUE_BROKEN, |
| 'attach_data.thedata' => { contains => [1] }, |
| longdesc => { contains => [1] }, |
| remaining_time => { contains => [1] }, |
| }, |
| changedby => { |
| CHANGED_BROKEN, |
| # This should probably search the attacher or anybody who changed |
| # anything about an attachment at all. |
| 'attach_data.thedata' => { contains => [1] }, |
| # This should probably search the reporter. |
| creation_ts => { contains => [1] }, |
| }, |
| }; |
| |
| ################### |
| # Broken NotTests # |
| ################### |
| |
| # Common BROKEN_NOT values for the changed* fields. |
| use constant CHANGED_BROKEN_NOT => ( |
| "attach_data.thedata" => { contains => [1] }, |
| "classification" => { contains => [1] }, |
| "commenter" => { contains => [1] }, |
| "delta_ts" => { contains => [1] }, |
| percentage_complete => { contains => [1] }, |
| "requestees.login_name" => { contains => [1] }, |
| "setters.login_name" => { contains => [1] }, |
| ); |
| |
| # For changedfrom and changedto. |
| use constant CHANGED_FROM_TO_BROKEN_NOT => ( |
| 'longdescs.count' => { search => 1 }, |
| "bug_group" => { contains => [1] }, |
| "cc" => { contains => [1] }, |
| "estimated_time" => { contains => [1] }, |
| "flagtypes.name" => { contains => [1] }, |
| "keywords" => { contains => [1] }, |
| FIELD_TYPE_MULTI_SELECT, { contains => [1] }, |
| ); |
| |
| # These are field/operator combinations that are broken when run under NOT(). |
| use constant BROKEN_NOT => { |
| allwords => { |
| cc => { contains => [1] }, |
| }, |
| 'allwords-<1> <2>' => { |
| cc => { }, |
| }, |
| allwordssubstr => { |
| cc => { contains => [1] }, |
| }, |
| 'allwordssubstr-<1>,<2>' => { |
| cc => { }, |
| }, |
| changedafter => { |
| "attach_data.thedata" => { contains => [2, 3, 4] }, |
| "classification" => { contains => [2, 3, 4] }, |
| "commenter" => { contains => [2, 3, 4] }, |
| percentage_complete => { contains => [2, 3, 4] }, |
| "delta_ts" => { contains => [2, 3, 4] }, |
| "requestees.login_name" => { contains => [2, 3, 4] }, |
| "setters.login_name" => { contains => [2, 3, 4] }, |
| }, |
| changedbefore => { |
| CHANGED_BROKEN_NOT, |
| }, |
| changedby => { |
| CHANGED_BROKEN_NOT, |
| creation_ts => { contains => [1] }, |
| work_time => { contains => [1] }, |
| }, |
| changedfrom => { |
| CHANGED_BROKEN_NOT, |
| CHANGED_FROM_TO_BROKEN_NOT, |
| 'attach_data.thedata' => { }, |
| blocked => { contains => [1, 2] }, |
| dependson => { contains => [1, 3] }, |
| work_time => { contains => [1] }, |
| FIELD_TYPE_BUG_ID, { contains => [1 .. 4] }, |
| |
| }, |
| changedto => { |
| CHANGED_BROKEN_NOT, |
| CHANGED_FROM_TO_BROKEN_NOT, |
| longdesc => { contains => [1] }, |
| "remaining_time" => { contains => [1] }, |
| }, |
| greaterthan => { |
| cc => { contains => [1] }, |
| }, |
| greaterthaneq => { |
| cc => { contains => [1] }, |
| }, |
| }; |
| |
| ############# |
| # Overrides # |
| ############# |
| |
| # These overrides are used in the TESTS constant, below. |
| |
| # Regex tests need unique test values for certain fields. |
| use constant REGEX_OVERRIDE => { |
| 'attachments.mimetype' => { value => '^text/x-1-' }, |
| bug_file_loc => { value => '^http://1-' }, |
| see_also => { value => '^http://1-' }, |
| blocked => { value => '^<1>$' }, |
| dependson => { value => '^<1>$' }, |
| bug_id => { value => '^<1>$' }, |
| 'attachments.isobsolete' => { value => '^1'}, |
| 'attachments.ispatch' => { value => '^1'}, |
| 'attachments.isprivate' => { value => '^1' }, |
| cclist_accessible => { value => '^1' }, |
| reporter_accessible => { value => '^1' }, |
| everconfirmed => { value => '^1' }, |
| 'longdescs.count' => { value => '^3' }, |
| 'longdescs.isprivate' => { value => '^1' }, |
| creation_ts => { value => '^2037-01-01' }, |
| delta_ts => { value => '^2037-01-01' }, |
| deadline => { value => '^2037-02-01' }, |
| estimated_time => { value => '^1.0' }, |
| remaining_time => { value => '^9.0' }, |
| work_time => { value => '^1.0' }, |
| longdesc => { value => '^1-' }, |
| percentage_complete => { value => '^10' }, |
| FIELD_TYPE_BUG_ID, { value => '^<1>$' }, |
| FIELD_TYPE_DATETIME, { value => '^2037-03-01' } |
| }; |
| |
| # Common overrides between lessthan and lessthaneq. |
| use constant LESSTHAN_OVERRIDE => ( |
| alias => { contains => [1,5] }, |
| estimated_time => { contains => [1,5] }, |
| qa_contact => { contains => [1,5] }, |
| resolution => { contains => [1,5] }, |
| status_whiteboard => { contains => [1,5] }, |
| FIELD_TYPE_TEXTAREA, { contains => [1,5] }, |
| FIELD_TYPE_FREETEXT, { contains => [1,5] }, |
| ); |
| |
| # The mandatorily-set fields have values higher than <1>, |
| # so bug 5 shows up. |
| use constant GREATERTHAN_OVERRIDE => ( |
| classification => { contains => [2,3,4,5] }, |
| assigned_to => { contains => [2,3,4,5] }, |
| bug_id => { contains => [2,3,4,5] }, |
| bug_group => { contains => [1,2,3,4] }, |
| bug_severity => { contains => [2,3,4,5] }, |
| bug_status => { contains => [2,3,4,5] }, |
| component => { contains => [2,3,4,5] }, |
| commenter => { contains => [2,3,4,5] }, |
| # keywords matches if *any* keyword matches |
| keywords => { contains => [1,2,3,4] }, |
| longdesc => { contains => [1,2,3,4] }, |
| op_sys => { contains => [2,3,4,5] }, |
| priority => { contains => [2,3,4,5] }, |
| product => { contains => [2,3,4,5] }, |
| reporter => { contains => [2,3,4,5] }, |
| rep_platform => { contains => [2,3,4,5] }, |
| short_desc => { contains => [2,3,4,5] }, |
| version => { contains => [2,3,4,5] }, |
| tag => { contains => [1,2,3,4] }, |
| target_milestone => { contains => [2,3,4,5] }, |
| # Bug 2 is the only bug besides 1 that has a Requestee set. |
| 'requestees.login_name' => { contains => [2] }, |
| FIELD_TYPE_SINGLE_SELECT, { contains => [2,3,4,5] }, |
| # Override SINGLE_SELECT for resolution. |
| resolution => { contains => [2,3,4] }, |
| # MULTI_SELECTs match if *any* value matches |
| FIELD_TYPE_MULTI_SELECT, { contains => [1,2,3,4] }, |
| ); |
| |
| # For all positive multi-value types. |
| use constant MULTI_BOOLEAN_OVERRIDE => ( |
| 'attachments.ispatch' => { value => '1,1', contains => [1] }, |
| 'attachments.isobsolete' => { value => '1,1', contains => [1] }, |
| 'attachments.isprivate' => { value => '1,1', contains => [1] }, |
| cclist_accessible => { value => '1,1', contains => [1] }, |
| reporter_accessible => { value => '1,1', contains => [1] }, |
| 'longdescs.isprivate' => { value => '1,1', contains => [1] }, |
| everconfirmed => { value => '1,1', contains => [1] }, |
| ); |
| |
| # Same as above, for negative multi-value types. |
| use constant NEGATIVE_MULTI_BOOLEAN_OVERRIDE => ( |
| 'attachments.ispatch' => { value => '1,1', contains => [2,3,4,5] }, |
| 'attachments.isobsolete' => { value => '1,1', contains => [2,3,4,5] }, |
| 'attachments.isprivate' => { value => '1,1', contains => [2,3,4,5] }, |
| cclist_accessible => { value => '1,1', contains => [2,3,4,5] }, |
| reporter_accessible => { value => '1,1', contains => [2,3,4,5] }, |
| 'longdescs.isprivate' => { value => '1,1', contains => [2,3,4,5] }, |
| everconfirmed => { value => '1,1', contains => [2,3,4,5] }, |
| ); |
| |
| # For anyexact and anywordssubstr |
| use constant ANY_OVERRIDE => ( |
| 'longdescs.count' => { contains => [1,2,3,4] }, |
| 'work_time' => { value => '1.0,2.0' }, |
| dependson => { value => '<1>,<3>', contains => [1,3] }, |
| MULTI_BOOLEAN_OVERRIDE, |
| ); |
| |
| # For all the changed* searches. The ones that have empty contains |
| # are fields that never change in value, or will never be rationally |
| # tracked in bugs_activity. |
| use constant CHANGED_OVERRIDE => ( |
| 'attachments.submitter' => { contains => [] }, |
| bug_id => { contains => [] }, |
| reporter => { contains => [] }, |
| tag => { contains => [] }, |
| ); |
| |
| ######### |
| # Tests # |
| ######### |
| |
| # The basic format of this is a hashref, where the keys are operators, |
| # and each operator has an arrayref of tests that it runs. The tests |
| # are hashrefs, with the following possible keys: |
| # |
| # contains: This is a list of bug numbers that the search is expected |
| # to contain. (This is bug numbers, like 1,2,3, not the bug |
| # ids. For a description of each bug number, see NUM_BUGS.) |
| # Any bug not listed in "contains" must *not* show up in the |
| # search result. |
| # value: The value that you're searching for. There are certain special |
| # codes that will be replaced with bug values when the tests are |
| # run. In these examples below, "#" indicates a bug number: |
| # |
| # <#> - The field value for this bug. |
| # |
| # For any operator that has the string "word" in it, this is |
| # *all* the values for the current field from the numbered bug, |
| # joined by a space. |
| # |
| # If the operator has the string "substr" in it, then we |
| # take a substring of the value (for single-value searches) |
| # or we take a substring of each value and join them (for |
| # multi-value "word" searches). The length of the substring |
| # is determined by the SUBSTR_SIZE constants above.) |
| # |
| # For other operators, this just becomes the first value from |
| # the field for the numbered bug. |
| # |
| # So, if we were running the "equals" test and checking the |
| # cc field, <1> would become the login name of the first cc on |
| # Bug 1. If we did an "anywords" search test, it would become |
| # a space-separated string of the login names of all the ccs |
| # on Bug 1. If we did an "anywordssubstr" search test, it would |
| # become a space-separated string of the first few characters |
| # of each CC's login name on Bug 1. |
| # |
| # <#-id> - The bug id of the numbered bug. |
| # <#-reporter> - The login name of the numbered bug's reporter. |
| # <#-delta> - The delta_ts of the numbered bug. |
| # |
| # escape: If true, we will call quotemeta() on the value immediately |
| # before passing it to Search.pm. |
| # |
| # transform: A function to call on any field value before inserting |
| # it for a <#> replacement. The transformation function |
| # gets all of the bug's values for the field as its arguments. |
| # if_equal: This allows you to override "contains" for the case where |
| # the transformed value (from calling the "transform" function) |
| # is equal to the original value. |
| # |
| # override: This allows you to override "contains" and "values" for |
| # certain fields. |
| use constant TESTS => { |
| equals => [ |
| { contains => [1], value => '<1>' }, |
| ], |
| notequals => [ |
| { contains => [2,3,4,5], value => '<1>' }, |
| ], |
| substring => [ |
| { contains => [1], value => '<1>', |
| override => { |
| percentage_complete => { contains => [1,2,3] }, |
| } |
| }, |
| ], |
| casesubstring => [ |
| { contains => [1], value => '<1>', |
| override => { |
| percentage_complete => { contains => [1,2,3] }, |
| } |
| }, |
| { contains => [], value => '<1>', transform => sub { lc($_[0]) }, |
| extra_name => 'lc', if_equal => { contains => [1] }, |
| override => { |
| percentage_complete => { contains => [1,2,3] }, |
| } |
| }, |
| ], |
| notsubstring => [ |
| { contains => [2,3,4,5], value => '<1>', |
| override => { |
| percentage_complete => { contains => [4,5] }, |
| }, |
| } |
| ], |
| regexp => [ |
| { contains => [1], value => '<1>', escape => 1, |
| override => { |
| percentage_complete => { value => '^10' }, |
| } |
| }, |
| { contains => [1], value => '^1-', override => REGEX_OVERRIDE }, |
| ], |
| notregexp => [ |
| { contains => [2,3,4,5], value => '<1>', escape => 1, |
| override => { |
| percentage_complete => { value => '^10' }, |
| } |
| }, |
| { contains => [2,3,4,5], value => '^1-', override => REGEX_OVERRIDE }, |
| ], |
| lessthan => [ |
| { contains => [1], value => 2, |
| override => { |
| # A lot of these contain bug 5 because an empty value is validly |
| # less than the specified value. |
| bug_file_loc => { value => 'http://2-', contains => [1,5] }, |
| see_also => { value => 'http://2-' }, |
| 'attachments.mimetype' => { value => 'text/x-2-' }, |
| blocked => { value => '<4-id>', contains => [1,2] }, |
| dependson => { value => '<3-id>', contains => [1,3] }, |
| bug_id => { value => '<2-id>' }, |
| 'attachments.isprivate' => { value => 1, contains => [2,3,4] }, |
| 'attachments.isobsolete' => { value => 1, contains => [2,3,4] }, |
| 'attachments.ispatch' => { value => 1, contains => [2,3,4] }, |
| cclist_accessible => { value => 1, contains => [2,3,4,5] }, |
| reporter_accessible => { value => 1, contains => [2,3,4,5] }, |
| 'longdescs.count' => { value => 3, contains => [2,3,4,5] }, |
| 'longdescs.isprivate' => { value => 1, contains => [1,2,3,4,5] }, |
| everconfirmed => { value => 1, contains => [2,3,4,5] }, |
| creation_ts => { value => '2037-01-02', contains => [1,5] }, |
| delta_ts => { value => '2037-01-02', contains => [1,5] }, |
| deadline => { value => '2037-02-02', contains => [1,5] }, |
| remaining_time => { value => 10, contains => [1,5] }, |
| percentage_complete => { value => 11, contains => [1,5] }, |
| longdesc => { value => '2-', contains => [1,5] }, |
| work_time => { value => 1, contains => [5] }, |
| FIELD_TYPE_BUG_ID, { value => '<2>', contains => [1,5] }, |
| FIELD_TYPE_DATETIME, { value => '2037-03-02', contains => [1,5] }, |
| LESSTHAN_OVERRIDE, |
| } |
| }, |
| ], |
| lessthaneq => [ |
| { contains => [1], value => '<1>', |
| override => { |
| 'attachments.isobsolete' => { value => 0, contains => [2,3,4] }, |
| 'attachments.ispatch' => { value => 0, contains => [2,3,4] }, |
| 'attachments.isprivate' => { value => 0, contains => [2,3,4] }, |
| cclist_accessible => { value => 0, contains => [2,3,4,5] }, |
| reporter_accessible => { value => 0, contains => [2,3,4,5] }, |
| 'longdescs.count' => { value => 2, contains => [2,3,4,5] }, |
| 'longdescs.isprivate' => { value => -1, contains => [] }, |
| everconfirmed => { value => 0, contains => [2,3,4,5] }, |
| bug_file_loc => { contains => [1,5] }, |
| blocked => { contains => [1,2] }, |
| deadline => { contains => [1,5] }, |
| dependson => { contains => [1,3] }, |
| creation_ts => { contains => [1,5] }, |
| delta_ts => { contains => [1,5] }, |
| remaining_time => { contains => [1,5] }, |
| longdesc => { contains => [1,5] }, |
| percentage_complete => { contains => [1,5] }, |
| work_time => { value => 1, contains => [1,5] }, |
| FIELD_TYPE_BUG_ID, { contains => [1,5] }, |
| FIELD_TYPE_DATETIME, { contains => [1,5] }, |
| LESSTHAN_OVERRIDE, |
| }, |
| }, |
| ], |
| greaterthan => [ |
| { contains => [2,3,4], value => '<1>', |
| override => { |
| dependson => { contains => [3] }, |
| blocked => { contains => [2] }, |
| 'attachments.ispatch' => { value => 0, contains => [1] }, |
| 'attachments.isobsolete' => { value => 0, contains => [1] }, |
| 'attachments.isprivate' => { value => 0, contains => [1] }, |
| cclist_accessible => { value => 0, contains => [1] }, |
| reporter_accessible => { value => 0, contains => [1] }, |
| 'longdescs.count' => { value => 2, contains => [1] }, |
| 'longdescs.isprivate' => { value => 0, contains => [1] }, |
| everconfirmed => { value => 0, contains => [1] }, |
| 'flagtypes.name' => { value => 2, contains => [2,3,4] }, |
| GREATERTHAN_OVERRIDE, |
| }, |
| }, |
| ], |
| greaterthaneq => [ |
| { contains => [2,3,4], value => '<2>', |
| override => { |
| 'attachments.ispatch' => { value => 1, contains => [1] }, |
| 'attachments.isobsolete' => { value => 1, contains => [1] }, |
| 'attachments.isprivate' => { value => 1, contains => [1] }, |
| cclist_accessible => { value => 1, contains => [1] }, |
| reporter_accessible => { value => 1, contains => [1] }, |
| 'longdescs.count' => { value => 3, contains => [1] }, |
| 'longdescs.isprivate' => { value => 1, contains => [1] }, |
| everconfirmed => { value => 1, contains => [1] }, |
| dependson => { value => '<3>', contains => [1,3] }, |
| blocked => { contains => [1,2] }, |
| GREATERTHAN_OVERRIDE, |
| } |
| }, |
| ], |
| matches => [ |
| { contains => [1], value => '<1>' }, |
| ], |
| notmatches => [ |
| { contains => [2,3,4,5], value => '<1>' }, |
| ], |
| anyexact => [ |
| { contains => [1,2], value => '<1>, <2>', |
| override => { ANY_OVERRIDE } }, |
| ], |
| anywordssubstr => [ |
| { contains => [1,2], value => '<1> <2>', |
| override => { |
| ANY_OVERRIDE, |
| percentage_complete => { contains => [1,2,3] }, |
| } |
| }, |
| ], |
| allwordssubstr => [ |
| { contains => [1], value => '<1>', |
| override => { |
| MULTI_BOOLEAN_OVERRIDE, |
| # We search just the number "1" for percentage_complete, |
| # which matches a lot of bugs. |
| percentage_complete => { contains => [1,2,3] }, |
| }, |
| }, |
| { contains => [], value => '<1>,<2>', |
| override => { |
| dependson => { value => '<1-id> <3-id>', contains => [] }, |
| # bug 3 has the value "21" here, so matches "2,1" |
| percentage_complete => { value => '<2>,<3>', contains => [3] }, |
| # 1 0 matches bug 1, which has both public and private comments. |
| 'longdescs.isprivate' => { contains => [1] }, |
| } |
| }, |
| ], |
| nowordssubstr => [ |
| { contains => [2,3,4,5], value => '<1>', |
| override => { |
| # longdescs.isprivate translates to "1 0", so no bugs should |
| # show up. |
| 'longdescs.isprivate' => { contains => [] }, |
| percentage_complete => { contains => [4,5] }, |
| work_time => { contains => [2,3,4,5] }, |
| } |
| }, |
| ], |
| anywords => [ |
| { contains => [1], value => '<1>', |
| override => { |
| MULTI_BOOLEAN_OVERRIDE, |
| } |
| }, |
| { contains => [1,2], value => '<1> <2>', |
| override => { |
| MULTI_BOOLEAN_OVERRIDE, |
| dependson => { value => '<1> <3>', contains => [1,3] }, |
| 'longdescs.count' => { contains => [1,2,3,4] }, |
| }, |
| }, |
| ], |
| allwords => [ |
| { contains => [1], value => '<1>', |
| override => { MULTI_BOOLEAN_OVERRIDE } }, |
| { contains => [], value => '<1> <2>', |
| override => { |
| dependson => { contains => [], value => '<2-id> <3-id>' }, |
| # 1 0 matches bug 1, which has both public and private comments. |
| 'longdescs.isprivate' => { contains => [1] }, |
| } |
| }, |
| ], |
| nowords => [ |
| { contains => [2,3,4,5], value => '<1>', |
| override => { |
| # longdescs.isprivate translates to "1 0", so no bugs should |
| # show up. |
| 'longdescs.isprivate' => { contains => [] }, |
| work_time => { contains => [2,3,4,5] }, |
| } |
| }, |
| ], |
| |
| changedbefore => [ |
| { contains => [1], value => '<1-delta>', |
| override => { |
| CHANGED_OVERRIDE, |
| creation_ts => { contains => [1,5] }, |
| blocked => { contains => [1,2] }, |
| dependson => { contains => [1,3] }, |
| longdesc => { contains => [1,5] }, |
| 'longdescs.count' => { contains => [1,5] }, |
| } |
| }, |
| ], |
| changedafter => [ |
| { contains => [2,3,4], value => '<2-delta>', |
| override => { |
| CHANGED_OVERRIDE, |
| creation_ts => { contains => [3,4] }, |
| # We only change this for one bug, and it doesn't match. |
| 'longdescs.isprivate' => { contains => [] }, |
| # Same for everconfirmed. |
| 'everconfirmed' => { contains => [] }, |
| # For blocked and dependson, they have the delta_ts of bug1 |
| # in the bugs_activity table, so they won't ever match. |
| blocked => { contains => [] }, |
| dependson => { contains => [] }, |
| } |
| }, |
| ], |
| changedfrom => [ |
| { contains => [1], value => '<1>', |
| override => { |
| CHANGED_OVERRIDE, |
| # The test never changes an already-set dependency field, but |
| # we *can* attempt to test searching against an empty value, |
| # which should get us some bugs. |
| blocked => { value => '', contains => [1,2] }, |
| dependson => { value => '', contains => [1,3] }, |
| FIELD_TYPE_BUG_ID, { value => '', contains => [1,2,3,4] }, |
| # longdesc changedfrom doesn't make any sense. |
| longdesc => { contains => [] }, |
| # Nor does creation_ts changedfrom. |
| creation_ts => { contains => [] }, |
| 'attach_data.thedata' => { contains => [] }, |
| bug_id => { value => '<1-id>', contains => [] }, |
| }, |
| }, |
| ], |
| changedto => [ |
| { contains => [1], value => '<1>', |
| override => { |
| CHANGED_OVERRIDE, |
| # I can't imagine any use for creation_ts changedto. |
| creation_ts => { contains => [] }, |
| } |
| }, |
| ], |
| changedby => [ |
| { contains => [1], value => '<1-reporter>', |
| override => { |
| CHANGED_OVERRIDE, |
| blocked => { contains => [1,2] }, |
| dependson => { contains => [1,3] }, |
| }, |
| }, |
| ], |
| }; |
| |
| # Fields that do not behave as we expect, for InjectionTest. |
| # search => 1 means the Bugzilla::Search creation fails. |
| # sql_error is a regex that specifies a SQL error that's OK for us to throw. |
| # operator_ok overrides the "brokenness" of certain operators, so that they |
| # are always OK for that field/operator combination. |
| use constant INJECTION_BROKEN_FIELD => { |
| # Pg can't run injection tests against integer or date fields. See bug 577557. |
| 'attachments.isobsolete' => { db_skip => ['Pg'] }, |
| 'attachments.ispatch' => { db_skip => ['Pg'] }, |
| 'attachments.isprivate' => { db_skip => ['Pg'] }, |
| blocked => { db_skip => ['Pg'] }, |
| bug_id => { db_skip => ['Pg'] }, |
| cclist_accessible => { db_skip => ['Pg'] }, |
| creation_ts => { db_skip => ['Pg'] }, |
| days_elapsed => { db_skip => ['Pg'] }, |
| dependson => { db_skip => ['Pg'] }, |
| deadline => { db_skip => ['Pg'] }, |
| delta_ts => { db_skip => ['Pg'] }, |
| estimated_time => { db_skip => ['Pg'] }, |
| everconfirmed => { db_skip => ['Pg'] }, |
| 'longdescs.isprivate' => { db_skip => ['Pg'] }, |
| percentage_complete => { db_skip => ['Pg'] }, |
| remaining_time => { db_skip => ['Pg'] }, |
| reporter_accessible => { db_skip => ['Pg'] }, |
| work_time => { db_skip => ['Pg'] }, |
| FIELD_TYPE_BUG_ID, { db_skip => ['Pg'] }, |
| FIELD_TYPE_DATETIME, { db_skip => ['Pg'] }, |
| owner_idle_time => { search => 1 }, |
| 'longdescs.count' => { |
| search => 1, |
| db_skip => ['Pg'], |
| operator_ok => [qw(allwords allwordssubstr anywordssubstr casesubstring |
| changedbefore changedafter greaterthan greaterthaneq |
| lessthan lessthaneq notregexp notsubstring |
| nowordssubstr regexp substring anywords |
| notequals nowords equals anyexact)], |
| }, |
| }; |
| |
| # Operators that do not behave as we expect, for InjectionTest. |
| # search => 1 means the Bugzilla::Search creation fails, but |
| # field_ok contains fields that it does actually succeed for. |
| use constant INJECTION_BROKEN_OPERATOR => { |
| changedafter => { search => 1, field_ok => ['creation_ts'] }, |
| changedbefore => { search => 1, field_ok => ['creation_ts'] }, |
| changedby => { search => 1 }, |
| }; |
| |
| # Tests run by Bugzilla::Test::Search::InjectionTest. |
| # We have to make sure the values are all one word or they'll be split |
| # up by the multi-word tests. |
| use constant INJECTION_TESTS => ( |
| { value => ';SEMICOLON_TEST' }, |
| { value => '--COMMENT_TEST' }, |
| { value => "'QUOTE_TEST" }, |
| { value => "';QUOTE_SEMICOLON_TEST" }, |
| { value => '/*STAR_COMMENT_TEST' } |
| ); |
| |
| ################# |
| # Special Tests # |
| ################# |
| |
| use constant SPECIAL_PARAM_TESTS => ( |
| { field => 'bug_status', operator => 'anyexact', value => '__open__', |
| contains => [5] }, |
| { field => 'bug_status', operator => 'anyexact', value => '__closed__', |
| contains => [1,2,3,4] }, |
| { field => 'bug_status', operator => 'anyexact', value => '__all__', |
| contains => [1,2,3,4,5] }, |
| |
| { field => 'resolution', operator => 'anyexact', value => '---', |
| contains => [5] }, |
| |
| # email* query parameters. |
| { field => 'assigned_to', operator => 'anyexact', |
| value => '<1>, <2-reporter>', contains => [1,2], |
| extra_params => { emailreporter1 => 1 } }, |
| { field => 'assigned_to', operator => 'equals', |
| value => '<1>', extra_name => 'email2', contains => [], |
| extra_params => { |
| email2 => generate_random_password(100), emaillongdesc2 => 1, |
| }, |
| }, |
| |
| # standard pronouns |
| { field => 'assigned_to', operator => 'equals', value => '%assignee%', |
| contains => [1,2,3,4,5] }, |
| { field => 'reporter', operator => 'equals', value => '%reporter%', |
| contains => [1,2,3,4,5] }, |
| { field => 'qa_contact', operator => 'equals', value => '%qacontact%', |
| contains => [1,2,3,4,5] }, |
| { field => 'cc', operator => 'equals', value => '%user%', |
| contains => [1] }, |
| # group pronouns |
| { field => 'reporter', operator => 'equals', |
| value => '%group.<1-bug_group>%', contains => [1,2,3,4,5] }, |
| { field => 'assigned_to', operator => 'equals', |
| value => '%group.<1-bug_group>%', contains => [1,2,3,4,5] }, |
| { field => 'qa_contact', operator => 'equals', |
| value => '%group.<1-bug_group>%', contains => [1,2,3,4] }, |
| { field => 'cc', operator => 'equals', |
| value => '%group.<1-bug_group>%', contains => [1,2,3,4] }, |
| { field => 'commenter', operator => 'equals', |
| value => '%group.<1-bug_group>%', contains => [1,2,3,4,5] }, |
| ); |
| |
| use constant CUSTOM_SEARCH_TESTS => ( |
| { name => 'OP without CP', contains => [1], |
| params => [ |
| { f => 'OP' }, |
| { f => 'bug_id', o => 'equals', v => '<1>' }, |
| ] |
| }, |
| |
| { name => 'Empty OP/CP pair before criteria', contains => [1], |
| params => [ |
| { f => 'OP' }, { f => 'CP' }, |
| { f => 'bug_id', o => 'equals', v => '<1>' }, |
| ] |
| }, |
| |
| { name => 'Empty OP/CP pair after criteria', contains => [1], |
| params => [ |
| { f => 'bug_id', o => 'equals', v => '<1>' }, |
| { f => 'OP' }, { f => 'CP' }, |
| ] |
| }, |
| |
| { name => 'empty OP/CP mid criteria', contains => [1], |
| columns => ['assigned_to'], |
| params => [ |
| { f => 'bug_id', o => 'equals', v => '<1>' }, |
| { f => 'OP' }, { f => 'CP' }, |
| { f => 'assigned_to', o => 'substr', v => '@' }, |
| ] |
| }, |
| |
| { name => 'bug_id = 1 AND assigned_to contains @', contains => [1], |
| columns => ['assigned_to'], |
| params => [ |
| { f => 'bug_id', o => 'equals', v => '<1>' }, |
| { f => 'assigned_to', o => 'substr', v => '@' }, |
| ] |
| }, |
| |
| { name => 'NOT(bug_id = 1) AND NOT(assigned_to = 2)', |
| contains => [3,4,5], |
| columns => ['assigned_to'], |
| params => [ |
| { n => 1, f => 'bug_id', o => 'equals', v => '<1>' }, |
| { n => 1, f => 'assigned_to', o => 'equals', v => '<2>' }, |
| ] |
| }, |
| |
| { name => 'bug_id = 1 OR assigned_to = 2', contains => [1,2], |
| columns => ['assigned_to'], top_params => { j_top => 'OR' }, |
| params => [ |
| { f => 'bug_id', o => 'equals', v => '<1>' }, |
| { f => 'assigned_to', o => 'equals', v => '<2>' }, |
| ] |
| }, |
| |
| { name => 'NOT(bug_id = 1 AND assigned_to = 1)', contains => [2,3,4,5], |
| columns => ['assigned_to'], |
| params => [ |
| { f => 'OP', n => 1 }, |
| { f => 'bug_id', o => 'equals', v => '<1>' }, |
| { f => 'assigned_to', o => 'equals', v => '<1>' }, |
| { f => 'CP' }, |
| ] |
| }, |
| |
| |
| { name => '(bug_id = 1 AND assigned_to contains @) ' |
| . ' OR (bug_id = 2 AND assigned_to contains @)', |
| contains => [1,2], columns => ['assigned_to'], |
| top_params => { j_top => 'OR' }, |
| params => [ |
| { f => 'OP' }, |
| { f => 'bug_id', o => 'equals', v => '<1>' }, |
| { f => 'assigned_to', o => 'substr', v => '@' }, |
| { f => 'CP' }, |
| { f => 'OP' }, |
| { f => 'bug_id', o => 'equals', v => '<2>' }, |
| { f => 'assigned_to', o => 'substr', v => '@' }, |
| { f => 'CP' }, |
| ] |
| }, |
| |
| { name => '(bug_id = 1 OR assigned_to = 2) ' |
| . ' AND (bug_id = 2 OR assigned_to = 1)', |
| contains => [1,2], columns => ['assigned_to'], |
| params => [ |
| { f => 'OP', j => 'OR' }, |
| { f => 'bug_id', o => 'equals', v => '<1>' }, |
| { f => 'assigned_to', o => 'equals', v => '<2>' }, |
| { f => 'CP' }, |
| { f => 'OP', j => 'OR' }, |
| { f => 'bug_id', o => 'equals', v => '<2>' }, |
| { f => 'assigned_to', o => 'equals', v => '<1>' }, |
| { f => 'CP' }, |
| ] |
| }, |
| |
| { name => 'bug_id = 3 OR ( (bug_id = 1 OR assigned_to = 2) ' |
| . ' AND (bug_id = 2 OR assigned_to = 1) )', |
| contains => [1,2,3], columns => ['assigned_to'], |
| top_params => { j_top => 'OR' }, |
| params => [ |
| { f => 'bug_id', o => 'equals', v => '<3>' }, |
| { f => 'OP' }, |
| { f => 'OP', j => 'OR' }, |
| { f => 'bug_id', o => 'equals', v => '<1>' }, |
| { f => 'assigned_to', o => 'equals', v => '<2>' }, |
| { f => 'CP' }, |
| { f => 'OP', j => 'OR' }, |
| { f => 'bug_id', o => 'equals', v => '<2>' }, |
| { f => 'assigned_to', o => 'equals', v => '<1>' }, |
| { f => 'CP' }, |
| { f => 'CP' }, |
| ] |
| }, |
| |
| { name => 'bug_id = 3 OR ( (bug_id = 1 OR assigned_to = 2) ' |
| . ' AND (bug_id = 2 OR assigned_to = 1) ) OR bug_id = 4', |
| contains => [1,2,3,4], columns => ['assigned_to'], |
| top_params => { j_top => 'OR' }, |
| params => [ |
| { f => 'bug_id', o => 'equals', v => '<3>' }, |
| { f => 'OP' }, |
| { f => 'OP', j => 'OR' }, |
| { f => 'bug_id', o => 'equals', v => '<1>' }, |
| { f => 'assigned_to', o => 'equals', v => '<2>' }, |
| { f => 'CP' }, |
| { f => 'OP', j => 'OR' }, |
| { f => 'bug_id', o => 'equals', v => '<2>' }, |
| { f => 'assigned_to', o => 'equals', v => '<1>' }, |
| { f => 'CP' }, |
| { f => 'CP' }, |
| { f => 'bug_id', o => 'equals', v => '<4>' }, |
| ] |
| }, |
| |
| ); |
| |
| 1; |
