diff options
| author | Aaron Patterson <aaron.patterson@gmail.com> | 2014-01-17 11:14:50 -0800 |
|---|---|---|
| committer | Aaron Patterson <aaron.patterson@gmail.com> | 2014-01-17 11:14:50 -0800 |
| commit | 9c04b55e52b50ced257dc215071605aa6291fc30 (patch) | |
| tree | 1525bb9fdb3066e16401def6a3e82c3749da41ce /activerecord/test/cases/adapters/sqlite3 | |
| parent | 5927f55ac2ed1b13b14292ec4906cce92aedfa7f (diff) | |
| download | rails-9c04b55e52b50ced257dc215071605aa6291fc30.tar.gz rails-9c04b55e52b50ced257dc215071605aa6291fc30.tar.bz2 rails-9c04b55e52b50ced257dc215071605aa6291fc30.zip | |
fixing explain tests for sqlite3
Diffstat (limited to 'activerecord/test/cases/adapters/sqlite3')
| -rw-r--r-- | activerecord/test/cases/adapters/sqlite3/explain_test.rb | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/activerecord/test/cases/adapters/sqlite3/explain_test.rb b/activerecord/test/cases/adapters/sqlite3/explain_test.rb index 4bee74000f..68169cc7fc 100644 --- a/activerecord/test/cases/adapters/sqlite3/explain_test.rb +++ b/activerecord/test/cases/adapters/sqlite3/explain_test.rb @@ -5,21 +5,21 @@ module ActiveRecord module ConnectionAdapters class SQLite3Adapter class ExplainTest < ActiveRecord::TestCase - #fixtures :developers + fixtures :developers - #def test_explain_for_one_query - # explain = Developer.where(:id => 1).explain - # assert_match %(EXPLAIN for: SELECT "developers".* FROM "developers" WHERE "developers"."id" = 1), explain - # assert_match(/(SEARCH )?TABLE developers USING (INTEGER )?PRIMARY KEY/, explain) - #end + def test_explain_for_one_query + explain = Developer.where(:id => 1).explain + assert_match %(EXPLAIN for: SELECT "developers".* FROM "developers" WHERE "developers"."id" = ?), explain + assert_match(/(SEARCH )?TABLE developers USING (INTEGER )?PRIMARY KEY/, explain) + end - #def test_explain_with_eager_loading - # explain = Developer.where(:id => 1).includes(:audit_logs).explain - # assert_match %(EXPLAIN for: SELECT "developers".* FROM "developers" WHERE "developers"."id" = 1), explain - # assert_match(/(SEARCH )?TABLE developers USING (INTEGER )?PRIMARY KEY/, explain) - # assert_match %(EXPLAIN for: SELECT "audit_logs".* FROM "audit_logs" WHERE "audit_logs"."developer_id" IN (1)), explain - # assert_match(/(SCAN )?TABLE audit_logs/, explain) - #end + def test_explain_with_eager_loading + explain = Developer.where(:id => 1).includes(:audit_logs).explain + assert_match %(EXPLAIN for: SELECT "developers".* FROM "developers" WHERE "developers"."id" = ?), explain + assert_match(/(SEARCH )?TABLE developers USING (INTEGER )?PRIMARY KEY/, explain) + assert_match %(EXPLAIN for: SELECT "audit_logs".* FROM "audit_logs" WHERE "audit_logs"."developer_id" IN (1)), explain + assert_match(/(SCAN )?TABLE audit_logs/, explain) + end end end end |