we4tech · December 11, 2015 05:48
diff --git a/export-mongo-collections.rb b/export-mongo-collections.rb
 # Export collection name and their properties list in HTML format. 

 require 'mongo'

 include Mongo

 # Connect with mongodb server
 client = MongoClient.new('localhost', 27017)

 # Load database
 db     = client['YOUR DB NAME']

 # List all excluded collections
 excluded_collections = ['system.indexes']

 # Genearte new html 
 html = %{<html>
  <head><title>Collection properties</title>
 	<style>
 		h4 { background: #f0f0f0; padding: 5px; display: block; border-bottom: 1px solid #ccc; margin-bottom: 2px; }
 		table { border: 1px solid #ccc; width: 100%; }
 		table tr td { border-bottom: 1px solid #ccc; }
 		table tr th { background: #f0f0f0; border-bottom: 1px solid #ccc; }
 		h1 { background: #f0f0f0; padding: 5px; border-bottom: 2px solid #ccc; }
 	</style>
 	</head>
 	<body>
 	<h1>Collections from #{db.name}</h1>
 	}

 html << '<table>'

 # Iterate through all collections and retrieve their all keys 
 # based on first record.
 db.collection_names.each do |n|

 	# Don't add collection if it doesn't contain any record
 	if !db[n].find_one.nil? && !excluded_collections.include?(n)
 		html << "<tr><th colspan='2'><h4>Collection: #{n}</h4></th></tr>"
 		html << '<tr><th>Column</th><th>Type</th>'
 		html << db[n].find_one.map{|k, v| "<tr><td>#{k}</td><td>#{v.class.name}</td></tr>"}.join
 	end
 end

 html << '</table>'
 html << '</body>'

 # Write this html to some location
 File.open('YOUR PATH to OUTPUT', 'wb') {|f| f.puts html }
	# Export collection name and their properties list in HTML format.

	require 'mongo'

	include Mongo

	# Connect with mongodb server
	client = MongoClient.new('localhost', 27017)

	# Load database
	db = client['YOUR DB NAME']

	# List all excluded collections
	excluded_collections = ['system.indexes']

	# Genearte new html
	html = %{<html>
	<head><title>Collection properties</title>
	<style>
	h4 { background: #f0f0f0; padding: 5px; display: block; border-bottom: 1px solid #ccc; margin-bottom: 2px; }
	table { border: 1px solid #ccc; width: 100%; }
	table tr td { border-bottom: 1px solid #ccc; }
	table tr th { background: #f0f0f0; border-bottom: 1px solid #ccc; }
	h1 { background: #f0f0f0; padding: 5px; border-bottom: 2px solid #ccc; }
	</style>
	</head>
	<body>
	<h1>Collections from #{db.name}</h1>
	}

	html << '<table>'

	# Iterate through all collections and retrieve their all keys
	# based on first record.
	db.collection_names.each do \|n\|

	# Don't add collection if it doesn't contain any record
	if !db[n].find_one.nil? && !excluded_collections.include?(n)
	html << "<tr><th colspan='2'><h4>Collection: #{n}</h4></th></tr>"
	html << '<tr><th>Column</th><th>Type</th>'
	html << db[n].find_one.map{\|k, v\| "<tr><td>#{k}</td><td>#{v.class.name}</td></tr>"}.join
	end
	end

	html << '</table>'
	html << '</body>'

	# Write this html to some location
	File.open('YOUR PATH to OUTPUT', 'wb') {\|f\| f.puts html }