Unique field validation

[imissyouso]

Unique field validation

[nanov]

Having what @adrai said in mind, there are a few patterns you can apply to solve your problem, after you have decided that cqrs/es is suitable for youe user/account management:

• in your case you can set the aggregate id as the email, and give the command a rule that the aggregate does not exists.

• you may take a look on this answer that i gave for similar question - as last resort this is a solution.
  In your case

[adrai]

Hehe... welcome to the cqrs world...
Do not mix domain and eventDenormalizer stuff that way.
To solve this you really need 1 aggregate.
To make this more efficient when having too much events, there are snapshots.

[imissyouso]

Also the way

If you really want to solve it in the domain, you need only 1 aggregate instance i.e. with a fix aggregate id (i.e. USER_EMAILS)

is not a suitable because for every check we need to load the whole aggregate with full list of emails and then make check directly in code (in cycle?). What if we have > 1k users? We cannot make such complex operation just for simple checking for uniqueness.

Thanks for reply in advance.

[imissyouso]

Found similar question on stackoverflow
https://stackoverflow.com/questions/31386244/cqrs-event-sourcing-check-username-is-unique-or-not-from-eventstore-while-sendin
conclusion: there is no universal way how to do that. In most cases we have to put up with possible data inconsistency in such types of architectures and do not try to hack CAP theorem.

[dmitry-textmagic]

The second approach is quite clear. But in the first one, how should we manage email change? If we set an email as an aggregate id, then change email (and it was aggregate id), it causes that any other entities that have this aggregate id (email, in this case) inside would be linked to non-existent/invalid aggregate.

[adrai]

This is why I said, you need 1 aggregate for all email addresses...
Or solve this outside of cqrs.
PS. sorry for not responding with a more complete/longer answer... writing from hospital

[imissyouso]

This is why I said, you need 1 aggregate for all email addresses...
Or solve this outside of cqrs.
PS. sorry for not responding with a more complete/longer answer... writing from hospital

I wish you a speedy recovery!