csudijo/assets/sqlTasks.js
2023-10-03 07:57:37 +02:00

31 lines
1.0 KiB
JavaScript

const fs = require('fs')
const path = require('path')
let sqlTasks = require('./sqlTasks.json')
const os = require('os');
const getSqlTasks = () => {
return new Promise((resolve, reject) => {
fs.readFile(path.join(__dirname, "../lekerdezesek/lekerdezesek.sql"), 'utf8', (err, data) => {
if (err) {
reject(err)
} else {
let sqlQueriesFromFile = data.split("***").splice(1)
sqlQueriesFromFile.forEach(sqlQuery => {
let lines = sqlQuery.split(os.EOL)
const id = lines[1].split(".")[0]
lines = lines.splice(2)
if (lines.length > 0) {
const sqlQueryText = lines.reduce((sql, line) => sql + " " + line).trim()
let sqlTask = sqlTasks.filter(task => task.id == id)[0]
sqlTask.sql = sqlQueryText
}
})
resolve(sqlTasks)
}
})
})
}
module.exports = getSqlTasks