StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
13208425
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-11-03T10:46:33
FavoriteCount
0
LastActivityDate
2012-11-03T10:46:33
LastEditDate
2017-05-23T11:53:55.947
LastEditorUserId
-1
OwnerUserId
1356142
ParentId
13208212
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<p>use pythons string manipulation: <a href="http://docs.python.org/2/library/stdtypes.html#string-formatting" rel="nofollow noreferrer">http://docs.python.org/2/library/stdtypes.html#string-formatting</a></p> <p>generally the % operator is used to put a variable into a string, %i for integers, %s for strings and %f for floats, NB: there is also another formatting type (.format) which is also described in the above link, that allows you to pass in a dict or list slightly more elegant than what I show below, this may be what you should go for in the long run as the % operator gets confusing if you have 100 variables you want to put into a string, though the use of dicts (my last example) kinda negates this. </p> <pre><code>code_str = "super duper heading" html = "<h1>%s</h1>" % code_str # <h1>super duper heading</h1> code_nr = 42 html = "<h1>%i</h1>" % code_nr # <h1>42</h1> html = "<h1>%s %i</h1>" % (code_str, code_nr) # <h1>super duper heading 42</h1> html = "%(my_str)s %(my_nr)d" % {"my_str": code_str, "my_nr": code_nr} # <h1>super duper heading 42</h1> </code></pre> <p>this is very basic and only work with primitive types, if you want to be able to store dicts, lists and possible objects I suggest you use cobvert them to jsons <a href="http://docs.python.org/2/library/json.html" rel="nofollow noreferrer">http://docs.python.org/2/library/json.html</a> and <a href="https://stackoverflow.com/questions/4759634/python-json-tutorial">https://stackoverflow.com/questions/4759634/python-json-tutorial</a> are good sources of inspiration</p> <p>Hope this helps</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPython Variable in an HTML email in Python
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USjcr
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.