StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
15546809
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-03-21T11:55:03.563
FavoriteCount
0
LastActivityDate
2013-03-21T11:55:03.563
LastEditDate
LastEditorUserId
0
OwnerUserId
43662
ParentId
15543379
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I think you need to rethink your Mustache template slightly. The jMustache library (which I assume you are using) seems to always treat <code>{{#</code> entities as lists and iterate their contents, regardless of the data type passed in. Something like this should work: <pre><code><h1>{{header}}</h1> {{#items}} <li> {{#url}}<a href="{{.}}">{{/url}} {{^url}}{{/url}} {{caption}} {{#url}}</a>{{/url}} {{^url}}{{/url}} </li> {{/items}} {{^items}} The list is empty. {{/items}} </code></pre> This will produce an HMTL anchor only if a "link" value is provided, thus avoiding the jMustache if condition issue. So the JSON model would look something like this: <pre><code>{ "header": "Colors", "items": [ {"caption": "title"}, {"caption": "red", "url": "#Red"}, {"caption": "green", "url": "#Green"}, {"caption": "blue", "url": "#Blue"} ] } </code></pre> Finally, you will need to convert your JSON to something jMustache understands. I've never seen or heard of the "HTTPFunctions" class in any library I've used, but I've done some similar mapping using Gson in the past. Note that this is a very simple implementation and you may need to extend it to fit your needs: <pre><code>private Map<String, Object> getModelFromJson(JSONObject json) throws JSONException { Map<String,Object> out = new HashMap<String,Object>(); Iterator it = json.keys(); while (it.hasNext()) { String key = (String)it.next(); if (json.get(key) instanceof JSONArray) { // Copy an array JSONArray arrayIn = json.getJSONArray(key); List<Object> arrayOut = new ArrayList<Object>(); for (int i = 0; i < arrayIn.length(); i++) { JSONObject item = (JSONObject)arrayIn.get(i); Map<String, Object> items = getModelFromJson(item); arrayOut.add(items); } out.put(key, arrayOut); } else { // Copy a primitive string out.put(key, json.getString(key)); } } return out; } </code></pre> This basic JUnit test demonstrates the theory: <a href="http://www.pasteshare.co.uk/p/841/" rel="nofollow">http://www.pasteshare.co.uk/p/841/</a>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POTake Mustache Template, pass JSON and Convert to HTML
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USseanhodges
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POTake Mustache Template, pass JSON and Convert to HTML
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.