CustomerFinder.java

package org.tests.model.basic.finder;

import io.ebean.Finder;
import org.tests.model.basic.Customer;
import org.jetbrains.annotations.Nullable;

import java.util.List;

/**
 * Finder methods for Customer.
 */
public class CustomerFinder extends Finder<Integer, Customer> {

  public CustomerFinder() {
    super(Customer.class);
  }

  public CustomerFinder(String serverName) {
    super(Customer.class, serverName);
  }

  /**
   * Find customer by unique name.
   */
  @Nullable
  public Customer byName(String name) {

    return query().where().eq("name", name).findUnique();
  }

  public List<Customer> byNameStatus(String nameStartsWith, Customer.Status status) {

    return query("where status = :status and name istartsWith :name order by name")
      .setParameter("status", status)
      .setParameter("name", nameStartsWith)
      .findList();
  }

  public List<String> namesStartingWith(String name) {

    return nativeSql("select name from o_customer where name like ? order by name")
      .setParameter(1, name+"%")
      .findSingleAttributeList();
  }
}