StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7596718
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-09-29T11:34:23.770
FavoriteCount
0
LastActivityDate
2011-09-29T12:00:51.053
LastEditDate
2011-09-29T12:00:51.053
LastEditorUserId
447232
OwnerUserId
447232
ParentId
3973963
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Taking out only internal part of the server answer containing actualy the body structure: <pre><code>struct = ('(((("TEXT" "PLAIN" ("CHARSET" "ISO-8859-1") NIL NIL "7BIT" 16 2)' '("TEXT" "HTML" ("CHARSET" "ISO-8859-1") NIL NIL "QUOTED-PRINTABLE"' ' 392 6) "ALTERNATIVE")("IMAGE" "GIF" ("NAME" "538.gif") ' '"<538@goomoji.gmail>" NIL "BASE64" 172)("IMAGE" "PNG" ("NAME" ' '"4F4.png") "<gtalk.4F4@goomoji.gmail>" NIL "BASE64" 754) "RELATED")' '("IMAGE" "JPEG" ("NAME" "avatar_airbender.jpg") NIL NIL "BASE64"' ' 157924) "MIXED")') </code></pre> Next step is to replace some tokens, what would prepair string to transform into python types: <pre><code>struct = struct.replace(' ', ',').replace(')(', '),(') </code></pre> Using built-in module <a href="http://docs.python.org/library/compiler.html" rel="nofollow">compiler</a> to parse our structure: <pre><code>import compiler expr = compiler.parse(struct.replace(' ', ',').replace(')(', '),('), 'eval') </code></pre> Performing simple recursive function to transform expression: <pre><code>def transform(expression): if isinstance(expression, compiler.transformer.Expression): return transform(expression.node) elif isinstance(expression, compiler.transformer.Tuple): return tuple(transform(item) for item in expression.nodes) elif isinstance(expression, compiler.transformer.Const): return expression.value elif isinstance(expression, compiler.transformer.Name): return None if expression.name == 'NIL' else expression.name </code></pre> And finally we get the desired result as nested python tuples: <pre><code>result = transform(expr) print result (((('TEXT', 'PLAIN', ('CHARSET', 'ISO-8859-1'), None, None, '7BIT', 16, 2), ('TEXT', 'HTML', ('CHARSET', 'ISO-8859-1'), None, None, 'QUOTED-PRINTABLE', 392, 6), 'ALTERNATIVE'), ('IMAGE', 'GIF', ('NAME', '538.gif'), '<538@goomoji.gmail>', None, 'BASE64', 172), ('IMAGE', 'PNG', ('NAME', '4F4.png'), '<gtalk.4F4@goomoji.gmail>', None, 'BASE64', 754), 'RELATED'), ('IMAGE', 'JPEG', ('NAME', 'avatar_airbender.jpg'), None, None, 'BASE64', 157924), 'MIXED') </code></pre> From where we can recognize different headers of body structure: <pre><code>text, attachments = (result[0], result[1:]) </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POparsing parenthesized list in python's imaplib
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USscraplesh
UserOwnerUserId
1. USscraplesh
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. 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.