StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17856366
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-07-25T11:10:50.380
FavoriteCount
0
LastActivityDate
2013-07-25T15:41:59.370
LastEditDate
2013-07-25T15:41:59.370
LastEditorUserId
923854
OwnerUserId
923854
ParentId
17854219
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
This kind of manipulation is fairly easy with an index sequence technique: generate an index sequence with two fewer indices than your tuple, and use that sequence to select fields from the original. Using <a href="http://www.open-std.org/jtc1/sc22/wg21/docs/papers/2013/n3658.html" rel="nofollow"><code>std::make_index_sequence</code></a> and return type deduction from C++14: <pre><code>template <typename... T, std::size_t... I> auto subtuple_(const std::tuple<T...>& t, std::index_sequence<I...>) { return std::make_tuple(std::get(t)...); } template <int Trim, typename... T> auto subtuple(const std::tuple<T...>& t) { return subtuple_(t, std::make_index_sequence<sizeof...(T) - Trim>()); } </code></pre> In C++11: <pre><code>#include <cstddef> // for std::size_t template<typename T, T... I> struct integer_sequence { using value_type = T; static constexpr std::size_t size() noexcept { return sizeof...(I); } }; namespace integer_sequence_detail { template <typename, typename> struct concat; template <typename T, T... A, T... B> struct concat<integer_sequence<T, A...>, integer_sequence<T, B...>> { typedef integer_sequence<T, A..., B...> type; }; template <typename T, int First, int Count> struct build_helper { using type = typename concat< typename build_helper<T, First, Count/2>::type, typename build_helper<T, First + Count/2, Count - Count/2>::type >::type; }; template <typename T, int First> struct build_helper<T, First, 1> { using type = integer_sequence<T, T(First)>; }; template <typename T, int First> struct build_helper<T, First, 0> { using type = integer_sequence<T>; }; template <typename T, T N> using builder = typename build_helper<T, 0, N>::type; } // namespace integer_sequence_detail template <typename T, T N> using make_integer_sequence = integer_sequence_detail::builder<T, N>; template <std::size_t... I> using index_sequence = integer_sequence<std::size_t, I...>; template<size_t N> using make_index_sequence = make_integer_sequence<size_t, N>; #include <tuple> template <typename... T, std::size_t... I> auto subtuple_(const std::tuple<T...>& t, index_sequence<I...>) -> decltype(std::make_tuple(std::get(t)...)) { return std::make_tuple(std::get(t)...); } template <int Trim, typename... T> auto subtuple(const std::tuple<T...>& t) -> decltype(subtuple_(t, make_index_sequence<sizeof...(T) - Trim>())) { return subtuple_(t, make_index_sequence<sizeof...(T) - Trim>()); } </code></pre> <a href="http://coliru.stacked-crooked.com/view?id=af8b52a1a5db4e56a33a6cd1f4f213a7-e1204655eaff68246b392dc70c5a32c9" rel="nofollow">Live at Coliru</a>.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCreating a sub-tuple starting from a std::tuple<some_types...>
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCasey
UserOwnerUserId
1. USCasey
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POCreating a sub-tuple starting from a std::tuple<some_types...>
 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
 VTUpMod
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.