MySQL-Connector

Script to connect to MySQL databases with Google Cloud Proxy support.

Example

index.js (Server File)

This is the final result inside your server’s file.

// Get Module
const mysql = require('./connect');
// Start the MySQL Connection
mysql('server-database-name').then(async db => {
    // Print
    db.query('SELECT * FROM test')
        // Success
        .then(data => {
            // Print
            console.log(data);
            // Complete
            return;
        })
        // Fail
        .catch(err => {
            // Print
            console.error(err);
            // Complete
            return;
        });
    // Complete
    return;      
}).catch(err => {
    console.error(err);
});
// Start the MySQL Connection with multiple databases
mysql(['server-database-name-1', 'server-database-name-2']).then(dbs => {
    // Get Database 1
    const db = dbs['server-database-name-1'];
    // Complete
    return;      
}).catch(err => {
    console.error(err);
});

connect.js (Module)

You will use this module to create a totally easy to use method to create a connection to your database. You just need to insert your database name into the method. Totally simple and easy!

module.exports = function (database = 'main', insertSSL = true) {
    return new Promise(async function (resolve, reject) {
        // Modules
        const mysql = require('@tinypudding/mysql-connector/create');
        const getMySQL = require('./get');
        // Single Database
        if (typeof database === "string") {
            // Get MySQL Connection
            // If you want to use only the normal connection. Change the "firebase" option to "default".
            mysql(require('mysql'), 'firebase', getMySQL(database, insertSSL)).then(resolve).catch(reject);
        }
        // Nope
        else {
            // Prepapre Module
            const sameUser = require('@tinypudding/mysql-connector/sameUser');
            // Prepare Keys
            let key;
            const keys = [];
            // Get Keys
            for (const item in database) {
                if (Number(item) > 0) {
                    keys.push(sameUser(database[item], key));
                } else { key = getMySQL(database[item], insertSSL); keys.push(key); }
            }
            // start Connection
            mysql(require('mysql'), 'firebase', keys).then(resolve).catch(reject);
        }
        // Complete
        return;
    });
};

get.js (Module)

This module will get the json from your database settings.

module.exports = function (database = 'main', insertSSL = true) {
    // Get Key
    const key = require('clone')(require('./keys.json'));
    // Insert Database Value
    key.data.database = database;
    // Insert SSL
    if(insertSSL) {key.data.ssl = require('./getSSL')();}
    // Complete
    return key;
};

getSSL.js (Module)

If you are using SSL. This file will help you to get your SSL data.

module.exports = function (readType) {
    // Prepare FS
    const fs = require('fs');
    const path = require('path');
    // Prepare Items
    const result = {
        ca: fs.readFileSync(path.join(__dirname, '/server-ca.pem'), readType),
        cert: fs.readFileSync(path.join(__dirname, '/client-cert.pem'), readType),
        key: fs.readFileSync(path.join(__dirname, '/client-key.pem'), readType),
        rejectUnauthorized: true
    };
    // Send Result
    return result;
};

keys.json (JSON)

This is the file that will contain all the default connection settings for your database.

{
    "google_cloud": {
        "socketPath": "/cloudsql/{project-name}:{region}:{database-server-id}"
    },
    "default": {
        "host": "public-database-server-ip",
        "port": 3306
    },
    "data": {
        "database": "server-database-name",
        "user": "root",
        "password": "example123"
    }
}