Sha256: effaa8db2f8eccd4215f4001c3029d08080a9c399f6ff4e663f9dcb882bf50a6

Contents?: true

Size: 668 Bytes

Versions: 5

Compression:

Stored size: 668 Bytes

Contents

module EmployeeFactory
  # Creates new employee with valid field values.
  # Pass in parameters only field values that you want to override.
  def create_employee(params)
    employee = {
      :employee_id => plsql.employees2_seq.nextval,
      :last_name => 'Last',
      :email => 'last@example.com',
      :hire_date => Date.today,
      :job_id => plsql.jobs.first[:job_id],
      :commission_pct => nil,
      :salary => nil
    }.merge(params)
    plsql.employees2.insert employee
    get_employee employee[:employee_id]
  end

  # Select employee by primary key
  def get_employee(employee_id)
    plsql.employees2.first :employee_id => employee_id
  end

end

Version data entries

5 entries across 5 versions & 1 rubygems

Version Path
ruby-plsql-spec-0.5.0 examples/spec/factories/employee_factory.rb
ruby-plsql-spec-0.4.0 examples/spec/factories/employee_factory.rb
ruby-plsql-spec-0.3.0 examples/spec/factories/employee_factory.rb
ruby-plsql-spec-0.2.1 examples/spec/factories/employee_factory.rb
ruby-plsql-spec-0.1.0 examples/spec/factories/employee_factory.rb