[Question] Adding UIImage as Blob about sqlite.swift HOT 5 CLOSED

Using the extensions means you can bypass Blob and not need to call datatypeValue directly. E.g.:

let uuid = Expression<Int>("uuid")
let png = Expression<UIImage?>("png")

if let insertedID = ingredientTable.insert(uuid <- createUUID() ,png <- pic) {
    println("inserted id: \(insertedID)")
}

This also means that you'll get UIImage objects directly when accessing a retrieved row (no need to translate the Blob into a UIImage yourself):

for ingredient in ingredientTable {
    let image = ingredient.get("png") // UIImage?
}

Beyond that, I've copied and pasted your code above and have had no issue compiling. Can you provide more code? I faked the missing data using the following:

let ingredientsTable = Database()["ingredients"]
func createUUID() -> Int { return 1 }
let pic = UIImage(named: "test")

from sqlite.swift.

Thanks for the clarification on the extension usage.

I did get my code above to compile when I changed png <- pic?.datatypeValue to png <- pic!.datatypeValue although I think that is not exactly what I want to be doing here.

I plan on updating my code to follow your extension instructions.

Thanks again. The project is a godsend.

from sqlite.swift.

What is png exactly? In your example, it's:

Expression<Blob?>

But I'd expect the behavior you were getting above if it were:

Expression<Blob>

from sqlite.swift.

Is it safe to close this issue now?

from sqlite.swift.

Oh yes. It's working great now! Thanks again

from sqlite.swift.