Re: [Babeldoc-devel] Database Tables

[bruce <br...@mc...>]

Erik,

Does this meet want you need?



On Friday 28 March 2003 09:56 am, bruce wrote:
> On Friday 28 March 2003 09:49 am, Dejan Krsmanovic wrote:
> > You could store script as document atribute. There is pipeline stage
> > called sqlEnrich wich you can use to get data from database using any sql
> > query and store the result as document attribute. That way you can use it
> > as inline script in XslTransform witout changing original babeldoc db
> > schema
>
> Yes - thats a great idea.  But even so, we will still have to make the
> change to the XslTransformPipelineStage to load the script inline.  I will
> make this change.
>
> > Dejan
> >
> > ----- Original Message -----
> > From: <ek...@ba...>
> > To: "Babeldoc Developers List" <bab...@li...>
> > Sent: Friday, March 28, 2003 3:37 PM
> > Subject: Re: [Babeldoc-devel] Database Tables
> >
> > > <<
> > >
> > > > We add another configuration parameter to the XslTransform that
> > >
> > > provides
> > >
> > > > the
> > > > XSL document inline.  This will be in addition to the file
> > >
> > > configuration
> > >
> > > > parameter.  So the logic is:
> > > >
> > > > 1.  If the file/url parameter is not null, load from the url
> > > > 2.  if the inline parameter is not null, use the XSL in the parameter
> > > >
> > > >
> > > > I'm not sure of the method signature that would take this, but is it
> > > > possible to have an overloaded implementation that has one method
> > > > that takes a URL and another that takes a String?
> > >
> > > No, we have another configuration parameter for the XslTransform
> > > pipeline
> > > stage called, say transformationScript.  This contains the script
> > > inline
> > >
> > > > Also, how would this information be stored in the Properties Files /
> > > > CONFIG table?  An additional key/value pair or column?  Or are you
> > > > thinking of using the existing key / cfg_value field to store EITHER
> > >
> > > the
> > >
> > > > URL or the actual script?  If this is your choice, the db schema has
> > >
> > > to
> > >
> > > > change to support more than 255 chars.
> > >
> > > Bingo - we will have to increase the storage area.  The script will get
> > > stored
> > > in the cfg_value column.
> > >
> > >
> > > Sounds good to me.  However, I feel strongly that the database fields
> > > needs to be an unlimited length text field, which may require special
> > > JDBC processing like you have for BLOBs ... but I was under the
> > > assumption that JDBC 2.0 supported this directly without special
> > > coding.
> > >
> > > Also, is this type of functionality needed for other Pipeline Stages
> > > (other than XslTransform)?
> > >
> > > Erik
> > >
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.net email is sponsored by:
> > > The Definitive IT and Networking Event. Be There!
> > > NetWorld+Interop Las Vegas 2003 -- Register today!
> > > http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
> > > _______________________________________________
> > > Babeldoc-devel mailing list
> > > Bab...@li...
> > > https://lists.sourceforge.net/lists/listinfo/babeldoc-devel
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by:
> > The Definitive IT and Networking Event. Be There!
> > NetWorld+Interop Las Vegas 2003 -- Register today!
> > http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
> > _______________________________________________
> > Babeldoc-devel mailing list
> > Bab...@li...
> > https://lists.sourceforge.net/lists/listinfo/babeldoc-devel
>
> -------------------------------------------------------
> This SF.net email is sponsored by:
> The Definitive IT and Networking Event. Be There!
> NetWorld+Interop Las Vegas 2003 -- Register today!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
> _______________________________________________
> Babeldoc-devel mailing list
> Bab...@li...
> https://lists.sourceforge.net/lists/listinfo/babeldoc-devel