Package org.teiid.query.optimizer.xml

Source Code of org.teiid.query.optimizer.xml.TestMarkExcludeVisitor

/*
* JBoss, Home of Professional Open Source.
* See the COPYRIGHT.txt file distributed with this work for information
* regarding copyright ownership.  Some portions may be licensed
* to Red Hat, Inc. under one or more contributor license agreements.
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*/

package org.teiid.query.optimizer.xml;

import java.io.PrintWriter;
import java.io.StringWriter;
import java.util.Collection;

import org.teiid.query.mapping.xml.MappingDocument;
import org.teiid.query.mapping.xml.MappingOutputter;
import org.teiid.query.optimizer.xml.XMLPlanner;
import org.teiid.query.processor.xml.TestXMLProcessor;
import org.teiid.query.sql.lang.Query;
import org.teiid.query.sql.symbol.GroupSymbol;
import org.teiid.query.sql.visitor.GroupCollectorVisitor;
import org.teiid.query.unittest.FakeMetadataFacade;

import junit.framework.TestCase;



/**
*
*/
public class TestMarkExcludeVisitor extends TestCase {
   
    void helpTest(String sql, String expected) throws Exception{
        FakeMetadataFacade metadata = TestXMLProcessor.exampleMetadataCached();
        Query query = (Query)TestXMLProcessor.helpGetCommand(sql, metadata);

        Collection groups = GroupCollectorVisitor.getGroups(query, true);
        GroupSymbol group = (GroupSymbol) groups.iterator().next();
       
        MappingDocument docOrig = (MappingDocument)metadata.getMappingNode(metadata.getGroupID(group.getName()));
        MappingDocument doc = (MappingDocument)docOrig.clone();
       
        doc = XMLPlanner.preMarkExcluded(query, doc);      
        XMLPlanner.removeExcluded(doc);
       
        MappingOutputter out = new MappingOutputter();
        StringWriter sw = new StringWriter();
        out.write(doc, new PrintWriter(sw));
        String actual = sw.toString();
       
        expected = expected.replaceAll("\\s*<", "<"); //$NON-NLS-1$ //$NON-NLS-2$
        assertEquals(expected, actual);
    }
   
    public void testAttribute() throws Exception {       
        String expected = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" //$NON-NLS-1$
                "<xmlMapping>" //$NON-NLS-1$
                "<documentEncoding>UTF-8</documentEncoding>" //$NON-NLS-1$
                "<formattedDocument>true</formattedDocument>" //$NON-NLS-1$                                                               
                "   <mappingNode>" //$NON-NLS-1$
                "       <name>Catalogs</name>" //$NON-NLS-1$
                "       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "       <mappingNode>" //$NON-NLS-1$
                "           <name>Catalog</name>" //$NON-NLS-1$
                "           <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "           <mappingNode>" //$NON-NLS-1$
                "               <name>Items</name>" //$NON-NLS-1$
                "               <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                   <mappingNode>" //$NON-NLS-1$
                "                       <name>Item</name>" //$NON-NLS-1$
                "                       <maxOccurs>-1</maxOccurs>" //$NON-NLS-1$
                "                       <source>xmltest.group.items</source>" //$NON-NLS-1$
                "                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                       <mappingNode>" //$NON-NLS-1$
                "                           <name>ItemID</name>" //$NON-NLS-1$
                "                           <nodeType>attribute</nodeType>" //$NON-NLS-1$
                "                           <symbol>xmltest.group.items.itemNum</symbol>" //$NON-NLS-1$
                "                           <includeAlways>false</includeAlways>"+ //$NON-NLS-1$               
                "                       </mappingNode>" //$NON-NLS-1$
                "                   </mappingNode>" //$NON-NLS-1$
                "           </mappingNode>" //$NON-NLS-1$
                "       </mappingNode>" //$NON-NLS-1$
                "   </mappingNode>" //$NON-NLS-1$
                "</xmlMapping>"; //$NON-NLS-1$
       
        helpTest("SELECT Catalogs.Catalog.Items.Item.@ItemID FROM xmltest.doc9", expected); //$NON-NLS-1$               
    }
   
   
    public void testGroupNode() throws Exception{
        String expected = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" //$NON-NLS-1$
                "<xmlMapping>" //$NON-NLS-1$
                "<documentEncoding>UTF-8</documentEncoding>" //$NON-NLS-1$
                "<formattedDocument>true</formattedDocument>" //$NON-NLS-1$                                                               
                "   <mappingNode>" //$NON-NLS-1$
                "       <name>Catalogs</name>" //$NON-NLS-1$
                "       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "       <mappingNode>" //$NON-NLS-1$
                "           <name>Catalog</name>" //$NON-NLS-1$
                "           <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "           <mappingNode>" //$NON-NLS-1$
                "               <name>Items</name>" //$NON-NLS-1$
                "               <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "               <mappingNode>" //$NON-NLS-1$
                "                   <name>Item</name>" //$NON-NLS-1$
                "                   <maxOccurs>-1</maxOccurs>" //$NON-NLS-1$
                "                   <source>xmltest.group.items</source>" //$NON-NLS-1$               
                "                   <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                   <mappingNode>" //$NON-NLS-1$
                "                       <name>Suppliers</name>" //$NON-NLS-1$
                "                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                       <mappingNode>" //$NON-NLS-1$
                "                           <name>Supplier</name>" //$NON-NLS-1$
                "                           <maxOccurs>-1</maxOccurs>" //$NON-NLS-1$
                "                           <source>xmltest.suppliers</source>" //$NON-NLS-1$               
                "                           <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                           <mappingNode>" //$NON-NLS-1$
                "                               <name>SupplierID</name>" //$NON-NLS-1$
                "                               <nodeType>attribute</nodeType>" //$NON-NLS-1$
                "                               <symbol>xmltest.suppliers.supplierNum</symbol>" //$NON-NLS-1$
                "                               <includeAlways>false</includeAlways>"+ //$NON-NLS-1$               
                "                           </mappingNode>" //$NON-NLS-1$
                "                           <mappingNode>" //$NON-NLS-1$
                "                               <name>Name</name>" //$NON-NLS-1$
                "                               <symbol>xmltest.suppliers.supplierName</symbol>" //$NON-NLS-1$
                "                               <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                           </mappingNode>" //$NON-NLS-1$
                "                           <mappingNode>" //$NON-NLS-1$
                "                               <name>Zip</name>" //$NON-NLS-1$
                "                               <symbol>xmltest.suppliers.supplierZipCode</symbol>" //$NON-NLS-1$
                "                               <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                           </mappingNode>" //$NON-NLS-1$
                "                           <mappingNode>" //$NON-NLS-1$
                "                               <name>Orders</name>" //$NON-NLS-1$
                "                               <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                               <mappingNode>" //$NON-NLS-1$
                "                                   <name>Order</name>" //$NON-NLS-1$
                "                                   <maxOccurs>-1</maxOccurs>" //$NON-NLS-1$
                "                                   <source>xmltest.orders</source>" //$NON-NLS-1$               
                "                                   <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                                   <mappingNode>" //$NON-NLS-1$
                "                                       <name>OrderID</name>" //$NON-NLS-1$
                "                                       <nodeType>attribute</nodeType>" //$NON-NLS-1$
                "                                       <symbol>xmltest.orders.orderNum</symbol>" //$NON-NLS-1$
                "                                       <includeAlways>false</includeAlways>"+ //$NON-NLS-1$               
                "                                   </mappingNode>" //$NON-NLS-1$
                "                                   <mappingNode>" //$NON-NLS-1$
                "                                       <name>OrderDate</name>" //$NON-NLS-1$
                "                                       <symbol>xmltest.orders.orderDate</symbol>" //$NON-NLS-1$
                "                                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                                   </mappingNode>" //$NON-NLS-1$
                "                                   <mappingNode>" //$NON-NLS-1$
                "                                       <name>OrderQuantity</name>" //$NON-NLS-1$
                "                                       <symbol>xmltest.orders.orderQty</symbol>" //$NON-NLS-1$
                "                                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                                   </mappingNode>" //$NON-NLS-1$
                "                                   <mappingNode>" //$NON-NLS-1$
                "                                       <name>OrderStatus</name>" //$NON-NLS-1$
                "                                       <minOccurs>0</minOccurs>" //$NON-NLS-1$
                "                                       <symbol>xmltest.orders.orderStatus</symbol>" //$NON-NLS-1$
                "                                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                                   </mappingNode>" //$NON-NLS-1$
                "                               </mappingNode>" //$NON-NLS-1$
                "                           </mappingNode>" //$NON-NLS-1$
                "                       </mappingNode>" //$NON-NLS-1$
                "                   </mappingNode>" //$NON-NLS-1$
                "               </mappingNode>" //$NON-NLS-1$
                "           </mappingNode>" //$NON-NLS-1$
                "       </mappingNode>" //$NON-NLS-1$
                "   </mappingNode>" //$NON-NLS-1$
                "</xmlMapping>"; //$NON-NLS-1$
       
        helpTest("SELECT Catalogs.Catalog.Items.Item.Suppliers.Supplier.* FROM xmltest.doc9", expected); //$NON-NLS-1$
        helpTest("SELECT Supplier.* FROM xmltest.doc9", expected); //$NON-NLS-1$
    }   
   
    public void testElements() throws Exception {
        String expected="<?xml version=\"1.0\" encoding=\"UTF-8\"?>" //$NON-NLS-1$
                "<xmlMapping>" //$NON-NLS-1$
                "<documentEncoding>UTF-8</documentEncoding>" //$NON-NLS-1$
                "<formattedDocument>true</formattedDocument>" //$NON-NLS-1$                                                               
                "   <mappingNode>" //$NON-NLS-1$
                "       <name>Catalogs</name>" //$NON-NLS-1$
                "       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "       <mappingNode>" //$NON-NLS-1$
                "           <name>Catalog</name>" //$NON-NLS-1$
                "           <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "           <mappingNode>" //$NON-NLS-1$
                "               <name>Items</name>" //$NON-NLS-1$
                "               <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "               <mappingNode>" //$NON-NLS-1$
                "                   <name>Item</name>" //$NON-NLS-1$
                "                   <maxOccurs>-1</maxOccurs>" //$NON-NLS-1$
                "                   <source>xmltest.group.items</source>" //$NON-NLS-1$               
                "                   <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                   <mappingNode>" //$NON-NLS-1$
                "                       <name>ItemID</name>" //$NON-NLS-1$
                "                       <nodeType>attribute</nodeType>" //$NON-NLS-1$
                "                       <symbol>xmltest.group.items.itemNum</symbol>" //$NON-NLS-1$
                "                       <includeAlways>false</includeAlways>"+ //$NON-NLS-1$               
                "                   </mappingNode>" //$NON-NLS-1$
                "                   <mappingNode>" //$NON-NLS-1$
                "                       <name>Suppliers</name>" //$NON-NLS-1$
                "                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                       <mappingNode>" //$NON-NLS-1$
                "                           <name>Supplier</name>" //$NON-NLS-1$
                "                           <maxOccurs>-1</maxOccurs>" //$NON-NLS-1$
                "                           <source>xmltest.suppliers</source>" //$NON-NLS-1$               
                "                           <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                           <mappingNode>" //$NON-NLS-1$
                "                               <name>SupplierID</name>" //$NON-NLS-1$
                "                               <nodeType>attribute</nodeType>" //$NON-NLS-1$
                "                               <symbol>xmltest.suppliers.supplierNum</symbol>" //$NON-NLS-1$
                "                               <includeAlways>false</includeAlways>"+ //$NON-NLS-1$
                "                           </mappingNode>" //$NON-NLS-1$
                "                           <mappingNode>" //$NON-NLS-1$
                "                               <name>Orders</name>" //$NON-NLS-1$
                "                               <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                               <mappingNode>" //$NON-NLS-1$
                "                                   <name>Order</name>" //$NON-NLS-1$
                "                                   <maxOccurs>-1</maxOccurs>" //$NON-NLS-1$
                "                                   <source>xmltest.orders</source>" //$NON-NLS-1$               
                "                                   <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                                   <mappingNode>" //$NON-NLS-1$
                "                                       <name>OrderID</name>" //$NON-NLS-1$
                "                                       <nodeType>attribute</nodeType>" //$NON-NLS-1$
                "                                       <symbol>xmltest.orders.orderNum</symbol>" //$NON-NLS-1$
                "                                       <includeAlways>false</includeAlways>"+ //$NON-NLS-1$               
                "                                   </mappingNode>" //$NON-NLS-1$
                "                                   <mappingNode>" //$NON-NLS-1$
                "                                       <name>OrderQuantity</name>" //$NON-NLS-1$
                "                                       <symbol>xmltest.orders.orderQty</symbol>" //$NON-NLS-1$
                "                                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                                   </mappingNode>" //$NON-NLS-1$
                "                               </mappingNode>" //$NON-NLS-1$
                "                           </mappingNode>" //$NON-NLS-1$
                "                       </mappingNode>" //$NON-NLS-1$
                "                   </mappingNode>" //$NON-NLS-1$
                "               </mappingNode>" //$NON-NLS-1$
                "           </mappingNode>" //$NON-NLS-1$
                "       </mappingNode>" //$NON-NLS-1$
                "   </mappingNode>" //$NON-NLS-1$
                "</xmlMapping>"; //$NON-NLS-1$
       
        helpTest("SELECT OrderQuantity, SupplierID, ItemID, OrderID FROM xmltest.doc9"  + //$NON-NLS-1$
                 " ORDER BY Catalogs.Catalog.Items.Item.Suppliers.Supplier.SupplierID ASC," + //$NON-NLS-1$
                 " OrderID DESC, Catalogs.Catalog.Items.Item.ItemID DESC", expected);           //$NON-NLS-1$
    }
   
    public void testSelectAll() throws Exception {
        String expected= "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" //$NON-NLS-1$
                "<xmlMapping>" //$NON-NLS-1$
                "<documentEncoding>UTF-8</documentEncoding>" //$NON-NLS-1$
                "<formattedDocument>true</formattedDocument>" //$NON-NLS-1$                                                               
                "   <mappingNode>" //$NON-NLS-1$
                "       <name>Catalogs</name>" //$NON-NLS-1$
                "       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "       <mappingNode>" //$NON-NLS-1$
                "           <name>Catalog</name>" //$NON-NLS-1$
                "           <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "           <mappingNode>" //$NON-NLS-1$
                "               <name>Items</name>" //$NON-NLS-1$
                "               <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "               <mappingNode>" //$NON-NLS-1$
                "                   <name>Item</name>" //$NON-NLS-1$
                "                   <maxOccurs>-1</maxOccurs>" //$NON-NLS-1$
                "                   <source>xmltest.group.items</source>" //$NON-NLS-1$
                "                   <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                   <mappingNode>" //$NON-NLS-1$
                "                       <name>ItemID</name>" //$NON-NLS-1$
                "                       <nodeType>attribute</nodeType>" //$NON-NLS-1$
                "                       <symbol>xmltest.group.items.itemNum</symbol>" //$NON-NLS-1$
                "                       <includeAlways>false</includeAlways>"+ //$NON-NLS-1$               
                "                   </mappingNode>" //$NON-NLS-1$
                "                   <mappingNode>" //$NON-NLS-1$
                "                       <name>Name</name>" //$NON-NLS-1$
                "                       <symbol>xmltest.group.items.itemName</symbol>" //$NON-NLS-1$
                "                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                   </mappingNode>" //$NON-NLS-1$
                "                   <mappingNode>" //$NON-NLS-1$
                "                       <name>Quantity</name>" //$NON-NLS-1$
                "                       <symbol>xmltest.group.items.itemQuantity</symbol>" //$NON-NLS-1$
                "                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                   </mappingNode>" //$NON-NLS-1$
                "                   <mappingNode>" //$NON-NLS-1$
                "                       <name>Suppliers</name>" //$NON-NLS-1$
                "                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                       <mappingNode>" //$NON-NLS-1$
                "                           <name>Supplier</name>" //$NON-NLS-1$
                "                           <maxOccurs>-1</maxOccurs>" //$NON-NLS-1$
                "                           <source>xmltest.suppliers</source>" //$NON-NLS-1$               
                "                           <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                           <mappingNode>" //$NON-NLS-1$
                "                               <name>SupplierID</name>" //$NON-NLS-1$
                "                               <nodeType>attribute</nodeType>" //$NON-NLS-1$
                "                               <symbol>xmltest.suppliers.supplierNum</symbol>" //$NON-NLS-1$
                "                               <includeAlways>false</includeAlways>"+ //$NON-NLS-1$               
                "                           </mappingNode>" //$NON-NLS-1$
                "                           <mappingNode>" //$NON-NLS-1$
                "                               <name>Name</name>" //$NON-NLS-1$
                "                               <symbol>xmltest.suppliers.supplierName</symbol>" //$NON-NLS-1$
                "                               <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                           </mappingNode>" //$NON-NLS-1$
                "                           <mappingNode>" //$NON-NLS-1$
                "                               <name>Zip</name>" //$NON-NLS-1$
                "                               <symbol>xmltest.suppliers.supplierZipCode</symbol>" //$NON-NLS-1$
                "                               <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                           </mappingNode>" //$NON-NLS-1$
                "                           <mappingNode>" //$NON-NLS-1$
                "                               <name>Orders</name>" //$NON-NLS-1$
                "                               <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                               <mappingNode>" //$NON-NLS-1$
                "                                   <name>Order</name>" //$NON-NLS-1$
                "                                   <maxOccurs>-1</maxOccurs>" //$NON-NLS-1$
                "                                   <source>xmltest.orders</source>" //$NON-NLS-1$
                "                                   <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                                   <mappingNode>" //$NON-NLS-1$
                "                                       <name>OrderID</name>" //$NON-NLS-1$
                "                                       <nodeType>attribute</nodeType>" //$NON-NLS-1$
                "                                       <symbol>xmltest.orders.orderNum</symbol>" //$NON-NLS-1$
                "                                       <includeAlways>false</includeAlways>"+ //$NON-NLS-1$               
                "                                   </mappingNode>" //$NON-NLS-1$
                "                                   <mappingNode>" //$NON-NLS-1$
                "                                       <name>OrderDate</name>" //$NON-NLS-1$
                "                                       <symbol>xmltest.orders.orderDate</symbol>" //$NON-NLS-1$
                "                                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                                   </mappingNode>" //$NON-NLS-1$
                "                                   <mappingNode>" //$NON-NLS-1$
                "                                       <name>OrderQuantity</name>" //$NON-NLS-1$
                "                                       <symbol>xmltest.orders.orderQty</symbol>" //$NON-NLS-1$
                "                                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                                   </mappingNode>" //$NON-NLS-1$
                "                                   <mappingNode>" //$NON-NLS-1$
                "                                       <name>OrderStatus</name>" //$NON-NLS-1$
                "                                       <minOccurs>0</minOccurs>" //$NON-NLS-1$
                "                                       <symbol>xmltest.orders.orderStatus</symbol>" //$NON-NLS-1$
                "                                       <includeAlways>false</includeAlways>" //$NON-NLS-1$
                "                                   </mappingNode>" //$NON-NLS-1$
                "                               </mappingNode>" //$NON-NLS-1$
                "                           </mappingNode>" //$NON-NLS-1$
                "                       </mappingNode>" //$NON-NLS-1$
                "                   </mappingNode>" //$NON-NLS-1$
                "               </mappingNode>" //$NON-NLS-1$
                "           </mappingNode>" //$NON-NLS-1$
                "       </mappingNode>" //$NON-NLS-1$
                "   </mappingNode>" //$NON-NLS-1$
                "</xmlMapping>" ; //$NON-NLS-1$
       
        // everything as it is..
        helpTest("SELECT * FROM xmltest.doc9", expected); //$NON-NLS-1$
    }
}
TOP

Related Classes of org.teiid.query.optimizer.xml.TestMarkExcludeVisitor

TOP
Copyright © 2015 www.massapi.com. All rights reserved.
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.