AnyLogic: Correct way to select a dataset from internal database

Question

In my anylogic-project i query datasets from the internal database. The table i want to query has following structure:

Name: product_innovation_level
--------------------------------
ID|level_customer|level_employee|
--|--------------|--------------|
 1|            10|            14|

The only example i could find uses the Tuple-class as shown below. It works, but it feels quite clunky that i have to extract the needed values manually from the item.

Tuple innovationLevel = selectFrom(product_innovation_level).
                        where(product_innovation_level.id.eq(1)).
                        firstResult(product_innovation_level.level_customer, product_innovation_level.level_employee);

double ngEmployee = innovationLevel.get(product_innovation_level.level_employee);
double ngCustomer = innovationLevel.get(product_innovation_level.level_customer);

Is there a better way to select the values directly into an model class? I'm looking for something like this:

xxx innovationLevel = selectFrom(product_innovation_level).
                                  where(product_innovation_level.id.eq(1)).
                                  firstResult(xxx);

What class i schould use for xxx? I found an automatically created class Qproduct_innovation_level, but i didn't found a way to access the values of this dataset.

Qproduct_innovation_level innovationLevel = selectFrom(product_innovation_level).
                                  where(product_innovation_level.id.eq(1)).
                                  firstResult(product_innovation_level);
int i  = innovationLevel.level_customer.intValue();
Error: Type mismatch: cannot convert from NumberExpression<Integer> to int

I tried to write a model-class on my own, but here i get type-mismatch error (cannot convert from Qproduct_innovation_level to InnovationLevelModel).

Your second code snippet that is exactly how you do it directly (if you know your query only returns 1 value). What is the problem? — Benjamin
Hi Benjamin. I extended my question, i don't know whawt class to use respectively how i can access the needed values. — JoKo

Felipe Felipe · Accepted Answer · 2019-07-01T02:37:33

Ok, my answer may be a bit ridiculous, but maybe it's what you want...

Create a class with the following constructor and variables:

public class MyClass implements Serializable {

    public double ngEmployee;
    public double ngCustomer;
    /**
     * Default constructor
     */
    public MyClass(Tuple innovationLevel) {
        this.ngEmployee = innovationLevel.get(product_innovation_level.level_employee);
        this.ngCustomer = innovationLevel.get(product_innovation_level.level_customer);
    }

}

And then you can create an instance of that class like this:

MyClass mc=new MyClass(selectFrom(product_innovation_level).
                        where(product_innovation_level.id.eq(1)).
                        firstResult(product_innovation_level.level_customer, product_innovation_level.level_employee));

Magic... now you can access the variables using mc.ngEmployee and mc.ngCustomer

AnyLogic: Correct way to select a dataset from internal database

2 Answers