org.skife.jdbi.v2.sqlobject.customizers.RegisterMapper Java Examples

The following examples show how to use org.skife.jdbi.v2.sqlobject.customizers.RegisterMapper. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example #1
Source File: TaskDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 6 votes vote down vote up
@SqlQuery("SELECT *, RESULT.ID AS RESULT_ID, RESULT.ERRNO FROM (SELECT T.TASK_ID, MT.MONITOR_ID, M.NAME AS MONITOR_NAME, T.ACCOUNT_ID, T.NAME, TASK_INTERVAL AS 'INTERVAL', CONFIG_JSON, T.STATUS, T.CREATION_TIME, T.MODIFIED_TIME FROM SNM_TASK T " +
"LEFT JOIN SNM_MONITOR_TASK MT ON MT.TASK_ID = T.TASK_ID " +
"LEFT JOIN SNM_MONITOR M ON M.MONITOR_ID = MT.MONITOR_ID " +
"WHERE T.ACCOUNT_ID = :accountId AND T.STATUS <ne> :taskDeleteStatus GROUP BY T.TASK_ID, MONITOR_ID) AS TMP " +
"LEFT JOIN ( " +
        "SELECT R.ID, R.COLLECTED_TIME, R.MONITOR_ID, R.TASK_ID, R.ERRNO " +
        "FROM SNM_NIPING_RESULT AS R " +
        "INNER JOIN  " +
        "( " +
        "SELECT MAX(RES2.ID) AS ID " +
        "FROM SNM_NIPING_RESULT RES2 " +
        "INNER JOIN ( " +
        "SELECT MAX(COLLECTED_TIME) AS T1, MONITOR_ID, TASK_ID FROM SNM_NIPING_RESULT WHERE COLLECTED_TIME <ge> :lasthour AND TYPE = :type GROUP BY TASK_ID, MONITOR_ID " +
        ") AS RES1 " +
        "ON RES2.COLLECTED_TIME = RES1.T1 AND RES1.MONITOR_ID = RES2.MONITOR_ID AND RES1.TASK_ID = RES2.TASK_ID " +
        "GROUP BY RES2.COLLECTED_TIME, RES2.TASK_ID, RES2.MONITOR_ID\n" +
        ") AS RES3 " +
        "ON R.ID = RES3.ID "+
") AS RESULT ON TMP.MONITOR_ID = RESULT.MONITOR_ID AND TMP.TASK_ID = RESULT.TASK_ID " +
" ORDER BY TMP.CREATION_TIME DESC")
@RegisterMapper(TaskMapper.class)
List<Task> selectByAccountId(@Bind("accountId") String accountId, @Bind("taskDeleteStatus") int taskDeleteStatus, @Bind("lasthour") Date lasthour, @Bind("type") int type, @Define("ne") String notEqual, @Define("ge") String greaterThan);
 
Example #2
Source File: MonitorNiPingResultDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 6 votes vote down vote up
@SqlQuery("SELECT R.TASK_ID, R.AV2, R.TR2, R.ERRNO, R.MONITOR_ID, M.MONITOR_ID, M.NAME, M.IP, M.COUNTRY, M.PROVINCE, M.CITY, M.ISP " +
        "FROM SNM_NIPING_RESULT AS R " +
        "INNER JOIN " +
        "( " +
        "SELECT MAX(RES2.ID) AS ID " +
        "FROM SNM_NIPING_RESULT RES2 " +
        "INNER JOIN ( " +
        "SELECT MAX(COLLECTED_TIME) AS T1, MONITOR_ID, TASK_ID FROM SNM_NIPING_RESULT WHERE ACCOUNT_ID = :accountId AND TASK_ID = :taskId AND TYPE = :type GROUP BY TASK_ID, MONITOR_ID " +
        ") AS RES1 " +
        "ON RES2.COLLECTED_TIME = RES1.T1 AND RES1.MONITOR_ID = RES2.MONITOR_ID AND RES1.TASK_ID = RES2.TASK_ID " +
        "GROUP BY RES2.COLLECTED_TIME, RES2.TASK_ID, RES2.MONITOR_ID " +
        ") AS RES3 " +
        "ON R.ID = RES3.ID " +
        "INNER JOIN SNM_MONITOR M ON M.MONITOR_ID = R.MONITOR_ID")
@RegisterMapper(MonitorNiPingResultMapper.class)
List<MonitorNiPingResult> selectByTaskId(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Bind("type") int type);
 
Example #3
Source File: MonitorNiPingResultDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT R.TASK_ID, NAME FROM SNM_NIPING_RESULT R INNER JOIN SNM_TASK T ON T.TASK_ID = R.TASK_ID WHERE T.ACCOUNT_ID = " +
        ":accountId GROUP BY R.TASK_ID")
@RegisterMapper(ResultTaskMapper.class)
List<Task> selectTasks(@Bind("accountId") String accountId);
 
Example #4
Source File: ArticleDao.java    From rufus with MIT License 4 votes vote down vote up
@RegisterMapper(SourceMapper.class)
@SqlQuery("select * from sources where :tag = any (tags) and userid = :id")
List<Source> getSourcesByTag(@Bind("id") long id, @Bind("tag") String tag);
 
Example #5
Source File: ArticleDao.java    From rufus with MIT License 4 votes vote down vote up
@RegisterMapper(SourceMapper.class)
@SqlQuery("select * from publicsources")
List<Source> getPublicSources();
 
Example #6
Source File: ArticleDao.java    From rufus with MIT License 4 votes vote down vote up
@RegisterMapper(SourceMapper.class)
@SqlQuery("select * from rufususer left outer join sources on rufususer.userid = sources.userid where rufususer.userid = :id")
List<Source> getSources(@Bind("id") long id);
 
Example #7
Source File: UserDao.java    From rufus with MIT License 4 votes vote down vote up
@RegisterMapper(UserMapper.class)
@SqlUpdate("delete from rufususer where email = :email")
void deleteUser(@Bind("email") String email);
 
Example #8
Source File: UserDao.java    From rufus with MIT License 4 votes vote down vote up
@RegisterMapper(UserMapper.class)
@SqlUpdate("insert into rufususer (EMAIL, PASSWORD) values (:email, :password)")
void addUser(@BindBean User user);
 
Example #9
Source File: UserDao.java    From rufus with MIT License 4 votes vote down vote up
@RegisterMapper(UserMapper.class)
@SqlQuery("select * from rufususer where EMAIL = :email")
User findByEmail(@Bind("email") String email);
 
Example #10
Source File: UserDao.java    From rufus with MIT License 4 votes vote down vote up
@RegisterMapper(UserMapper.class)
@SqlQuery("select * from rufususer")
List<User> getAll();
 
Example #11
Source File: MonitorNiPingResultDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT R.COLLECTED_TIME, R.START_TIME, R.END_TIME, R.TYPE, R.AV2, R.ERRNO, R.ERRMSG, R.TR2 " +
        "FROM SNM_NIPING_RESULT R " +
        "WHERE R.ACCOUNT_ID = :accountId AND R.MONITOR_ID = :monitorId AND R.TASK_ID = :taskId AND R.COLLECTED_TIME <ge> :time <condition> ORDER BY R.COLLECTED_TIME DESC")
@RegisterMapper(MonitorNiPingResultListMapper.class)
List<MonitorNiPingResult> selectAll(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Bind("monitorId") String monitorId, @Bind("time") long time, @Define("condition") String condition, @Define("ge") String ge);
 
Example #12
Source File: MonitorNiPingResultDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT R.COLLECTED_TIME, R.START_TIME, R.END_TIME, R.TYPE, R.AV2, R.ERRNO, R.ERRMSG, R.TR2 " +
        "FROM SNM_NIPING_RESULT R " +
        "WHERE R.ACCOUNT_ID = :accountId AND R.MONITOR_ID = :monitorId AND R.TASK_ID = :taskId AND R.COLLECTED_TIME <ge> :time <condition> ORDER BY R.COLLECTED_TIME DESC <page>")
@RegisterMapper(MonitorNiPingResultListMapper.class)
List<MonitorNiPingResult> select(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Bind("monitorId") String monitorId, @Bind("time") long time, @Define("condition") String condition, @Define("page") String page, @Define("ge") String ge);
 
Example #13
Source File: MonitorNiPingResultDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT R.TYPE, R.ERRNO " +
        "FROM SNM_NIPING_RESULT R " +
        "WHERE R.ACCOUNT_ID = :accountId AND R.MONITOR_ID = :monitorId AND R.TASK_ID = :taskId AND R.COLLECTED_TIME <ge> :time <condition> ")
@RegisterMapper(MonitorNiPingResultUsableMapper.class)
List<MonitorNiPingResult> getMonitorNiPingResult(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Bind("monitorId") String monitorId, @Bind("time") long time, @Define("ge") String ge);
 
Example #14
Source File: MonitorNiPingResultDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT R.COLLECTED_TIME, R.AV2 AS VALUE " +
        "FROM SNM_NIPING_RESULT R " +
        "WHERE R.ACCOUNT_ID = :accountId AND R.MONITOR_ID = :monitorId AND R.TASK_ID = :taskId AND TYPE = :type AND R.COLLECTED_TIME <ge> :time AND R.AV2 IS NOT NULL <condition> ORDER BY R.COLLECTED_TIME")
@RegisterMapper(MetricsMapper.class)
List<Metrics> selectAVMetrics(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Bind("monitorId") String monitorId, @Bind("type") int type, @Bind("time") long time, @Define("ge") String ge);
 
Example #15
Source File: MonitorNiPingResultDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT R.COLLECTED_TIME, R.TR2 AS VALUE " +
        "FROM SNM_NIPING_RESULT R " +
        "WHERE R.ACCOUNT_ID = :accountId AND R.MONITOR_ID = :monitorId AND R.TASK_ID = :taskId AND TYPE = :type AND R.COLLECTED_TIME <ge> :time AND R.TR2 IS NOT NULL ORDER BY R.COLLECTED_TIME")
@RegisterMapper(MetricsMapper.class)
List<Metrics> selectTRMetrics(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Bind("monitorId") String monitorId, @Bind("type") int type, @Bind("time") long time, @Define("ge") String ge);
 
Example #16
Source File: MonitorNiPingResultDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT M.MONITOR_ID, M.NAME, M.IP FROM (SELECT MONITOR_ID FROM SNM_NIPING_RESULT WHERE ACCOUNT_ID = :accountId AND TASK_ID = :taskId GROUP BY MONITOR_ID) TMP " +
        " INNER JOIN SNM_MONITOR M ON M.MONITOR_ID = TMP.MONITOR_ID <condition>")
@RegisterMapper(ResultMonitorMapper.class)
List<Monitor> selectMonitors(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Define("condition") String condition);
 
Example #17
Source File: UserDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT USER_ID, ACCOUNT_ID, NAME, PASSWORD, PASSWORD_SALT, LOGIN_NAME FROM SNM_USER " +
        " WHERE LOGIN_NAME = :loginName AND STATUS = :status")
@RegisterMapper(UserMapper.class)
public User getUser(@Bind("loginName") String loginName, @Bind("status") int status);
 
Example #18
Source File: MonitorNiPingResultDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT TASK_ID, ERRNO, ERRNO, TR2, AV2, M.MONITOR_ID, M.NAME, M.IP, M.COUNTRY, M.PROVINCE, M.CITY, M.ISP FROM SNM_NIPING_RESULT R " +
        "INNER JOIN SNM_MONITOR M ON M.MONITOR_ID = R.MONITOR_ID " +
        "WHERE R.ACCOUNT_ID = :accountId AND R.TASK_ID = :taskId AND TYPE = :type AND collected_Time <ge> :startDate")
@RegisterMapper(MonitorNiPingResultMapper.class)
List<MonitorNiPingResult> selectByTaskId(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Bind("startDate") long startTime, @Bind("type") int type, @Define("ge") String ge);
 
Example #19
Source File: AccessCredentialsDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT TOKEN, ACCOUNT_ID, COMMENT, EXPIRY_DATE, CREATION_TIME, MODIFIED_TIME FROM SNM_ACCESS_CREDENTIALS " +
        " WHERE TOKEN = :token")
@RegisterMapper(AccessCredentialsMapper.class)
public AccessCredentials getCredentialsByToken(@Bind("token") String token);
 
Example #20
Source File: TaskDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT T.TASK_ID, T.NAME FROM SNM_TASK T " +
        "INNER JOIN SNM_NIPING_RESULT R ON T.TASK_ID = R.TASK_ID " +
        "WHERE T.ACCOUNT_ID = :accountId GROUP BY TASK_ID")
@RegisterMapper(TaskMapper.class)
List<Task> selectTasksWithResult(@Bind("accountId") String accountId);
 
Example #21
Source File: TaskDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT * FROM (SELECT SNM_TASK.TASK_ID, MONITOR_ID, ACCOUNT_ID, NAME, TASK_INTERVAL AS 'INTERVAL', CONFIG_JSON, STATUS, CREATION_TIME, MODIFIED_TIME FROM SNM_TASK LEFT JOIN SNM_MONITOR_TASK ON SNM_MONITOR_TASK.TASK_ID = SNM_TASK.TASK_ID " +
        " WHERE ACCOUNT_ID = :accountId AND SNM_TASK.TASK_ID = :taskId AND SNM_TASK.STATUS <ne> :taskDeleteStatus) AS TMP GROUP BY MONITOR_ID")
@RegisterMapper(TaskMapper.class)
List<Task> get(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Bind("taskDeleteStatus") int taskDeleteStatus, @Define("ne") String notEqual);
 
Example #22
Source File: TaskDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT TASK_ID, ACCOUNT_ID, NAME, TASK_INTERVAL AS 'INTERVAL', " +
        " CONFIG_JSON, STATUS, CREATION_TIME, MODIFIED_TIME FROM SNM_TASK " +
        "WHERE ACCOUNT_ID = :accountId")
@RegisterMapper(TaskMapper.class)
List<Task> selectByAccountId(@Bind("accountId") String accountId);
 
Example #23
Source File: TaskDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT SNM_TASK.TASK_ID, MONITOR_ID, ACCOUNT_ID, NAME, TASK_INTERVAL AS 'INTERVAL', CONFIG_JSON, STATUS, CREATION_TIME, MODIFIED_TIME FROM SNM_TASK INNER JOIN SNM_MONITOR_TASK ON SNM_MONITOR_TASK.TASK_ID = SNM_TASK.TASK_ID " +
        " WHERE SNM_MONITOR_TASK.MONITOR_ID = :monitorId AND REDISPATCHER = :needRedispatcher AND STATUS = :taskEnableStatus")
@MaxRows(1)
@RegisterMapper(TaskMapper.class)
Task getNextRestartTask(@Bind("monitorId") String monitorId, @Bind("needRedispatcher") int needRedispatcher, @Bind("taskEnableStatus") int taskEnableStatus) ;
 
Example #24
Source File: TaskDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT SNM_TASK.TASK_ID, MONITOR_ID, ACCOUNT_ID, NAME, TASK_INTERVAL AS 'INTERVAL', CONFIG_JSON, STATUS, CREATION_TIME, MODIFIED_TIME FROM SNM_TASK INNER JOIN SNM_MONITOR_TASK ON SNM_MONITOR_TASK.TASK_ID = SNM_TASK.TASK_ID " +
        " WHERE SNM_MONITOR_TASK.MONITOR_ID = :monitorId AND SNM_MONITOR_TASK.TASK_ID NOT IN (<runningTaskIds>) AND STATUS = :taskEnableStatus AND REDISPATCHER <ne> :redispatcher")
@MaxRows(1)
@RegisterMapper(TaskMapper.class)
Task getNextStartTask(@Bind("monitorId") String monitorId, @BindIn("runningTaskIds") List<String> runningTaskIds, @Bind("taskEnableStatus") int taskEnableStatus, @Define("ne") String notEqual, @Bind("redispatcher") int redispatcher) ;
 
Example #25
Source File: MonitorDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT SNM_MONITOR.MONITOR_ID, VERSION, ACCOUNT_ID, NAME, COUNTRY, PROVINCE, CITY, ISP, AREA, IP, NIPING_T, STATUS, CREATION_TIME, MODIFIED_TIME FROM SNM_MONITOR INNER JOIN SNM_MONITOR_TASK " +
        " ON SNM_MONITOR.MONITOR_ID = SNM_MONITOR_TASK.MONITOR_ID" +
        " WHERE ACCOUNT_ID = :accountId AND TASK_ID = :taskId <condition>")
@RegisterMapper(MonitorMapper.class)
List<Monitor> selectMonitors(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Define("condition") String condition);
 
Example #26
Source File: MonitorDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT MONITOR_ID, VERSION, ACCOUNT_ID, NAME, COUNTRY, PROVINCE, CITY, ISP, AREA, IP, NIPING_T, STATUS, CREATION_TIME, MODIFIED_TIME FROM SNM_MONITOR " +
        " WHERE ACCOUNT_ID = :accountId")
@RegisterMapper(MonitorMapper.class)
List<Monitor> selectAllByAccountId( @Bind("accountId") String accountId);
 
Example #27
Source File: MonitorDao.java    From SAPNetworkMonitor with GNU General Public License v3.0 4 votes vote down vote up
@SqlQuery("SELECT MONITOR_ID, VERSION, ACCOUNT_ID, NAME, COUNTRY, PROVINCE, CITY, ISP, AREA, IP, NIPING_T, STATUS, CREATION_TIME, MODIFIED_TIME FROM SNM_MONITOR " +
        " WHERE ACCOUNT_ID = :accountId AND STATUS = :monitorEnableStatus")
@RegisterMapper(MonitorMapper.class)
List<Monitor> selectByAccountId( @Bind("accountId") String accountId,  @Bind("monitorEnableStatus") int status);