StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12276903
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
2012-09-06T02:31:56.623
CreationDate
2012-09-05T07:54:47.517
FavoriteCount
0
LastActivityDate
2012-09-06T02:31:56.623
LastEditDate
2012-09-06T02:31:56.623
LastEditorUserId
1309796
OwnerUserId
1309796
ParentId
3476987
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<hr> Adding <hr> from <pre><code>departments = ["this", "that"] departments.each{|d| Department.where(:name => d).first_or_create} </code></pre> to <pre><code>departments = ["this", "that", "there", "then"] departments.each{|d| Department.where(:name => d).first_or_create} </code></pre> this is a simple example, <hr> Updating/rename <hr> from <pre><code>departments = ["this", "that", "there", "then"] departments.each{|d| Department.where(:name => d).first_or_create} </code></pre> to <pre><code>departments = ["these", "those", "there", "then"] new_names = [['these', 'this'],['those','that']] new_names.each do |new| Department.where(:name => new).group_by(&:name).each do |name, depts| depts.first.update_column :name, new[0] if new[1] == name # skips validation # depts[1..-1].each(&:destroy) if depts.size > 1 # paranoid mode end end departments.each{|d| Department.where(:name => d).first_or_create} </code></pre> IMPORTANT: You need to update the elements of <code>departments</code> array else duplication will surely happen. Work around: Add a validates_uniqueness_of validation or a validation of uniqueness comparing all necessary attributes BUT don't use <a href="http://guides.rubyonrails.org/active_record_validations_callbacks.html#skipping-validations" rel="nofollow">methods skipping validations</a>. 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POappending to rake db:seed in rails and running it without duplicating data
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USRafael Perea
UserOwnerUserId
1. USRafael Perea
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. This table or related slice is empty.
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.