Skip to content

Instantly share code, notes, and snippets.

View gonzaga's full-sized avatar

Tatiana Potetinova gonzaga

View GitHub Profile
ARModel.where(id: []).each do |b|
puts "INSERT INTO models"
puts "(#{b.attributes.keys.join(',')})"
values = b.attributes.values.map do |v|
if v.nil?
'NULL'
else
if v.is_a?(String)
'"' + v.to_s + '"'
elsif v.is_a?(Time)
Get application name from Tangos
Get reward? Do we need this placeholder?
filter_step_product
filter_step_program_cap
filter_step_landing_page_cap
filter_step_daily_cap
filter_step_https
filter_step_reward_ok
filter_step_traffic_quality
filter_step_geo_target
filter_step_no_completed_by_assoc_users
filter_step_no_completed_self_cpi_by_assoc_users
LEFT OUTER JOIN `taggings` ON `taggings`.`taggable_id` = `landing_pages`.`id` AND taggings.context = 'whitelists' AND `taggings`.`taggable_type` = 'LandingPage' LEFT OUTER JOIN `tags` ON `tags`.`id` = `taggings`.`tag_id` LEFT OUTER JOIN `taggings` `blacklist_taggings_landing_pages_join` ON `blacklist_taggings_landing_pages_join`.`taggable_id` = `landing_pages`.`id` AND taggings.context = 'blacklists' AND `blacklist_taggings_landing_pages_join`.`taggable_type` = 'LandingPage' LEFT OUTER JOIN `tags` `blacklists_landing_pages` ON `blacklists_landing_pages`.`id` = `blacklist_taggings_landing_pages_join`.`tag_id`
LandingPage.for_country(country).for_category(category).
active.
includes(:whitelists, :blacklists).
includes(program_region: :country).
includes(:provisions).
includes(program: {advertiser: :affiliate_network}).
includes(:program_categories).
includes(:categories).
order("landing_pages.ID DESC")
@gonzaga
gonzaga / gist:5290983
Created April 2, 2013 09:16
With joins
SQL (903.1ms) SELECT `landing_pages`.`id` AS t0_r0, `landing_pages`.`program_region_id` AS t0_r1, `landing_pages`.`enabled` AS t0_r2, `landing_pages`.`program_url` AS t0_r3, `landing_pages`.`effort` AS t0_r4, `landing_pages`.`no_of_text_fields` AS t0_r5, `landing_pages`.`end_date` AS t0_r6, `landing_pages`.`double_opt_in` AS t0_r7, `landing_pages`.`revokement_quote` AS t0_r8, `landing_pages`.`ephc_90` AS t0_r9, `landing_pages`.`conversion` AS t0_r10, `landing_pages`.`title` AS t0_r11, `landing_pages`.`teaser` AS t0_r12, `landing_pages`.`required_actions` AS t0_r13, `landing_pages`.`created_at` AS t0_r14, `landing_pages`.`updated_at` AS t0_r15, `landing_pages`.`required_actions_long` AS t0_r16, `landing_pages`.`premium_brand` AS t0_r17, `landing_pages`.`priority` AS t0_r18, `landing_pages`.`epc` AS t0_r19, `landing_pages`.`method_of_payment` AS t0_r20, `landing_pages`.`required_actions_en` AS t0_r21, `landing_pages`.`deleted_at` AS t0_r22, `landing_pages`.`fraud_score` AS t0_r23, `landing_pages`.`fraud_limit_
class A
def foo(a)
bar(a)
end
end
class B < A
def bar(b)
blah blah
end