1
22
23 package com.liferay.portal.convert.util;
24
25 import com.liferay.portal.kernel.util.StringPool;
26 import com.liferay.portal.upgrade.util.Table;
27
28 import java.sql.Types;
29
30 import java.util.ArrayList;
31 import java.util.List;
32
33
39 public class ResourcePermissionView extends Table {
40
41 public static String getActionId(String[] values) {
42 return values[4];
43 }
44
45 public static long getCompanyId(String[] values) {
46 return Long.parseLong(values[0]);
47 }
48
49 public static String getPrimaryKey(String[] values) {
50 return values[2];
51 }
52
53 public static long getRoleId(String[] values) {
54 return Long.parseLong(values[3]);
55 }
56
57 public static int getScope(String[] values) {
58 return Integer.parseInt(values[1]);
59 }
60
61 public ResourcePermissionView(String name) {
62 super("ResourcePermissionView");
63
64 List<Object[]> columns = new ArrayList<Object[]>();
65
66 columns.add(new Object[] {"companyId", Types.BIGINT});
67 columns.add(new Object[] {"scope", Types.INTEGER});
68 columns.add(new Object[] {"primKey", Types.VARCHAR});
69 columns.add(new Object[] {"roleId", Types.BIGINT});
70 columns.add(new Object[] {"actionId", Types.VARCHAR});
71
72 setColumns(columns.toArray(new Object[0][]));
73
74 _name = name;
75 }
76
77 public String getSelectSQL() throws Exception {
78 StringBuilder sb = new StringBuilder();
79
80 sb.append(_SELECT_SQL);
81 sb.append(StringPool.APOSTROPHE);
82 sb.append(_name);
83 sb.append(StringPool.APOSTROPHE);
84
85 return sb.toString();
86 }
87
88 private String _name = StringPool.BLANK;
89
90 private static final String _SELECT_SQL =
91 "SELECT Permission_.companyId, ResourceCode.scope, " +
92 "Resource_.primKey, Roles_Permissions.roleId, Permission_.actionId " +
93 "FROM Roles_Permissions, Permission_, Resource_, ResourceCode WHERE " +
94 "Permission_.permissionId = Roles_Permissions.permissionId AND " +
95 "Permission_.resourceId = Resource_.resourceId AND " +
96 "Resource_.codeId = ResourceCode.codeId AND ResourceCode.name = ";
97
98 }