lib/jekyll/converters/typo.rb in mojombo-jekyll-0.4.1 vs lib/jekyll/converters/typo.rb in mojombo-jekyll-0.5.0
- old
+ new
@@ -1,25 +1,25 @@
# Author: Toby DiPasquale <toby@cbcg.net>
require 'fileutils'
require 'rubygems'
require 'sequel'
-
+
module Jekyll
module Typo
- # this SQL *should* work for both MySQL and PostgreSQL, but I haven't
+ # this SQL *should* work for both MySQL and PostgreSQL, but I haven't
# tested PostgreSQL yet (as of 2008-12-16)
SQL = <<-EOS
SELECT c.id id,
- c.title title,
- c.permalink slug,
+ c.title title,
+ c.permalink slug,
c.body body,
- c.published_at date,
+ c.published_at date,
c.state state,
COALESCE(tf.name, 'html') filter
- FROM contents c
+ FROM contents c
LEFT OUTER JOIN text_filters tf
- ON c.text_filter_id = tf.id
+ ON c.text_filter_id = tf.id
EOS
def self.process dbname, user, pass, host='localhost'
FileUtils.mkdir_p '_posts'
db = Sequel.mysql dbname, :user => user, :password => pass, :host => host
@@ -28,10 +28,10 @@
name = [ sprintf("%.04d", post[:date].year),
sprintf("%.02d", post[:date].month),
sprintf("%.02d", post[:date].day),
post[:slug].strip ].join('-')
- # Can have more than one text filter in this field, but we just want
+ # Can have more than one text filter in this field, but we just want
# the first one for this
name += '.' + post[:filter].split(' ')[0]
File.open("_posts/#{name}", 'w') do |f|
f.puts({ 'layout' => 'post',