CODEWITHSUNDEEP
iphoneioscore-data
Greg
Greg

Reputation: 34818

CoreData (IOS) Unique Constraint on Multiple columns?

Is it possible to, in CoreData for an iPhone app, have a Unique Constraint on Multiple columns?

For example:

So questions are:

  1. How could I setup this constraint in coredata?
  2. If it's not directly support any suggestions re how to put in place programmatically?

Upvotes: 6

Views: 2680

Answers (3)

Zahid
Zahid

Reputation: 562

Unique Constraints make sure that records in an Entity are unique by the given fields. But unique constraints along with To-Many relationship leads to a lot of weird issues while resolving conflicts.

e.g. “Dangling reference to an invalid object.”

This post is basically focused to a small problem that may take days to fix.

http://muhammadzahidimran.com/2016/12/08/coredata-unique-constraints-and-to-many-relationship/

Upvotes: 0

Stripes
Stripes

Reputation: 4229

To do

For any core data constraint that operates on more then a single managed object at once you want to look at implementing:

- (BOOL)validateForDelete:(NSError **)error
- (BOOL)validateForInsert:(NSError **)error
- (BOOL)validateForUpdate:(NSError **)error

(I normally have core data make a .h and .m file for the entity, and then make my own category for things like this so I don't have as much work if I change the entity a little later)

If you have something that only needs to make sure values in a single managed object are correct you can use -validate<Key>:error:

To do what you are looking for I would make EventItems' validateForInsert/validateForUpdate call a common method (maybe validateUniqueOrder). In that method I would use the relationship from EventItems to Event, and then fetch all the EventItems relating to the Event, and then check for uniqueness. I have fairly small sets of relations, so I didn't bother with anything fancy, but if you have a lot of event items associated with given events you might look into NSFetchRequests' setPropertiesToFetch method. Or maybe you can come up with a query that can directly search for duplicated values (I never could, so if you do, reply here to enlighten me).

Upvotes: 6

Caleb
Caleb

Reputation: 125007

How could I setup this constraint in coredata?

You control what goes into the data store, so you can impose any constraints you like, no matter how complex. But Core Data is not a database, and it doesn't implement the kinds of automatic constraints that you typically find in a RDBMS.

If it's not directly support any suggestions re how to put in place programmatically?

I'd do a check at the point in your code where you create or modify the affected object. In your case, you could create a custom setter for EventItem's 'order' property that compares the proposed 'order' to that of all the other EventItems related to the same event. Or, you might put the check in Event, and use an appropriate accessor to check any new EventItems as they're added.

Upvotes: 3

Related Questions