One-to-one relationship should be supported

[birolozturkk]

@AllArgsConstructor
@NoArgsConstructor
@Data
@DatabaseTable(tableName = "users")
public class User extends DatabaseObject {

    @DatabaseField(columnName = "user_id", generatedId = true, canBeNull = false)
    private int id;

    @DatabaseField(columnName = "name", canBeNull = false)
    private String name;

    @ForeignSingletonField
    private Image image;

    @ForeignCollectionField
    private Collection<Product> products;
    
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", products=" + products +
                '}';
    }
}

@AllArgsConstructor
@NoArgsConstructor
@Data
@DatabaseTable(tableName = "images")
public class Image extends DatabaseObject {

    @DatabaseField(columnName = "id", generatedId = true)
    @Id
    private int id;

    @DatabaseField(columnName = "image_url", canBeNull = false)
    private String imageUrl;

    @DatabaseField(foreignColumnName = "user_id", foreign = true, foreignAutoCreate = true, foreignAutoRefresh = true)
    private User user;
}

I need an annotation like @ForeignCollectionField which is for single object @ForeignSingletonField. I tried to make a one-to-one relationship with javax.persistence annotation with my knowledge from jpa, but I guess ormlite doesn't support persistence annotation enough.

If this ormlite is also not possible I'm calling out to the ORMLite developers. It would be great if you add @ForeignSingletonField annotation .

The annatation I want you to add corresponds to @OnetoOne in JPA

[j256]

What would the resulting schema look like? Also, can you replace the images with code samples?

[birolozturkk]

What would the resulting schema look like? Also, can you replace the images with code samples?

@ForeignCollectionField annotation made for single objects

[j256]

Can you give a concrete example of the SQL?

[birolozturkk]

[birolozturkk]

do you understand my suggestion

[birolozturkk]

Will my suggestion be considered?

[j256]

Sorry for the delay on this. Hasn't been a priority to add it but it's on the list.