So, I’ve been building projects using Apache CouchDB for a few years now, and there are some things I really like about it. But one need I’m always bumping up against is the ability to summarize tons of heterogeneous documents in a straightforward way. For example, I’m producing a list of users and I have a hierarchy of preferred display strings I want to generate, based on what information is available. Here’s a sample document that includes all of the possible fields I might want to show in summary string:
"CompanyName": "Absion Technologies LC",
So, in this case I want to see the user’s company and full name, like this:
Absion Technologies LC: Scott Means
But if the company name isn’t there, I want to see:
If there’s no
LastName, I want to see the
The engine expects a JSON array and a JSON object as its inputs. I could explain all of the rules here, but it’s actually a little easier to see some examples with an explanation:
["FirstName"] => "Scott"
Any array with only one element is inferred to be a field in the JSON object, and the corresponding value is returned. If this value doesn’t exist, it returns
["MissingField"] => undefined
If the array has multiple elements, the
evalJsonTemplate() function is executed recursively on each element, with the results being inserted into a result array:
[["FirstName"], " ", ["LastName"]] => ["Scott", " ", "Means"]
Then, the elements of the result array are concated and the result is returned to the caller. But what if one of the values is missing? Take the following example:
[["Title"], " ", ["LastName"]] => result array: [undefined, " ", "Means"]
By default, if any of the elements of the result array are undefined, the engine returns an empty string (
''). This is implicit, but it is possible to pass an explicit operator as the first element to any template array, like so:
["$all", ["Title"], " ", ["LastName"]] => ''
But there are other operators available. The
$any operator will concat any valid string elements together and return the result. So, the preceding template could be rewritten as:
["$any", ["Title"], " ", ["LastName"]] => ' Means'
Note the blank preceding my last name. That’s not very tidy. But using the rules we already know, it’s easy to collapse the blank by nesting the Title rule in another array:
[[["Title"], " "], ["LastName"]]
It was also possible to lose the $any opcode, because the
[["Title"], " "] rule returns an empty string, which will be prepended to the last name.
Now, there is only one more opcode needed to express all of the cases that I need to cover. That is the
$first opcode. It indicates that the first valid element of the result array (not
undefined) should be returned. This allows a list of possible formats to be specified in order, and the first one that produces output will be chosen.
As a complete example, the following JSON string conveys all of the preferred display strings that I want for my sample document above. It’s guaranteed to always produce something, thanks to the final
["$first", [[["Company"], ": "], [ ["FirstName"], " " ], ["LastName"] ],
["Company"], ["Email"], ["Username"], ["_id"] ]
And, as an added bonus, the entire template function is only 42 lines of code. It’s the answer to life, the universe, and everything. Or at least to generating summary strings without too much hassle. See my JS fiddle for the code.