Return-Path: Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 49168 invoked from network); 25 May 2003 13:15:52 -0000 Received: from kholmes.gotadsl.co.uk (HELO www.Open-IQ.com) (81.6.222.202) by daedalus.apache.org with SMTP; 25 May 2003 13:15:52 -0000 Received: from 192.168.0.2 ([192.168.0.2]) by www.Open-IQ.com (JAMES SMTP Server 2.1.2) with SMTP ID 905 for ; Sun, 25 May 2003 13:29:40 +0100 (BST) Message-ID: <008801c322c0$3c759570$0200a8c0@openiqworksta> From: "Kevin_lists" To: Subject: template fixes for data/dump and sql/load Date: Sun, 25 May 2003 14:18:45 +0100 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0082_01C322C8.8D7A1E20" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N ------=_NextPart_000_0082_01C322C8.8D7A1E20 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0083_01C322C8.8D7A1E20" ------=_NextPart_001_0083_01C322C8.8D7A1E20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All Congratulations on splitting out torque-gen, even at alpha one its a = killa tool.=20 We're using it to port one of our clients from oracle to postgres and = I've come across a couple of wrinkles. 1) derives from velocity's counter-intuitive #set directive behaviour, = which does NOT set the LHS if the RHS evaluates to null, so the current = data/dump/Control.vm template repeats values from columns with non-null = values into succeeding columns with null values.=20 2) strings containing single quotes arnt escaped when running the = datasql task so I used String.replaceAll in the = sql/load/postgresql/val.vm template. Obviously a similar fix needs to be = applied for the other databases. Ive attached diff files for the two templates : Control-vm.diff for = torque-gen-3.1-alpha1\templates\data\dump\Control.vm and val-vm.dif for = torque-gen-3.1-alpha1\templates\sql\load\postgresql\val.vm cheers, Kevin Holmes. ------=_NextPart_001_0083_01C322C8.8D7A1E20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi All

Congratulations on splitting out = torque-gen, even=20 at alpha one its a killa tool.

We're using it to port one of our = clients from=20 oracle to postgres and I've come across a couple of = wrinkles.

1) derives from velocity's = counter-intuitive=20 #set directive behaviour, which does NOT set the LHS if the RHS = evaluates to=20 null, so the current data/dump/Control.vm template repeats values = from=20 columns with non-null values into succeeding columns with null values.=20

2) strings containing single quotes = arnt escaped=20 when running the datasql task so I used String.replaceAll in the=20 sql/load/postgresql/val.vm template. Obviously a similar fix needs to be = applied=20 for the other databases.

Ive attached diff files for the two = templates=20 :

Control-vm.diff for=20 torque-gen-3.1-alpha1\templates\data\dump\Control.vm and

val-vm.dif for=20 torque-gen-3.1-alpha1\templates\sql\load\postgresql\val.vm

cheers,

Kevin = Holmes.

------=_NextPart_001_0083_01C322C8.8D7A1E20-- ------=_NextPart_000_0082_01C322C8.8D7A1E20--