org.pricingnexus.helper
Class DatabaseExtract

java.lang.Object
  |
  +--org.pricingnexus.helper.DatabaseExtract

public class DatabaseExtract

extends java.lang.Object

The application needs the following arguments in the command line to work

• #0 : Name of a valid PricingNexus INI-file
• #1 : Name of database system; needed for creation of matching escape codes, currently supported is "sybase" only
• #2 : Name of table to extract data from
• #3... : Name of columns to extract
Output goes to STDOUT - please feel free to pipe, tee or whatever *g*
Sorry for the somewhat quick'n dirty style, this shorty has been developed while traveling by train from Frankfurt to Essen and back some days later ,-)) $Header$

Constructor Summary

DatabaseExtract()


Method Summary

java.lang.StringBuffer	doEscape(java.lang.StringBuffer db, char ch, char ins) This small little code searches all occurences of the char ch in the StringBuffer db and inserts the ins char before this to escape this char.
static void	main(java.lang.String[] args)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DatabaseExtract

public DatabaseExtract()

Method Detail

main

public static void main(java.lang.String[] args)

doEscape

public java.lang.StringBuffer doEscape(java.lang.StringBuffer db,
                                       char ch,
                                       char ins)

This small little code searches all occurences of the char ch in the StringBuffer db and inserts the ins char before this to escape this char. This must be hardcoded for every database. It will problably become a small repository of datbase escape codes in the future *G*

Parameters:

db - StringBuffer that needs to be examined

ch - char that shall be searched for

ins - char that shall be put before any occurence of ch