Wt::Dbo BYTEA and BLOB type
Added by Freddy Martinez Garcia over 9 years ago
Hy guys...
how can I use BYTEA and BLOB type with Wt::Dbo??? cause I need to save some files into my db using the ORM of the framework...
is that possible ??
regards
Replies (3)
RE: Wt::Dbo BYTEA and BLOB type - Added by Wim Dumon over 9 years ago
Hello Freddy,
I believe an std::vector is saved as a blob type in the database. You can write your own traits classes to define how your raw data structures are to be stored in the database, if Wt::Dbo does not know them. There are a few included in Dbo by default, see Wt/Dbo/StdSqlTraits and its .C file.
Wim.
RE: Wt::Dbo BYTEA and BLOB type - Added by Freddy Martinez Garcia over 9 years ago
You can write your own traits classes to define how your raw data structures are to be stored in the database, if Wt::Dbo does not know them.
There is some example about it ??
I was looking for something like WFile or something like that and aI didn't find nothing. Lokking for more deep, I have found Wt::Dbo::backend::Postgres::blobType()
this method return a char*, which should be the file content, but, How can I define a field like BLOB?? Using a std::vector could be, but I must use bind() function ?? how can I do that ???
that is my doubt my friend !!!
I'm new with witty...
regards
RE: Wt::Dbo BYTEA and BLOB type - Added by Wim Dumon over 9 years ago
Hello Freddy,
Take a look at the documentation of Wt/Dbo/SqlTraits, and at Wt/Dbo/StdSqlTraits and Wt/Dbo/StdSqlTraits.C, and at WtSqlTraits and WtSqlTraits.C in the Wt source code for example implementations of traits classes. To map your own data structures on Dbo types, you can write a traits class. To store a file as a blob in the database, you can either store the file's contents in a std::vector (for which the traits class already exists), or write one of your own.
Best regards,
Wim.