require 'rubygems'
require_gem 'activerecord'

ActiveRecord::Base.establish_connection(
:adapter  => "mysql",
:database => "awong",
:socket   => "/var/run/mysqld/mysqld.sock",
:username => 'awong',
:password => 'passwordherelawl'
)
class Wiki_categories < ActiveRecord::Base
    set_table_name 'wiki_categories'
    set_primary_key 'id'
end

class Wiki_articles < ActiveRecord::Base
    set_table_name 'wiki_articles'
    set_primary_key 'id'
end

past_c_ids = []
info = File.new("kate_cat", "r")
c = Wiki_categories.new
a = Wiki_articles.new
while (line =  info.readline)
	infos = line.split("|")
	if (!past_c_ids.include?(infos[0]))
		past_c_ids.push(infos[0])
		c.category_id = infos[0]
		c.category_title = infos[1]
		c.save
	end
	id = infos[2]
	title = infos[3].gsub(/\"/, '')
	#puts "Id: " + id+ " Title: " + title
	a.article_id = id.to_i
	a.article_title = title
	a.save
end