Class: JekyllImport::Importers::Typo

Inherits:
JekyllImport::Importer show all
Defined in:
lib/jekyll-import/importers/typo.rb

Constant Summary collapse

SQL =

This SQL should work for both MySQL and PostgreSQL.

<<~SQL
  SELECT c.id id,
         c.title title,
         c.permalink slug,
         c.body body,
         c.extended extended,
         c.published_at date,
         c.state state,
         c.keywords keywords,
         COALESCE(tf.name, 'html') filter
    FROM contents c
         LEFT OUTER JOIN text_filters tf
                      ON c.text_filter_id = tf.id
SQL

Class Method Summary collapse

Methods inherited from JekyllImport::Importer

inherited, run, stringify_keys, subclasses

Class Method Details

.process(options) ⇒ Object



41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
# File 'lib/jekyll-import/importers/typo.rb', line 41

def self.process(options)
  server = options.fetch("server")
  dbname = options.fetch("dbname")
  user   = options.fetch("user")
  pass   = options.fetch("password", "")
  host   = options.fetch("host", "localhost")

  FileUtils.mkdir_p "_posts"
  case server.intern
  when :postgres
    db = Sequel.postgres(dbname, :user => user, :password => pass, :host => host, :encoding => "utf8")
  when :mysql
    db = Sequel.mysql2(dbname, :user => user, :password => pass, :host => host, :encoding => "utf8")
  else
    raise "Unknown database server '#{server}'"
  end
  db[SQL].each do |post|
    next unless post[:state] =~ %r!published!i

    post[:slug] = "no slug" if post[:slug].nil?

    if post[:extended]
      post[:body] << "\n<!-- more -->\n"
      post[:body] << post[:extended]
    end

    name = [
      format("%.04d", post[:date].year),
      format("%.02d", post[:date].month),
      format("%.02d", post[:date].day),
      post[:slug].strip,
    ].join("-")

    # 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",
               "title"   => (post[:title]&.to_s&.force_encoding("UTF-8")),
               "tags"    => (post[:keywords]&.to_s&.force_encoding("UTF-8")),
               "typo_id" => post[:id], }.delete_if { |_k, v| v.nil? || v == "" }.to_yaml)
      f.puts "---"
      f.puts post[:body].delete("\r")
    end
  end
end

.require_depsObject



22
23
24
25
26
27
28
29
30
31
# File 'lib/jekyll-import/importers/typo.rb', line 22

def self.require_deps
  JekyllImport.require_with_fallback(%w(
    rubygems
    sequel
    mysql2
    pg
    fileutils
    safe_yaml
  ))
end

.specify_options(c) ⇒ Object



33
34
35
36
37
38
39
# File 'lib/jekyll-import/importers/typo.rb', line 33

def self.specify_options(c)
  c.option "server",   "--server TYPE", 'Server type ("mysql" or "postgres")'
  c.option "dbname",   "--dbname DB",   "Database name"
  c.option "user",     "--user USER",   "Database user name"
  c.option "password", "--password PW", "Database user's password (default: '')"
  c.option "host",     "--host HOST",   "Database host name"
end