472,986 Members | 2,980 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,986 software developers and data experts.

Retic EAI Server 0.3.2 Released - SQLTreeSource included.

I've released a new version of Retic with new components :

- Pipes : XPathPipe and FlatToXMLPipe
- Source : SQLTreeSource (permits to build complex XML
documents from several SQL requests).

The Designer is now fully working and supports all components
of the current Retic release.
It is available on sourceforge : http://sourceforge.net/projects/retic
================================================== ===========
Retic is an EAI Server.
The aim is to permit applications to communicate, even if they
don't speak the same language (which means transport protocols
as well as data structures).
This is done by building adaptors. An adaptor is composed of :
- One source
- Several pipes (process data transformations)
- Several sinks (destination of data)
- Several loggers (using the logging module of python 2.3)

================================================== ===========
Sometimes (well, might even be more than that) you need to get
more than a bunch of rows from a table translated to XML. You
need a whole structured XML document with a complex and deep
architecture. The SQLTreeSource is what you need then. It
permits to describe an XML tree, each node being the result of
an SQL statement. Here's an example :

<source name="SQLTreeSource" type="SQLTreeSource" dbType="odbc"
dsn="localhost_mysql" user="root" password="" rootTag="XPWeb"
encoding="ISO-8859-1" msgSize="0" polls="1" pollPeriod="0">
<query SQL="select * from iterations" recTag="iteration">
<query SQL="select * from stories"parentLink="id"
childLink="iteration_id" recTag="story">
<query SQL="select * from tasks"
parentLink="id,iteration_id" childLink="story_id,iteration_id"recTag="task"/>
Here is the XML output of the source described above :

<?xml version="1.0" encoding="ISO-8859-1"?>
<description>Mise en recette Valo
<name>Evironnement de tests unitaires</name>
<description>Création d'un environnement de tests
unitaires et de non-régression.</description>
<name>Scripts de création des données
<description>Ecriture des scripts de
création de base</description>
<name>Environnement $U - Session et
<description>Création des sessions et
uprocs propres aux tests.</description>

This is an extraction of my XPWeb database (THE Extreme
Programming management tool - http://xpweb.sourceforge.net ).
Three tables are accessed here : iterations, stories and tasks.
Iterations may have several stories, which may have several
tasks. What I wanted here is to extract all my iterations with
their stories and tasks into a single XML document.

<query SQL="select * from iterations" recTag="iteration">

This permits to get all iterations at the second level (the
first being the root one whose name is defined in the rootTag
attribute of the source component) of the document. Each
iteration will be written to XML, embraced by an <iteration> tag
Providing a new subquery this way :

<query SQL="select * from iterations" recTag="iteration">
<query SQL="select * from stories" parentLink="id"
childLink="iteration_id" recTag="story"/>

Permits to define a new sublevel under iteration, writing the
stories inside <story> tags.
parentLink and childLink permit to assign the stories to their
iteration (we don't want all stories to be repeated under each
iteration). Here, we make a link between the fields :
iterations.id and stories.iteration_id
At execution time, the SQL statement is modified to include
the link.
(for example : select * from stories where iteration_id = 4)
Now, let's add a subquery to stories :

<query SQL="select * from iterations" recTag="iteration">
<query SQL="select * from stories" parentLink="id"
childLink="iteration_id" recTag="story">
<query SQL="select * from tasks" parentLink="id"
childLink="story_id" recTag="task"/>

Here, we've added a new sublevel, which will come under
stories. It will write all tasks for each stories (with a link
between stories.id and tasks.story_id).
Simple, isn't it ?
Note : Although it is not said yet in the doc, supported databases are :
mysql, odbc (not mxOdbc), sybase, dcoracle2, cx_oracle (dbtype in the
config file must take one of those values spelled exactly this way). Of
course, they'll only work if corresponding db modules are correctly
installed. I've tested mysql and odbc but couldn't yet test the others
(feedback is welcome !!).
Upcoming components are :

- xmlBlasterSource (already developped - will be shipped in the next
release this week)
- JabberSink (already developped - will be shipped in the next release this
- httpSink
- SoapSource
- SoapSink
- xmlBlasterSink
- MQSeries source and sink (if I manage in compiling it with python 2.3 and
MinGw32 under win32 - help appreciated - Compile is ok but I get an error
at import : blablabla : Memory could not be read)
- Support for other popular databases (DB/2, PostgreSQL, etc...)

================================================== ===========
Have fun !!

PS : One last thing ==> Tell me if you're interested by Retic (good formy

Jul 18 '05 #1
0 1353

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Alexander DEJANOVSKI | last post by:
Retic 0.6 comes with 3 new major features : - Retic Administrator : a cross-platform (wxPython 2.4) GUI for creating/modifying adaptors and launching them. (replaces the buggy win32 Retic...
by: Brian Lloyd | last post by:
Python for .NET 1.0 beta 1 has been released - you can download it from: http://www.zope.org/Members/Brian/PythonNet/ Python for .NET is a near-seamless integration of Python with the ..NET...
by: phil hunt | last post by:
I've just released version 0.3.0 of my Easibox program, which is used to automate the creation of archive files (tar, tar.gz, tgz, tar.bz2 and zip formats), typically for open source projects. ...
by: Thomas Heller | last post by:
**py2exe 0.5.0** (finally) released =================================== py2exe is a Python distutils extension which converts python scripts into executable windows programs, able to run without...
by: Alexander DEJANOVSKI | last post by:
Just released Retic SOAP tester 0.2. New features : SOAP messages exchanged are now pretty-printed and syntax-colored for better legibility. Downloads : http://sourceforge.net/projects/retic/...
by: Anthony Baxter | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On behalf of the Python development team and the Python community, I'm happy to announce the release of Python 2.3.4 (release candidate 1). ...
by: David Fraser | last post by:
Following up on a promise in the Config discussion ... preftree has been released under the Python license. You can get version 0.3 from http://davidf.sjsoft.com/files/preftree-0.3.tar.gz The...
by: Mark_S | last post by:
Does the .net framework v1.1 come pre-installed on new Window's PC's? For example, there is a recent news article about AOL selling a $299 PC bundle that has Windows XP Home edition- will this PC...
by: prunoki | last post by:
Hello, I am an SQL server newbie. Our company has a massive application written in PL/SQL. I need to port parts of it to SQL Server. - Which SQL server version should I choose, to have a...
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.