#!/usr/bin/perl 

use strict;
use warnings;

use Data::Dumper;
use SQLValidation;
use XML::Simple;


my $xml_obj1 =  XML::Simple->new();

#my $file_path     = 'C:\Users\Desktop\sql_test.xml' ;
my $file_path     = 'C:\Users\Desktop\derived_tif_cd.XML' ;
my $xmlfile       = $xml_obj1->XMLin($file_path) or die "Failed for $file_path: $!";

#print Dumper $xmlfile;
=c
my $val = $xmlfile->{queries}->{query}->[2]->{content};
print "$val";
=cut
foreach my $queries ($xmlfile->{queries}){
	if($xmlfile->{queries} eq 'query') {
		foreach my $query (@{$queries->{query}}) 
		{
			foreach my $sql ($query->{content}) {
					print "$sql\n";
				}
		}
	}
	else {
		foreach my $query (@{$queries->{query}}) {
			print "---->$query\n";
		}
	}
}

##</code><code>##

<Common_Checks>
        <comments>
                This xml includes validations for order event types (Checks for Others).
        </comments>
        <queries>
		<comments>
			ORDER_TYPE_CODE and expiration date for TIF  code derivation:
		</comments>
		<query>
		
                	 INSERT INTO table_name   (column1, column2, column3,...) select (value1, value2, value3,...);    
				
                <orderTypes>order_nw_stgng</orderTypes>
                <orderTypes>order_or_stgng</orderTypes>
                <orderTypes>order_oe_stgng</orderTypes>
                <orderTypes>order_cr_stgng</orderTypes>
				
                <queryParam>BATCH_ID</queryParam>
            </query>
            
            <query>
	    	       GENERATE EXPRESS STATISTICS ON drvd_tif_order_stgng;
            </query>

		<comments>
			ORDER_TYPE_CODE and expiration date for TIF  code derivation:
		</comments>
	    <query>
			
			INSERT INTO table_name   (column1, column2, column3,...) select (value1, value2, value3,...);   
	        			
				<orderTypes>order_nw_stgng</orderTypes>
				<orderTypes>order_or_stgng</orderTypes>
				<orderTypes>order_oe_stgng</orderTypes>
				<orderTypes>order_cr_stgng</orderTypes>
				
				<queryParam>BATCH_ID</queryParam>
	
	    </query>  
			
	   <query>
			GENERATE EXPRESS STATISTICS ON drvd_tif_order_stgng;
           </query>
			
		
                
        </queries>
</Common_Checks>