StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20081448
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-11-19T20:32:43.180
FavoriteCount
0
LastActivityDate
2013-11-19T20:49:26.713
LastEditDate
2013-11-19T20:49:26.713
LastEditorUserId
370768
OwnerUserId
370768
ParentId
20080789
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
You might want to take a look at <a href="https://github.com/rhdunn/cainteoir-engine/blob/0c283e798c8141a65060c5e92f462646c2689644/tests/dictionary.py" rel="nofollow">https://github.com/rhdunn/cainteoir-engine/blob/0c283e798c8141a65060c5e92f462646c2689644/tests/dictionary.py</a>. I wrote this to support regular expressions in text-to-speech pronunciation dictionaries, but the regex expanding logic is self-contained. You can use it like: <pre><code>import dictionary words, endings = dictionary.expand_expression('colou?r', {}) print words </code></pre> Here, the second parameter is for references (i.e. named blocks) and the endings is for, e.g. <code>look{s,ed,ing}</code> How it works ... <code>lex_expression</code> splits the string into tokens delimited by the regex tokens <code>[]<>|(){}?</code>. Thus, <code>a(b|cd)efg</code> becomes <code>['a', '(', 'b', '|', 'cd', ')', 'efg']</code>. This makes it easier to parse the regex. The <code>parse_XYZ_expr</code> functions (along with the top-level <code>parse_expr</code>) parse the regex elements, constructing an object hierarchy that represents the regex. These objects are: <ul> <li>Literal -- a literal sequence of one or more characters</li> <li>Choice -- any of the sub-expressions in the sequence (i.e. '|')</li> <li>Optional -- either the result of the expression, or not (i.e. <code>a?</code>)</li> <li>Sequence -- the sub-expressions in order</li> </ul> Thus, <code>ab(cd|e)?</code> is represented as <code>Sequence(Literal('ab'), Optional(Choice(Literal('cd'), Literal('e'))))</code>. These classes support an <code>expand</code> method that has the form <code>expr.expand(words) => expanded</code>, e.g.: <pre><code>expr = Optional('cd') print expr.expand(['ab', 'ef']) </code></pre> results in: <pre><code>ab abcd ef efcd </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POGiven a regular expression, how would I generate all strings that match it?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USreece
UserOwnerUserId
1. USreece
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.