Main | License | Installation | FAQ | Screenshots | Contact | Links | Sf.net | Freshmeat.net | KDE-Apps.org

XSU Class Reference
[Compilers]

#include <xsu.hpp>

Inheritance diagram for XSU:

[legend]

Public Member Functions
	XSU (DatabasePtr _database)
virtual void	translate (std::istream &inputStream, std::ostream &outputStream) const throw (Error)
Protected Attributes
DatabasePtr	database
	Pointer to database.

---

Detailed Description

Implementation of a tool similar to Oracle's XML SQL Utility. Using a connection to a database, the XML SQL Utility takes SQL scripts as input and produces XML as output. For example the following input

    # OPEN test;
    SELECT 1;
    # CLOSE test;

would result in the following output:

    <?xml version='1.0' encoding='UTF-8'?>
    <data>
      <test>
        <table>
          <meta>
            <column><![CDATA[1]]></column>
          </meta>
          <row>
            <column><![CDATA[1]]></column>
          </row>
        </table>
      </test>
    </data>

Note, that the text after the '# OPEN'-comment is being used as a tag-name for the data.

Date:

Thu Mar 28 2005

Author:

Jan Wedekind (wedesoft@users.sourceforge.net)

Definition at line 57 of file xsu.hpp.

---

Constructor & Destructor Documentation

XSU::XSU

(

DatabasePtr

_database

)

[inline]

Constructor. The constructor takes a reference to a database as argument.

Parameters:

_database

Database to pass SQL-queries to.

Definition at line 63 of file xsu.hpp.

: database( _database ) {}

---

Member Function Documentation

void XSU::translate	(	std::istream &	inputStream,
		std::ostream &	outputStream
	)			const throw (Error) [virtual]

Do SQL-queries.

Parameters:

	inputStream	Input containing sequence of SQL-queries.
	outputStream	Stream to write XML-output to.

Implements Compiler.

Definition at line 24 of file xsu.cpp.

References ERRORMACRO, and xmlText().

{

  outputStream << "<?xml version='1.0' encoding='"SQLENCODING"'?>" << endl
               << "<data>" << endl;

  stack< string > tagName;

  while ( inputStream ) {

    string line;
    getline( inputStream, line );

    if ( line[0] == '#' ) {

      // Encountering comment. Check for possible "# OPEN tagname;" hook.
      if ( line.compare( 1, 5, " OPEN" ) == 0 ) {
        tagName.push( line.substr( 7, line.size() - 8 ) );
        // The error-handling for proper tag-names has to be done by the
        // Xalan-library at the moment.
        outputStream << "<" << tagName.top() << '>' << endl;
      } else if ( line.compare( 1, 6, " CLOSE" ) == 0 ) {
        string closingTagName = line.substr( 8, line.size() - 9 );
        ERRORMACRO( !tagName.empty(), Error, ,
                    "Cannot close tag \"" << closingTagName << "\", because "
                    "all tags have been closed already." );
        ERRORMACRO( tagName.top() == closingTagName, Error, ,
                    "Encountered closing of tag \"" << closingTagName
                    << "\", but was expecting closing of tag with name \""
                    << tagName.top() << "\"." );
        outputStream << "</" << closingTagName << '>' << endl;
        tagName.pop();
      };

    } else {

      // Pass on content to unixODBC/ODBC interface.
      StatementPtr statement = database->execQuery( line );

      if ( !tagName.empty() && statement->getNumCols() > 0 ) {

        // Extract meta-data.
        outputStream << "    <table>" << endl
                     << "      <meta>" << endl;
        for ( int i=0; i<statement->getNumCols(); i++ )
          outputStream << "        <column>"
                       << xmlText( statement->getColAttr( i ) )
                       << "</column>" << endl;
        outputStream << "      </meta>" << endl;

        // Extract data.
        ResultRowPtr row;
        while ( row = statement->fetchRow() ) {
          outputStream << "      <row>" << endl;
          for ( int i=0; i<statement->getNumCols(); i++ )
            outputStream << "        <column>" << xmlText( (*row)[i] )
                         << "</column>" << endl;
          outputStream << "      </row>" << endl;
          // Release object accessing results.
          row.reset();
        };
        outputStream << "    </table>" << endl;

      };
    };
  };

  ERRORMACRO( tagName.empty(), Error, ,
              "Expected closing of tag \"" << tagName.top() << "\"." );

  outputStream << "</data>" << endl;
}

---

Field Documentation

DatabasePtr XSU::database [protected]

Pointer to database.

Definition at line 72 of file xsu.hpp.

---

The documentation for this class was generated from the following files:

• xsu.hpp
• xsu.cpp

---