to_do_genie.csv

to_do_genie.rb

#get input from user: task_name, task_desc, task_due, task_status
#write to .csv with headers: Name, Description, Due, Status
#email list of to do tasks two sections.. Due Today and Past due
#EXTENSION
#allow the user to update status
#strip completed from file
#need more explanation on protecting gmail account information name/password
#read the file and send an email to user
 
# NOTE FROM BRANDON:
# My recommendation is to do `gem install dotenv` and keep variables in 
# a `.env` file that looks like this (without the comment hash marks:

# GMAIL_USERNAME=your email here
# GMAIL_PASSWORD=your password here

# If you set ENV another way you can comment out the require 'dotenv' line below.
require 'dotenv'
require 'csv'
require 'gmail'

Dotenv.load
 
@gmail_username = ENV['GMAIL_USERNAME']
@gmail_password = ENV['GMAIL_PASSWORD']

# Opens .csv file and writes headings
def create_file
  if File.exist?('to_do_genie.csv') == false
    CSV.open('to_do_genie.csv', 'ab') do |csv|
      csv << ["Name", "Description", "Due"]
    end
  end
end

def enter_tasks
  puts "Enter a task name."
  task_name = gets.chomp 
    puts "Enter a description of task."
  task_desc = gets.chomp
    puts "Enter a due date in the format dd/mm/yy"
  task_due = gets.chomp
  until task_due.length == 8 && task_due.include?('/')
    puts "Please enter date in dd/mm/yy format"
    task_due = gets.chomp
  end
  puts "task is saved"
  CSV.open('to_do_genie.csv','ab') do |csv|
    csv << [task_name, task_desc, task_due]
    puts "Do you want to add another task? (y or n)"
    answer = gets.chomp
    if answer == 'y'
      get_task
    else
      puts "Goodbye"
    end
  end
end

def create_html_body
  html_email = '<table border="1" bordercolor="#FFCC00" style="background-color:#FFFFCC" width="100%" cellpadding="3" cellspacing="3">
        <tr style="text-align:center">
          <th>Task</th>
          <th>Description</th>
          <th>Due Date</th> 
        </tr>'
  closing_tag = '</table>'

  CSV.read('to_do_genie.csv').each do |row|
    html_email << "<tr>\n"
    row.each do |column|
      html_email << "<td>#{column}</td>\n"
    end
    html_email << "</tr>\n"
    # html_email << "<tr><td>#{row[0]}</td><td>#{row[1]}</td><td>#{row[2]}</td></tr>\n"
  end

  html_email + closing_tag
end
 
# # send function...
def send_email
  html_body = create_html_body
  
  gmail = Gmail.new(@gmail_username, @gmail_password)
  gmail.deliver do
    to "jswatson0@gmail.com"
    from "jswatson0@gmail.com"
    subject "ToDo Test"

    html_part do
      body html_body
    end 
  end
end

# This is the star of your show. It's going to create the file, let you edit, and then send it to you.
def update_and_send_task_list
  create_file
  enter_tasks
  create_html_body
  send_email
end

update_and_send_task_list


# This test simply validates that create_file does its job.
# There's a lot more to break up and test here, and it should be moved to another file.

# class TestToDoGenie < MiniTest::Unit::TestCase
#   def setup
#     File.delete("to_do_genie.csv") if File.exist?('to_do_genie.csv')
#   end

#   def test_create_file_creates_a_file
#     assert !File.exist?('to_do_genie.csv')
#     create_file

#     assert File.exist?('to_do_genie.csv')
#   end

#   def test_create_file_contains_headers
#     create_file

#     assert_equal "Name,Description,Due\n", File.read("to_do_genie.csv")
#   end
# end

For one thing, on line 22, you need to indent the if statement and add another end. Looking through the rest now.

Also, for clarity, lines 98-101 need to be outdented. That doesn't explain why the code isn't doing what you want, though.

Also, the way you're using the Gmail library is in conflict with the documentation you've pasted below. First, you need an actual username and password, not the strings "username" and "password" in the Gmail.new constructor.

Second, you don't do gmail.deliver inside the Gmail.new block, it's done afterwards. I'm working on a fork of this gist that I'll post up in a moment.

One other thing is that when you're dealing with two-dimensional arrays, you need to iterate over both of them. Here's an example that will show up in the gist I'm working on:

CSV.read('to_do_genie.csv').each do |row|
  html_email << "<tr>\n"
  row.each do |column|
    html_email << "<td>#{column}</td>\n"
  end
  html_email << "</tr>\n"
end

You ROCK Brandon! Thanks for your help!