2

I have few records with BLOBs im posting one record's screenshot below: enter image description here

i need to convert it back to pdf and save in a folder. here is what i have tried so far but nothing worked:

simply saving blob to file(failed)

const mysql = require('mysql');
const fs = require('fs');

const con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "SQL1234",
  database: "mydb"
});

con.connect(function(err) {
  if (err) throw err;

  const sql = 'SELECT * FROM documents WHERE idnum = 29347';

  con.query(sql, function (err, result, fields) {
    if (err) throw err;
    const row = result[0];
    const pdf = row.pdf;
    fs.writeFileSync('some.pdf', pdf);

  });

});

then converting it to string base64 and using package base64topdf

const base64 = require('base64topdf');
var bufferBase64 = pdf.toString('base64');
let decodedBase64 = base64.base64Decode(bufferBase64, 'finalpdf.pdf');

another failed attempt:

    let buffer = Buffer.from(row.pdf);
    fs.writeFile('file.pdf', buffer, 'binary', function(err) {
        if(err) {
            console.log(err);
        }else{
            console.log('file saved');
            fs.readFile('test.pdf', (err, data) => {
                res.contentType("application/pdf");
                res.send(data);//
            });
        }
    });

using blob-to-buffer:

const toBuffer = require('blob-to-buffer');
 var blob = b64toBlob(row.pdf, 'application/pdf');

 toBuffer(blob, function (err, buffer) {
   if (err) throw err

   buffer[0] // => 1
   buffer.readUInt8(1) // => 2
   let decodedBase64 = base64.base64Decode(buffer, 'myfile2.pdf');
 });

i know im doing something stupid thats y i have posted a screenshot of the blob so you know what kind of data i have. any help would be appreciated.

2

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.