Project And Layer Lookup

Project And Layer Lookup
 1# This script shows how to use LookupProjectAndLayerKeysFromValue and LookupValueFromProjectOrLayerKey
 2
 3
 4ot = impact.gui.output_toolbox
 5
 6
 7def do_lookup(test_no, look_opts):
 8    look_opts.max_results_exceeded = False
 9    impact.active_database.lookup_project_and_layer_keys_from_value(look_opts)
10    title = "TEST " + str(test_no)
11
12    if look_opts.max_results_exceeded:
13        title = str(title) + " Max results (" + str(look_opts.max_results) + ") exceeded"
14
15    ot.add(title)
16
17    p_array = look_opts.project_keys
18    l_array = look_opts.layer_keys
19    mv_array = look_opts.matching_values
20
21    # all 3 arrays will have the same bounds
22    if len(mv_array) - 1 == -1:
23        ot.add("Nothing found")
24    else:
25        for i in range(0, len(mv_array) - 1  + 1):
26            v = mv_array[i]
27            p = p_array[i]
28            v = str(v) + " (ProjectKey = " + str(p) + ")"
29            l = l_array[i]
30
31            if l != 0:
32                v = str(v) + " (LayerKey = " + str(l) + ")"
33
34            ot.add(v)
35
36    ot.add("")
37
38def do_reverse_lookup(test_no, tab_name, col_name, key):
39    # TODO: Verify the native return format and no-match semantics in Impact.
40    # The three-argument wrapper forwards the COM result despite its None annotation.
41    # Diagnostic only: do not infer a match or 'Nothing found' from its truthiness.
42    lookup_result = impact.active_database.lookup_value_from_project_or_layer_key(tab_name, col_name, key)
43    ot.add("TEST " + str(test_no))
44    ot.add("Lookup result (diagnostic only; return format unverified): " + repr(lookup_result))
45    ot.add("")
46
47ot.clear()
48
49look_opts = impact.creator.lookup_project_and_layer_keys_from_value_params()
50look_opts.table_name = "DRAWINGS"
51look_opts.column_name = "D_NAME"
52look_opts.value = "poly"
53look_opts.search_type = 0  # ipStringSearchType.sstExact'
54look_opts.for_customer_keys = [651, 298, 361]
55do_lookup(0, look_opts)
56
57look_opts.search_type = 1  # ipStringSearchType.sstBeginsWith'
58do_lookup(1, look_opts)
59
60look_opts.search_type = 2  # ipStringSearchType.sstContains'
61do_lookup(2, look_opts)
62
63look_opts.search_type = 3  # ipStringSearchType.sstEndsWith'
64do_lookup(3, look_opts)
65
66look_opts.search_type = 2  # ipStringSearchType.sstContains'
67look_opts.for_customer_keys = [651]
68do_lookup(4, look_opts)
69
70look_opts.for_customer_keys = []  # no customers (so no results)
71do_lookup(5, look_opts)
72
73look_opts.for_customer_keys = None  # all customers
74do_lookup(6, look_opts)
75
76look_opts.max_results = 2
77do_lookup(7, look_opts)
78
79look_opts.table_name = "ONE_UP"
80look_opts.column_name = "OU_CADNUM"
81look_opts.search_type = 0  # ipStringSearchType.sstExact'
82look_opts.value = "3947"
83do_lookup(8, look_opts)
84
85look_opts.table_name = "LAYERS"
86look_opts.column_name = "L_CADNUM"
87look_opts.value = "49358205"
88do_lookup(9, look_opts)
89
90do_reverse_lookup(10, "DRAWINGS", "D_NAME", 1982)
91do_reverse_lookup(11, "ONE_UP", "OU_CADNUM", 49358205)
92do_reverse_lookup(12, "LAYERS", "L_CADNUM", 49358207)