StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18326764
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-08-20T04:01:16.140
FavoriteCount
0
LastActivityDate
2013-08-20T04:01:16.140
LastEditDate
LastEditorUserId
0
OwnerUserId
2518263
ParentId
18326540
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<pre><code>import re from sys import stdout #stdout = open("result.txt", 'w+') def read(in_file): cases = [] caselines_index = [] readlines = [] readlines_num = [] with open(in_file, 'r') as file: readfile = file.read().strip() for line in readfile.split('\n'): readlines_num.append(line.strip()) regex = re.compile("switch$\$\d$.+?\}", re.DOTALL) readfile = re.sub(regex, ' ', readfile) for line in readfile.split('\n'): readlines.append(line.strip()) for line in readlines: case_search = re.search("case\s\".+?\"\:\s", line) if case_search: caselines_index.append(readlines.index(line)) #print caselines_index caselines_index_iter = iter(caselines_index) try: int_line_index = int(next(caselines_index_iter)) except: print "No cases found" try: int_next_index = int(next(caselines_index_iter)) except: int_next_index = len(readlines) - 1 while True: try: case_text = ' '.join(readlines[int_line_index:int_next_index]).strip() match1 = re.search("nvp_add", case_text) match2 = re.search("details", case_text) if match1 or match2: case = [readlines[int_line_index].strip(), readlines_num.index(readlines[int_line_index]) + 1, case_text] cases.append(case) int_line_index = int_next_index int_next_index = int(next(caselines_index_iter)) except StopIteration: case_text = ' '.join(readlines[int_line_index:len(readlines) - 1]).strip() case = [readlines[int_line_index].strip(), readlines_num.index(readlines[int_line_index]), case_text] cases.append(case) break return cases def work(cases): MATCH = 1 for case_list in cases: details = [] nvp_add = [] caseline = case_list[0].strip() nvp = re.findall("details$.+?$", case_list[2].strip()) for item in nvp: result_list = re.findall("(\$.+?)[\,\)]", item) for result in result_list: if "$*" not in result: details.append(result) nvp = re.findall("nvp_add$.+?$", case_list[2].strip()) for item in nvp: result_list = re.findall("(\$.+?)[\,\)]", item) for result in result_list: if "$*" not in result: nvp_add.append(result) missing_from_details, missing_from_nvp_add = [], [] missing_from_details = [o for o in nvp_add if o not in set(details)] missing_from_nvp_add = [o for o in details if o not in set(nvp_add)] if missing_from_nvp_add or missing_from_details: MATCH = 0 print caseline + " LINE - " + str(case_list[1] + 1) for mismatch in missing_from_details: print "Missing from details:" print mismatch for mismatch in missing_from_nvp_add: print "Missing from nvp_add:" print mismatch print "\n" if MATCH == 1: print "MATCH" else: print "MISMATCHES" def main(): in_file = "target1.txt" cases = read(in_file) work(cases) if __name__=="__main__": main() </code></pre> <p>This will filter out all the switches that are nested. This will only work in your case with your input file.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow do I filter nested cases to be filter out python
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USVaibhav Aggarwal
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow do I filter nested cases to be filter out python
  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
CommentsPostId
1. COPERFECT answer from you bro
  singulars
  PostPostId
  PO
  UserUserId
  USuser2671444
2. COBro , for below case
  singulars
  PostPostId
  PO
  UserUserId
  USuser2671444

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.