Example usage for org.apache.ibatis.jdbc SQL SQL

Introduction

In this page you can find the example usage for org.apache.ibatis.jdbc SQL SQL.

Prototype

SQL

Source Link

Usage

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildFindUserByMail() {
    return new SQL() {
        {//from   w  w w. j  a v  a  2s.  com
            SELECT("*");
            FROM(Tables.USERS_TABLE);
            WHERE("user_email = #{userMail}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildFindUserIDByLogin() {
    return new SQL() {
        {//  w w  w  . ja va  2  s .c o  m
            SELECT("ID");
            FROM(Tables.USERS_TABLE);
            WHERE("user_login = #{userName}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildFindUserById() {
    return new SQL() {
        {/*from w w w . j a va 2s . com*/
            SELECT("*");
            FROM(Tables.USERS_TABLE);
            WHERE("ID = #{userId.id}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildFindUserRoles() {
    return new SQL() {
        {//from   www  . j a  v a 2 s  .  c o m
            SELECT("role_name");
            FROM(Tables.USER_ROLES_TABLE);
            JOIN(Tables.ROLES_TABLE + " ON " + Tables.USER_ROLES_TABLE + ".role_id = " + Tables.ROLES_TABLE
                    + ".ID");
            WHERE("user_id = #{userId.id}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildFindUserPermissions() {
    return new SQL() {
        {// ww w.  j a  v  a  2s. c  o  m
            SELECT("permission_name");
            FROM(Tables.USER_PERMISSIONS_TABLE);
            JOIN(Tables.PERMISSIONS_TABLE + " ON " + Tables.USER_PERMISSIONS_TABLE + ".permission_id = "
                    + Tables.PERMISSIONS_TABLE + ".id");
            WHERE("user_id = #{userId.id}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildIsUserNameExists() {
    return new SQL() {
        {//  ww w .  jav a  2  s .c  o  m
            SELECT("count(1)");
            FROM(Tables.USERS_TABLE);
            WHERE("user_login = #{userName}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildIsUserMailExists() {
    return new SQL() {
        {/*from   w  w w .  j  a  va2  s  .  c om*/
            SELECT("count(1)");
            FROM(Tables.USERS_TABLE);
            WHERE("user_email = #{userMail}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildIsUserActive() {
    return new SQL() {
        {/*from  w w w .ja  va2s .  c o  m*/
            SELECT("user_status");
            FROM(Tables.USERS_TABLE);
            WHERE("user_login = #{userName}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildFindConfirmationKeyFromUser() {
    return new SQL() {
        {/*w  ww  .j a v  a  2 s  .co m*/
            SELECT("user_confirmationkey");
            FROM(Tables.USERS_TABLE);
            WHERE("ID = #{userId.id}");
        }
    }.toString();
}

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildSaveUser() {
    return new SQL() {
        {/*  ww w. java  2  s .  c o m*/
            INSERT_INTO(Tables.USERS_TABLE);
            VALUES("user_login, user_pass, user_email, user_status, user_registerdate, user_lastlogin",
                    "#{userName}, #{hashedPassword}, #{userMail}, #{isActive, typeHandler=com.blazarquant.bfp.database.typehandlers.user.ActiveUserTypeHandler}, "
                            + "#{registrationDate, typeHandler=com.blazarquant.bfp.database.typehandlers.InstantTypeHandler}, "
                            + "#{lastLogin, typeHandler=com.blazarquant.bfp.database.typehandlers.InstantTypeHandler}");
        }
    }.toString();
}