bradrobertson

def self.open_for_participant(contact_id, group_id = nil)
    
    find_by_sql(<<-SQL)
      SELECT challenges.* FROM challenges
      LEFT OUTER JOIN challenge_participants ON challenge_participants.challenge_id = challenges.id
        AND challenge_participants.contact_id = #{contact_id}
      WHERE (EXISTS (
      	SELECT 1 FROM group_challenges
      	JOIN group_contacts ON group_challenges.group_id = group_contacts.group_id
      	#{"JOIN groups on group_challenges.group_id = groups.id" if group_id}

bradrobertson

development:
  adapter: jdbc
  driver: com.mysql.jdbc.Driver
  jndi: java:/comp/env/jdbc/VeloUl
  url: jdbc:mysql://localhost:3306/velo_ultralite_development
  username: root
  password:
  timeout: 5000

bradrobertson

development:
  adapter: jdbc
  jndi: java:/comp/env/jdbc/VeloUl
  database: velo_ultralite_development
  username: root
  password:
  timeout: 5000

# When running rake db:migrate, I get the following:

bradrobertson

development:
  adapter: mysql
  database: velo_ultralite_development
  username: root
  password:
  timeout: 5000

bradrobertson

---
  port: 8080                        # port where trinidad is running
  ajp:                              # ajp configuration section
    port: 8009                

  jruby_min_runtimes: 1             # min number of runtimes
  jruby_max_runtimes: 1             # max number of runtimes

  web_apps:
    default:

bradrobertson

---
  port: 8080                        # port where trinidad is running
  ajp:                              # ajp configuration section
    port: 8009                

  jruby_min_runtimes: 1             # min number of runtimes
  jruby_max_runtimes: 1             # max number of runtimes

  extensions:
    logging:

bradrobertson

---
  port: 8080                        # port where trinidad is running
  ajp:                              # ajp configuration section
    port: 8009                

  jruby_min_runtimes: 1             # min number of runtimes
  jruby_max_runtimes: 1             # max number of runtimes

  extensions:
    logging:

bradrobertson

# remote machine
admin@velo.uat:/mnt/apps/velo-ul$ ls -l
total 12
lrwxrwxrwx  1 app admin   41 2010-11-09 09:40 current -> /mnt/apps/velo-ul/releases/20101109143915
drwxrwxr-x 40 app admin 4096 2010-11-09 09:39 releases
drwxrwxr-x  9 app admin 4096 2010-11-02 15:25 shared
drwxr-xr-x  3 app admin 4096 2010-11-02 11:35 tomcat.8080

# local machine
brad-robertsons-macbook-pro:trunk bradrobertson$ cap staging deploy:stop

bradrobertson

#! /bin/sh
# Generic script for running ruby scripts as daemons using
# jsvc and a java class to control the daemon.
#
# Contains common parameters and start/stop

# Things you'll need to set on a per script/daemon basis:
# SCRIPT_NAME - Path to the ruby script which creates a Daemon
# object for jsvc to control
# APP_NAME - Name of your application

bradrobertson

# command_line_parser_spec.rb

  it "respects web_app_dir if applicable when loading config" do
    args = "--dir #{MOCK_WEB_APP_DIR} --config".split
    options = subject.parse(args)
    
    options[:config].should == "#{MOCK_WEB_APP_DIR}/config/trinidad.yml"
  end

# command_line_parser.rb (line 32)