Module: SfCli::Sf::Data::Query

Included in:
Core
Defined in:
lib/sf_cli/sf/data/query.rb,
lib/sf_cli/sf/data/query_helper.rb

Defined Under Namespace

Classes: BulkResultAdjuster, RawOutputResultAdjuster, RegularResultAdjuster

Instance Method Summary collapse

Instance Method Details

#query(soql, target_org: nil, format: nil, bulk: false, wait: nil, api_version: nil, model_class: nil, &block) ⇒ Array, [String,Array]

Get object records using SOQL. When using Bulk API, you get the records when the query job completes within time limit. The method returns a tapple(an array), which changes its contents according to the job result.

Examples:

sf.data.query 'SELECT Id, Name FROM Account LIMIT 1' # => [{Id: "abc", Name: "account name"}]

accounts = sf.data.query('SELECT Id, Name From Account') do |record|
             record['Name'] += " Changed!" # can manipulate the record in block
           end

Account = Struct.new(:Id, :Name)
sf.data.query('SELECT Id, Name From Account Limit 3', model_class: Account)  # returns an array of Account struct object

# child-parent relationship is supported
sf.data.query 'SELECT Id, Name, Account.Name From Contact Limit 1'  #  [{Id: "abc", Name: "contact name", Account: {Name: "account name"}}]

# parent-children relationship is supported
sf.data.query 'SELECT Id, Name, (SELECT Name From Contacts) FROM Account Limit 1'  #  [{Id: "abc", Name: "account name", Contacts: [{Name: "contact name"}]}]
done, result = sf.data.query 'SELECT Id, Name FROM Account', bulk: true              # max wait 1 min to get result (default)
done, result = sf.data.query 'SELECT Id, Name FROM Account', bulk: true, wait: 5  # max wait 5 min to get result
done, result = sf.data.query 'SELECT Id, Name FROM Account', bulk: true, wait: 0  # returns immediately

rows = result   if done     # if job is completed, the result is an array of record
job_id = result unless done # if job hasn't completed or it has aborted, the result is the job ID

Parameters:

  • soql (String) —

    SOQL

  • target_org (Symbol, String) (defaults to: nil) —

    an alias of paticular org, or username can be used

  • format (Symbol, String) (defaults to: nil) —

    get the command’s raw output. human, csv, json can be available

  • model_class (Class) (defaults to: nil) —

    the object model class

  • bulk (Boolean) (defaults to: false) —

    use Bulk API

  • wait (Integer) (defaults to: nil) —

    max minutes to wait for the job complete in Bulk API mode

  • api_version (Numeric) (defaults to: nil) —

    override the api version used for api requests made by this command

Returns:

  • (Array, [String,Array]) —

    records or a tuple containing a flag and records

See Also:



46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
 
# File 'lib/sf_cli/sf/data/query.rb', line 46

def query(soql, target_org: nil, format: nil, bulk: false, wait: nil, api_version: nil, model_class: nil, &block)
  flags    = {
    :"query"    => %("#{soql}"),
    :"target-org" => target_org,
    :"result-format" => format,
    :"wait" => (bulk ? wait : nil),
    :"api-version" => api_version,
  }
  switches = {
    bulk: bulk,
  }
  raw_output = format ? true : false
  format = format&.to_sym || :json

  exec_result = exec(__method__, flags: flags, switches: switches, redirection: :null_stderr, raw_output: raw_output, format: format)

  results = return_result(exec_result, raw_output, bulk, model_class)

  return results if raw_output

  results.each(&block) if block_given?

  results
end

#query_resume(job_id:, target_org: nil, format: nil, api_version: nil, model_class: nil) ⇒ Array, [String,Array]

Resume a bulk query job, which you previously started, and get records

Examples:

# start a query job
result1 = sf.data.query 'SELECT Id, Name FROM Account', bulk: true, wait: 0  # returns immediately

result1 # => [false, "<job id>"]

# the job has already started asynchronously.
# So you should check and get the result.
done, result2 = sf.data.query_resume job_id: result1.last

puts 'get the records!' if done # the job has completed

result2 # => if done is true, this is an array of record. Otherwise it should be the Job ID.

Parameters:

  • job_id (String) —

    job ID you want to resume

  • target_org (Symbol, String) (defaults to: nil) —

    an alias of paticular org, or username can be used

  • format (Symbol, String) (defaults to: nil) —

    get the command’s raw output. human, csv, json can be available

  • model_class (Class) (defaults to: nil) —

    the object model class

  • api_version (Numeric) (defaults to: nil) —

    override the api version used for api requests made by this command

Returns:

  • (Array, [String,Array]) —

    records or a tuple containing a flag and records

See Also:



96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
 
# File 'lib/sf_cli/sf/data/query.rb', line 96

def query_resume(job_id:, target_org: nil, format: nil, api_version: nil, model_class: nil)
  flags    = {
    :"bulk-query-id" => job_id,
    :"target-org" => target_org,
    :"result-format" => format,
    :"api-version" => api_version,
  }
  raw_output = format ? true : false
  format = format || :json

  action = __method__.to_s.tr('_', ' ')
  result = exec(action, flags: flags, redirection: :null_stderr, raw_output: raw_output, format: format)

  return_result(result, raw_output, true, model_class)
end