require 'nokogiri'
require 'open-uri'
require 'sequel'
require 'sqlite3'
require 'pry'
require 'uri'
require 'cgi'



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

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

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


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


  puts "This is an array of the genres:"
  puts genres
  puts
  puts "These are the genre links:"
  puts genreslink
  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:///D:/Users/RyanOConnor/workspace/testing/clublandlv.sqlite')
# Create a dataset
        main_genre = DB[:genres]
# Insert the results



#  genres.each do |genre|
#   main_genre.insert(:genre => genre)
#    unless db_has_genre?
#    genre;


        genreslink.each do |g_link|
        link_id = g_link.children.first["href"]
        link_cut = CGI.parse(URI.parse(link_id).query)['f']
        #   main_genre.insert(:forum_id => link_cut)
        g_link;
    binding.pry





     #   main_genre.insert(:forum_id => genrelink)
      #  unless db_has_genre?
     #   genrelink;

      end
    end
#  end