Laravel 9, Parent child bulk insert while replacing uuid to id.

Laravel 9, Parent child bulk insert while replacing uuid to id.

To perform a bulk insert of parent-child records in Laravel 9 while replacing UUIDs with IDs, you can use the DB facade's transaction method to ensure the integrity of the database. Here's a step-by-step guide to help you achieve this:

1. Assuming you have two models: ParentModel and ChildModel. Both models have UUIDs as primary keys.

2. Create a new method in your ParentModel to generate a new ID before inserting the record. You can use Laravel's uuid function to generate a new UUID and then convert it to an integer using PHP's bin2hex and hexdec functions.

public static function generateNewId(): string
{
    $uuid = Uuid::generate(4); // Generate a new UUID
    $hex = bin2hex($uuid); // Convert UUID to hexadecimal
    $decimal = hexdec($hex); // Convert hexadecimal to decimal
    return (string) ($decimal & 0xFFFFFFFF); // Keep only the lower 32 bits
}

3. Create a new method in your ParentModel to perform the bulk insert with child records.

public static function createWithChildren(array $parentsData, array $childrenData): void
{
    DB::beginTransaction();

    try {
        $parentsIds = [];

        // Insert parent records and get their IDs
        foreach ($parentsData as $parentData) {
            $parentData['id'] = static::generateNewId();
            static::create($parentData);
            $parentsIds[] = $parentData['id'];
        }

        // Insert child records with the parent IDs
        ChildModel::insert($childrenData, ['parent_id' => $parentsIds]);

        DB::commit();
    } catch (\Throwable $th) {
        DB::rollback();
        throw $th;
    }
}

4. Use the createWithChildren method to perform the bulk insert.

$parentsData = [
    ['name' => 'Parent 1'],
    ['name' => 'Parent 2'],
];

$childrenData = [
    ['name' => 'Child 1', 'parent_id' => ''],
    ['name' => 'Child 2', 'parent_id' => ''],
];

ParentModel::createWithChildren($parentsData, $childrenData);

This example demonstrates how to perform a bulk insert of parent-child records while replacing UUIDs with IDs in Laravel 9. Make sure to adjust the code according to your specific models and requirements.