delete.md

Delete helper

drop multi tables

Suppose you want to drop multiple tables by their names in the database, you can do it with the following implementation.

    QueryHelperFacade::deleteInstance()
        ->setTables(['posts', 'users' , 'comments']) 
        // tables names.
        // or you can select all tables that exists in the database from the below function
        // ->setAllTablesFromDatabase()
        ->dropMultiTables()
        ->executeAll();

truncate multi tables

Suppose you want to truncate multiple tables by their names in the database, you can do it with the following implementation.

    QueryHelperFacade::deleteInstance()
        // tables names.
        ->setTables(['posts', 'users' , 'comments'])
        // or you can select all tables that exists in the database from the below function
        // ->setAllTablesFromDatabase()
        ->truncateMultiTables()
        ->executeWithoutPrepare();

delete large data

If you have a table that contains a large number of data (maybe millions of records) and you want to delete everything contained in this table, if you execute the command with one query, this query will take a lot of time, so this function divides the large query into more queries with an easy-to-use structure.

    QueryHelperFacade::deleteInstance()
        ->setField('id') // Set the field that we will query on it.
        ->setAllowedWhereInQueryNumber(10) // Set the number that the query will delete each time
        ->setTableName('tests')
        ->deleteLargeData();

    // and you can implement your custom query by a callback.
    QueryHelperFacade::deleteInstance()
        ->setField('id') // Set the field that we will query on it.
        ->setAllowedWhereInQueryNumber(10) // Set the number that the query will delete each time.
        ->setTableName('tests')
        ->deleteLargeData(function ($table) {
            return $table->where('id', '<', 100)->pluck('id')->toArray();
        }); //  this will implement the delete process only on the result of this callback.

drop all tables

If you want to drop all tables from the database.

    QueryHelperFacade::deleteInstance()
        ->prepareDataBaseTablesToDrop()
        ->executeAll();