CLI application for importing transactions from a JSON file.
- Docker Compose
- PHP 8.5.12
- FrankenPHP
- MySQL 9.7
- Docker Compose
- PDO
- PHPUnit
- PHPStan
- PHP-CS-Fixer
- Rector
- Monolog
Show CLI information:
docker compose run --rm app bin/console aboutImport transaction from JSON file:
docker compose run --rm app bin/console import var/input.jsonExpected result:
Transaction imported: trx-001
Import transactions from JSON array:
docker compose run --rm app bin/console import var/input-bulk.jsonExpected result:
Transactions imported: 2
Invalid input is rejected and the database transaction is rolled back:
docker compose run --rm app bin/console import var/input-invalid.jsonExpected result:
Error: Transaction amount must be a valid decimal number
Importing the same transaction again is rejected by external_id:
Error: Transaction with external ID "external-001" already exists
Run this to start with empty database (next import command will create fresh MySQL volume):
docker compose down -vdocker compose exec mysql mysql -h 127.0.0.1 -utransaction_import -ptransaction_import transaction_import -e "SELECT id, external_id, amount_minor_units, currency, status FROM transactions;"- The amount is stored in minor currency units. For example,
125.50 EURis stored as12550.
Application logs stored in var/app.log.
Read the log from application container:
docker compose run --rm app cat var/app.logRun the complete project check:
docker compose run --rm app composer quality- Runs simultaneously
php-cs-fixer,phpstan,rectorandphpunit
src/Domain domain objects and contracts
src/Application import and persistence use cases
src/Infrastructure JSON, PDO, MySQL and logging
src/Presentation/CLI import CLI command
tests unit and integration tests
docker/mysql/init.sql transactions table schema