Examples of PgView

cz.startnet.utils.pgdiff.schema.PgView
Stores view information. @author fordfrog

Examples of cz.startnet.utils.pgdiff.schema.PgView


        final String objectName = ParserUtils.getObjectName(tableName);
        final PgTable table = schema.getTable(objectName);


        if (table == null) {
            final PgView view = schema.getView(objectName);


            if (view != null) {
                parseView(parser, view, outputIgnoredStatements, tableName,
                        database);
                return;

View Full Code Here

Examples of cz.startnet.utils.pgdiff.schema.PgView


        parser.expect("AS");


        final String query = parser.getRest();


        final PgView view = new PgView(ParserUtils.getObjectName(viewName));
        view.setColumnNames(columnNames);
        view.setQuery(query);


        final String schemaName = ParserUtils.getSchemaName(viewName, database);
        final PgSchema schema = database.getSchema(schemaName);


        if (schema == null) {

View Full Code Here

Examples of cz.startnet.utils.pgdiff.schema.PgView

                    Resources.getString("CannotFindSchema"), schemaName,
                    statement));
        }


        final String objectName = ParserUtils.getObjectName(viewName);
        final PgView view = schema.getView(objectName);


        if (view == null) {
            throw new RuntimeException(MessageFormat.format(
                    Resources.getString("CannotFindView"), viewName,
                    statement));
        }


        while (!parser.expectOptional(";")) {
            if (parser.expectOptional("ALTER")) {
                parser.expectOptional("COLUMN");


                final String columnName =
                        ParserUtils.getObjectName(parser.parseIdentifier());


                if (parser.expectOptional("SET", "DEFAULT")) {
                    final String expression = parser.getExpression();
                    view.addColumnDefaultValue(columnName, expression);
                } else if (parser.expectOptional("DROP", "DEFAULT")) {
                    view.removeColumnDefaultValue(columnName);
                } else {
                    parser.throwUnsupportedCommand();
                }
            } else if (parser.expectOptional("OWNER", "TO")) {
                // we do not parse this one so we just consume the identifier

View Full Code Here

Examples of cz.startnet.utils.pgdiff.schema.PgView

        final String viewName = parser.parseIdentifier();
        final String objectName = ParserUtils.getObjectName(viewName);
        final String schemaName =
                ParserUtils.getSchemaName(viewName, database);


        final PgView view = database.getSchema(schemaName).getView(objectName);


        parser.expect("IS");
        view.setComment(getComment(parser));
        parser.expect(";");
    }

View Full Code Here

Examples of cz.startnet.utils.pgdiff.schema.PgView

        final PgSchema schema = database.getSchema(schemaName);


        final PgTable table = schema.getTable(tableName);


        if (table == null) {
            final PgView view = schema.getView(tableName);
            parser.expect("IS");


            final String comment = getComment(parser);


            if (comment == null) {
                view.removeColumnComment(objectName);
            } else {
                view.addColumnComment(objectName, comment);
            }
            parser.expect(";");
        } else {
            final PgColumn column = table.getColumn(objectName);

View Full Code Here

Examples of cz.startnet.utils.pgdiff.schema.PgView

        if (oldSchema == null) {
            return;
        }


        for (final PgView oldView : oldSchema.getViews()) {
            final PgView newView = newSchema.getView(oldView.getName());


            if (newView == null || isViewModified(oldView, newView)) {
                searchPathHelper.outputSearchPath(writer);
                writer.println();
                writer.println(oldView.getDropSQL());

View Full Code Here

Examples of cz.startnet.utils.pgdiff.schema.PgView

        if (oldSchema == null) {
            return;
        }


        for (final PgView oldView : oldSchema.getViews()) {
            final PgView newView = newSchema.getView(oldView.getName());


            if (newView == null) {
                continue;
            }


            diffDefaultValues(writer, oldView, newView, searchPathHelper);


            if (oldView.getComment() == null
                    && newView.getComment() != null
                    || oldView.getComment() != null
                    && newView.getComment() != null
                    && !oldView.getComment().equals(
                    newView.getComment())) {
                searchPathHelper.outputSearchPath(writer);
                writer.println();
                writer.print("COMMENT ON VIEW ");
                writer.print(
                        PgDiffUtils.getQuotedName(newView.getName()));
                writer.print(" IS ");
                writer.print(newView.getComment());
                writer.println(';');
            } else if (oldView.getComment() != null
                    && newView.getComment() == null) {
                searchPathHelper.outputSearchPath(writer);
                writer.println();
                writer.print("COMMENT ON VIEW ");
                writer.print(PgDiffUtils.getQuotedName(newView.getName()));
                writer.println(" IS NULL;");
            }


            final List<String> columnNames =
                    new ArrayList<String>(newView.getColumnComments().size());


            for (final PgView.ColumnComment columnComment :
                    newView.getColumnComments()) {
                columnNames.add(columnComment.getColumnName());
            }


            for (final PgView.ColumnComment columnComment :
                    oldView.getColumnComments()) {
                if (!columnNames.contains(columnComment.getColumnName())) {
                    columnNames.add(columnComment.getColumnName());
                }
            }


            for (final String columnName : columnNames) {
                PgView.ColumnComment oldColumnComment = null;
                PgView.ColumnComment newColumnComment = null;


                for (final PgView.ColumnComment columnComment :
                        oldView.getColumnComments()) {
                    if (columnName.equals(columnComment.getColumnName())) {
                        oldColumnComment = columnComment;
                        break;
                    }
                }


                for (final PgView.ColumnComment columnComment :
                        newView.getColumnComments()) {
                    if (columnName.equals(columnComment.getColumnName())) {
                        newColumnComment = columnComment;
                        break;
                    }
                }


                if (oldColumnComment == null && newColumnComment != null
                        || oldColumnComment != null && newColumnComment != null
                        && !oldColumnComment.getComment().equals(
                        newColumnComment.getComment())) {
                    searchPathHelper.outputSearchPath(writer);
                    writer.println();
                    writer.print("COMMENT ON COLUMN ");
                    writer.print(PgDiffUtils.getQuotedName(newView.getName()));
                    writer.print('.');
                    writer.print(PgDiffUtils.getQuotedName(
                            newColumnComment.getColumnName()));
                    writer.print(" IS ");
                    writer.print(newColumnComment.getComment());
                    writer.println(';');
                } else if (oldColumnComment != null
                        && newColumnComment == null) {
                    searchPathHelper.outputSearchPath(writer);
                    writer.println();
                    writer.print("COMMENT ON COLUMN ");
                    writer.print(PgDiffUtils.getQuotedName(newView.getName()));
                    writer.print('.');
                    writer.print(PgDiffUtils.getQuotedName(
                            oldColumnComment.getColumnName()));
                    writer.println(" IS NULL;");
                }

View Full Code Here

TOP

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.