Contents

# -*- encoding : utf-8 -*-

class Card::Reference < ActiveRecord::Base
  def referencer
    Card[referer_id]
  end

  def referencee
    Card[referee_id]
  end

  class << self

    def delete_all_from card
      delete_all :referer_id => card.id
    end

    def delete_all_to card
      where( :referee_id => card.id ).update_all :present=>0, :referee_id => nil
    end

    def update_existing_key card, name=nil
      key = (name || card.name).to_name.key
      where( :referee_key => key ).update_all :present => 1, :referee_id => card.id
    end

    def update_on_rename card, newname, update_referers=false
      if update_referers
        # not currentlt needed because references are deleted and re-created in the process of adding new revision
        #where( :referee_id=>card.id ).update_all :referee_key => newname.to_name.key
      else
        delete_all_to card
      end
      #Rails.logger.warn "update on rename #{card.inspect}, #{newname}, #{update_referers}"
      update_existing_key card, newname
    end

    def update_on_delete card
      delete_all_from card
      delete_all_to card
    end

    def repair_missing_referees
      joins('LEFT JOIN cards ON card_references.referee_id = cards.id').where('(cards.id IS NULL OR cards.trash IS TRUE) AND referee_id IS NOT NULL').update_all :referee_id=>nil
    end

    def delete_missing_referers
      joins('LEFT JOIN cards ON card_references.referer_id = cards.id').where('cards.id IS NULL OR cards.trash IS TRUE').delete_all
    end

    def repair_all
      delete_missing_referers

      Card.where(:trash=>false).find_each do |card|
        Rails.logger.info "\nRepairing references for '#{card.name}' (id: #{card.id}) ... "
        card.update_references
      end
    end

  end

end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
card-1.16.6	lib/card/reference.rb
card-1.16.5	lib/card/reference.rb
card-1.16.4	lib/card/reference.rb
card-1.16.3	lib/card/reference.rb
card-1.16.2	lib/card/reference.rb
card-1.16.1	lib/card/reference.rb
card-1.16.0	lib/card/reference.rb