diff options
author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2016-04-20 12:27:32 +0300 |
---|---|---|
committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2016-04-20 13:25:42 +0300 |
commit | 1aae8a9fda184b8a8fa139d9fc4bf2aa2c6ba8a0 (patch) | |
tree | 678fb932d5bda2fdc2961c054dbaea64d81f977c /src/mod_mam_sql.erl | |
parent | Rename ejabberd_sm_odbc -> ejabberd_sm_sql (diff) |
Rename odbc to sql everywhere
Diffstat (limited to 'src/mod_mam_sql.erl')
-rw-r--r-- | src/mod_mam_sql.erl | 56 |
1 files changed, 28 insertions, 28 deletions
diff --git a/src/mod_mam_sql.erl b/src/mod_mam_sql.erl index 1f24de31..69fdf323 100644 --- a/src/mod_mam_sql.erl +++ b/src/mod_mam_sql.erl @@ -26,11 +26,11 @@ init(_Host, _Opts) -> ok. remove_user(LUser, LServer) -> - SUser = ejabberd_odbc:escape(LUser), - ejabberd_odbc:sql_query( + SUser = ejabberd_sql:escape(LUser), + ejabberd_sql:sql_query( LServer, [<<"delete from archive where username='">>, SUser, <<"';">>]), - ejabberd_odbc:sql_query( + ejabberd_sql:sql_query( LServer, [<<"delete from archive_prefs where username='">>, SUser, <<"';">>]). @@ -43,7 +43,7 @@ delete_old_messages(ServerHost, TimeStamp, Type) -> true -> [<<" and kind='">>, jlib:atom_to_binary(Type), <<"'">>] end, TS = integer_to_binary(now_to_usec(TimeStamp)), - ejabberd_odbc:sql_query( + ejabberd_sql:sql_query( ServerHost, [<<"delete from archive where timestamp<">>, TS, TypeClause, <<";">>]), ok. @@ -67,18 +67,18 @@ store(Pkt, LServer, {LUser, LHost}, Type, Peer, Nick, _Dir) -> jid:tolower(Peer)), XML = fxml:element_to_binary(Pkt), Body = fxml:get_subtag_cdata(Pkt, <<"body">>), - case ejabberd_odbc:sql_query( + case ejabberd_sql:sql_query( LServer, [<<"insert into archive (username, timestamp, " "peer, bare_peer, xml, txt, kind, nick) values (">>, - <<"'">>, ejabberd_odbc:escape(SUser), <<"', ">>, + <<"'">>, ejabberd_sql:escape(SUser), <<"', ">>, <<"'">>, TS, <<"', ">>, - <<"'">>, ejabberd_odbc:escape(LPeer), <<"', ">>, - <<"'">>, ejabberd_odbc:escape(BarePeer), <<"', ">>, - <<"'">>, ejabberd_odbc:escape(XML), <<"', ">>, - <<"'">>, ejabberd_odbc:escape(Body), <<"', ">>, + <<"'">>, ejabberd_sql:escape(LPeer), <<"', ">>, + <<"'">>, ejabberd_sql:escape(BarePeer), <<"', ">>, + <<"'">>, ejabberd_sql:escape(XML), <<"', ">>, + <<"'">>, ejabberd_sql:escape(Body), <<"', ">>, <<"'">>, jlib:atom_to_binary(Type), <<"', ">>, - <<"'">>, ejabberd_odbc:escape(Nick), <<"');">>]) of + <<"'">>, ejabberd_sql:escape(Nick), <<"');">>]) of {updated, _} -> {ok, ID}; Err -> @@ -89,10 +89,10 @@ write_prefs(LUser, _LServer, #archive_prefs{default = Default, never = Never, always = Always}, ServerHost) -> - SUser = ejabberd_odbc:escape(LUser), + SUser = ejabberd_sql:escape(LUser), SDefault = erlang:atom_to_binary(Default, utf8), - SAlways = ejabberd_odbc:encode_term(Always), - SNever = ejabberd_odbc:encode_term(Never), + SAlways = ejabberd_sql:encode_term(Always), + SNever = ejabberd_sql:encode_term(Never), case update(ServerHost, <<"archive_prefs">>, [<<"username">>, <<"def">>, <<"always">>, <<"never">>], [SUser, SDefault, SAlways, SNever], @@ -104,15 +104,15 @@ write_prefs(LUser, _LServer, #archive_prefs{default = Default, end. get_prefs(LUser, LServer) -> - case ejabberd_odbc:sql_query( + case ejabberd_sql:sql_query( LServer, [<<"select def, always, never from archive_prefs ">>, <<"where username='">>, - ejabberd_odbc:escape(LUser), <<"';">>]) of + ejabberd_sql:escape(LUser), <<"';">>]) of {selected, _, [[SDefault, SAlways, SNever]]} -> Default = erlang:binary_to_existing_atom(SDefault, utf8), - Always = ejabberd_odbc:decode_term(SAlways), - Never = ejabberd_odbc:decode_term(SNever), + Always = ejabberd_sql:decode_term(SAlways), + Never = ejabberd_sql:decode_term(SNever), {ok, #archive_prefs{us = {LUser, LServer}, default = Default, always = Always, @@ -135,8 +135,8 @@ select(LServer, JidRequestor, #jid{luser = LUser} = JidArchive, % and the client did not specify a limit using RSM then the server should % return a policy-violation error to the client." We currently don't do this % for v0.2 requests, but we do limit #rsm_in.max for v0.3 and newer. - case {ejabberd_odbc:sql_query(LServer, Query), - ejabberd_odbc:sql_query(LServer, CountQuery)} of + case {ejabberd_sql:sql_query(LServer, Query), + ejabberd_sql:sql_query(LServer, CountQuery)} of {{selected, _, Res}, {selected, _, [[Count]]}} -> {Max, Direction} = case RSM of #rsm_in{max = M, direction = D} -> {M, D}; @@ -206,8 +206,8 @@ make_sql_query(User, LServer, Start, End, With, RSM) -> {none, none, <<>>} end, ODBCType = ejabberd_config:get_option( - {odbc_type, LServer}, - ejabberd_odbc:opt_type(odbc_type)), + {sql_type, LServer}, + ejabberd_sql:opt_type(sql_type)), LimitClause = if is_integer(Max), Max >= 0, ODBCType /= mssql -> [<<" limit ">>, jlib:integer_to_binary(Max+1)]; true -> @@ -223,14 +223,14 @@ make_sql_query(User, LServer, Start, End, With, RSM) -> []; {text, Txt} -> [<<" and match (txt) against ('">>, - ejabberd_odbc:escape(Txt), <<"')">>]; + ejabberd_sql:escape(Txt), <<"')">>]; {_, _, <<>>} -> [<<" and bare_peer='">>, - ejabberd_odbc:escape(jid:to_string(With)), + ejabberd_sql:escape(jid:to_string(With)), <<"'">>]; {_, _, _} -> [<<" and peer='">>, - ejabberd_odbc:escape(jid:to_string(With)), + ejabberd_sql:escape(jid:to_string(With)), <<"'">>]; none -> [] @@ -262,7 +262,7 @@ make_sql_query(User, LServer, Start, End, With, RSM) -> _ -> [] end, - SUser = ejabberd_odbc:escape(User), + SUser = ejabberd_sql:escape(User), Query = [<<"SELECT ">>, TopClause, <<" timestamp, xml, peer, kind, nick" " FROM archive WHERE username='">>, @@ -291,14 +291,14 @@ update(LServer, Table, Fields, Vals, Where) -> <<A/binary, "='", B/binary, "'">> end, Fields, Vals), - case ejabberd_odbc:sql_query(LServer, + case ejabberd_sql:sql_query(LServer, [<<"update ">>, Table, <<" set ">>, join(UPairs, <<", ">>), <<" where ">>, Where, <<";">>]) of {updated, 1} -> {updated, 1}; _ -> - ejabberd_odbc:sql_query(LServer, + ejabberd_sql:sql_query(LServer, [<<"insert into ">>, Table, <<"(">>, join(Fields, <<", ">>), <<") values ('">>, join(Vals, <<"', '">>), <<"');">>]) |