doyevaristo/liquet-database

use mysql queries and and efficiently import thousands of records from csv

Liquet Database

Simple data MySQL query runner and imports database records from big data CSV., _(*1)

Made this library for loading layer of Data Warehousing, _(*2)

Features:

• runs query in straight forward manner
• Import huge csv. Either update the existing record or add new records.

Usage:, _(*3)

use Doyevaristo\LiquetDatabase\CsvReader;
use Doyevaristo\LiquetDatabase\LiquetCSVImporter;
use Doyevaristo\LiquetDatabase\LiquetDatabase;




$liquetDatabase = new LiquetDatabase('db_username','db_password','db_database','db_hostname');
$csvReader = new CsvReader();
$csvImporter = new LiquetCSVImporter($liquetDatabase,$csvReader);
$csvImporter
    ->table('your_table_name')
    ->import($file);

Notes: - CSV must have header same with table column name, _(*4)

To Do: - Improve documentation - Unit testing, _(*5)