diff options
| author | Ryuta Kamizono <kamipo@gmail.com> | 2019-05-21 23:25:14 +0900 | 
|---|---|---|
| committer | Ryuta Kamizono <kamipo@gmail.com> | 2019-05-21 23:25:14 +0900 | 
| commit | 0810c076de0d9b7879ee240bb08d31fb7c2f5ac9 (patch) | |
| tree | 7e43039b721451cbbb1edc12b651a2f99d69b5ca /railties/lib/rails/commands/help/USAGE | |
| parent | 973096b6ae1f34310316a74e282501357739ac87 (diff) | |
| download | rails-0810c076de0d9b7879ee240bb08d31fb7c2f5ac9.tar.gz rails-0810c076de0d9b7879ee240bb08d31fb7c2f5ac9.tar.bz2 rails-0810c076de0d9b7879ee240bb08d31fb7c2f5ac9.zip | |
Except SCHEMA SQLs in `capture_sql`
Testing the result of `capture_sql` is fragile, it is due to whether
SCHEMA SQLs are executed or not depends on whether schema cache is
filled or not.
https://buildkite.com/rails/rails/builds/61248#a5b9dc59-ff0c-40c0-b56e-0895662fbc4c/993-1004
https://buildkite.com/rails/rails/builds/61248#1157b389-f2c7-4554-b6e5-a37624a0e74a/996-1005
I've confirmed all `capture_sql` use cases in our code base, all cases
won't expect SCHEMA SQLs are included.
```
% git grep -n capture_sql
test/cases/associations/belongs_to_associations_test.rb:202:    sql = capture_sql { comment.post }
test/cases/associations/belongs_to_associations_test.rb:204:    assert_not_equal sql, capture_sql { comment.post }
test/cases/associations/has_many_associations_test.rb:169:    sql = capture_sql { post.comments.to_a }
test/cases/associations/has_many_associations_test.rb:171:    assert_not_equal sql, capture_sql { post.comments.to_a }
test/cases/associations/has_many_associations_test.rb:276:    expected_sql = capture_sql { author.thinking_posts.delete_all }
test/cases/associations/has_many_associations_test.rb:281:    loaded_sql = capture_sql { author.thinking_posts.delete_all }
test/cases/associations/has_many_associations_test.rb:289:    expected_sql = capture_sql { author.posts.delete_all }
test/cases/associations/has_many_associations_test.rb:294:    loaded_sql = capture_sql { author.posts.delete_all }
test/cases/associations/left_outer_join_association_test.rb:22:      queries = capture_sql do
test/cases/associations/left_outer_join_association_test.rb:49:    queries = capture_sql { Author.left_outer_joins(:posts).to_a }
test/cases/associations/left_outer_join_association_test.rb:54:    queries = capture_sql { Author.joins(:posts).left_outer_joins(:posts).to_a }
test/cases/associations/left_outer_join_association_test.rb:60:    queries = capture_sql { Author.left_outer_joins({}).to_a }
test/cases/associations/left_outer_join_association_test.rb:65:    queries = capture_sql { Author.left_outer_joins([]).to_a }
test/cases/associations/left_outer_join_association_test.rb:78:    queries = capture_sql { Author.left_outer_joins(:essays).to_a }
test/cases/associations_test.rb:384:    log = capture_sql do
test/cases/associations_test.rb:399:    log = capture_sql do
test/cases/associations_test.rb:414:    log = capture_sql do
test/cases/associations_test.rb:429:    log = capture_sql do
test/cases/associations_test.rb:444:    log = capture_sql do
test/cases/associations_test.rb:459:    log = capture_sql do
test/cases/reflection_test.rb:307:    expected_sql = capture_sql { hotel.recipes.to_a }
test/cases/reflection_test.rb:312:    loaded_sql = capture_sql { hotel.recipes.to_a }
test/cases/relation_test.rb:212:      queries = capture_sql { Author.joins(:posts).merge(Post.joins(:comments)).to_a }
test/cases/relation_test.rb:232:      queries = capture_sql { Post.joins(:author, :categorizations).merge(Author.select(:id)).merge(categorizations_with_authors).to_a }
test/cases/relation_test.rb:347:      log = capture_sql do
test/cases/scoping/relation_scoping_test.rb:146:      log = capture_sql do
test/cases/scoping/relation_scoping_test.rb:159:    log = capture_sql do
test/cases/test_case.rb:33:    def capture_sql
test/cases/test_case.rb:41:      capture_sql { yield }
```
Diffstat (limited to 'railties/lib/rails/commands/help/USAGE')
0 files changed, 0 insertions, 0 deletions
