FilesExpand file tree

 main

/

query.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

83 lines (68 loc) · 3.1 KB

 main

/

query.py

Copy path

Top

File metadata and controls

• Code
• Blame

83 lines (68 loc) · 3.1 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

#!/usr/bin/env python

#

# This work is licensed under the GNU GPLv2 or later.

# See the COPYING file in the top-level directory.

# query.py: Perform a few varieties of queries

import time

import bugzilla

# public test instance of bugzilla.redhat.com. It's okay to make changes

URL = "bugzilla.stage.redhat.com"

bzapi = bugzilla.Bugzilla(URL)

# build_query is a helper function that handles some bugzilla version

# incompatibility issues. All it does is return a properly formatted

# dict(), and provide friendly parameter names. The param names map

# to those accepted by Bugzilla Bug.search:

# https://bugzilla.readthedocs.io/en/latest/api/core/v1/bug.html#search-bugs

query = bzapi.build_query(

product="Fedora",

component="python-bugzilla")

# Since 'query' is just a dict, you could set your own parameters too, like

# if your bugzilla had a custom field. This will set 'status' for example,

# but for common opts it's better to use build_query

query["status"] = "CLOSED"

# query() is what actually performs the query. it's a wrapper around Bug.search

t1 = time.time()

bugs = bzapi.query(query)

t2 = time.time()

print("Found %d bugs with our query" % len(bugs))

print("Query processing time: %s" % (t2 - t1))

# Depending on the size of your query, you can massively speed things up

# by telling bugzilla to only return the fields you care about, since a

# large chunk of the return time is transmitting the extra bug data. You

# tweak this with include_fields:

# https://wiki.mozilla.org/Bugzilla:BzAPI#Field_Control

# Bugzilla will only return those fields listed in include_fields.

query = bzapi.build_query(

product="Fedora",

component="python-bugzilla",

include_fields=["id", "summary"])

t1 = time.time()

bugs = bzapi.query(query)

t2 = time.time()

print("Quicker query processing time: %s" % (t2 - t1))

# bugzilla.redhat.com, and bugzilla >= 5.0 support queries using the same

# format as is used for 'advanced' search URLs via the Web UI. For example,

# I go to bugzilla.stage.redhat.com -> Search -> Advanced Search, select

# Classification=Fedora

# Product=Fedora

# Component=python-bugzilla

# Unselect all bug statuses (so, all status values)

# Under Custom Search

# Creation date -- is less than or equal to -- 2010-01-01

#

# Run that, copy the URL and bring it here, pass it to url_to_query to

# convert it to a dict(), and query as usual

query = bzapi.url_to_query("https://bugzilla.stage.redhat.com/"

"buglist.cgi?classification=Fedora&component=python-bugzilla&"

"f1=creation_ts&o1=lessthaneq&order=Importance&product=Fedora&"

"query_format=advanced&v1=2010-01-01")

query["include_fields"] = ["id", "summary"]

bugs = bzapi.query(query)

print("The URL query returned 22 bugs... "

"I know that without even checking because it shouldn't change!... "

"(count is %d)" % len(bugs))

# One note about querying... you can get subtley different results if

# you are not logged in. Depending on your bugzilla setup it may not matter,

# but if you are dealing with private bugs, check bzapi.logged_in setting

# to ensure your cached credentials are up to date. See update.py for

# an example usage