set :application, "rss_remixer"
set :repository,  "http://svn.forgreatjustice.net/code/rss_remixer_lite"

set :user, "root"
set :svn_user, "devp"

set :deploy_to, "/var/www/#{application}"

role :app, "weloveyarps.com"
role :db, "weloveyarps.com"

deploy.task :restart do
  run "cd #{current_path}; ruby daemonized_rssremixer.rb restart production"
end

deploy.task :start do
  run "cd #{current_path}; ruby daemonized_rssremixer.rb start production"
end

deploy.task :stop do
  run "cd #{current_path}; ruby daemonized_rssremixer.rb stop production"
end

desc "View currently running processes"
deploy.task :status do
  run "ps auxw | grep rssremixer.rb"
end

desc "no migrations really needed"
deploy.task :migrate do
 #nothing
end

desc "View all currently registered users"
task :users do
  run "sqlite3 /var/db/rssremixer.db 'SELECT id,name FROM users'"
end

task :feeds do
  run "sqlite3 /var/db/rssremixer.db 'SELECT * FROM feeds WHERE user_id>1'"
end