Statements should support setting and retrieving BLOB columns about squeal HOT 6 CLOSED

yep, it would be great.
I was just started over with your wrapper and I'm stuck because I can't see something to get blob columns.
May be I'm gonna write by myself the implementation and pull over here

from squeal.

might it helps.
do you think is better to return NSData or [Bytes]?

public func blobValue(columnName:String) -> Bool? {
    if let columnIndex = indexOfColumnNamed(columnName) {
        return boolValueAtIndex(columnIndex)
    } else {
        return nil
    }
}

public func blobValueAtIndex(columnIndex:Int) -> NSData? {
    if sqliteStatement == nil {
        return nil
    }
    let blobPtr = sqlite3_column_blob(sqliteStatement, Int32(columnIndex))
    let blobSize = sqlite3_column_bytes(sqliteStatement, Int32(columnIndex))
    let blob = NSData(bytes: blobPtr, length: Int(blobSize))
    return blob
}

from squeal.

I would think NSData for now, because most Objective-C libraries use it. But that's a question I asked myself as well.

How have other Swift libraries worked with byte arrays?

from squeal.

nope!

from squeal.

Thanks @progeny ! There was a bit more work needed to support NULL and empty blobs, plus some work to bind BLOBs.

But BLOBs work now, and I hope it helps!

from squeal.

Thank you very much!

Inviato da iPhone

Il giorno 14/set/2014, alle ore 20:56, Christian Niles [email protected] ha scritto:

Thanks @progeny ! There was a bit more work needed to support NULL and empty blobs, plus some work to bind BLOBs.

But BLOBs work now, and I hope it helps!

—
Reply to this email directly or view it on GitHub.

from squeal.