Skip to content

Generate random resultset from actual resultset

 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
/*
* Show defined number of random entries in current resultset
*
*
* Usage:
* 1. Edit the number of entries to show randomly
* 2. Run button script
* 3. Show all in Query Mode to be able to use the button script again
*
* @author David Pech <dpech@chemaxon.com>
*/


import com.im.df.api.dml.*
import com.im.df.api.support.SelectionDescription
import com.im.ijc.core.api.util.IJCCoreUtils


init = { widget ->
}

destroy = { widget ->
}

// evaluate is called when the button is clicked to perform action
//
// widget is IJCWidget instance
evaluate = { widget ->

    // get the needed environmental variables
    def rs = widget.form.resultSet  // result set
    def rootVS = rs.rootVertexState // vertex state of the resultset

    // set amount of entries to generate from your resultset
    def randomSeriesLength = 20;
    println "Showing random entries of total count of " + randomSeriesLength


    // get all the IDs of your current resultset and
    // create a copy of the immutable List to work with
    List listOfIDs = new ArrayList(rootVS.getIds());
    // randlomly shuffle the list
    Collections.shuffle(listOfIDs);
    // select n values from the list and sort
    // n of values defined in randomSeriesLength
    def randomSeries = listOfIDs.subList(0, randomSeriesLength).sort();
    // convert the generated sublist type to ArrayList type
    // to be able to load it
    List randomList = new ArrayList(randomSeries)

    // apply the list of IDs to the resultset
    def rsLock = rs.lockable.withLock('applying random list of IDs') { rsEnv ->
                rs.applyList(randomList, rsEnv)
            }

}


on_change = { widget, button ->

}