miller
发布于

nodejs 操作 mysql html转markdown

  • npm init
  • install package
 "dependencies": {
    "mysql": "^2.18.1",
    "node-html-markdown": "^1.3.0"
  }
  • code

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();

浏览 (360)
点赞
收藏
评论