mizzy/typo_to_jekyll.rb

## typo_to_jekyll.rb
require "rubygems"
require "active_record"

ActiveRecord::Base.establish_connection(
    :adapter  => "mysql2",
    :host     => "192.168.10.12",
    :user     => "root",
    :password => "root",
    :database => "typo",
    :encoding => "utf8"
)

class Content < ActiveRecord::Base
  Content.inheritance_column = 'foo'
end

contents = Content.all

contents.each do |content|
  dt = content.published_at
  date = sprintf("%04s-%02d-%02d", dt.year, dt.month, dt.day)
  datetime = date + sprintf(" %02d:%02d", dt.hour, dt.min)
  file = date + "-" + content.id.to_s + ".markdown"

  body = <<BODY
---
layout: post
title: "#{content.title}"
date: #{datetime}
comments: true
categories:
---
#{content.body}
BODY

  File.open(file, 'w') do |file|
    file.write(body)
  end
end
	require "rubygems"
	require "active_record"

	ActiveRecord::Base.establish_connection(
	:adapter => "mysql2",
	:host => "192.168.10.12",
	:user => "root",
	:password => "root",
	:database => "typo",
	:encoding => "utf8"
	)

	class Content < ActiveRecord::Base
	Content.inheritance_column = 'foo'
	end

	contents = Content.all

	contents.each do \|content\|
	dt = content.published_at
	date = sprintf("%04s-%02d-%02d", dt.year, dt.month, dt.day)
	datetime = date + sprintf(" %02d:%02d", dt.hour, dt.min)
	file = date + "-" + content.id.to_s + ".markdown"

	body = <<BODY
	---
	layout: post
	title: "#{content.title}"
	date: #{datetime}
	comments: true
	categories:
	---
	#{content.body}
	BODY

	File.open(file, 'w') do \|file\|
	file.write(body)
	end
	end