julesce

Plan for an explosion in personal wealth
By Magnus Heystek22 April 2021 12:35
The past ten years have not been a very good decade for most South African investors. Your pension and equity portfolio have not risen much over this period.

In fact, it was one of the lowest average ten-year returns in many decades. If inflation and transaction costs are taken into account, then most people today have much less in real terms than they think.

When the returns of the JSE over ten years are measured against the major world regions, the average returns were among the weakest in the world.

And as last week's article pointed out, yields in US dollar terms were round zero.

julesce

# Summary
# -------
# If you care about performance, use `&&` or an `if` statement instead of the object.foo.try(:name) pattern. 
#
# Like so...
#   object.foo.name if object.foo
# OR
#   object.foo && object.foo.name

class Object

julesce

Promotion.find_each(:batch_size => 10) do |p|
  if p.refreshing_stats?
    date_refresh_started_at = p.retrieve_stats_cache_info(:refreshing => false)
    if date_refresh_started_at
      threshold_time = 6.hours.ago
      if date_refresh_started_at < threshold_time
        p.done_refreshing_stats
        puts "Forced the completion of stats refresh for promotion #{p.id}"
      end

julesce

EventMachine.run {
  EventMachine::PeriodicTimer.new(60){
    result = ActiveRecord::Base.connection.select_rows("show global status like 'threads_running'") # => [['threads_running', 1]]
    threads_running = result.try(:first).try(:at, 1)

    message = "#{threads_running} threads running at #{Time.now}"
    puts message

    file = File.open("#{Rails.root}/log/mysql_thread_count.log", 'a')
    file.puts message

julesce

#   This migration will loop through all RssPromotions and ensure that the default values from the 'unsent'
#   mailing are correctly migrated to the new defaults created for RssPromotions, specifically:
#     - new fields on the rss_promotion
#     - rss_promotion has_and_belongs_to_many :audience_lists
#     - rss_promotion has_and_belongs_to_many :audience_members

migrated_count = 0

RssPromotion.find_each do |rss_promotion|
  mailing = rss_promotion.mailing

julesce

  def async_save
    json_v2_response_only do
      json = JSON.parse(params[:promotion])
      @promotion = current_user.promotions_find(json["id"])
      validator = PromotionModuleValidator.new(@promotion, json)

      if validator.valid?
        @promotion.update_from_json(json, true)

        # Update the mailing for the RSS Promotion when changing the promotion's name

julesce

>> mc = MembershipCampaign.find 54834774412
=> #<MembershipCampaign id: 54834774412, drip_campaign_id: 2686, membership_id: 3530060049, completed: true, created_at: "2012-11-05 11:48:23", updated_at: "2013-04-16 03:34:28">
>> am = mc.audience_member
=> #<AudienceMember id: 3470006376, user_id: 88088, first_name: "Miri", last_name: nil, email: "miriwageningen540@msn.com", created_at: "2012-11-05 11:48:23", updated_at: "2012-11-05 11:48:23", city: nil, created_by: "member", confirmed_at: nil, phone: nil, company: nil, title: nil, address: nil, state: nil, zip: nil, country: nil, aux_data: nil, ip: "85.130.200.159", suppressed: false, activation_code: nil, signup_id: 45146, confirmed: 1, rev_email: "", suppression_reason: nil, bounce_code: nil, soft: 0, deleted: 0, audience_import_id: nil>
>> RPromotionAttempt.find_all_keys_by_index(:audience_member_id, am.id)
=> ["267473035302864268", "370746214726985283"]
>> RPromotionAttempt.find_all_keys_by_index(:audience_member_id, am.id)
=> ["267473035302864268", "3707462

julesce

#
# There are a couple of drips that have not had their RLinkIndex created, since they are returning false for archived_mailing_links?
# This script attempts to fix this, by ensuring that the index is created, and archived_mailing_links? returns true
#
require 'logger'

Object.const_set(:RIAK_DISABLE_SECONDARY_INDEXES, false)
logger = Logger.new('log/fix_drip_clicks.log')

logger.info "====================== S T A R T  ========================"

julesce

mailings_to_refresh = []
click_thrus_to_delete = []
promotions_to_refresh = []

ClickThru.find_each(:select => 'click_thrus.id, mailing_links.mailing_id',
                          :joins => "INNER JOIN mailing_links ON click_thrus.mailing_link_id = mailing_links.id",
                          :conditions => {:promotion_attempt_id => 9223372036854775807}) do |click_thru|

  click_thrus_to_delete << click_thru.id
  mailings_to_refresh << click_thru.mailing_id unless mailings_to_refresh.include?(click_thru.mailing_id)

julesce

    def self.new_count(mailing, stat_type)
      case stat_type
      when :total
        Total.new(mailing, stat_type).count
      when :ga
        GoogleAnalyticsMailingStat.total_value(mailing)
      when :total_viewed
        PromotionAttemptEvent.count_by_state(mailing.id, stat_type) + archive_count(mailing, :viewed)
      when :tweeted, :facebooked, :plusoned, :pinned, :forwarded, :shared,
           :forward_total_viewed, :subscribed