require 'rubygems'
require 'nokogiri'
require 'open-uri'
require 'sequel'
require 'sqlite3'


clubland = "http://www.clublandlv.com/forum.php"

doc = Nokogiri::HTML(open(clubland))

puts doc.css('title').text
puts


doc.css("#cat10").each do |grab|
  genre = grab.at_css(".forumtitle").text
  # map(&:text)
  genrelink = grab.css(".forumtitle a"){[:href]}
  subgenre = grab.css(".subforum a").map(&:text)
  subgenrelink = grab.css(".subforum a"){[:href]}

  puts "This is an array of the genres:"
  puts "#{genre}"
  puts
  puts "These are the genre links:"
  puts "#{genrelink}"
  puts
  puts "This is an array of the subgenres:"
  puts "#{subgenre}"
  puts
  puts "These are the subgenre links:"
  puts "#{subgenrelink}"


# Table has 3 columns. ID(auto), genre, forum_id

#Connects to the local DB
    DB = Sequel.connect('sqlite://clublandlv.sqlite')
# Create a dataset
    main_genre = DB[:genres]
# Insert the results
    main_genre.insert(:genre => "#{genre}", :forum_id => "#{genrelink}")

end