X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=scripts%2Flib%2Futil%2Fconvert_specialized.js;h=3b89903efa7d0c02a8d65bd23f8bfbc4baafa3e8;hb=8951aa4e11623aa67fee4f02c21b1323961f6863;hp=95b8d52340e179cdc498101f2380c943bf5a87db;hpb=4c9d894d9f8bf4d3f2d0457288c596c50bdb5f8f;p=xtuple diff --git a/scripts/lib/util/convert_specialized.js b/scripts/lib/util/convert_specialized.js index 95b8d5234..3b89903ef 100644 --- a/scripts/lib/util/convert_specialized.js +++ b/scripts/lib/util/convert_specialized.js @@ -50,10 +50,8 @@ regexp:true, undef:true, strict:true, trailing:true, white:true */ grade = "0", tableName = defaultSchema ? defaultSchema + ".pkgreport" : "report", description, - disableSql, updateSql, - insertSql, - enableSql; + insertSql; if (lines[3].indexOf(" ") !== 0 || lines[4].indexOf(" ") !== 0) { @@ -68,8 +66,6 @@ regexp:true, undef:true, strict:true, trailing:true, white:true */ grade = grade.substring(0, grade.indexOf("<")); } - disableSql = "ALTER TABLE " + tableName + " DISABLE TRIGGER ALL;"; - insertSql = "insert into " + tableName + " (report_name, report_descrip, " + "report_source, report_loaddate, report_grade) select " + "'" + name + "'," + @@ -87,21 +83,15 @@ regexp:true, undef:true, strict:true, trailing:true, white:true */ "where report_name = '" + name + "' and report_grade = " + grade + ";"; - enableSql = "ALTER TABLE " + tableName + " ENABLE TRIGGER ALL;"; - - return disableSql + insertSql + updateSql + enableSql; + return insertSql + updateSql; }; var convertFromScript = function (content, filename, defaultSchema) { var name = path.basename(filename, '.js'), tableName = defaultSchema ? defaultSchema + ".pkgscript" : "unknown", notes = "", //"xtMfg package", - disableSql, insertSql, - updateSql, - enableSql; - - disableSql = "ALTER TABLE " + tableName + " DISABLE TRIGGER ALL;"; + updateSql; insertSql = "insert into " + tableName + " (script_name, script_order, script_enabled, " + "script_source, script_notes) select " + @@ -117,21 +107,15 @@ regexp:true, undef:true, strict:true, trailing:true, white:true */ "$$, script_notes = '" + notes + "' " + "where script_name = '" + name + "';"; - enableSql = "ALTER TABLE " + tableName + " ENABLE TRIGGER ALL;"; - - return disableSql + insertSql + updateSql + enableSql; + return insertSql + updateSql; }; var convertFromUiform = function (content, filename, defaultSchema) { var name = path.basename(filename, '.ui'), tableName = defaultSchema ? defaultSchema + ".pkguiform" : "unknown", notes = "", //"xtMfg package", - disableSql, insertSql, - updateSql, - enableSql; - - disableSql = "ALTER TABLE " + tableName + " DISABLE TRIGGER ALL;"; + updateSql; insertSql = "insert into " + tableName + " (uiform_name, uiform_order, uiform_enabled, " + "uiform_source, uiform_notes) select " + @@ -146,9 +130,7 @@ regexp:true, undef:true, strict:true, trailing:true, white:true */ "uiform_source = $$" + content + "$$, uiform_notes = '" + notes + "' " + "where uiform_name = '" + name + "';"; - enableSql = "ALTER TABLE " + tableName + " ENABLE TRIGGER ALL;"; - - return disableSql + insertSql + updateSql + enableSql; + return insertSql + updateSql; }; exports.conversionMap = {