aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/cases/adapters/mysql2/schema_test.rb
diff options
context:
space:
mode:
authorEileen M. Uchitelle <eileencodes@gmail.com>2016-07-01 11:30:40 -0400
committerGitHub <noreply@github.com>2016-07-01 11:30:40 -0400
commit4abd389ef77cf8f8b45793451c6d4429ca08062e (patch)
tree89930d89f7a22d07010207d78721ff136b782c17 /activerecord/test/cases/adapters/mysql2/schema_test.rb
parent297e262035ce9dce9c33f8bebc778f36760a5e40 (diff)
parent7b7b7c5ce62e1ede29dad4ae1ce613bd12f8089c (diff)
downloadrails-4abd389ef77cf8f8b45793451c6d4429ca08062e.tar.gz
rails-4abd389ef77cf8f8b45793451c6d4429ca08062e.tar.bz2
rails-4abd389ef77cf8f8b45793451c6d4429ca08062e.zip
Merge pull request #25307 from kamipo/extract_foreign_key_action_from_information_schema
Extract foreign key action from `information_schema`
Diffstat (limited to 'activerecord/test/cases/adapters/mysql2/schema_test.rb')
-rw-r--r--activerecord/test/cases/adapters/mysql2/schema_test.rb21
1 files changed, 21 insertions, 0 deletions
diff --git a/activerecord/test/cases/adapters/mysql2/schema_test.rb b/activerecord/test/cases/adapters/mysql2/schema_test.rb
index 43957791b1..57ea8258d1 100644
--- a/activerecord/test/cases/adapters/mysql2/schema_test.rb
+++ b/activerecord/test/cases/adapters/mysql2/schema_test.rb
@@ -103,3 +103,24 @@ module ActiveRecord
end
end
end
+
+class Mysql2AnsiQuotesTest < ActiveRecord::Mysql2TestCase
+ def setup
+ @connection = ActiveRecord::Base.connection
+ @connection.execute("SET SESSION sql_mode='ANSI_QUOTES'")
+ end
+
+ def teardown
+ @connection.reconnect!
+ end
+
+ def test_primary_key_method_with_ansi_quotes
+ assert_equal "id", @connection.primary_key("topics")
+ end
+
+ def test_foreign_keys_method_with_ansi_quotes
+ fks = @connection.foreign_keys("lessons_students")
+ assert_equal([["lessons_students", "students", :cascade]],
+ fks.map {|fk| [fk.from_table, fk.to_table, fk.on_delete] })
+ end
+end