61 lines
1.7 KiB
JavaScript
61 lines
1.7 KiB
JavaScript
|
|
e = [];
|
|
sql = [];
|
|
|
|
e['TXLCode'] = "GW101010001";
|
|
e['MessDate'] = "3333-12-31";
|
|
e['RauDate'] = "2222-11-31";
|
|
e['Lieferbox'] = 23;
|
|
e['OL1'] = 232.23;
|
|
e['OL2'] = 233.22;
|
|
e['OW1'] = 232.23;
|
|
e['OW2'] = 232.23;
|
|
e['R11'] = 23.32;
|
|
e['R12'] = 23.32;
|
|
e['R13'] = 23.32;
|
|
e['R21'] = 23.32;
|
|
e['R22'] = 23.32;
|
|
e['R23'] = 23.32;
|
|
e['R31'] = 23.32;
|
|
e['R32'] = 23.32;
|
|
e['R33'] = 23.32;
|
|
e['R41'] = 23.32;
|
|
e['R42'] = 23.32;
|
|
e['R43'] = 23.32;
|
|
e['LW'] = 23.32;
|
|
e['CW'] = 23.32;
|
|
e['InfoMessComm'] = "IMC";
|
|
e['InfoRauComm'] = "IRC";
|
|
|
|
sql.push(`INSERT INTO Bauteile (
|
|
TXLCode, Messdatum, Rauheitsdatum, Lieferbox,
|
|
OL1, OL2, OW1, OW2,
|
|
R11, R12, R13,
|
|
R21, R22, R23,
|
|
R31, R32, R33,
|
|
R41, R42, R43,
|
|
CW, LW, MessComm, RauComm
|
|
) VALUES (
|
|
"${e['TXLCode']}", "${e['MessDate']}", "${e['RauDate']}", ${e['Lieferbox']},
|
|
${e['OL1']}, ${e['OL2']}, ${e['OW1']}, ${e['OW2']},
|
|
${e['R11']}, ${e['R12']}, ${e['R13']},
|
|
${e['R21']}, ${e['R22']}, ${e['R23']},
|
|
${e['R31']}, ${e['R32']}, ${e['R33']},
|
|
${e['R41']}, ${e['R42']}, ${e['R43']},
|
|
${e['LW']}, ${e['CW']}, "${e['InfoMessComm']}", "${e['InfoRauComm']}"
|
|
) ON DUPLICATE KEY UPDATE
|
|
TXLCode = "${e['TXLCode']}", Messdatum = "${e['MessDate']}", Rauheitsdatum = "${e['RauDate"']}",
|
|
Lieferbox = "${e['Lieferbox']}",
|
|
OL1 = ${e['OL1']}, OL2 = ${e['OL2']}, OW1 = ${e['OW1']}, OW2 = ${e['OW2']},
|
|
R11 = ${e['R11']}, R12 = ${e['R12']}, R13 = ${e['R13']},
|
|
R21 = ${e['R21']}, R22 = ${e['R22']}, R23 = ${e['R23']},
|
|
R31 = ${e['R31']}, R32 = ${e['R32']}, R33 = ${e['R33']},
|
|
R41 = ${e['R41']}, R42 = ${e['R42']}, R43 = ${e['R43']},
|
|
CW = ${e['LW']}, LW = ${e['CW']}, MessComm = "${e['InfoMessComm']}", RauComm = "${e['InfoRauComm']}";`);
|
|
|
|
|
|
|
|
sql.forEach(function(e,i){
|
|
console.log("i: ", i, " | e: ", e );
|
|
})
|