• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Check / Force field uniqueness in EOF
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Check / Force field uniqueness in EOF


  • Subject: Check / Force field uniqueness in EOF
  • From: Dan Grec <email@hidden>
  • Date: Wed, 25 Mar 2009 13:46:37 -0600

Full of questions today....

I have an EO that has a field "RemoteSystemID" that must be unique in the DB.
I have the constraint in the DB and that works well.

What I would like, is a way in EOF to detect non-uniqueness without going to the db and relying on the SQL Exception.

Currently, I have something like this:

    @Override
    public void validateForSave() throws NSValidation.ValidationException {
        validateRemoteSystemId();
        super.validateForSave();
    }

    //check that no Categories have this same remoteSystemID
    public void validateRemoteSystemId() {
        NSArray<Category> categories = SCEOFetcher.objectsMatchingKeyAndValue(editingContext(), Category.class, _Category.REMOTE_SYSTEM_ID_KEY, remoteSystemId(), EOFetcher.DBEC);
        if (categories.count() > 1)
        throw new NSValidation.ValidationException("Category Remote System Id must be unique.", this, REMOTE_SYSTEM_ID_KEY);
    }

This works really well if there is already one in the DB with a value of say "123" and I try to add with with a value of "123".
This does not work if I try to add two at the same time with a value of "567", it allows them both through.

Does anyone have a strategy to catch uniqueness at the EOF level?

Or, is it fine to just rely on the DB throwing an SQLException and catch that after ec().saveChanges() ?
(I feel like letting that happen is bad, and might leave EOF in an un-happy state - is there any chance of that?)

Thanks again,
-Dan Grec
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Check / Force field uniqueness in EOF
      • From: Simon McLean <email@hidden>
    • Re: Check / Force field uniqueness in EOF
      • From: Chuck Hill <email@hidden>
    • Re: Check / Force field uniqueness in EOF
      • From: Guido Neitzer <email@hidden>
  • Prev by Date: Re: Setting not-nullable field to null - nothing happens
  • Next by Date: Re: Check / Force field uniqueness in EOF
  • Previous by thread: Re: creating and instantiating formatters
  • Next by thread: Re: Check / Force field uniqueness in EOF
  • Index(es):
    • Date
    • Thread