Database Manager

With database manager class, you can create a backup of your database or export, download database table columns as CSV or JSOn file format. All your backup and backup will be stored in /luminova.ng/writeable/caches/database/

• Class namespace: \Luminova\Database\Manager

constructor

Initializes database manager class with DriversInterface you are using.

new Manager(\Luminova\Interface\DriversInterface $db, null|string $table = null): mixed

Get database manager instance from QueryBulder class.

$manager = $bilder->manager(): Manager;

Parameters:

Methods

setTable

Set the databse table to backup.

public setTable(string $table): void

Parameters:

export

Export database table and download it to browser as JSON or CSV format.

public export(string $as = 'csv', string $filename = null, array $columns = ['*']): bool

Parameters:

Return Value:

bool - Return true on success else false.

Throws:

• \Luminova\Exceptions\DatabaseException - If invalid format is provided.
• \Luminova\Exceptions\DatabaseException - If unable to create export temp directory.
• \Luminova\Exceptions\DatabaseException - If failed to create export.

backup

Create a database backup file.

public backup(string $filename = null): bool

Parameters:

Return Value:

bool - Return true on success else false.

Throws:

• \Luminova\Exceptions\DatabaseException - If unable to create backup directory.
• \Luminova\Exceptions\DatabaseException - If failed to create backup.