What annotation is used in Ormlite mapping for Enum as Foreign?

Question

I have the Client class and the Animal Award, where a customer can have 1 or more pets. I would look like this:

@DatabaseTable(tableName = "cliente")
public class Cliente{

@DatabaseField(generateId = true)
private Long id;

@DatabaseField
private String nome;

@????
List<AnimaisEstimacao> animais;

Enum Animaisestimacao

public enum AnimaisEstimacao{
GATO(0);
CACHORRO(1);
PASSARO(2);
OUTROS(3);
//implementacao
}

What would be the Ormlite annotation for the Enum Animalsestimate present in the Client class?

Answer 1

According to the Ormlite documentation it would look like this:

@DatabaseTable(tableName = "cliente")
public class Cliente{

@DatabaseField(generateId = true)
private Long id;

@DatabaseField
private String nome;

@DatabaseField(dataType = DataType.ENUM_INTEGER)
List<AnimaisEstimacao> animais;

Answer 2

A while ago I made a similar code. Try to solve this way:

@DatabaseTable(tableName = "cliente")
public class Cliente{

@DatabaseField(generateId = true)
private Long id;

@DatabaseField
private String nome;

@ForeignCollectionField(foreign = true, eager = true)
Collection<AnimaisEstimacaoCliente> animais;

Then you create a class, for example, "Animaisestimacaocliente" with the fields "Animalestimacao" and "Client" for the relationship. This class must be a representation of a table in the database.

@DatabaseTable(tableName = "animais_estimacao_cliente")
    public class AnimaisEstimacaoCliente{

    @DatabaseField(generateId = true)
    private Long id;

    @ForeignCollectionField(foreign = true )
    private Cliente cliente;


    @DatabaseField(dataType = DataType.ENUM_INT)
    private AnimalEstimacao animal;
}

More information is available at the links:

• http://ormlite.com/javadoc/ormlite-core/doc-files/ormlite_2.html#index-Collections-of-Objects
• https://github.com/j256/ormlite-jdbc/tree/master/src/test/java/com/j256/ormlite/examples/foreignCollection