module SchemaPlus::Indexes::Middleware::Schema::Sqlite3::Indexes
Public Instance Methods
after(env)
click to toggle source
# File lib/schema_plus/indexes/middleware/schema.rb, line 9 def after(env) indexes = Hash[env.index_definitions.map{ |d| [d.name, d] }] env.connection.exec_query("SELECT name, sql FROM sqlite_master WHERE type = 'index'").map do |row| if row['sql'] && (desc_columns = row['sql'].scan(/['"`]?(\w+)['"`]? DESC\b/).flatten).any? index = indexes[row['name']] index.orders = Hash[index.columns.map {|column| [column, desc_columns.include?(column) ? :desc : :asc]}] end end end