Simple example for blob

[Rodolfo Ochoa]

need a simple example for blob fields...
read/write...

[Russell Bradberry]

you can use either a binary string or a Buffer object to insert Blobs

[Rodolfo Ochoa]

I have this:

    fs.readFile('image.jpg', function read(err, data) {

   pool.cql(insert_query, ['Test User', 'Test User', '1234567890', data], function(err, results){

      console.log(err, results);

   });

data is already a buffer, but this throw

{ [HelenusInvalidRequestException: line 1:21725 no viable alternative at input ')'] name: 'HelenusInvalidRequestException' } undefined

what else is need?

[Rodolfo Ochoa]

previously 

create_query = " CREATE TABLE IF NOT EXISTS users ( name text, lastname text, phone text, picture blob, \

                     PRIMARY KEY (name) ) ";

and the insert query is:

    insert_query = "  INSERT INTO users (name, lastname, phone, picture) \

                      VALUES (?, ?, ?, ?); "

[Russell Bradberry]

what version of Hlenus are you using?

[Rodolfo Ochoa]

latest... fresh from npm...

[Russell Bradberry]

can you paste your CREATE TABLE schema here

[Russell Bradberry]

nevermind, i didnt notice that, ill check into this

[Rodolfo Ochoa]

should I use on the buffer:

data.toString('hex')

and on the query:

    insert_query = "  INSERT INTO users (name, lastname, phone, picture) \

                      VALUES (?, ?, ?, textAsBlob(?)); "

is this the way?

[Russell Bradberry]

it seems that now it expects the format of "0x..." for the blob data.  I'll have to change the driver to do this automagically but in the mean time you can use your original code just change the update statement to:

INSERT INTO users (name, lastname, phone, picture) VALUES (?, ?, ?, 0x?);

That should allow it to insert. 

[Rodolfo Ochoa]

thanks!!