@nyffels/mynodeorm - npm Package Compare versions

Comparing version 1.0.0-alpha121 to 1.0.0-alpha122

dist/app.js

@@ -171,4 +171,5 @@ #! /usr/bin/env node
                 }
-                columnSql.push(`INDEX \`fk_${table}_${key.sourceColumn}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`);
-                columnSql.push(`CONSTRAINT \`fk_${table}_${key.sourceColumn}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`);
+                const fName = `${table}_${key.sourceColumn}`.substring(0, 57);
+                columnSql.push(`INDEX \`fk_${fName}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`);
+                columnSql.push(`CONSTRAINT \`fk_${fName}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`);
             }
@@ -380,4 +381,5 @@ const sql = `CREATE TABLE ${table}(${columnSql.join(', ')});`;
                     }
-                    lines.push(`ADD INDEX \`fk_${table}_${key.sourceColumn}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`);
-                    lines.push(`ADD CONSTRAINT \`fk_${table}_${key.sourceColumn}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`);
+                    const fName = `${table}_${key.sourceColumn}`.substring(0, 57);
+                    lines.push(`ADD INDEX \`fk_${fName}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`);
+                    lines.push(`ADD CONSTRAINT \`fk_${fName}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`);
                 }
@@ -384,0 +386,0 @@ }

dist/logic/migration.logic.js

@@ -113,4 +113,5 @@ import path from "node:path";
                 }
-                columnSql.push(`INDEX \`fk_${table}_${key.sourceColumn}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`);
-                columnSql.push(`CONSTRAINT \`fk_${table}_${key.sourceColumn}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`);
+                const fName = `${table}_${key.sourceColumn}`.substring(0, 57);
+                columnSql.push(`INDEX \`fk_${fName}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`);
+                columnSql.push(`CONSTRAINT \`fk_${fName}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`);
             }
@@ -207,4 +208,5 @@ const sql = `CREATE TABLE ${table}(${columnSql.join(', ')});`;
                 }
-                columnSql.push(`INDEX \`fk_${table}_${key.sourceColumn}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`);
-                columnSql.push(`CONSTRAINT \`fk_${table}_${key.sourceColumn}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`);
+                const fName = `${table}_${key.sourceColumn}`.substring(0, 57);
+                columnSql.push(`INDEX \`fk_${fName}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`);
+                columnSql.push(`CONSTRAINT \`fk_${fName}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`);
             }
@@ -422,4 +424,5 @@ const sql = `CREATE TABLE ${table}(${columnSql.join(', ')});`;
                     }
-                    lines.push(`ADD INDEX \`fk_${table}_${key.sourceColumn}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`);
-                    lines.push(`ADD CONSTRAINT \`fk_${table}_${key.sourceColumn}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`);
+                    const fName = `${table}_${key.sourceColumn}`.substring(0, 57);
+                    lines.push(`ADD INDEX \`fk_${fName}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`);
+                    lines.push(`ADD CONSTRAINT \`fk_${fName}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`);
                 }
@@ -426,0 +429,0 @@ }

package.json

 {
   "name": "@nyffels/mynodeorm",
-  "version": "1.0.0-alpha121",
+  "version": "1.0.0-alpha122",
   "description": "A full-fledged ORM framework for NodeJS and MySQL with develop friendly code aimed to handle database migrations, MySQL Query builder / helper and property mapping.",
@@ -5,0 +5,0 @@ "private": false,

No alert changes

Improved metrics

Total package byte prevSize

190081

increased by0.26%

Lines of code

2626

increased by0.19%

No dependency changes