README

This package contains dialect-agnostic SQL transaction implementations shared across different database adapters of the AEATech Transaction Manager ecosystem.

It provides a unified, reusable foundation for SQL write-operations that work with any relational database as long as a database-specific identifier quoter is supplied.

Typical adapters are built on top of this package:

• aeatech/transaction-manager-mysql
• aeatech/transaction-manager-postgresql

This package does not contain any dialect-specific SQL features (e.g., INSERT IGNORE, ON DUPLICATE KEY, ON CONFLICT).
Those features belong to adapter-specific packages.

✨ Features

• Common SQL transaction types:
  • InsertTransaction
  • UpdateTransaction
  • DeleteTransaction
  • UpdateWhenThenTransaction (multi-row conditional updates)
  • SqlTransaction (raw SQL)
• Fully decoupled from any SQL dialect
• Requires an implementation of IdentifierQuoterInterface
  • MySQL → backtick quoter\
  • PostgreSQL → double-quote quoter\
• Compatible with Transaction Manager Core retry policy, backoff strategy, and transactional engine
• Cleanly testable in isolation

📦 Installation

composer require aeatech/transaction-manager-common-transactions

🧩 Architecture Overview

Each transaction class builds SQL using:

• an injected identifier quoter, and\
• a dedicated builder (e.g., InsertValuesBuilder, UpdateWhenThenDefinitionsBuilder)

All SQL dialect specifics are delegated to adapter packages.

transaction-manager-core
       ↑
       │
transaction-manager-common-transactions
       ↑
       ├──────── transaction-manager-mysql
       └──────── transaction-manager-postgresql

🔧 Usage Example

use AEATech\TransactionManager\Transaction\InsertTransaction;
use AEATech\TransactionManager\MySQL\IdentifierQuoter;
use AEATech\TransactionManager\Transaction\Internal\InsertValuesBuilder;

$transaction = new InsertTransaction(
    insertValuesBuilder: new InsertValuesBuilder(),
    quoter: new IdentifierQuoter(),
    tableName: 'users',
    rows: [
        ['name' => 'Alex', 'age' => 30],
        ['name' => 'Bob',  'age' => 25],
    ],
    columnTypes: ['name' => \PDO::PARAM_STR, 'age' => \PDO::PARAM_INT],
);

🧪 Running Tests in Docker

Start containers

docker-compose -p aeatech-transaction-manager-common-transactions -f docker/docker-compose.yml up -d --build

Stop and remove containers

docker-compose -p aeatech-transaction-manager-common-transactions -f docker/docker-compose.yml down -v

📥 Install dependencies (example: PHP 8.2)

docker-compose -p aeatech-transaction-manager-common-transactions -f docker/docker-compose.yml exec php-cli-8.2 composer install

▶️ Run tests for a specific PHP version

PHP 8.2:

docker-compose -p aeatech-transaction-manager-common-transactions -f docker/docker-compose.yml exec php-cli-8.2 vendor/bin/phpunit

PHP 8.3:

docker-compose -p aeatech-transaction-manager-common-transactions -f docker/docker-compose.yml exec php-cli-8.3 vendor/bin/phpunit

PHP 8.4:

docker-compose -p aeatech-transaction-manager-common-transactions -f docker/docker-compose.yml exec php-cli-8.4 vendor/bin/phpunit

🔄 Run all configured PHP variants

for v in 8.2 8.3 8.4 ; do \
  echo "Testing PHP $v..."; \
  docker-compose -p aeatech-transaction-manager-common-transactions -f docker/docker-compose.yml exec -T php-cli-$v vendor/bin/phpunit || break; \
done

Run phpstan

docker-compose -p aeatech-transaction-manager-common-transactions -f docker/docker-compose.yml exec php-cli-8.4 vendor/bin/phpstan analyse -c phpstan.neon --memory-limit=1G

🧵 Attach interactive shells

PHP 8.2:

docker-compose -p aeatech-transaction-manager-common-transactions -f docker/docker-compose.yml exec php-cli-8.2 /bin/bash

PHP 8.3:

docker-compose -p aeatech-transaction-manager-common-transactions -f docker/docker-compose.yml exec php-cli-8.3 /bin/bash

PHP 8.4:

docker-compose -p aeatech-transaction-manager-common-transactions -f docker/docker-compose.yml exec php-cli-8.4 /bin/bash

License

This project is licensed under the MIT License. See the LICENSE file for details.