Skip to content

Instantly share code, notes, and snippets.

@clemens

clemens/indexes.rb

Created February 18, 2015 09:46
Show Gist options
  • Save clemens/1a584d512232f2a064e7 to your computer and use it in GitHub Desktop.
Save clemens/1a584d512232f2a064e7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
indexes.rb
pp ActiveRecord::Base.connection.select_all("SHOW INDEXES FROM spree_paypal_website_payments_standard_notifications")
=> [
{"Table"=>"spree_paypal_website_payments_standard_notifications",
"Non_unique"=>0,
"Key_name"=>"unique_idx_paypal_standard_notifications_transaction_id",
"Seq_in_index"=>1,
"Column_name"=>"transaction_id",
"Collation"=>"A",
"Cardinality"=>473,
"Sub_part"=>nil,
"Packed"=>nil,
"Null"=>"YES",
"Index_type"=>"BTREE",
"Comment"=>"",
"Index_comment"=>""}
]
Raw
payments.rb
Spree::Order.find_by_number('A15-00043').payments.map { |p| p.source.transaction_id }
=> ["2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T", "2VD45557J6213751T"]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment