Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
Subject: Re: Show the SQL that will be generated by an EJBQLQuery?
From: Andrus Adamchik <andrus@objectstyle.org>
In-Reply-To: <9D3823BE-B5B6-41F6-B55C-B022F8B07E60@karlmenn.is>
Date: Tue, 16 Aug 2016 18:49:40 +0300
Content-Transfer-Encoding: quoted-printable
Message-Id: <66CFAB55-9367-4D0A-8785-F42CCD8C3802@objectstyle.org>
References: <9D3823BE-B5B6-41F6-B55C-B022F8B07E60@karlmenn.is>
To: user@cayenne.apache.org
archived-at: Tue, 16 Aug 2016 15:49:48 -0000

EJBQL translation goes through a phase of creating a SQLTemplate, which =
is essentially SQL with embedded Velocity directives. Then SQLTemplate =
is executed against the DB. All this happens inside EJBQLAction [1]. So =
perhaps you can copy some of this code and put it in your unit test and =
analyze SQLTemplate contents?=20

The only "context" you will need is DataNode. It is available via =
injection inside any test that inherits from ServerCase:

@Inject
protected DataNode node;

Andrus

[1] =
https://github.com/apache/cayenne/blob/master/cayenne-server/src/main/java=
/org/apache/cayenne/access/jdbc/EJBQLAction.java


> On Aug 16, 2016, at 6:36 PM, Hugi Thordarson <hugi@karlmenn.is> wrote:
>=20
> Hi all,
> since I want to try to do a little work on EJBQL in Cayenne; is there =
any way for me to generate and look at the SQL that will be generated by =
an EJBQLQuery without actually submitting it to the DB?
>=20
> Cheers,
> - hugi
>=20
> // Hugi Thordarson
> // http://www.loftfar.is/
> // s. 895-6688
>=20
>=20
>=20