"dependencies": {
"mysql": "^2.18.1",
"node-html-markdown": "^1.3.0"
}
import { createConnection } from "mysql";
import { NodeHtmlMarkdown } from 'node-html-markdown'
var connection = createConnection({
host: 'xxxx',
user : 'xxx',
password : 'xxx',
database : 'xxx',
port:'3306'
});
var sql = "select id,content from t_article where content_type='html' limit 33"
connection.connect();
connection.query(sql, function (err, result) {
if (err) {
console.log('[SELECT ERROR] - ', err.message);
return;
}
var data = JSON.parse(JSON.stringify(result));
console.log("ret len:",result.length);
data.forEach(ele => {
var markdown = NodeHtmlMarkdown.translate(ele.content)
console.log('id: ',ele.id)
let sqlup = "UPDATE t_article SET content = ?,content_type ='markdown' WHERE Id = ?"
let sqlParmas = [markdown, ele.id]
connection.query(sqlup, sqlParmas, function (err, results) {
if (err) {
console.log('update err :', err)
throw err
}
console.log('update ret :', results)
})
// console.log(markdown);
// console.log(ele.id);
console.log('------------------------------------------------------------\n\n');
});
});
// connection.end();