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'
}
}
}