haben/laravel-batch-db

Proper batch insert and update on Laravel

dev-main 2021-05-21 09:53 UTC

Requires

• illuminate/database: ^8.25
• illuminate/support: ^8.25

MIT

• Haben Amare

README

EARLY STAGE OF DEVELOPMENT

Basic Usage

<?php

use Haben\Facades\BatchDB;

// or

$batchDb = new BatchDB('optionalDatabaseConnectionName');

BatchDB::upsert('tableName', []);

// or

$dbConn = DB::connection('databaseConnectionName');
BatchDB::upsert('tableName', [], $dbConn);

// or

BatchDB::connection('databaseConnectionName')->upsert('tableName', []);

API

insert

Perform a batch insert.

insertAndGet

Perform a batch insert and get the inserted items.

upsert

Perform a batch upsert (insert or update) via INSERT ... ON DUPLICATE KEY UPDATE.

License

MIT