5.9 mysql插入文件

1、file/insert_file.js

const fs = require('fs')
const mysql_config = require('../config/mysql_config')
const {connect, read} = require('../mysql/mysql')
/**
 *
 * @description mysql插入文件
 */
!(async () => {
    let path = mysql_config.options.insert_file.path
    let a = fs.readdirSync(path)
    let c = await connect(mysql_config.options)
    for (let i in a) {
        if (a.hasOwnProperty(i)) {
            let r = fs.readFileSync(path + '/' + a[i]).toString('hex')
            let sql = `insert  into ${mysql_config.options.insert_file.table} set ${mysql_config.options.insert_file.field1}=0x${r.toUpperCase()},${mysql_config.options.insert_file.field2}='${a[i]}'`
            await read(c, sql).then(r => {
                console.log(`The file ${a[i]} success`)
            }).catch(err => {
                console.log(err)
            })
        }
    }
    await c.end()
})()

2、config/mysql_config

module.exports = {
    options: {
        host: 'vm-mysql57.lan',
        user: 'root',
        password: 'wlh123456',
        database: 'data_jimi',
        insert_file: {
            table: 'file',
            path: 'D:\\target',
            field1: 'content',
            field2: 'filename'
        }
    }
}