Class: JekyllImport::Importers::Drupal7
- Inherits:
-
JekyllImport::Importer
- Object
- JekyllImport::Importer
- JekyllImport::Importers::Drupal7
- Defined in:
- lib/jekyll-import/importers/drupal7.rb
Constant Summary collapse
- QUERY =
Reads a MySQL database via Sequel and creates a post file for each story and blog node.
"SELECT n.nid, \ n.title, \ fdb.body_value, \ n.created, \ n.status \ FROM node AS n, \ field_data_body AS fdb \ WHERE (n.type = 'blog' OR n.type = 'story' OR n.type = 'article') \ AND n.nid = fdb.entity_id \ AND n.vid = fdb.revision_id"
Class Method Summary collapse
- .process(options) ⇒ Object
- .require_deps ⇒ Object
- .specify_options(c) ⇒ Object
- .validate(options) ⇒ Object
Methods inherited from JekyllImport::Importer
inherited, run, stringify_keys, subclasses
Class Method Details
.process(options) ⇒ Object
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 88 89 90 91 92 93 |
# File 'lib/jekyll-import/importers/drupal7.rb', line 42 def self.process() dbname = .fetch('dbname') user = .fetch('user') pass = .fetch('password', "") host = .fetch('host', "localhost") prefix = .fetch('prefix', "") db = Sequel.mysql(dbname, :user => user, :password => pass, :host => host, :encoding => 'utf8') unless prefix.empty? QUERY[" node "] = " " + prefix + "node " QUERY[" field_data_body "] = " " + prefix + "field_data_body " end FileUtils.mkdir_p "_posts" FileUtils.mkdir_p "_drafts" FileUtils.mkdir_p "_layouts" db[QUERY].each do |post| # Get required fields and construct Jekyll compatible name node_id = post[:nid] title = post[:title] content = post[:body_value] created = post[:created] time = Time.at(created) is_published = post[:status] == 1 dir = is_published ? "_posts" : "_drafts" slug = title.strip.downcase.gsub(/(&|&)/, ' and ').gsub(/[\s\.\/\\]/, '-').gsub(/[^\w-]/, '').gsub(/[-_]{2,}/, '-').gsub(/^[-_]/, '').gsub(/[-_]$/, '') name = time.strftime("%Y-%m-%d-") + slug + '.md' # Get the relevant fields as a hash, delete empty fields and convert # to YAML for the header data = { 'layout' => 'post', 'title' => title.to_s, 'created' => created, }.delete_if { |k,v| v.nil? || v == ''}.to_yaml # Write out the data and content to file File.open("#{dir}/#{name}", "w") do |f| f.puts data f.puts "---" f.puts content end end # TODO: Make dirs & files for nodes of type 'page' # Make refresh pages for these as well # TODO: Make refresh dirs & files according to entries in url_alias table end |
.require_deps ⇒ Object
33 34 35 36 37 38 39 40 |
# File 'lib/jekyll-import/importers/drupal7.rb', line 33 def self.require_deps JekyllImport.require_with_fallback(%w[ rubygems sequel fileutils safe_yaml ]) end |
.specify_options(c) ⇒ Object
25 26 27 28 29 30 31 |
# File 'lib/jekyll-import/importers/drupal7.rb', line 25 def self.(c) 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 (default: "localhost")' c.option 'prefix', '--prefix PREFIX', 'Table prefix name' end |
.validate(options) ⇒ Object
17 18 19 20 21 22 23 |
# File 'lib/jekyll-import/importers/drupal7.rb', line 17 def self.validate() %w[dbname user].each do |option| if [option].nil? abort "Missing mandatory option --#{option}." end end end |