0

I'm using greenDAO for an ORM in an Android App that I'm writing.

I generated all the DAO files and am now at the point of inserting, updating and deleting in my database.

I'm at a particular point where I'm not sure if an Entity will exist in the database or not and I'd like to update the Entity if it exists or insert the Entity if it does not.

(Also, I have a unique constraint on 2 columns, for simplicity call them ColumnA and ColumnB).

Anyone know how to perform this type of task? Every time I try to insert into the database I get a COLUMNS ARE NOT UNIQUE SqLite error which tells me that I'm not updating rather inserting a record whose uniqueness already exists in the database.

Thank you! Best Regards, Christopher Steven

chocospaz
  • 739
  • 1
  • 8
  • 15

1 Answers1

1

What could be useful for this (since greenDao doesn't support this out of the box at this moment) is to take those two (or three or any number of database colums) and implement/generate a hash method there in the model and make that the primary key.

pl3kn0r
  • 347
  • 4
  • 9