X-Git-Url: https://git.auder.net/assets/config.php?a=blobdiff_plain;f=parser.js;h=f718f316aa61b3528573a54e48629a3406c8219a;hb=19addd10d9f37cc081779b9ec17f2f98ee161889;hp=8fc65edc3330eedf29ac02c7d9a9e957ab217a3f;hpb=c728aeca9ef83bb786ed0c886a2b3dc4faf3dc45;p=erdiag.git diff --git a/parser.js b/parser.js index 8fc65ed..f718f31 100644 --- a/parser.js +++ b/parser.js @@ -3,23 +3,18 @@ class ErDiags { constructor(description) { - this.entities = {}; - this.inheritances = []; - this.associations = []; - this.txt2json(description); - this.tables = []; + this.entities = { }; + this.inheritances = [ ]; + this.associations = [ ]; + this.tables = { }; + this.mcdParsing(description); + this.mldParsing(); // Cache SVG graphs returned by server (in addition to server cache = good perfs) this.mcdGraph = ""; this.mldGraph = ""; this.sqlText = ""; } - static get TYPES() - { - // SQLite storage classes without null - return ["integer","real","text","blob"]; - } - static get CARDINAL() { return { @@ -32,12 +27,12 @@ class ErDiags }; } - ////////////////// - // PARSING STAGE 1 - ////////////////// + /////////////////////////////// + // PARSING STAGE 1: text to MCD + /////////////////////////////// // Parse a textual description into a json object - txt2json(text) + mcdParsing(text) { let lines = text.split("\n"); lines.push(""); //easier parsing: always empty line at the end @@ -109,14 +104,8 @@ class ErDiags if (parenthesis !== null) { let sqlClues = parenthesis[1]; - let qualifiers = sqlClues; - let firstWord = sqlClues.match(/[^\s]+/)[0]; - if (ErDiags.TYPES.includes(firstWord)) - { - field.type = firstWord; - qualifiers = sqlClues.substring(firstWord.length).trim(); - } - field.qualifiers = qualifiers; + field.type = sqlClues.match(/[^\s]+/)[0]; //type is always the first indication (mandatory) + field.qualifiers = sqlClues.substring(field.type.length).trim(); } attributes.push(field); } @@ -166,9 +155,95 @@ class ErDiags return assoce; } - ////////////////// - // PARSING STAGE 2 - ////////////////// + ////////////////////////////// + // PARSING STAGE 2: MCD to MLD + ////////////////////////////// + + // From entities + relationships to tables + mldParsing() + { + // Pass 1: initialize tables + Object.keys(this.entities).forEach( name => { + let newTable = [ ]; //array of fields + this.entities[name].attributes.forEach( attr => { + newTable.push({ + name: attr.name, + type: attr.type, + isKey: attr.isKey, + qualifiers: attr.qualifiers, + }); + }); + this.tables[name] = newTable; + }); + // Pass 2: parse associations, add foreign keys when cardinality is 0,1 or 1,1 + this.associations.forEach( a => { + let newTableAttrs = [ ]; + a.entities.forEach( e => { + if (['?','1'].includes(e.card[0])) + { + // Foreign key apparition (for each entity in association minus current one, for each identifying attribute) + a.entities.forEach( e2 => { + if (e2.name == e.name) + return; + e2.attributes.forEach( attr => { + if (attr.isKey) + { + this.tables[e.name].push({ + isKey: e.card.length >= 2 && e.card[1] == 'R', //"weak tables" foreign keys become part of the key + name: "#" + e2.name + "_" + attr.name, + type: attr.type, + qualifiers: "foreign key references " + e2.name + " " + (e.card[0]=='1' : "not null" : ""), + ref: e2.name, //easier drawMld function (fewer regexps) + }); + } + }); + }); + } + else + { + // Add all keys in current entity + let fields = e.attributes.filter( attr => { return attr.isKey; }); + newTableAttrs.push({ + fields: fields, + entity: e.name, + }); + } + } + if (newTableAttrs.length > 1) + { + // Ok, really create a new table + let newTable = { + name: a.name || newTableAttrs.map( item => { return item.entity; }).join("_"); + fields: [ ], + }; + newTableAttrs.forEach( item => { + item.fields.forEach( f => { + newTable.fields.push({ + name: item.entity + "_" + f.name, + isKey: true, + type: f.type,, + qualifiers: (f.qualifiers+" " || "") + "foreign key references " + item.entity + " not null", + ref: item.entity, + }); + }); + }); + // Add relationship potential own attributes + a.attributes.forEach( attr => { + newTable.fields.push({ + name: attr.name, + isKey: false, + type: attr.type, + qualifiers: attr.qualifiers, + }); + }); + this.tables[newTable.name] = newTable.fields; + } + }); + } + + ///////////////////////////////// + // DRAWING + GET SQL FROM PARSING + ///////////////////////////////// static AjaxGet(dotInput, callback) { @@ -261,9 +336,7 @@ class ErDiags mcdDot += 'node [shape=rectangle, style=rounded];\n'; let assoceCounter = 0; _.shuffle(this.associations).forEach( a => { - let name = !!a.name && a.name.length > 0 - ? a.name - : '_assoce' + assoceCounter++; + let name = a.name || "_assoce" + assoceCounter++; if (mcdStyle == "bubble") { mcdDot += '"' + name + '" [shape="diamond", style="filled", color="lightgrey", label="' + name + '"'; @@ -285,12 +358,12 @@ class ErDiags } else { - let label = name; + let label = '<' + name + '>'; if (!!a.attributes) { a.attributes.forEach( attr => { let attrLabel = (attr.isKey ? '#' : '') + attr.name; - label += '\\n<' + attrLabel + '>'; + label += '\\n' + attrLabel; }); } mcdDot += '"' + name + '" [color="lightgrey", label="' + label + '"'; @@ -314,7 +387,7 @@ class ErDiags }); } - // "Modèle logique des données" + // "Modèle logique des données", from MCD without anomalies // TODO: this one should draw links from foreign keys to keys (port=... in
' + name + ' |
' + label + ' |
" + sqlText + "
";
}
}