fs.readFile('headers.txt', 'utf-8', (err, data) => {
if (err) {
throw err;
}
const myattrs = data.split(';');
(async () => {
const db = await sqlite.open({
filename: 'mydb.db',
driver: sqlite3.Database
})
for (let attr of myattrs) {
try {
const result = await db.run(
'INSERT INTO attributes (name) VALUES (?)',
`${attr}`
)
} catch (e) {
console.log(e);
console.log(attr)
}
}
await db.close();
})()
})
ZnMucmVhZEZpbGUoJ2hlYWRlcnMudHh0JywgJ3V0Zi04JywgKGVyciwgZGF0YSkgPT4gewogICAgaWYgKGVycikgewogICAgICAgIHRocm93IGVycjsKICAgIH0KCiAgICBjb25zdCBteWF0dHJzID0gZGF0YS5zcGxpdCgnOycpOwoKICAgICAgICAgICAgKGFzeW5jICgpID0+IHsKICAgICAgICAgICAgICAgIGNvbnN0IGRiID0gYXdhaXQgc3FsaXRlLm9wZW4oewogICAgICAgICAgICAgICAgICAgIGZpbGVuYW1lOiAnbXlkYi5kYicsCiAgICAgICAgICAgICAgICAgICAgZHJpdmVyOiBzcWxpdGUzLkRhdGFiYXNlCiAgICAgICAgICAgICAgICB9KQoKICAgICAgICAgICAgICAgIGZvciAobGV0IGF0dHIgb2YgbXlhdHRycykgewogICAgICAgICAgICAgICAgICAgIHRyeSB7CiAgICAgICAgICAgICAgICAgICAgICAgIGNvbnN0IHJlc3VsdCA9IGF3YWl0IGRiLnJ1bigKICAgICAgICAgICAgICAgICAgICAgICAgICAgICdJTlNFUlQgSU5UTyBhdHRyaWJ1dGVzIChuYW1lKSBWQUxVRVMgKD8pJywKICAgICAgICAgICAgICAgICAgICAgICAgICAgIGAke2F0dHJ9YAogICAgICAgICAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAgICAgfSBjYXRjaCAoZSkgewogICAgICAgICAgICAgICAgICAgICAgICBjb25zb2xlLmxvZyhlKTsKICAgICAgICAgICAgICAgICAgICAgICAgY29uc29sZS5sb2coYXR0cikKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICB9CgogICAgICAgICAgICAgICAgYXdhaXQgZGIuY2xvc2UoKTsKICAgICAgICAgICAgfSkoKQoKfSk=