|
32 | 32 | import org.apache.doris.plsql.Scope; |
33 | 33 | import org.apache.doris.plsql.Var; |
34 | 34 | import org.apache.doris.plsql.metastore.PlsqlMetaClient; |
| 35 | +import org.apache.doris.plsql.metastore.PlsqlProcedureKey; |
35 | 36 | import org.apache.doris.plsql.metastore.PlsqlStoredProcedure; |
36 | 37 | import org.apache.doris.qe.ConnectContext; |
37 | 38 |
|
38 | 39 | import org.antlr.v4.runtime.CharStreams; |
39 | 40 | import org.antlr.v4.runtime.CommonTokenStream; |
40 | 41 | import org.antlr.v4.runtime.ParserRuleContext; |
41 | 42 |
|
| 43 | +import java.text.SimpleDateFormat; |
42 | 44 | import java.util.ArrayList; |
| 45 | +import java.util.Calendar; |
43 | 46 | import java.util.HashMap; |
| 47 | +import java.util.List; |
44 | 48 | import java.util.Map; |
45 | 49 | import java.util.Optional; |
46 | 50 |
|
@@ -85,6 +89,35 @@ private String qualified(String name) { |
85 | 89 | return (ConnectContext.get().getDatabase() + "." + name).toUpperCase(); |
86 | 90 | } |
87 | 91 |
|
| 92 | + @Override |
| 93 | + public void showProcedure(List<List<String>> columns) { |
| 94 | + Map<PlsqlProcedureKey, PlsqlStoredProcedure> allProc = client.getAllPlsqlStoredProcedures(); |
| 95 | + for (Map.Entry<PlsqlProcedureKey, PlsqlStoredProcedure> entry : allProc.entrySet()) { |
| 96 | + List<String> row = new ArrayList<>(); |
| 97 | + PlsqlStoredProcedure proc = entry.getValue(); |
| 98 | + row.add(proc.getName()); |
| 99 | + row.add(Long.toString(proc.getCatalogId())); |
| 100 | + row.add(Long.toString(proc.getDbId())); |
| 101 | + row.add(proc.getPackageName()); |
| 102 | + row.add(proc.getOwnerName()); |
| 103 | + row.add(proc.getCreateTime()); |
| 104 | + row.add(proc.getModifyTime()); |
| 105 | + row.add(proc.getSource()); |
| 106 | + columns.add(row); |
| 107 | + } |
| 108 | + } |
| 109 | + |
| 110 | + @Override |
| 111 | + public void showCreateProcedure(FuncNameInfo procedureName, List<List<String>> columns) { |
| 112 | + List<String> row = new ArrayList<>(); |
| 113 | + PlsqlStoredProcedure proc = client.getPlsqlStoredProcedure(procedureName.getName(), |
| 114 | + procedureName.getCtlId(), procedureName.getDbId()); |
| 115 | + if (proc != null) { |
| 116 | + row.add(proc.getName()); |
| 117 | + row.add(proc.getSource()); |
| 118 | + columns.add(row); |
| 119 | + } |
| 120 | + } |
88 | 121 |
|
89 | 122 | @Override |
90 | 123 | public boolean exec(FuncNameInfo procedureName, Expr_func_paramsContext ctx) { |
@@ -196,10 +229,21 @@ public void addUserProcedure(Create_procedure_stmtContext ctx) { |
196 | 229 | @Override |
197 | 230 | public void save(FuncNameInfo procedureName, String source, boolean isForce) { |
198 | 231 | try { |
| 232 | + SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| 233 | + String createTime = f.format(Calendar.getInstance().getTime()); |
| 234 | + String modifyTime = createTime; |
| 235 | + if (isForce) { |
| 236 | + // need to get create time and use that. |
| 237 | + PlsqlStoredProcedure oldProc = client.getPlsqlStoredProcedure(procedureName.getName(), |
| 238 | + procedureName.getCtlId(), procedureName.getDbId()); |
| 239 | + if (oldProc != null) { |
| 240 | + createTime = oldProc.getCreateTime(); |
| 241 | + } |
| 242 | + } |
199 | 243 | // TODO support packageName |
200 | 244 | client.addPlsqlStoredProcedure(procedureName.getName(), procedureName.getCtlId(), procedureName.getDbId(), |
201 | 245 | "", |
202 | | - ConnectContext.get().getQualifiedUser(), source, isForce); |
| 246 | + ConnectContext.get().getQualifiedUser(), source, createTime, modifyTime, isForce); |
203 | 247 | } catch (Exception e) { |
204 | 248 | throw new RuntimeException("failed to save procedure", e); |
205 | 249 | } |
|
0 commit comments