Confluence Content Recovery from Database

confluence_recover_from_database.rb

require 'csv'
require 'pathname'

txt = File.open('backup-bible-content.txt').read #dump of `bodycontent` table in txt format
blobs = txt.split("\t")
cols = []
blobs[4..-1].each_slice(3) {|arr| cols << arr} #0 -> content, 1-> contentid

CSV.open('bible-pages.csv').each do |row| #dump of `pages` table in csv format
  content_id, _ , title = row
  content = cols.find {|a| a[1] == content_id }&.[](0)
  path = Pathname("pages/#{title}.html")
  path.dirname.mkpath
  path.write(content) if content
end