Xavar : SQL Query to Document Transformation Tool (XML,JSON,Text,…)

The basic idea

Features

• Hierarchic SQL to POX (Plain Old XML), JSON (Javascript Object Notation, etc …)
• Named parameters.
• Direct output from JDBC resultsets to OutputStreams

Download

• Jar file
• Sources

Getting started

Example model:

Example query:

QueryBuilder query = new XavarQueryBuilder();

query.add(
  "persons/person",
  "select per.* from Person per where per.id = $P{person}");

query.add(
  "persons/person/orders/order",
  "select ord.* from Order ord where ord.person_id=${../../id}");

query.add(
  "persons/person/orders/order/items/item",
  "select itm.* from OrderItem itm where itm.order_id=${../../id}");

query.setParameter("person", 1);

OutputStream out = getOutput(...);
Connection conn = getConnection(...);
XMLStreamExcecutor exe = new XMLStreamExcecutor(con, out);
exe.execute(query);

Result:

<persons>
  <person id="1" name="Jonh" phone="555-837374" address="123 Thomson Street">
    <orders>
      <order id="123" date="2007-05-05" amount="4324324.00" description="baby things">
        <items>
          <item id="23" description="shoes" quantity="3" price="12" />
          <item id="34" description="hat" quantity="1" price="35" />
          <item id="78" description="shirt" quantity="1" price="25" />
        <items>
      <order>
      ...
    </orders>
  </person>
  ...
</persons>

Todo:

• Documentation
• Develop more executors:
  • DOM executor
  • JSON executor