TestAutoTuneProfiling.java

package org.tests.query.autotune;

import io.ebean.BaseTestCase;
import io.ebean.Ebean;
import org.tests.model.basic.Address;
import org.tests.model.basic.Customer;
import org.tests.model.basic.Order;
import org.tests.model.basic.OrderDetail;
import org.tests.model.basic.ResetBasicData;
import org.junit.Ignore;
import org.junit.Test;

import java.util.List;
import java.util.Random;

public class TestAutoTuneProfiling extends BaseTestCase {

  @Ignore
  @Test
  public void test() throws InterruptedException {

    ResetBasicData.reset();

    for (int i = 0; i < 1; i++) {
      execute();
    }
    collectUsage();

    sortOfBusy();

    for (int i = 0; i < 10; i++) {
      execute();
    }
    collectUsage();

    sortOfBusy();

    for (int i = 0; i < 1; i++) {
      execute();
    }
  }

  private void sortOfBusy() {

    for (int i = 0; i < 90000000; i++) {
      new Random().nextLong();
    }
  }


  private void execute() {
    useOrderDate();
    useOrderDateCustomerName();
    useLots();
    useLotUntuned();
  }

  private Order findById(long id) {
    return Ebean.find(Order.class)
      .select("status, orderDate, shipDate")
      .setId(id)
      .findUnique();
  }

  private void useOrderDate() {
    Order order = findById(3);
    order.getStatus();
    order.getShipDate();
  }

  private void useOrderDateCustomerName() {
    Order order = findById(3);
    order.getOrderDate();
    order.getCustomer().getName();
  }

  private void useLots() {

    Order order = findById(3);
    order.getOrderDate();
    order.getShipDate();
    // order.setShipDate(new Date(System.currentTimeMillis()));
    Customer customer = order.getCustomer();
    customer.getName();
    Address shippingAddress = customer.getShippingAddress();
    if (shippingAddress != null) {
      shippingAddress.getLine1();
      shippingAddress.getCity();
    }
  }

  private void useLotUntuned() {
    Order order = findById(3);
    List<OrderDetail> details = order.getDetails();
    for (OrderDetail detail : details) {
      detail.getProduct().getName();
      detail.getOrderQty();
      detail.getShipQty();
      detail.getUnitPrice();
    }

    Customer customer = order.getCustomer();
    customer.getName();
    Address billingAddress = customer.getBillingAddress();
    if (billingAddress != null) {
      billingAddress.getCity();
      billingAddress.getLine1();
      billingAddress.getLine2();
    }
  }

  private static void collectUsage() {

    Ebean.getDefaultServer().getAutoTune().collectProfiling();
  }

}