cppcms-users

[Cppcms-users] dbixx and time()

[augustin <aug...@ov...>]

Hello,

What's the proper way to use Unix timestamps in dbixx queries?

I have:

		dbixx::session sql;
		// ...
                time_t t = time(NULL);
                sql << "SELECT COUNT(*) FROM table WHERE time < ?", t;
                dbixx::row r;
                sql.single(r);
                int count;
                r >> count;

but it won't compile:


In file included from main.cpp:3:
/usr/local/include/dbixx/dbixx.h: In member function ‘dbixx::session& 
dbixx::session::operator,(T) [with T = long int]’:
main.cpp:170:   instantiated from here
/usr/local/include/dbixx/dbixx.h:148: error: call of overloaded ‘bind(long 
int&, bool)’ is ambiguous
/usr/local/include/dbixx/dbixx.h:128: note: candidates are: void 
dbixx::session::bind(const std::string&, bool) <near match>
/usr/local/include/dbixx/dbixx.h:129: note:                 void 
dbixx::session::bind(const long long int&, bool)
/usr/local/include/dbixx/dbixx.h:130: note:                 void 
dbixx::session::bind(const long long unsigned int&, bool)
/usr/local/include/dbixx/dbixx.h:131: note:                 void 
dbixx::session::bind(const int&, bool)
/usr/local/include/dbixx/dbixx.h:132: note:                 void 
dbixx::session::bind(const unsigned int&, bool)
/usr/local/include/dbixx/dbixx.h:133: note:                 void 
dbixx::session::bind(const double&, bool)
make: *** [learn] Error 1

thanks,

Augustin.


-- 
Friends: http://www.reuniting.info/ http://activistsolutions.org/
My projects:
http://astralcity.org/ http://3enjeux.overshoot.tv/ http://linux.overshoot.tv/ 
http://overshoot.tv/ http://charityware.info/ http://masquilier.org/
http://openteacher.info/ http://minguo.info/ 
http://www.wechange.org/ http://searching911.info/












.

Re: [Cppcms-users] dbixx and time()

[Artyom <art...@ya...>]

> Hello,
> 
> What's the proper way to use Unix timestamps in dbixx  queries?

Depending on how do you save it in the DB,
if you save it as a number, then just operate over time_t as numeric value.

If you save it as datatime then you should use std::tm - i.e. convert time_t to 
std::tm
and then save it or load it from DB (see man localtime_r, mktime)

Artyom


      

Re: [Cppcms-users] dbixx and time()

[augustin <aug...@ov...>]

On Thursday 14 October 2010 08:25:41 pm Artyom wrote:
> > 
> > What's the proper way to use Unix timestamps in dbixx  queries?
> 
> Depending on how do you save it in the DB,
> if you save it as a number, then just operate over time_t as numeric value.
> 

I save it as an integer.
The problem is that the code won't compile:

	/usr/local/include/dbixx/dbixx.h:148: error: call of overloaded ‘bind(long 
int&, bool)’ is ambiguous.

Augustin.

-- 
Friends: http://www.reuniting.info/ http://activistsolutions.org/
My projects:
http://astralcity.org/ http://3enjeux.overshoot.tv/ http://linux.overshoot.tv/ 
http://overshoot.tv/ http://charityware.info/ http://masquilier.org/
http://openteacher.info/ http://minguo.info/ 
http://www.wechange.org/ http://searching911.info/












.

Re: [Cppcms-users] dbixx and time()

[Artyom <art...@ya...>]

> 
> I save  it as an integer.
> The problem is that the code won't  compile:
> 
>     /usr/local/include/dbixx/dbixx.h:148: error:  call of overloaded ‘bind(long 
>
> int&, bool)’ is  ambiguous.
> 
> Augustin.
>

Yes, you are right,

cast it to long long it and this would work.

       time_t t = time(NULL);
       sql << "SELECT COUNT(*) FROM table WHERE time < ?", static_cast<long long 
int>(t);

You may open a bug/feature ticket to show that bind/fetch member functions 
require better overloading.

Artyom


      

Re: [Cppcms-users] dbixx and time()

[augustin <aug...@ov...>]

On Thursday 14 October 2010 09:12:42 pm Artyom wrote:
>        time_t t = time(NULL);
>        sql << "SELECT COUNT(*) FROM table WHERE time < ?", static_cast<long
>  long int>(t);

Thanks a lot. It works this way.

If anybody is interested, here is the related ticket:
 
https://sourceforge.net/tracker/?func=detail&aid=3087401&group_id=209965&atid=1011835


Augustin.

-- 
Friends: http://www.reuniting.info/ http://activistsolutions.org/
My projects:
http://astralcity.org/ http://3enjeux.overshoot.tv/ http://linux.overshoot.tv/ 
http://overshoot.tv/ http://charityware.info/ http://masquilier.org/
http://openteacher.info/ http://minguo.info/ 
http://www.wechange.org/ http://searching911.info/












.