2 Aug
2010
2 Aug
'10
5:01 p.m.
Hi, sqlops module documentation doesn't say what the function
sql_query returns in case of DB failure. I'll do my tests but if
somebody knows I would like to know the expected return code.
Thanks a lot.
--
Iñaki Baz Castillo
<ibc(a)aliax.net>
3 Aug
3 Aug
6:48 p.m.
New subject: [sqlops] What does sql_query return in case of DB error?
On Monday 02 August 2010, Iñaki Baz Castillo wrote:
Hi, sqlops module documentation doesn't say what
the function
sql_query returns in case of DB failure. I'll do my tests but if
somebody knows I would like to know the expected return code.
Hi Iñaki,
it returns this values:
* 1 on succes
* 2 on success, but no result after query
* -1 on failure
modules_k/sqlops/sql_api.c
197:int sql_do_query(struct sip_msg *msg, sql_con_t *con, pv_elem_t *query,
Cheers,
Henning
8:04 p.m.
New subject: [sqlops] What does sql_query return in case of DB error?
2010/8/3 Henning Westerholt <henning.westerholt(a)1und1.de>de>:
On Monday 02 August 2010, Iñaki Baz Castillo wrote:
Thanks a lot for the clarification. Would make sense this information
to be added in the documentation?
Let me another question. Let's suppose the following case:
-------------------
sql_query("con1", "SELECT field1 FROM table1", "res");
sql_query("con1", "SELECT field1, field2, field3 FROM table2",
"res");
sql_result_free("res");
------------------
Is it safe? This is, can I perform a second query storing the result
in same "res" structure without freeing before? would it leak? would
be overlap in the "res" structure after the second query?
Thanks a lot.
--
Iñaki Baz Castillo
<ibc(a)aliax.net>
Hi, sqlops module documentation doesn't say
what the function
sql_query returns in case of DB failure. I'll do my tests but if
somebody knows I would like to know the expected return code.
Hi Iñaki,
it returns this values:
* 1 on succes
* 2 on success, but no result after query
* -1 on failure
modules_k/sqlops/sql_api.c
197:int sql_do_query(struct sip_msg *msg, sql_con_t *con, pv_elem_t *query,
8:11 p.m.
New subject: [sqlops] What does sql_query return in case of DB error?
On Tuesday 03 August 2010, Iñaki Baz Castillo wrote:
Hi Iñaki,
yes, i think it would be useful.
* 1 on succes
* 2 on success, but no result after query
* -1 on failure
modules_k/sqlops/sql_api.c
197:int sql_do_query(struct sip_msg *msg, sql_con_t *con, pv_elem_t
*query,
Thanks a lot for the clarification. Would make sense this information
to be added in the documentation? Let me another question. Let's suppose the
following case:
-------------------
sql_query("con1", "SELECT field1 FROM table1", "res");
sql_query("con1", "SELECT field1, field2, field3 FROM table2",
"res");
sql_result_free("res");
------------------
Is it safe? This is, can I perform a second query storing the result
in same "res" structure without freeing before? would it leak? would
be overlap in the "res" structure after the second query?
AFAIK this was discussed to some extend earlier - if i remember correctly the
second sql_query will free the first result set before executing its SQL. So
neiter the queries nor the result sets should overlap. If you looking for
something like a cfg script DB "fetch_result", then i think this is currently
not available. But of course this could be added.
Regards,
Henning
5018
days inactive
5019
days old
3 comments
2 participants
participants (2)
-
Henning Westerholt -
Iñaki Baz Castillo