testing - What RSpec tests should I write for this stand a lone Ruby application? -

i have small ruby app 1 model, model uses activerecord & find_by_sql method query little complex, loops on results , produces csv file, file uploaded remote ftp server.

just wondering rspec tests should consider writing non-rails app?

first time writing non-rails tests , have been hit "testers block" :-)

thanks!

here's list of things test for.

1. test application can connect ftp server , upload trivial file.
2. test query various points of data.
3. test csv generation irregular data (a forgotten field , other pebcak errors)
4. test csv file contains all data.
5. test application responds gracefully (or intended) in event of failure.

posting code or query allow offer better advice.