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

Olle E. Johansson writes:

27 maj 2013 kl. 12:55 skrev Juha Heinanen jh@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