require "google_drive"

session = GoogleDrive::Session.from_config("config.json")
key = "1-QkYYrbFtj_MIz9wsfsoKW6UzVJslrjAhXt18VMcF_8"
ary = []

File.open("migrations/01_initial.rb", 'w') do |f|
  f.puts <<-HEREDOC
Sequel.migration do
  change do
  HEREDOC
end

session.spreadsheet_by_key(key).worksheets.each do |w|
  title = w.title

  File.open("migrations/01_initial.rb", 'a') do |f|
    f.puts "    create_table(:'#{title}') do"
    f.puts "      primary_key :id"
    f.puts "      foreign_key :tracker_id"
    w.rows.each do |r|
      f.puts "      ##{r[5]}"
      f.puts "      #{r[3] == 'Integer' ? 'Integer' : 'String'} :'#{r[2]}', :null => #{r[4] == 'Nein' ? 'false' : 'true'}#{r[8] == "" || r[8].nil? ? "" : ", :default => '#{r[8]}'"}"
    end
    f.puts "    end"
  end
end

File.open("migrations/01_initial.rb", 'a') do |f|
  f.puts <<-HEREDOC
  end
end
  HEREDOC
end