Search in sources :

Example 1 with SelectWrapper

use of com.github.mgramin.sqlboot.model.resource_type.wrappers.header.SelectWrapper 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;
}
Also used : SelectWrapper(com.github.mgramin.sqlboot.model.resource_type.wrappers.header.SelectWrapper) LimitWrapper(com.github.mgramin.sqlboot.model.resource_type.wrappers.list.LimitWrapper) SqlResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.sql.SqlResourceType) MarkdownFile(com.github.mgramin.sqlboot.model.resource_type.impl.composite.md.MarkdownFile) ArrayList(java.util.ArrayList) JdbcSqlQuery(com.github.mgramin.sqlboot.sql.impl.JdbcSqlQuery) FileUtils.readFileToString(org.apache.commons.io.FileUtils.readFileToString) ParentTableJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.relation.ParentTableJdbcResourceType) PkJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.pk.PkJdbcResourceType) ProcedureJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.procedure.ProcedureJdbcResourceType) PageWrapper(com.github.mgramin.sqlboot.model.resource_type.wrappers.list.PageWrapper) TemplateBodyWrapper(com.github.mgramin.sqlboot.model.resource_type.wrappers.body.TemplateBodyWrapper) FunctionJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.function.FunctionJdbcResourceType) PkJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.pk.PkJdbcResourceType) SqlResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.sql.SqlResourceType) FunctionJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.function.FunctionJdbcResourceType) TableJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.TableJdbcResourceType) ParentTableJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.relation.ParentTableJdbcResourceType) ResourceType(com.github.mgramin.sqlboot.model.resource_type.ResourceType) SchemaJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.SchemaJdbcResourceType) FkJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.fk.FkJdbcResourceType) ViewJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.view.ViewJdbcResourceType) IndexJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.index.IndexJdbcResourceType) ColumnJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.column.ColumnJdbcResourceType) ChildTableJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.relation.ChildTableJdbcResourceType) ProcedureJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.procedure.ProcedureJdbcResourceType) IOException(java.io.IOException) IndexJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.index.IndexJdbcResourceType) SchemaJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.SchemaJdbcResourceType) GroovyTemplateGenerator(com.github.mgramin.sqlboot.template.generator.impl.GroovyTemplateGenerator) FkJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.fk.FkJdbcResourceType) TableJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.TableJdbcResourceType) ParentTableJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.relation.ParentTableJdbcResourceType) ChildTableJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.relation.ChildTableJdbcResourceType) ViewJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.view.ViewJdbcResourceType) ChildTableJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.relation.ChildTableJdbcResourceType) MarkdownFile(com.github.mgramin.sqlboot.model.resource_type.impl.composite.md.MarkdownFile) File(java.io.File) ColumnJdbcResourceType(com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.column.ColumnJdbcResourceType)

Aggregations

ResourceType (com.github.mgramin.sqlboot.model.resource_type.ResourceType)1 MarkdownFile (com.github.mgramin.sqlboot.model.resource_type.impl.composite.md.MarkdownFile)1 SchemaJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.SchemaJdbcResourceType)1 FunctionJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.function.FunctionJdbcResourceType)1 ProcedureJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.procedure.ProcedureJdbcResourceType)1 TableJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.TableJdbcResourceType)1 ColumnJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.column.ColumnJdbcResourceType)1 FkJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.fk.FkJdbcResourceType)1 IndexJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.index.IndexJdbcResourceType)1 PkJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.pk.PkJdbcResourceType)1 ChildTableJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.relation.ChildTableJdbcResourceType)1 ParentTableJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.relation.ParentTableJdbcResourceType)1 ViewJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.view.ViewJdbcResourceType)1 SqlResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.sql.SqlResourceType)1 TemplateBodyWrapper (com.github.mgramin.sqlboot.model.resource_type.wrappers.body.TemplateBodyWrapper)1 SelectWrapper (com.github.mgramin.sqlboot.model.resource_type.wrappers.header.SelectWrapper)1 LimitWrapper (com.github.mgramin.sqlboot.model.resource_type.wrappers.list.LimitWrapper)1 PageWrapper (com.github.mgramin.sqlboot.model.resource_type.wrappers.list.PageWrapper)1 JdbcSqlQuery (com.github.mgramin.sqlboot.sql.impl.JdbcSqlQuery)1 GroovyTemplateGenerator (com.github.mgramin.sqlboot.template.generator.impl.GroovyTemplateGenerator)1