SQL File Importer

Import or compare SQL file to database in MariaDB server.

Probably also works in MySQL server, but currently only tested in MariaDB 10.4 & 10.11.

Installation

npm i sql-file-importer

History

v0.1.1

• Handle FULLTEXT KEY column

v0.1.0

• Add SQLCompare to compare between existing database and SQL File
• Export class SQLImporter and SQLCompare
• Example

   const { SQLImporter, SQLCompare } = require('sql-file-importer');
  
   const config = {
   		host: 'localhost',
   		port: 3306,
   		user: 'root',
   		password: '',
   		database: 'test_db',
   		charset: 'utf8mb4',
   		trace: true,
   		verbose: 2,
   	};
  
   (async () => {
   	/* ------------------ import db ------------------ */
   	const importer = new SQLImporter();
  
   	importer.init(config);
  
   	const proc = await importer
   			.importFile(filepath, {
   				withData: 'single',
   				dropFirst: true,
   			});
  
   	/* ----------------- compare db ------------------ */
   	const cmp = new SQLCompare();
  
   	cmp.init(config);
  
   	// fetch SQL from existing database
   	const source = await cmp.existing();
  
   	// fetch SQL from File
   	const target = await cmp.fromFile('db_dump.sql');
  
   	// compare
   	const res = compare.compare(source, target);
  
   	// get comparison error code
   	const errno = compare.getErrno(res);
  
   	// get diff report
   	const diff = compare.getDiffString(res);
  
   	console.log('Error code:', errno);
   	console.log(diff)
   }();

v0.0.3

• Basic SQL file import

   const sqlFileImporter = require('sql-file-importer');
  
   const config = {
   		host: 'localhost',
   		port: 3306,
   		user: 'root',
   		password: '',
   		database: 'test_db',
   		charset: 'utf8mb4',
   		trace: true,
   		verbose: 2,
   	};
  
   	(async () => {
   		/* import db data and multiple rows insert statement will be splitted into
   		* single row statements.
   		* */
   		const proc = await importer.init(config).importFile(filepath, {
   				withData: 'single',
   				dropFirst: true,
   			});
   	}();