buchin/jl-importer

Import JSON Line into MySQL database

dev-master 2016-11-23 15:39 UTC

Requires

• gabordemooij/redbean: ^4.3

Requires (Dev)

• kahlan/kahlan: ^3.0

Halal

• Mochammad Masbuchin

README

Import existing JSON Lines into MySQL database

Installation

composer require buchin/jl-importer

Usage

<?php
use Buchin\Jl\Importer;

// Initialize importer
$importer = new Importer;

// define parameters
$source = '/Path/to/jlfile.jl';
$dsn = 'mysql:unix_socket=/Applications/MAMP/tmp/mysql/mysql.sock;dbname=test';
$user = 'mysql_user';
$password = 'mysql_password';

// start importing
$importer->import($source, $dsn, $user, $password);

Test

./vendor/bin/kahlan --reporter=verbose