README

English | 中文

A Symfony bundle that provides direct database insertion capabilities for Doctrine entities without using the ORM's persist/flush mechanism.

This bundle is designed for high-performance scenarios where you need to insert data directly into the database.

Features

Direct database insertion without ORM overhead
Support for auto-generated and preset IDs
Dedicated database connection support
Compatible with various data types (string, text, integer, float, boolean, nullable fields)
Automatic SQL generation based on entity metadata

Installation

composer require tourze/doctrine-direct-insert-bundle

Configuration

Add the bundle to your config/bundles.php:

<?php

return [
    // ... other bundles
    Tourze\DoctrineDirectInsertBundle\DoctrineDirectInsertBundle::class => ['all' => true],
];

Quick Start

Basic Usage

<?php

use Tourze\DoctrineDirectInsertBundle\Service\DirectInsertService;

class MyController
{
    public function __construct(
        private readonly DirectInsertService $directInsertService
    ) {
    }

    public function createEntity(): Response
    {
        $entity = new MyEntity();
        $entity->setName('Example Name');
        $entity->setEmail('example@example.com');
        
        // Insert directly into database and get the ID
        $id = $this->directInsertService->directInsert($entity);
        
        return new JsonResponse(['id' => $id]);
    }
}

With Preset ID

<?php

$entity = new MyEntity();
$entity->setId(12345); // Set a specific ID
$entity->setName('Example with preset ID');

$returnedId = $this->directInsertService->directInsert($entity);
// $returnedId will be 12345

Entity Example

<?php

use Doctrine\DBAL\Types\Types;
use Doctrine\ORM\Mapping as ORM;

#[ORM\Entity]
#[ORM\Table(name: 'my_entity')]
class MyEntity
{
    #[ORM\Id]
    #[ORM\Column(type: Types::INTEGER)]
    #[ORM\GeneratedValue(strategy: 'IDENTITY')]
    private ?int $id = null;

    #[ORM\Column(type: Types::STRING, length: 255)]
    private string $name;

    #[ORM\Column(type: Types::STRING, length: 255)]
    private string $email;

    // ... getters and setters
}

Advanced Usage

Dedicated Connection

This bundle supports dedicated database connections using the @WithDedicatedConnection attribute. The service uses a dedicated connection channel called direct_insert for improved performance and isolation.

Data Type Support

The bundle supports all standard Doctrine data types:

String and Text types
Integer and Float types
Boolean types
Nullable fields
Auto-generated IDs
Preset IDs

Performance Benefits

No ORM Overhead: Bypasses Doctrine's Unit of Work for faster insertions
Dedicated Connection: Uses a separate database connection to avoid conflicts
Direct SQL: Generates optimized INSERT statements directly
Batch Operations: Suitable for high-volume data insertion scenarios

Requirements

PHP 8.1+
Symfony 6.4+
Doctrine ORM 3.0+
Doctrine DBAL 4.0+

Dependencies

This bundle depends on:

tourze/doctrine-entity-checker-bundle - For SQL formatting utilities

License

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

tourze / doctrine-direct-insert-bundle

Maintainers

Details