Untitled

  class LinkGraph

    attr_accessor :crawler_id, :crawl_date    

   

    LOCAL_DB = {:adapter => "postgresql", :host => "localhost", :database => "development234", :username => "hello", :password => "howdy" }    

   

   

    def table_name

      "#{crawler_id}__#{crawl_date.gsub("/","_")}__linkgraph"

    end

   

    def initialize_activerecord

      ActiveRecord::Base.establish_connection(LOCAL_DB)

    end

   

    def create_table

      if @crawler_id.blank? || @crawl_date.blank?

        puts "Need Crawler ID and Crawl Date to use temporary tables. "

        return false

      end

      ActiveRecord::Base.connection.execute(

        "CREATE TABLE #{table_name}

        (page_url text,

        page_id integer,

        destination_url text,

        destination_code integer,

        destination char(50));"

      )

    end

   

    class LinkGraphchild < ActiveRecord::Base

      set_table_name table_name

    end