<dataConfig>
    <script>
        <![CDATA[

            function type(val){
                return Object.prototype.toString.call(val).replace(/^\[object (.+)\]$/,"$1").toLowerCase();
            }

            var atomicTransformer2= function (row) {

                var log = java.util.logging.Logger.getLogger("expand_multi_string_entities");
                var LEVEL = java.util.logging.Level.INFO;


                var map = new java.util.HashMap();
                var v = String(row.get('sku'));
                map.put('add',v);
                row.put('items', map);
                row.remove("sku");
                log.log(LEVEL, row.toString());
                return row;
            };

            var atomicTransformer = function (row) {
                var log = java.util.logging.Logger.getLogger("expand_multi_string_entities");
                var LEVEL = java.util.logging.Level.INFO;
                //log.log(LEVEL, "hello");

                var authorMap = new java.util.HashMap();
                f = String(row.get('user'));
                row.put('user', f.toLowerCase());

                return row;
            };
        ]]>
    </script>

    <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3307/magentodb" user="magentouser" password="TCSwebSHOP"/>

    <document name="products">
        <entity name="item" dataSource="JdbcDataSource"
                query="SELECT concat(a.firstname,' ',a.lastname) as user, o.created_at, o.entity_id, if (s.code = 'admin', 'en', if (s.code = 'eng', 'en', if (s.code = 'ned', 'nl', s.code))) as code FROM magentodb.sales_flat_order o left join sales_flat_order_address a on a.parent_id = o.entity_id and a.address_type='billing' left join core_store s on s.store_id = o.store_id where LOWER(a.lastname)='shop' and LOWER(a.firstname)='johnny' order by created_at asc"
                transformer="LogTransformer,script:atomicTransformer" level="trace">
            <field name="user" column="user" />
            <field name="changed" column="created_at" />
            <field name="language" column="code"/>

            <entity name="items" query="select sku from sales_flat_order_item where order_id = ${item.entity_id}"
                    transformer="LogTransformer,script:atomicTransformer2" level="trace">
                <field name="items" column="sku" />
            </entity>
        </entity>
    </document>
</dataConfig>