androidormliteforeign-collection

Ormlite - deleting nested objects from ForeignCollection but not from database


I have ContactItem which contains ForeignCollection of GroupItem:

public class ContactItem implements Parcelable{
    @DatabaseField(generatedId = true)
    private Integer id;
    @DatabaseField(dataType = DataType.STRING, columnName = Constants.CONTACT_NAME)
    private String name;
    @DatabaseField(dataType = DataType.STRING, columnName = Constants.CONTACT_NUMBER)
    private String number;
    @DatabaseField(dataType = DataType.INTEGER, columnName = Constants.CONTACT_ICON)
    private int icon;
    @DatabaseField(dataType = DataType.INTEGER, columnName = Constants.CONTACT_DAYS)
    private int days;
    @DatabaseField(foreign=true,canBeNull = true,foreignAutoRefresh = true,columnName = Constants.CONTACT_GROUP)
    private GroupItem group;
    @ForeignCollectionField(columnName = Constants.CONTACT_GROUP_LIST)
    private ForeignCollection<GroupItem> groups;
}

and GroupItem, which contains ForeignCollection of ContactItem:

public class GroupItem implements  Parcelable{
    @DatabaseField(generatedId = true)
    private Integer id;
    @DatabaseField(dataType = DataType.STRING, columnName = Constants.GROUP_NAME)
    private String name;
    @DatabaseField(dataType = DataType.INTEGER, columnName = Constants.GROUP_ICON)
    private int icon;
    @DatabaseField(dataType = DataType.INTEGER, columnName = Constants.GROUP_COUNT)
    private int count;
    @DatabaseField(foreign=true,canBeNull = true,foreignAutoRefresh = true, columnName = Constants.GROUP_CONTACT)
    private ContactItem contact;
    @ForeignCollectionField(eager = true, columnName=Constants.GROUP_CONTACTS_LIST)
    private ForeignCollection<ContactItem> contacts;
    @DatabaseField(dataType = DataType.INTEGER, columnName = Constants.GROUP_DAYS)
    private int days;
}

and i need to delete ContactItem from GroupItem's ForeignCollection of ContactItems. I do it like that:

  public void removeContactFromGroup(GroupItem group, ContactItem contact)
        {
            DatabaseHandler db = new DatabaseHandler(context.getApplicationContext());
            Dao<GroupItem,Integer> daoGroup = null;
            Dao<ContactItem,Integer> daoContact = null;
            GroupItem newGroup = null;
             try {
                 daoGroup = db.getGroupDao();
                 daoContact = db.getContactDao();
                 UpdateBuilder<GroupItem, Integer> updateBuilder = daoGroup.updateBuilder();
                 newGroup = daoGroup.queryForId(group.getId());
                 if ( newGroup.getContactCollection().contains(contact))
                 {


                 }
             }
             catch(Exception e)
             {
                 Log.i(" saveGroupContacts database problem","It is cause problem");
                 e.printStackTrace();
             }
        }

but it delets ContactItem from whole database. But I need to remove it only from ForeignCollection. How can I implement this?


Solution

  • I solved my issue by maybe not elegant, but workable solution : I simply set my nested object in those, which contains it to null and update object-container with dao :

    public void removeContactFromGroup(GroupItem group, ContactItem contact)
            {
                DatabaseHandler db = new DatabaseHandler(context.getApplicationContext());
                Dao<GroupItem,Integer> daoGroup = null;
                Dao<ContactItem,Integer> daoContact = null;
                GroupItem newGroup = null;
                ContactItem contactFromDb = null;
                 try {
                     daoGroup = db.getGroupDao();
                     daoContact = db.getContactDao();
                     UpdateBuilder<GroupItem, Integer> updateBuilder = daoGroup.updateBuilder();
                     newGroup = daoGroup.queryForId(group.getId());
                     contactFromDb = daoContact.queryForId(contact.getId());
                     contactFromDb.setContactGroup(null);
                     daoContact.update(contactFromDb);
    
                 }
                 catch(Exception e)
                 {
                     Log.i(" saveGroupContacts database problem","It is cause problem");
                     e.printStackTrace();
                 }
            }
    

    Worked for me.