diff options
author | Rafael França <rafaelmfranca@gmail.com> | 2017-10-25 11:44:08 -0400 |
---|---|---|
committer | GitHub <noreply@github.com> | 2017-10-25 11:44:08 -0400 |
commit | 08df10a95b4a72128ff5e5cee858c29c149e22a7 (patch) | |
tree | da93471a499c79fd6beb234b88c1f0be3615ffa6 /activerecord | |
parent | df4632fece02d5a780f6d71e688499cb7b4bfcf3 (diff) | |
parent | ab8c7a518eb9583dbc574ff68fd56bcccf383452 (diff) | |
download | rails-08df10a95b4a72128ff5e5cee858c29c149e22a7.tar.gz rails-08df10a95b4a72128ff5e5cee858c29c149e22a7.tar.bz2 rails-08df10a95b4a72128ff5e5cee858c29c149e22a7.zip |
Merge pull request #30970 from rohitpaulk/fix-sqlite-3-index-order-dump
Save index order :desc to schema.rb (sqlite). Fixes #30902
Diffstat (limited to 'activerecord')
-rw-r--r-- | activerecord/CHANGELOG.md | 7 | ||||
-rw-r--r-- | activerecord/lib/active_record/connection_adapters/sqlite3/schema_statements.rb | 12 | ||||
-rw-r--r-- | activerecord/test/cases/schema_dumper_test.rb | 2 |
3 files changed, 19 insertions, 2 deletions
diff --git a/activerecord/CHANGELOG.md b/activerecord/CHANGELOG.md index ee73004810..3e1b467633 100644 --- a/activerecord/CHANGELOG.md +++ b/activerecord/CHANGELOG.md @@ -1,3 +1,10 @@ +* Fixed a bug where column orders for an index weren't written to + db/schema.rb when using the sqlite adapter. + + Fixes #30902. + + *Paul Kuruvilla* + * Remove deprecated method `#sanitize_conditions`. *Rafael Mendonça França* diff --git a/activerecord/lib/active_record/connection_adapters/sqlite3/schema_statements.rb b/activerecord/lib/active_record/connection_adapters/sqlite3/schema_statements.rb index f0d702136d..58e5138e02 100644 --- a/activerecord/lib/active_record/connection_adapters/sqlite3/schema_statements.rb +++ b/activerecord/lib/active_record/connection_adapters/sqlite3/schema_statements.rb @@ -23,12 +23,22 @@ module ActiveRecord col["name"] end + # Add info on sort order for columns (only desc order is explicitly specified, asc is + # the default) + orders = {} + if index_sql # index_sql can be null in case of primary key indexes + index_sql.scan(/"(\w+)" DESC/).flatten.each { |order_column| + orders[order_column] = :desc + } + end + IndexDefinition.new( table_name, row["name"], row["unique"] != 0, columns, - where: where + where: where, + orders: orders ) end end diff --git a/activerecord/test/cases/schema_dumper_test.rb b/activerecord/test/cases/schema_dumper_test.rb index 60e3bc17f2..a03fd39abc 100644 --- a/activerecord/test/cases/schema_dumper_test.rb +++ b/activerecord/test/cases/schema_dumper_test.rb @@ -186,7 +186,7 @@ class SchemaDumperTest < ActiveRecord::TestCase assert_equal 't.index ["firm_id", "type", "rating"], name: "company_index", length: { type: 10 }', index_definition end else - assert_equal 't.index ["firm_id", "type", "rating"], name: "company_index"', index_definition + assert_equal 't.index ["firm_id", "type", "rating"], name: "company_index", order: { rating: :desc }', index_definition end end |