Just working with postgres, but can be easily adapted to work with both mysql and postgres.
# File lib/jekyll/migrators/enki.rb, line 22 def self.process(dbname, user, pass, host = 'localhost') FileUtils.mkdir_p('_posts') db = Sequel.postgres(:database => dbname, :user => user, :password => pass, :host => host, :encoding => 'utf8') db[SQL].each do |post| name = [ sprintf("%.04d", post[:date].year), sprintf("%.02d", post[:date].month), sprintf("%.02d", post[:date].day), post[:slug].strip ].join('-') name += '.textile' File.open("_posts/#{name}", 'w') do |f| f.puts({ 'layout' => 'post', 'title' => post[:title].to_s, 'enki_id' => post[:id], 'categories' => post[:tags] }.delete_if { |k, v| v.nil? || v == '' }.to_yaml) f.puts '---' f.puts post[:body].delete("\r") end end end
Generated with the Darkfish Rdoc Generator 2.