Used to generate charsets for node-mysql

charsetgenerate.js

var mysql      = require('mysql');
var fs = require('fs');

var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root'
});

connection.connect();

connection.query('SELECT collation_name, id FROM information_schema.collations ORDER BY id', function(err, rows, fields) {
  if (err) throw err;
  
    var data = "";
    
    var currentRow = "";
        for(var x=0; x<rows.length; x++)
        {
            currentRow = "exports."+rows[x].collation_name.toUpperCase();
            
            while((currentRow.length-30)<0)
            {   
                currentRow+=" ";
            }
            
               currentRow+=(" = "+ rows[x].id + ";\n");
               
               data+=currentRow;
        }
  
  
        fs.writeFile('charsets.js', data,function(err){
        });
});

connection.end();