gistfile1.rb

desc "populate dataset table"
    task :load_sources => :environment do
      Dataset.delete_all
      user = User.find_by_username "WCMC"
      Dataset.create :citation => "WDPA v1", :user => user
      sources = DataImport.find_by_sql(["SELECT DISTINCT(source) from data_import"])
      sources.each do |source|   
        if (data_there? source.source)
          Dataset.create :citation => source.source, :user => user
        end
      end
    end