insert-into-database-from-file.php

<?php
/**
 * insert-into-database-from-file.php
 *
 * @author: Onirudda Odikare Jhalak <jhalak1983@gmail.com>
 * @created on: 6/10/18
 */
require_once "vendor/autoload.php";
require_once "database.php";

use Illuminate\Database\Capsule\Manager as Database;


if (count($argv) < 2) {
	print "Argument missing: " . PHP_EOL;
	print "Example: php insert-into-database-from-file.php [fileName]" . PHP_EOL;
	exit();
}

$filename = $argv[1];

echo "Writing records in students table from file ... " . PHP_EOL;


try {
	TimeTracker::start();
	$query = 'LOAD DATA LOCAL INFILE \'' . $filename . '\' 
		INTO TABLE students 
		CHARACTER SET UTF8 
		FIELDS TERMINATED BY \'\t\' 
		ENCLOSED BY \'\\"\' 
		LINES TERMINATED BY \'\n\'';
	Database::connection()->getPdo()->exec(Database::raw($query));
	TimeTracker::end();
	TimeTracker::showTimeDiff();

} catch (Exception $e) {
	echo $e->getMessage();
}