lib/jekyll/migrators/mephisto.rb in jekyll-0.10.0 vs lib/jekyll/migrators/mephisto.rb in jekyll-0.11.0

- old
+ new

@@ -34,32 +34,37 @@ end # This query will pull blog posts from all entries across all blogs. If # you've got unpublished, deleted or otherwise hidden posts please sift # through the created posts to make sure nothing is accidently published. + QUERY = "SELECT id, \ + permalink, \ + body, \ + published_at, \ + title \ + FROM contents \ + WHERE user_id = 1 AND \ + type = 'Article' AND \ + published_at IS NOT NULL \ + ORDER BY published_at" - QUERY = "SELECT id, permalink, body, published_at, title FROM contents WHERE user_id = 1 AND type = 'Article' AND published_at IS NOT NULL ORDER BY published_at" - def self.process(dbname, user, pass, host = 'localhost') - db = Sequel.mysql(dbname, :user => user, :password => pass, :host => host, :encoding => 'utf8') + db = Sequel.mysql(dbname, :user => user, + :password => pass, + :host => host, + :encoding => 'utf8') FileUtils.mkdir_p "_posts" db[QUERY].each do |post| title = post[:title] slug = post[:permalink] date = post[:published_at] content = post[:body] -# more_content = '' - # Be sure to include the body and extended body. -# if more_content != nil -# content = content + " \n" + more_content -# end - - # Ideally, this script would determine the post format (markdown, html - # , etc) and create files with proper extensions. At this point it - # just assumes that markdown will be acceptable. + # Ideally, this script would determine the post format (markdown, + # html, etc) and create files with proper extensions. At this point + # it just assumes that markdown will be acceptable. name = [date.year, date.month, date.day, slug].join('-') + ".markdown" data = { 'layout' => 'post', 'title' => title.to_s,