Database Query¶
Database Query¶
1# This example shows how to use a Database Query having a single distance range criterion
2
3ot = impact.gui.output_toolbox
4ot.clear()
5
6settings = impact.active_database.find_master_tool_settings(ipMasterSettingType.mstDBQuery)
7
8if not settings.isNone():
9 setting = settings.item("shellrad")
10 max_records = 10
11 criteria = setting.criteria
12 criterion = criteria.item(1)
13
14 if criterion.user_value_can_be_null:
15 ot.add("Value can be null")
16 else:
17 ot.add("Value cannot be null")
18
19 # TODO: Verify GetRange's native return format in Impact before extracting bounds.
20 # The wrapper forwards the COM result despite its None annotation; these reads
21 # are diagnostic only, not a verified replacement for VBScript's ByRef outputs.
22 range_result = criterion.get_range()
23 ot.add("Range result (diagnostic only; return format unverified): " + repr(range_result))
24 criterion.set_range("1/32in", "1/16in")
25 range_result = criterion.get_range()
26 ot.add("Range result (diagnostic only; return format unverified): " + repr(range_result))
27
28 filter_opts = impact.creator.project_and_layer_filter_options()
29 cust_keys = [725, 42]
30 filter_opts.customer_keys = cust_keys
31 impact.active_database.project_and_layer_filter_options = filter_opts
32
33 # CountItemsOptions.drawing_type has no effect when used with Database Queries
34 count_opts = impact.creator.count_items_options()
35 count_opts.query_mts = setting
36 q_count = impact.active_database.count_items(count_opts)
37 ot.add(q_count)
38
39 # FindItemsOptions.drawing_type has no effect when used with Database Queries, the results are always ipDrawingType.dtProject
40 find_opts = impact.creator.find_items_options()
41 find_opts.query_mts = setting
42 find_opts.max_records = 3
43 find_opts.order_ascending = False
44 find_opts.order_by = "D_GROUP"
45 items = impact.active_database.find_items(find_opts)
46
47 for item in items:
48 ot.add(item.reference)
49
50 impact.active_database.disable_project_and_layer_filtering()
51 q_count = impact.active_database.count_items(count_opts)
52 ot.add(q_count)
53 impact.active_database.enable_project_and_layer_filtering()
54 q_count = impact.active_database.count_items(count_opts)
55 ot.add(q_count)