diff options
| author | Alexey Shchepin <alexey@process-one.net> | 2016-02-18 18:49:14 +0300 |
|---|---|---|
| committer | Alexey Shchepin <alexey@process-one.net> | 2016-03-02 00:12:49 +0300 |
| commit | 6d7ce0237af67a0e3f143a19bb0b313661ee116b (patch) | |
| tree | 854477d68c5a18dbce05b4c90de58fb8a30c0adf /src/odbc_queries.erl | |
| parent | New parse transform for ?SQL_UPSERT and ?SQL_UPSERT_T (diff) | |
Update mod_last SQL queries to the new API
Diffstat (limited to 'src/odbc_queries.erl')
| -rw-r--r-- | src/odbc_queries.erl | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/src/odbc_queries.erl b/src/odbc_queries.erl index b6c9a36c0..283e33dfe 100644 --- a/src/odbc_queries.erl +++ b/src/odbc_queries.erl @@ -122,22 +122,22 @@ update(LServer, Table, Fields, Vals, Where) -> sql_transaction(LServer, F) -> ejabberd_odbc:sql_transaction(LServer, F). -get_last(LServer, Username) -> - ejabberd_odbc:sql_query(LServer, - [<<"select seconds, state from last where " - "username='">>, - Username, <<"'">>]). +get_last(LServer, LUser) -> + ejabberd_odbc:sql_query( + LServer, + ?SQL("select @(seconds)d, @(state)s from last" + " where username=%(LUser)s")). -set_last_t(LServer, Username, Seconds, State) -> - update(LServer, <<"last">>, - [<<"username">>, <<"seconds">>, <<"state">>], - [Username, Seconds, State], - [<<"username='">>, Username, <<"'">>]). +set_last_t(LServer, LUser, TimeStamp, Status) -> + ?SQL_UPSERT(LServer, "last", + ["!username=%(LUser)s", + "seconds=%(TimeStamp)d", + "state=%(Status)s"]). -del_last(LServer, Username) -> - ejabberd_odbc:sql_query(LServer, - [<<"delete from last where username='">>, Username, - <<"'">>]). +del_last(LServer, LUser) -> + ejabberd_odbc:sql_query( + LServer, + ?SQL("delete from last where username=%(LUser)s")). get_password(LServer, LUser) -> ejabberd_odbc:sql_query( |