StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16926630
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-06-04T20:13:21.667
FavoriteCount
0
LastActivityDate
2013-06-04T20:13:21.667
LastEditDate
2017-05-23T12:23:13.470
LastEditorUserId
-1
OwnerUserId
1064226
ParentId
16923675
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
You're running a request spec: when you call visit the code under test is run in a server instance (in the same process). In particular this means that it's using a different thread. As a result the application code ends up using a different database connection, and since transactions are a per connection thing there is no transaction used when your controller inserts records into the database. There are several ways to address this. One is to abandon rspec's transactional fixtures and use the database_cleaner gem. You can set it up so that controller and model specs use transactions but request specs use truncate to forcibly clear out tables. Another approach is to try and force both the spec code and the server code to use the same database connection, this eliminating the problem. You can see this approach in <a href="https://stackoverflow.com/questions/8774227/why-not-use-shared-activerecord-connections-for-rspec-selenium">this answer</a>. In my experience this works pretty well until you start using a capybara driver such as poltergeist which will run any javascript on the page and your page fires ajax requests. The approach I've been using is to set the active record connection pool size to 1: there is only 1 connection allowed so everyone will use the same one. You do then have to do some work to ensure that connections are returned to the pool or your spec just hangs. I wrote up the details a while ago as a <a href="http://www.spacevatican.org/2012/8/18/threading-the-rat/" rel="nofollow noreferrer">blog post</a>, but in a nutshell you need to <ul> <li>call <code>ActiveRecord::Base.clear_active_connections!</code> before calling methods like visit, click and so on</li> <li>hack config.middleware.insert_before <code>ActiveRecord::ConnectionAdapters::ConnectionManagement</code> so that it clears the connection after each request (by default it doesn't do this in tests).</li> </ul>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhy are these Rspec examples not occuring within a DB transaction?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USFrederick Cheung
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.