I had a little play, and it looks somewhat promising. Hope this is enough to
get you started...
Cheers
Kerry
public class TestSelectHacking extends TestBase {
private void testParser() throws SQLException {
JdbcConnection cj = (JdbcConnection) getConnection("play");
Session s = (Session) cj.getSession();
Statement stat = cj.createStatement();
stat.execute("drop table if exists tab");
stat.execute("create table tab(v1 int, v2 int)");
stat.execute("insert into tab(v1, v2) values (6, 7)");
Prepared prep = s.prepare("SELECT v1 from tab");
Select select = (Select) prep;
select.getExpressions().add(new ExpressionColumn(s.getDatabase(),
null, null, "V2"));
select.getExpressions().add(ValueExpression.get(ValueString.get("BBBB")));
select.init();
System.out.println("NOW: " + prep.getPlanSQL());
ResultSet rs = stat.executeQuery(prep.getPlanSQL());
assertTrue(rs.next());
assertEquals(6, rs.getInt(1));
assertEquals(7, rs.getInt(2));
assertEquals("BBBB", rs.getString(3));
stat.execute("drop table tab");
}
On Tue, Jun 22, 2010 at 2:57 PM, Erin Drummond <[email protected]> wrote:
> Hi,
>
> I have a need to take a user-supplied SQL query and perform a few
> modifications to it before allowing it to execute against the
> database. Mostly, this consists of injecting in extra field names and
> conditions. I need this to be transparent to the user because the user
> cannot be relied on to include this information.
>
> Is it possible to use H2 to take a SQL string, convert it into a
> datastructure, then allow me to manipulate that datastructure (to add
> extra tables/fields/conditions/expressions), then convert it back into
> a SQL statement for executing against the database?
>
> Thanks,
> Erin
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<h2-database%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
