class JekyllImport::Importers::Joomla3

Public Class Methods

process(options) click to toggle source
# File lib/jekyll-import/importers/joomla3.rb, line 32
def self.process(options)
  dbname = options.fetch("dbname")
  user   = options.fetch("user")
  pass   = options.fetch("password", "")
  host   = options.fetch("host", "127.0.0.1")
  port   = options.fetch("port", 3306).to_i
  cid    = options.fetch("category", 0)
  table_prefix = options.fetch("prefix", "jos_")

  db = Sequel.mysql2(dbname, :user => user, :password => pass, :host => host, :port => port, :encoding => "utf8")

  FileUtils.mkdir_p("_posts")

  # Reads a MySQL database via Sequel and creates a post file for each
  # post in #__content that is published.
  query = "SELECT `cn`.`title`, `cn`.`alias`, `cn`.`introtext`, CONCAT(`cn`.`introtext`,`cn`.`fulltext`) AS `content`, "
  query << "`cn`.`created`, `cn`.`id`, `ct`.`title` AS `category`, `u`.`name` AS `author` "
  query << "FROM `#{table_prefix}content` AS `cn` JOIN `#{table_prefix}categories` AS `ct` ON `cn`.`catid` = `ct`.`id` "
  query << "JOIN `#{table_prefix}users` AS `u` ON `cn`.`created_by` = `u`.`id` "
  query << "WHERE (`cn`.`state` = '1' OR `cn`.`state` = '2') " # Only published and archived content items to be imported

  query << if cid.positive?
             " AND `cn`.`catid` = '#{cid}' "
           else
             " AND `cn`.`catid` != '2' " # Filter out uncategorized content
           end

  db[query].each do |post|
    # Get required fields and construct Jekyll compatible name.
    title = post[:title]
    slug = post[:alias]
    date = post[:created]
    author = post[:author]
    category = post[:category]
    content = post[:content]
    excerpt = post[:introtext]
    name = format("%02d-%02d-%02d-%s.markdown", date.year, date.month, date.day, slug)

    # Get the relevant fields as a hash, delete empty fields and convert
    # to YAML for the header.
    data = {
      "layout"     => "post",
      "title"      => title.to_s,
      "joomla_id"  => post[:id],
      "joomla_url" => slug,
      "date"       => date,
      "author"     => author,
      "excerpt"    => excerpt.strip.to_s,
      "category"   => category,
    }.delete_if { |_k, v| v.nil? || v == "" }.to_yaml

    # Write out the data and content to file
    File.open("_posts/#{name}", "w") do |f|
      f.puts data
      f.puts "---"
      f.puts content
    end
  end
end
require_deps() click to toggle source
# File lib/jekyll-import/importers/joomla3.rb, line 22
def self.require_deps
  JekyllImport.require_with_fallback(%w(
    rubygems
    sequel
    mysql2
    fileutils
    safe_yaml
  ))
end
specify_options(c) click to toggle source
# File lib/jekyll-import/importers/joomla3.rb, line 12
def self.specify_options(c)
  c.option "dbname",   "--dbname",   "Database name."
  c.option "user",     "--user",     "Database user name."
  c.option "password", "--password", "Database user's password. (default: '')"
  c.option "host",     "--host",     "Database host name. (default: 'localhost')"
  c.option "port",     "--port",     "Database port. (default: '3306')"
  c.option "category", "--category", "ID of the category. (default: '0')"
  c.option "prefix",   "--prefix",   "Table prefix name. (default: 'jos_')"
end
validate(options) click to toggle source
# File lib/jekyll-import/importers/joomla3.rb, line 6
def self.validate(options)
  %w(dbname user prefix).each do |option|
    abort "Missing mandatory option --#{option}." if options[option].nil?
  end
end