'use strict';

// @ts-ignore
import Converter from './utils/Converter';
const jsonMerger = require("json-merger");  //https://github.com/boschni/json-merger
const Graph = require("./utils/graph-data-structure");
const _ = require('underscore');

export default class MySqlDBSchemaGraph {

    //Get the array of same table names (edges) from two nodes
    getEdges = (node1, node2) => {
        let edgeNames = node1.filter(function (val) {
            return node2.indexOf(val) != -1;
        });

        return edgeNames;
    }

    //Get unique edges names
    //Purpose: so one edge as the key can have nested target and source
    getUniqueEdgeNames = (edgesAndNodesCombined: Array<any>) => {
        let edgeNames = [];
        for(let i=0; i<edgesAndNodesCombined.length; i++) {
            edgeNames.push(edgesAndNodesCombined[i][0]);
            //console.log(edgesAndNodesCombined[i][0]);
        }
        return _.uniq(edgeNames);
    }

    //Get the array of the same edges found from two nodes
    //return the array of edges as well as the two nodes
    getEdgesAndNodes = (tableWithColObject) => {
        let edgesAndNodes = [];
        let edgesAndNodesCombined = [];

        let referencedTables = [];
        let edgeName:string; //foreign key column name
        let sourceNode:string; //foreign key table name
        let targetNode:string;  //primary key table name
        let tableNames = Object.keys(tableWithColObject);

        //tableName is the key of the referential objects
        for(let tableName of tableNames){
            referencedTables = tableWithColObject[tableName];
            for(let referencedTable of referencedTables){
                edgeName = referencedTable['columnName'];               //foreign key
                sourceNode = referencedTable['tableName'];              //table that has the foreign key
                targetNode = referencedTable['referencedTableName'];    //table that has the primary key

                //adds edges and nodes to an array
                edgesAndNodes.push(edgeName);   //add edge name
                edgesAndNodes.push(sourceNode);
                edgesAndNodes.push(targetNode);
                edgesAndNodesCombined.push(edgesAndNodes);
                edgesAndNodes = [];
            }
        }
        
        return edgesAndNodesCombined;
    }

    //Get edges with source node and target node in Json
    getEdgesGraph = (uniqueEdgeNames:Array<any>, edgesAndNodesCombined: Array<any>) => {

        let serializedLinks;
        let edgesJson = {edges: {}};
        let sourceNode;
        let targetNode;
        let edgeName:string = '';

        let graph = new Graph();

        for (let i=0; i<uniqueEdgeNames.length; i++) {
            for(let j=0; j<edgesAndNodesCombined.length; j++) {
                if(edgesAndNodesCombined[j][0].includes(uniqueEdgeNames[i])) {
                    edgeName = uniqueEdgeNames[i];
                    sourceNode = edgesAndNodesCombined[j][1];
                    targetNode = edgesAndNodesCombined[j][2];

                    graph.addNode(sourceNode);
                    graph.addNode(targetNode);
                    graph.addEdge(sourceNode, targetNode);
                    //console.log(uniqueEdgeNames[i] + "\t" + edgesAndNodesCombined[j] )
                }
            }
            serializedLinks = graph.serializeLinks(edgeName);
            edgesJson.edges[edgeName] = serializedLinks[edgeName];
            graph = new Graph();

        }

        return edgesJson;
    }
}

/*********************************** Main Entry Point ************************************************/
/*
const extractedSchema = {
        "departments": {
            "dept_no": {
                "type": "CHAR(4)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": true,
                    "autoIncrement": false,
                    "comment": null
            },
            "dept_name": {
                "type": "VARCHAR(40)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            }
        },
        "dept_emp": {
            "emp_no": {
                "type": "INT(11)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": true,
                    "autoIncrement": false,
                    "comment": null
            },
            "dept_no": {
                "type": "CHAR(4)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": true,
                    "autoIncrement": false,
                    "comment": null
            },
            "from_date": {
                "type": "DATE",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            },
            "to_date": {
                "type": "DATE",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            }
        },
        "dept_manager": {
            "emp_no": {
                "type": "INT(11)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": true,
                    "autoIncrement": false,
                    "comment": null
            },
            "dept_no": {
                "type": "CHAR(4)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": true,
                    "autoIncrement": false,
                    "comment": null
            },
            "from_date": {
                "type": "DATE",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            },
            "to_date": {
                "type": "DATE",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            }
        },
        "employees": {
            "emp_no": {
                "type": "INT(11)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": true,
                    "autoIncrement": false,
                    "comment": null
            },
            "birth_date": {
                "type": "DATE",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            },
            "first_name": {
                "type": "VARCHAR(14)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            },
            "last_name": {
                "type": "VARCHAR(16)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            },
            "gender": {
                "type": "ENUM('M','F')",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            },
            "hire_date": {
                "type": "DATE",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            }
        },
        "salaries": {
            "emp_no": {
                "type": "INT(11)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": true,
                    "autoIncrement": false,
                    "comment": null
            },
            "salary": {
                "type": "INT(11)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            },
            "from_date": {
                "type": "DATE",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": true,
                    "autoIncrement": false,
                    "comment": null
            },
            "to_date": {
                "type": "DATE",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            }
        },
        "titles": {
            "emp_no": {
                "type": "INT(11)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": true,
                    "autoIncrement": false,
                    "comment": null
            },
            "title": {
                "type": "VARCHAR(50)",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": true,
                    "autoIncrement": false,
                    "comment": null
            },
            "from_date": {
                "type": "DATE",
                    "allowNull": false,
                    "defaultValue": null,
                    "primaryKey": true,
                    "autoIncrement": false,
                    "comment": null
            },
            "to_date": {
                "type": "DATE",
                    "allowNull": true,
                    "defaultValue": null,
                    "primaryKey": false,
                    "autoIncrement": false,
                    "comment": null
            }
        }
    }

const foreignKeyReferences = {
    "dept_emp": [
    {
        "constraint_name": "dept_emp_ibfk_1",
        "constraintName": "dept_emp_ibfk_1",
        "constraintSchema": "employees",
        "constraintCatalog": "employees",
        "tableName": "dept_emp",
        "tableSchema": "employees",
        "tableCatalog": "employees",
        "columnName": "emp_no",
        "referencedTableSchema": "employees",
        "referencedTableCatalog": "employees",
        "referencedTableName": "employees",
        "referencedColumnName": "emp_no"
    },
    {
        "constraint_name": "dept_emp_ibfk_2",
        "constraintName": "dept_emp_ibfk_2",
        "constraintSchema": "employees",
        "constraintCatalog": "employees",
        "tableName": "dept_emp",
        "tableSchema": "employees",
        "tableCatalog": "employees",
        "columnName": "dept_no",
        "referencedTableSchema": "employees",
        "referencedTableCatalog": "employees",
        "referencedTableName": "departments",
        "referencedColumnName": "dept_no"
    }],
    "dept_manager": [
    {
        "constraint_name": "dept_manager_ibfk_1",
        "constraintName": "dept_manager_ibfk_1",
        "constraintSchema": "employees",
        "constraintCatalog": "employees",
        "tableName": "dept_manager",
        "tableSchema": "employees",
        "tableCatalog": "employees",
        "columnName": "emp_no",
        "referencedTableSchema": "employees",
        "referencedTableCatalog": "employees",
        "referencedTableName": "employees",
        "referencedColumnName": "emp_no"
    },
    {
        "constraint_name": "dept_manager_ibfk_2",
        "constraintName": "dept_manager_ibfk_2",
        "constraintSchema": "employees",
        "constraintCatalog": "employees",
        "tableName": "dept_manager",
        "tableSchema": "employees",
        "tableCatalog": "employees",
        "columnName": "dept_no",
        "referencedTableSchema": "employees",
        "referencedTableCatalog": "employees",
        "referencedTableName": "departments",
        "referencedColumnName": "dept_no"
    }],
    "salaries": [
    {
        "constraint_name": "salaries_ibfk_1",
        "constraintName": "salaries_ibfk_1",
        "constraintSchema": "employees",
        "constraintCatalog": "employees",
        "tableName": "salaries",
        "tableSchema": "employees",
        "tableCatalog": "employees",
        "columnName": "emp_no",
        "referencedTableSchema": "employees",
        "referencedTableCatalog": "employees",
        "referencedTableName": "employees",
        "referencedColumnName": "emp_no"
    }],
    "titles": [
    {
        "constraint_name": "titles_ibfk_1",
        "constraintName": "titles_ibfk_1",
        "constraintSchema": "employees",
        "constraintCatalog": "employees",
        "tableName": "titles",
        "tableSchema": "employees",
        "tableCatalog": "employees",
        "columnName": "emp_no",
        "referencedTableSchema": "employees",
        "referencedTableCatalog": "employees",
        "referencedTableName": "employees",
        "referencedColumnName": "emp_no"
    }]
}


const mySqlDBSchemaGraph = new MySqlDBSchemaGraph();

let edgesAndNodesCombined = mySqlDBSchemaGraph.getEdgesAndNodes(foreignKeyReferences);
//console.log(edgesAndNodesCombined);

let uniqueEdgeNames = mySqlDBSchemaGraph.getUniqueEdgeNames(edgesAndNodesCombined);
//console.log(uniqueEdgeNames);

let nodesGraph = { nodes: { } };
nodesGraph.nodes = extractedSchema;
//console.log(nodesGraph);

let edgesJson = mySqlDBSchemaGraph.getEdgesGraph(uniqueEdgeNames,edgesAndNodesCombined);
//console.log(JSON.stringify(edgesJson,null,4));

let schemaGraph = jsonMerger.mergeObjects([nodesGraph, edgesJson]);
//console.log(JSON.stringify(schemaGraph,null,4));


//get the Ed version of the edge graph
const converter = new Converter();
let edEdgesGraph = converter.convertToEdEdgesGraph(uniqueEdgeNames, edgesJson);
//console.log(JSON.stringify(edEdgesGraph,null,4));

//to comply with Ed Schema Graph
let schemaEdGraph = jsonMerger.mergeObjects([nodesGraph, edEdgesGraph]);
console.log(JSON.stringify(schemaEdGraph,null,4));
*/