sqlpp11-connector-odbc v0.01 about sqlpp11 HOT 5 CLOSED

Hi,

That sounds very promising! As far as I can tell from your description, there are no critical issues.

Regarding encoding: I use sqlpp11 with UTF-8 most of the time.

I haven't really thought about wide strings yet. Assuming you don't need table or column names to be presented internally as wide character sequences, the main thing would be to allow wide character strings as text, I think. That might be just a few lines of code in the main library, actually. And then you could work with a serializer that produces SQL with wide characters...

Maybe you want to experiment with that?

Let me know when you think it is ready to be tested or used by others. I will add a link to sqlpp11's readme.

from sqlpp11.

I use UTF-8 myself as well because I'm mainly a Linux developer. When I do have to do Windows I always just do everything in ASCII because wide characters make no sense to me in a UTF-8 enabled world.

I think I should test update, remove, and the dynamic_ variants before I'd say it is ready, but if those behave the same way as either select or insert I'd say it should be ready now. BTW, is there a way to iterate through a results row by column, say for printing the values? In my ODBCTest.cpp I've got some functions to print out the returned results, but it would be nice if I could iterate over the columns instead of breaking everything up into different lines (especially since "NULL" isn't the same type as a given column so I can't use a ternary operator).

from sqlpp11.

As of now, there is no way to iterate through the columns. But it should be quite simple to add an accept method that takes a visitor argument.

Actually, there already are such methods, see for instance _bind() in result_row.h.

You could either submit a pull request with an accept method or write an issue (the latter will probably take a few days to get dealt with).

from sqlpp11.

Hi,

Any update on the odbc connector? Do you think it makes sense to link to it already?

Best,

Roland

from sqlpp11.

Yes link away. For some reason I thought you meant binary link instead of hyper link.

I tested insert, update, select, and delete. Should work fine, though I personally am considering it experimental until I finish a project using it.

from sqlpp11.