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)