Revision 4319 trunk/libraries/libAuthenticationService/src/org/gvsig/authentication/db/QueryBuilder.java
| QueryBuilder.java | ||
|---|---|---|
| 5 | 5 |
public class QueryBuilder |
| 6 | 6 |
{
|
| 7 | 7 |
//DB table/ field names... |
| 8 |
public static final String USER_TABLE = "users"; |
|
| 8 |
public static final String USER_TABLE = "users";
|
|
| 9 | 9 |
public static final String USER_USR_COL = "name"; |
| 10 | 10 |
public static final String USER_PWD_COL = "passwd"; |
| 11 |
public static final String USER_ID = "id"; |
|
| 11 |
public static final String USER_ID = "id";
|
|
| 12 | 12 |
|
| 13 |
public static final String USER_ROLES_TABLE = "users_roles"; |
|
| 14 |
public static final String USER_ROLES_ROLES_ID_COL = "roles_id"; |
|
| 15 |
public static final String USER_ROLES_USERS_ID_COL = "users_id";
|
|
| 13 |
public static final String USER_ROLES_TABLE = "users_roles";
|
|
| 14 |
public static final String USER_ROLES_ROLES_ID_COL = "roles_id";
|
|
| 15 |
public static final String USER_ROLES_USERS_ID_COL = "users_id";
|
|
| 16 | 16 |
|
| 17 |
public static final String ROLES_TABLE = "roles"; |
|
| 18 |
public static final String ROLES_TABLE_ID_COL = "id"; |
|
| 19 |
public static final String ROLES_TABLE_NAME_COL = "name"; |
|
| 17 |
public static final String ROLES_TABLE = "roles";
|
|
| 18 |
public static final String ROLES_TABLE_ID_COL = "id";
|
|
| 19 |
public static final String ROLES_TABLE_NAME_COL = "name";
|
|
| 20 | 20 |
public static final String ROLES_TABLE_PRIORITY_COL = "priority"; |
| 21 | 21 |
|
| 22 |
public static final String ROLE_GRANTS_TABLE = "role_grants"; |
|
| 23 |
public static final String ROLE_GRANTS_GRANTS_ID_COL = "grant_description_id";
|
|
| 22 |
public static final String ROLE_GRANTS_TABLE = "role_grants";
|
|
| 23 |
public static final String ROLE_GRANTS_GRANTS_ID_COL= "grant_description_id"; |
|
| 24 | 24 |
public static final String ROLE_GRANTS_ROLES_ID_COL = "roles_id"; |
| 25 | 25 |
|
| 26 |
public static final String GRANTS_TABLE = "grants_description"; |
|
| 27 |
public static final String GRANTS_ID_COL = "id"; |
|
| 28 |
public static final String GRANTS_TYPE_COL = "type_grant"; //comprobar en BD!!!! |
|
| 29 |
public static final String GRANTS_DATA_COL = "data"; |
|
| 30 |
public static final String GRANTS_NAME_COL = "name"; |
|
| 26 |
public static final String GRANTS_TABLE = "grants_description";
|
|
| 27 |
public static final String GRANTS_ID_COL = "id";
|
|
| 28 |
public static final String GRANTS_TYPE_COL = "type_grant"; //comprobar en BD!!!!
|
|
| 29 |
public static final String GRANTS_DATA_COL = "data";
|
|
| 30 |
public static final String GRANTS_NAME_COL = "name";
|
|
| 31 | 31 |
|
| 32 |
public static final String GRANT_TYPE_TABLE = "granttype"; |
|
| 33 |
public static final String GRANT_TYPE_ID_COL = "id"; |
|
| 32 |
public static final String GRANT_TYPE_TABLE = "granttype";
|
|
| 33 |
public static final String GRANT_TYPE_ID_COL = "id";
|
|
| 34 | 34 |
public static final String GRANT_TYPE_DESCRIPTION_COL = "description"; |
| 35 |
public static final String GRANT_TYPE_NAME_COL = "name"; |
|
| 35 |
public static final String GRANT_TYPE_NAME_COL = "name";
|
|
| 36 | 36 |
|
| 37 |
private static final int MAPDATATYPE = 1; |
|
| 38 |
private static final int GVSIGCONFIGDATATYPE = 2; |
|
| 37 |
private static final int MAPDATATYPE = 1; |
|
| 38 |
private static final int GVSIGCONFIGDATATYPE = 2; |
|
| 39 |
private static final int WMSTYPE = 3; |
|
| 39 | 40 |
|
| 40 | 41 |
public static String getLoginQuery(String usr, String pwd) |
| 41 | 42 |
{
|
| ... | ... | |
| 73 | 74 |
{
|
| 74 | 75 |
return getDataGrants(roles, String.valueOf(MAPDATATYPE)); |
| 75 | 76 |
} |
| 77 |
public static String getWMSQuery(Vector roles) |
|
| 78 |
{
|
|
| 79 |
return getDataGrants(roles, String.valueOf(WMSTYPE)); |
|
| 80 |
} |
|
| 76 | 81 |
|
| 77 | 82 |
public static String getDataGrants(Vector roles, String grantType) |
| 78 | 83 |
{
|
Also available in: Unified diff