ÿØÿà JFIF ` ` ÿþ
|
Server : Apache System : Linux cloud.heroica.com.br 4.18.0-553.36.1.el8_10.x86_64 #1 SMP Wed Jan 22 03:07:54 EST 2025 x86_64 User : farolpborg ( 1053) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /var/www/node_services/apicentralquestoes/src/scripts/ |
Upload File : |
const fs = require("fs");
const questions = JSON.parse(
fs.readFileSync(__dirname + "/revalida_2024_2_final_corrigido.json", "utf-8")
);
const escapedJson = JSON.stringify(questions)
.replace(/\\/g, "\\\\")
.replace(/"/g, '\\"')
.replace(/\n/g, "\\n");
const insertSQL = `
INSERT INTO provas (
year,
edition,
total_questions,
created_at,
updated_at,
segment,
questions
) VALUES (
'2024',
'Segunda Edição',
${questions.length},
NOW(),
NOW(),
'Medicina',
"${escapedJson}"
);
`;
fs.writeFileSync(__dirname + "/insert.sql", insertSQL);
console.log("✅ Arquivo 'insert.sql' gerado com sucesso!");