SEO-информация для категорий [tulp.ru]

categories_info.rb

parents = Category.where(parent_id: nil);

DUMP = -> (category) {
  [
    category.id,
    category.name,
    TulpSeo::Data.lookup(
      "seo.info.categories.#{category.translit}.default",
      { city_parent: 'Санкт-Петербурга' }
    )
  ]
};

CSV.open(Pathname.new('~/categories.csv').expand_path,'w') do |csv|
  parents.each do |parent|
    csv << DUMP[parent]
    parent.children.each do |child|
      csv << DUMP[child]
    end
  end
end