Examples of liquibase.statement.core.SelectFromDatabaseChangeLogStatement

liquibase.statement.core.SelectFromDatabaseChangeLogStatement

        return new ValidationErrors();
    }


    @Override
    public Sql[] generateSql(GetNextChangeSetSequenceValueStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain) {
        return SqlGeneratorFactory.getInstance().generateSql(new SelectFromDatabaseChangeLogStatement(new ColumnConfig().setName("MAX(ORDEREXECUTED)", true)), database);
    }

View Full Code Here

                    if (SnapshotGeneratorFactory.getInstance().hasDatabaseChangeLogTable(database)) {
                        LockService lockService = LockServiceFactory.getInstance().getLockService(database);
                        lockService.waitForLock();
                        List<Map<String, ?>> rows;
                        try {
                            SelectFromDatabaseChangeLogStatement select = new SelectFromDatabaseChangeLogStatement(new ColumnConfig().setName("COUNT(*) AS ROW_COUNT", true), new ColumnConfig().setName("MAX(DATEEXECUTED) AS LAST_EXEC", true));
                            rows = executor.queryForList(select);
                        } finally {
                            lockService.releaseLock();
                        }
                        PrintWriter writer = httpServletResponse.getWriter();

View Full Code Here

            if (SnapshotGeneratorFactory.getInstance().hasDatabaseChangeLogTable(database)) {


                outString = "<table class='table table-striped table-bordered table-condensed'>";
                outString += "<tr><th>Id</th><th>Author</th><th>Path</th><th>ExecType</th><th>Tag</th></tr>";


                SelectFromDatabaseChangeLogStatement select = new SelectFromDatabaseChangeLogStatement("FILENAME", "AUTHOR", "ID", "MD5SUM", "DATEEXECUTED", "ORDEREXECUTED", "EXECTYPE", "DESCRIPTION", "COMMENTS", "TAG", "LIQUIBASE").setOrderBy("DATEEXECUTED DESC", "ORDEREXECUTED DESC"); //going in opposite order for easier reading
                List<Map> ranChangeSets = (List) ExecutorService.getInstance().getExecutor(database).queryForList(select);


                for (Map row : ranChangeSets) {
                    String id = cleanHtmlId(row.get("ID") + ":" + row.get("AUTHOR") + ":" + row.get("FILENAME"));
                    outString += "<tr>" +

View Full Code Here

        super( new SelectFromDatabaseChangeLogGenerator());
    }


    @Override
    protected SelectFromDatabaseChangeLogStatement createSampleSqlStatement() {
        return new SelectFromDatabaseChangeLogStatement("ID");
    }

View Full Code Here

TOP

Related Classes of liquibase.statement.core.SelectFromDatabaseChangeLogStatement

liquibase.change.ColumnConfig

liquibase.sdk.watch.WatchCommand$DynamicContentHandler

liquibase.sqlgenerator.core.GetNextChangeSetSequenceValueGenerator

liquibase.sqlgenerator.core.SelectFromDatabaseChangeLogGeneratorTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.