| | 1 | |
|---|
| | 2 | |
|---|
| | 3 | {{{ |
|---|
| | 4 | // UserDetailsManager SQL |
|---|
| | 5 | public static final String DEF_CREATE_USER_SQL = |
|---|
| | 6 | "insert into users (username, password, enabled) values (?,?,?)"; |
|---|
| | 7 | public static final String DEF_DELETE_USER_SQL = |
|---|
| | 8 | "delete from users where username = ?"; |
|---|
| | 9 | public static final String DEF_UPDATE_USER_SQL = |
|---|
| | 10 | "update users set password = ?, enabled = ? where username = ?"; |
|---|
| | 11 | public static final String DEF_INSERT_AUTHORITY_SQL = |
|---|
| | 12 | "insert into authorities (username, authority) values (?,?)"; |
|---|
| | 13 | public static final String DEF_DELETE_USER_AUTHORITIES_SQL = |
|---|
| | 14 | "delete from authorities where username = ?"; |
|---|
| | 15 | public static final String DEF_USER_EXISTS_SQL = |
|---|
| | 16 | "select username from users where username = ?"; |
|---|
| | 17 | public static final String DEF_CHANGE_PASSWORD_SQL = |
|---|
| | 18 | "update users set password = ? where username = ?"; |
|---|
| | 19 | |
|---|
| | 20 | // GroupManager SQL |
|---|
| | 21 | public static final String DEF_FIND_GROUPS_SQL = |
|---|
| | 22 | "select group_name from groups"; |
|---|
| | 23 | public static final String DEF_FIND_USERS_IN_GROUP_SQL = |
|---|
| | 24 | "select username from group_members gm, groups g " + |
|---|
| | 25 | "where gm.group_id = g.id" + |
|---|
| | 26 | " and g.group_name = ?"; |
|---|
| | 27 | public static final String DEF_INSERT_GROUP_SQL = |
|---|
| | 28 | "insert into groups (group_name) values (?)"; |
|---|
| | 29 | public static final String DEF_FIND_GROUP_ID_SQL = |
|---|
| | 30 | "select id from groups where group_name = ?"; |
|---|
| | 31 | public static final String DEF_INSERT_GROUP_AUTHORITY_SQL = |
|---|
| | 32 | "insert into group_authorities (group_id, authority) values (?,?)"; |
|---|
| | 33 | public static final String DEF_DELETE_GROUP_SQL = |
|---|
| | 34 | "delete from groups where id = ?"; |
|---|
| | 35 | public static final String DEF_DELETE_GROUP_AUTHORITIES_SQL = |
|---|
| | 36 | "delete from group_authorities where group_id = ?"; |
|---|
| | 37 | public static final String DEF_DELETE_GROUP_MEMBERS_SQL = |
|---|
| | 38 | "delete from group_members where group_id = ?"; |
|---|
| | 39 | public static final String DEF_RENAME_GROUP_SQL = |
|---|
| | 40 | "update groups set group_name = ? where group_name = ?"; |
|---|
| | 41 | public static final String DEF_INSERT_GROUP_MEMBER_SQL = |
|---|
| | 42 | "insert into group_members (group_id, username) values (?,?)"; |
|---|
| | 43 | public static final String DEF_DELETE_GROUP_MEMBER_SQL = |
|---|
| | 44 | "delete from group_members where group_id = ? and username = ?"; |
|---|
| | 45 | public static final String DEF_GROUP_AUTHORITIES_QUERY_SQL = |
|---|
| | 46 | "select g.id, g.group_name, ga.authority " + |
|---|
| | 47 | "from groups g, group_authorities ga " + |
|---|
| | 48 | "where g.group_name = ? " + |
|---|
| | 49 | "and g.id = ga.group_id "; |
|---|
| | 50 | public static final String DEF_DELETE_GROUP_AUTHORITY_SQL = |
|---|
| | 51 | "delete from group_authorities where group_id = ? and authority = ?"; |
|---|
| | 52 | }}} |
|---|
