03/ Update Payment Status

This job was provided by an OpenFn.org user via the job library API.

Metadata

• Name: 03/ Update Payment Status
• Adaptor: @openfn/language-mysql
• Adaptor Version: latest
• Created about 5 years ago
• Updated over 4 years ago
• Score: 0 (an indicator of how useful this job may be)

Key Functions

alterState

Expression

sqlString(state => {
  console.log(state.data.transactionCode);
  return `SELECT record FROM entry WHERE string_value='${state.data.transactionCode}'`;
});

alterState(state => {
  // Note: we pluck out on the 'RowDataResponses' from the SQL server.
  const recordData = state.response.body.filter(x => x.record !== undefined);
  // Get the first record
  state.data.record = recordData[0] && recordData[0].record;
  return state;
});

sqlString(state => {
  return `UPDATE entry SET string_value='completed' where record=${state.data.record} and string_value='initiated'`;
});

sqlString(state => {
  return `UPDATE last_entry SET string_value='completed' where record=${state.data.record} and string_value='initiated'`;
});

sqlString(state => {
  return `UPDATE hippo_person_payments SET status='completed' where id='person_payments|${state.data.record}'`;
});