diff options
| author | Mickaël Rémond <mickael.remond@process-one.net> | 2007-08-28 14:36:39 +0000 |
|---|---|---|
| committer | Mickaël Rémond <mickael.remond@process-one.net> | 2007-08-28 14:36:39 +0000 |
| commit | b0bb9a79c338323bb53cbaf6cb749b3215ee5476 (patch) | |
| tree | 6ed37e7c94bcca14418206bf65105e06ab2fcb44 /src/odbc | |
| parent | * src/mod_muc/mod_muc_room.erl: Implements muc max users option (diff) | |
* src/mod_offline_odbc.erl: Implements quota for offline messages
in relational database (EJAB-314)
* src/odbc/odbc_queries.erl: Likewise
SVN Revision: 893
Diffstat (limited to 'src/odbc')
| -rw-r--r-- | src/odbc/odbc_queries.erl | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/src/odbc/odbc_queries.erl b/src/odbc/odbc_queries.erl index 343405b26..9b0ec61a3 100644 --- a/src/odbc/odbc_queries.erl +++ b/src/odbc/odbc_queries.erl @@ -1,4 +1,4 @@ -%% Copyrigh 2006, Process-one +%% Copyrigh 2006 Process-one %% This module is intended to take into account relational databases behaviour %% differences -module(odbc_queries). @@ -36,7 +36,8 @@ set_private_data_sql/3, get_private_data/3, del_user_private_storage/2, - escape/1]). + escape/1, + count_records_where/3]). %-define(generic, true). %-define(mssql, true). @@ -309,6 +310,11 @@ escape($") -> "\\\""; escape($\\) -> "\\\\"; escape(C) -> C. +%% Count number of records in a table given a where clause +count_records_where(LServer, Table, WhereClause) -> + ejabberd_odbc:sql_query( + LServer, + ["select count(*) from ", Table, " ", WhereClause, ";"]). -endif. %% ----------------- @@ -513,4 +519,10 @@ escape($\r) -> "\\r"; escape($') -> "\''"; escape($") -> "\\\""; escape(C) -> C. + +%% Count number of records in a table given a where clause +count_records_where(LServer, Table, WhereClause) -> + ejabberd_odbc:sql_query( + LServer, + ["select count(*) from ", Table, " ", WhereClause, " with (nolock)"]). -endif. |