I’m very new to the Event Store (and JavaScript), but seem to have encountered a question I don’t see covered anywhere else.
Question**: Is it possible to create a single projection that could be invoked with different values for the category name in the fromCategory(’CATEGORY NAME’) statement?**
Additional background: I’m building a POC to track the real-time holdings of securities in accounts for a firm that trades equities. A holding is uniquely identified by an AccountId (~300 accounts), a SecurityId (2000-3000 equities), and a HoldingType (i.e. long or short). I’m currently creating a stream for each position. I need to show that I can generate a report from the streams that contains the current holdings for each position (i.e. a table with columns, AccountId, SecurityId, HoldingType, ShareQuantity). I’m simplifying the problem a bit, but this should be enough detail for the purposes of this question.
I currently have a projection that looks something like this:
fromCategory(‘ACCOUNT1’)
.foreachStream()
.when({
$init: function()
{
return {
totalIntradayHoldings:0
};
},
IntradayOrderFilled:function(state, event)
{
state.totalIntradayHoldings += event.body.HoldingUpdateState.Quantity;
}
});
By changing the partition in the URL which invokes the projection, I can get the number of shares owned within each position on ACCOUNT1:
curl -i http://127.0.0.1:2113/projection/ACCOUNT1-AllHoldings/state?partition=ACCOUNT1-5723777long
I’m planning to write some C# code to generate all the partition strings and makes the many HTTP calls to the projection(s). (i.e. ACCOUNT1-5723777short, ACCOUNT1-5724099long, ACCOUNT1-5724099short, etc…). I’ll get a list of all the security ids each account trades and whether the account has long and/or short positions for those securities. There’s an example of this C# code creating the partition string and invoking the projection in Chapter 26 (see listings 26-14 and 26-15) of Patterns, Principles, and Practices of Domain-Driven Design (WROX Press). Back to my original question: I’d like to create a single projection and pass in the name of the account. Otherwise, I think I’ll need to create 300 projections that are the same, except for the name of the account in the statement fromCategory(‘ACCOUNT1’).
Thanks!
David Madrian