[Blogsum2WP.rb] Seemingly working database connections

git-svn-id: svn+ssh://scm.narf.ssji.net/svn/shtrom/scripts@1803 1991c358-8f32-0410-a49a-990740bdf4c2

1 files changed, 70 insertions, 0 deletions

diff --git a/Blogsum2WP.rb b/Blogsum2WP.rb
new file mode 100755
index 0000000..1971518
--- /dev/null
+++ b/Blogsum2WP.rb
@@ -0,0 +1,70 @@
+#!/usr/bin/env ruby19
+
+require 'rubygems'
+require 'yaml'
+require 'active_record'
+require 'sqlite3'
+require 'mysql'
+
+
+# Models generated by RMRE [0]
+# [0] https://github.com/bosko/rmre
+settings_file = './database.yml'
+# The yaml file should look like that
+# 
+#  blogsum:
+#    adapter: sqlite3
+#     database: ~/site.db
+#  
+#  wordpress:
+#    adapter: mysql
+#    encoding: utf8
+#    username: wordpress
+#    password:
+#    database: blog
+#    
+exit unless File.exists?(settings_file)
+$settings = YAML.load_file(settings_file)
+
+# Multiple database support from [1,2]
+# [1] http://jonathanng.com/ruby-on-rails/multiple-database-connections-with-rails/
+# [2] http://ilikestuffblog.com/2012/09/21/establishing-a-connection-to-a-non-default-database-in-rails-3-2-2
+class BlogsumTable < ActiveRecord::Base
+  establish_connection $settings["blogsum"]
+end
+class WordpressTable < ActiveRecord::Base
+  establish_connection $settings["wordpress"]
+end
+
+# Blogsum
+class Article < BlogsumTable
+  has_many :comments
+end
+class Comment < BlogsumTable
+end
+
+# Wordpress
+class WpComment < WordpressTable
+  self.primary_key = :comment_ID
+
+end
+class WpCommentmetum < WordpressTable
+  self.primary_key = :meta_id
+end
+class WpPost < WordpressTable
+  self.primary_key = :ID
+end
+class WpPostmetum < WordpressTable
+  self.primary_key = :meta_id
+end
+class WpTerm < WordpressTable
+  self.primary_key = :term_id
+end
+class WpTermRelationship < WordpressTable
+end
+class WpTermTaxonomy < WordpressTable
+  self.table_name = 'wp_term_taxonomy'
+  self.primary_key = :term_taxonomy_id
+end
+
+# vim: sw=2