An MySQL/PostgresSQL client lib ( copy from ejabberd )

$ make

-compile({parse_transform, z_sql_pt}).

get_last(Pool, LUser) -> z_mysql:sql_query(Pool, ?SQL("select @(seconds)d, @(state)s from last" " where username=%(LUser)s")).

set_last_t(Pool, LUser, TimeStamp, Status) -> ?SQL_UPSERT(Pool, "last", ["!username=%(LUser)s", "seconds=%(TimeStamp)d", "state=%(Status)s"]).

del_last(Pool, LUser) -> z_mysql:sql_query(Pool,?SQL("delete from last where username=%(LUser)s")).