1
22
23 package com.liferay.portal.convert.util;
24
25 import com.liferay.portal.kernel.util.StringUtil;
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
38 public class PermissionView extends Table {
39
40 public static String getActionId(String[] values) {
41 return values[values.length - 4];
42 }
43
44 public static long getCompanyId(String[] values) {
45 return Long.parseLong(values[values.length - 5]);
46 }
47
48 public static String getNameId(String[] values) {
49 return values[values.length - 2];
50 }
51
52 public static long getPermissionId(String[] values) {
53 return Long.parseLong(values[values.length - 6]);
54 }
55
56 public static long getPrimaryKey(String[] values) {
57 return Long.parseLong(values[0]);
58 }
59
60 public static long getResourceId(String[] values) {
61 return Long.parseLong(values[values.length - 3]);
62 }
63
64 public static int getScopeId(String[] values) {
65 return Integer.parseInt(values[values.length - 1]);
66 }
67
68 public PermissionView(String tableName, String[] primKeys) {
69 super(tableName);
70
71 List<Object[]> columns = new ArrayList<Object[]>();
72
73 for (String primKey : primKeys) {
74 columns.add(new Object[] {primKey, Types.BIGINT});
75 }
76
77 columns.add(new Object[] {"permissionId", Types.BIGINT});
78 columns.add(new Object[] {"companyId", Types.BIGINT});
79 columns.add(new Object[] {"actionId", Types.VARCHAR});
80 columns.add(new Object[] {"resourceId", Types.BIGINT});
81 columns.add(new Object[] {"name", Types.VARCHAR});
82 columns.add(new Object[] {"scope", Types.INTEGER});
83
84 setColumns(columns.toArray(new Object[0][]));
85 }
86
87 public String getSelectSQL() throws Exception {
88 return StringUtil.replace(_SELECT_SQL, "_OLD_TABLE_", getTableName());
89 }
90
91 private static final String _SELECT_SQL =
92 "SELECT _OLD_TABLE_.*, Permission_.companyId, Permission_.actionId, " +
93 "Resource_.resourceId, ResourceCode.name, ResourceCode.scope FROM " +
94 "_OLD_TABLE_, Permission_, Resource_, ResourceCode WHERE " +
95 "_OLD_TABLE_.permissionId = Permission_.permissionId AND " +
96 "Permission_.resourceId = Resource_.resourceId AND " +
97 "Resource_.codeId = ResourceCode.codeId ORDER BY " +
98 "Resource_.resourceId";
99
100 }