[sr-dev] git:master: modules/usrloc: added two new rpc commands ul.users and ul. contacts

Juha Heinanen jh at tutpro.com
Mon May 27 13:30:02 CEST 2013


Olle E. Johansson writes:

> 27 maj 2013 kl. 12:55 skrev Juha Heinanen <jh at tutpro.com>:
> 
> > +    query_str.len = snprintf(query, QUERY_LEN,
> > +			     "SELECT COUNT(DISTINCT %.*s, %.*s) FROM %.*s",
> > +			     user_col.len, user_col.s,
> > +			     domain_col.len, domain_col.s,
> > +			     table.len, table.s);
> 
> While this work in the short run, we might want to improve the db API to
> include a request for number of entries in order to support data storage
> that doesn't support raw SQL statements.

i agree, but i'm not myself expert in db api.

by the way, i didn't get any comment to this db api related question:

http://lists.sip-router.org/pipermail/sr-dev/2013-May/020062.html

-- juha



More information about the sr-dev mailing list