payment-reconciler
A lambda to reconcile payments. This service collates data from a payment reconciliation database and writes it to CSV's on an SFTP server.
The Lambda function
This API runs on AWS Lambda. Release and deployment of the lambda is similar to that of other trunk based services. After performing relevant unit tests, a github release task is run and the zip is uploaded to the S3 release bucket. Terraform is then run to deploy the new version.
Terraform deployment
All dependent AWS resources are provisioned by Terraform and deployed from a concourse pipeline. Click "plan" then "apply" jobs with desired environment to deploy the lambda. The pipeline is capable of deploying everything so manual deployment should not be necessary. For instructions on Terraform provisioning, see here.
Environment Variables
Environment variables required to execute the lambda:
| Name | Description | Examples |
|---|---|---|
| MONGODB_PAYMENT_REC_TRANSACTIONS_COLLECTION | The name of the collection within the payment reconciliation database from which to fetch transactions data. | |
| MONGODB_PAYMENT_REC_PRODUCTS_COLLECTION | The name of the collection within the payment reconciliation database from which to fetch products data. | |
| MONGODB_PAYMENT_REC_DATABASE | The name of the payment reconciliation database. | |
| MONGODB_URL | The Mongo database URL. | 'mongodb://<mongo_host>:27017 |
| SFTP_SERVER | The SFTP server host name. | |
| SFTP_PORT | The port over which to connect to the SFTP server. | '22' |
| SFTP_USERNAME | The username of the SFTP server credentials. | |
| SFTP_PASSWORD | The password of the SFTP server credentials. | |
| SFTP_FILE_PATH | The file path, relative to the root of the SFTP server, to which to upload CSV files. | 'uploadPath' (will result is CV's uploaded to directory: ~/uploadPath) |
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent