use of com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.function.FunctionJdbcResourceType in project sql-boot by sql-boot.
the class FsResourceTypes method walk.
/**
* @param path
* @return
*/
private List<ResourceType> walk(final String path) {
File[] files = new File(path).listFiles();
if (files == null)
return null;
List<ResourceType> list = new ArrayList<>();
for (File f : files) {
if (f.isDirectory()) {
File sqlFile = new File(f, "README.md");
list.addAll(walk(f.getAbsolutePath()));
final ResourceType jdbcResourceType;
switch(f.getName()) {
case "schema":
jdbcResourceType = new SchemaJdbcResourceType(dataSource);
break;
case "table":
jdbcResourceType = new TableJdbcResourceType(dataSource);
break;
case "child":
jdbcResourceType = new ChildTableJdbcResourceType(dataSource);
break;
case "parent":
jdbcResourceType = new ParentTableJdbcResourceType(dataSource);
break;
case "pk":
jdbcResourceType = new PkJdbcResourceType(dataSource);
break;
case "index":
jdbcResourceType = new IndexJdbcResourceType(dataSource);
break;
case "fk":
jdbcResourceType = new FkJdbcResourceType(dataSource);
break;
case "view":
jdbcResourceType = new ViewJdbcResourceType(dataSource);
break;
case "column":
jdbcResourceType = new ColumnJdbcResourceType(dataSource);
break;
case "function":
jdbcResourceType = new FunctionJdbcResourceType(dataSource);
break;
case "procedure":
jdbcResourceType = new ProcedureJdbcResourceType(dataSource);
break;
default:
jdbcResourceType = null;
}
String sql = null;
try {
MarkdownFile markdownFile = new MarkdownFile(readFileToString(sqlFile, UTF_8));
Map<String, String> parse = markdownFile.parse();
Iterator<Map.Entry<String, String>> iterator = parse.entrySet().iterator();
if (iterator.hasNext()) {
sql = iterator.next().getValue();
}
} catch (IOException e) {
// TODO catch and process this exception
}
final ResourceType baseResourceType;
if (sqlFile.exists() && sql != null) {
baseResourceType = new SqlResourceType(new JdbcSqlQuery(dataSource, new GroovyTemplateGenerator(sql)), singletonList(f.getName()));
} else if (jdbcResourceType != null) {
baseResourceType = jdbcResourceType;
} else {
baseResourceType = null;
}
final ResourceType resourceType = new SelectWrapper(// new SqlBodyWrapper(
new TemplateBodyWrapper(new PageWrapper(new LimitWrapper(// new WhereWrapper(
baseResourceType)), new GroovyTemplateGenerator("EMPTY BODY ...")));
if (baseResourceType != null) {
list.add(resourceType);
}
}
}
return list;
}
Aggregations