CustomerModel.java

package models;

import javax.persistence.*;


@Entity
@Table(name = "POS_CUSTOMER")
public class CustomerModel extends AuditedModel {

  public static Finder<Long, CustomerModel> find = new Finder<>(CustomerModel.class);
  @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  public Long id;
  public String name;

  @Column(unique=true)
  public String username;
  public String password;
  public String customer_number;

  @Column(columnDefinition = "TEXT")
  public String info;

  public static CustomerModel findByName(String name) {
    return find.where().ieq("name", name).findUnique();
  }

  public static CustomerModel findByUserName(String username) {
    return find.where().ieq("username", username).findUnique();
  }


}