activemq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jstrac...@apache.org
Subject svn commit: r529167 - in /activemq/camel/trunk/camel-josql: ./ src/ src/main/ src/main/java/ src/main/java/org/ src/main/java/org/apache/ src/main/java/org/apache/camel/ src/main/java/org/apache/camel/builder/ src/main/java/org/apache/camel/builder/sql...
Date Mon, 16 Apr 2007 08:37:29 GMT
Author: jstrachan
Date: Mon Apr 16 01:37:25 2007
New Revision: 529167

URL: http://svn.apache.org/viewvc?view=rev&rev=529167
Log:
added support for SQL expressions and predicates on POJOs using JoSQL

Added:
    activemq/camel/trunk/camel-josql/
    activemq/camel/trunk/camel-josql/pom.xml
    activemq/camel/trunk/camel-josql/src/
    activemq/camel/trunk/camel-josql/src/main/
    activemq/camel/trunk/camel-josql/src/main/java/
    activemq/camel/trunk/camel-josql/src/main/java/org/
    activemq/camel/trunk/camel-josql/src/main/java/org/apache/
    activemq/camel/trunk/camel-josql/src/main/java/org/apache/camel/
    activemq/camel/trunk/camel-josql/src/main/java/org/apache/camel/builder/
    activemq/camel/trunk/camel-josql/src/main/java/org/apache/camel/builder/sql/
    activemq/camel/trunk/camel-josql/src/main/java/org/apache/camel/builder/sql/SqlBuilder.java
    activemq/camel/trunk/camel-josql/src/test/
    activemq/camel/trunk/camel-josql/src/test/java/
    activemq/camel/trunk/camel-josql/src/test/java/org/
    activemq/camel/trunk/camel-josql/src/test/java/org/apache/
    activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/
    activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/
    activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/sql/
    activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/sql/Person.java
    activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/sql/SqlTest.java

Added: activemq/camel/trunk/camel-josql/pom.xml
URL: http://svn.apache.org/viewvc/activemq/camel/trunk/camel-josql/pom.xml?view=auto&rev=529167
==============================================================================
--- activemq/camel/trunk/camel-josql/pom.xml (added)
+++ activemq/camel/trunk/camel-josql/pom.xml Mon Apr 16 01:37:25 2007
@@ -0,0 +1,73 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+  
+  http://www.apache.org/licenses/LICENSE-2.0
+  
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
+
+<project xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"
+         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://maven.apache.org/POM/4.0.0">
+
+  <modelVersion>4.0.0</modelVersion>
+
+  <parent>
+    <groupId>org.apache.camel</groupId>
+    <artifactId>camel-parent</artifactId>
+    <version>1.0-SNAPSHOT</version>
+  </parent>
+
+  <artifactId>camel-josql</artifactId>
+  <name>Camel :: JoSQL</name>
+  <description>Camel JoSQL support</description>
+
+  <dependencies>
+
+    <dependency>
+      <groupId>org.apache.camel</groupId>
+      <artifactId>camel-core</artifactId>
+    </dependency>
+
+    <dependency>
+      <groupId>org.apache.camel</groupId>
+      <artifactId>camel-core</artifactId>
+      <type>test-jar</type>
+      <optional>true</optional>
+      <scope>test</scope>
+    </dependency>
+
+    <dependency>
+      <groupId>org.springframework</groupId>
+      <artifactId>spring</artifactId>
+    </dependency>
+
+    <dependency>
+      <groupId>commons-logging</groupId>
+      <artifactId>commons-logging</artifactId>
+    </dependency>
+
+    <dependency>
+      <groupId>org.apache.geronimo.specs</groupId>
+      <artifactId>geronimo-jms_1.1_spec</artifactId>
+    </dependency>
+
+
+    <dependency>
+      <groupId>junit</groupId>
+      <artifactId>junit</artifactId>
+      <scope>test</scope>
+    </dependency>
+  </dependencies>
+
+</project>

Added: activemq/camel/trunk/camel-josql/src/main/java/org/apache/camel/builder/sql/SqlBuilder.java
URL: http://svn.apache.org/viewvc/activemq/camel/trunk/camel-josql/src/main/java/org/apache/camel/builder/sql/SqlBuilder.java?view=auto&rev=529167
==============================================================================
--- activemq/camel/trunk/camel-josql/src/main/java/org/apache/camel/builder/sql/SqlBuilder.java
(added)
+++ activemq/camel/trunk/camel-josql/src/main/java/org/apache/camel/builder/sql/SqlBuilder.java
Mon Apr 16 01:37:25 2007
@@ -0,0 +1,138 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.camel.builder.sql;
+
+import org.apache.camel.Exchange;
+import org.apache.camel.Expression;
+import org.apache.camel.Message;
+import org.apache.camel.Predicate;
+import org.apache.camel.RuntimeExpressionException;
+import org.josql.Query;
+import org.josql.QueryExecutionException;
+import org.josql.QueryParseException;
+
+import java.util.Collections;
+import java.util.List;
+import java.util.Map;
+import java.util.Set;
+import java.util.HashMap;
+
+/**
+ * A builder of SQL {@link org.apache.camel.Expression} and {@link org.apache.camel.Predicate}
implementations
+ *
+ * @version $Revision: $
+ */
+public class SqlBuilder<E extends Exchange> implements Expression<E>, Predicate<E>
{
+
+    private Query query;
+    private Map<String,Object> variables = new HashMap<String, Object>();
+
+    public SqlBuilder(Query query) {
+        this.query = query;
+    }
+
+    public Object evaluate(E exchange) {
+        return evaluateQuery(exchange);
+    }
+
+    public boolean matches(E exchange) {
+        List list = evaluateQuery(exchange);
+        if (!list.isEmpty()) {
+            Object value = list.get(0);
+            if (value instanceof Boolean) {
+                Boolean flag = (Boolean) value;
+                return flag.booleanValue();
+            }
+            else {
+                // lets assume non-empty results are true
+                return true;
+            }
+        }
+        return false;
+    }
+
+    // Builder API
+    //-----------------------------------------------------------------------
+
+    /**
+     * Creates a new builder for the given SQL query string
+     *
+     * @param sql the SQL query to perform
+     * @return a new builder
+     * @throws QueryParseException if there is an issue with the SQL
+     */
+    public static <E extends Exchange> SqlBuilder<E> sql(String sql) throws QueryParseException
{
+        Query q = new Query();
+        q.parse(sql);
+        return new SqlBuilder(q);
+    }
+
+    /**
+     * Adds the variable value to be used by the SQL query
+     */
+    public SqlBuilder<E> variable(String name, Object value) {
+        getVariables().put(name, value);
+        return this;
+    }
+
+
+    // Properties
+    //-----------------------------------------------------------------------
+    public Map<String, Object> getVariables() {
+        return variables;
+    }
+
+    public void setVariables(Map<String, Object> properties) {
+        this.variables = properties;
+    }
+
+
+    // Implementation methods
+    //-----------------------------------------------------------------------
+    protected List evaluateQuery(E exchange) {
+        configureQuery(exchange);
+        Message in = exchange.getIn();
+        List list = in.getBody(List.class);
+        if (list == null) {
+            list = Collections.singletonList(in.getBody());
+        }
+        try {
+            return query.execute(list).getResults();
+        }
+        catch (QueryExecutionException e) {
+            throw new RuntimeExpressionException(e);
+        }
+    }
+
+    protected void configureQuery(E exchange) {
+        // lets pass in the headers as variables that the SQL can use
+        addVariables(exchange.getProperties());
+        addVariables(exchange.getIn().getHeaders());
+        addVariables(getVariables());
+
+        query.setVariable("exchange", exchange);
+        query.setVariable("in", exchange.getIn());
+        query.setVariable("out", exchange.getOut());
+    }
+
+    protected void addVariables(Map <String, Object> map) {
+        Set<Map.Entry<String, Object>> propertyEntries = map.entrySet();
+        for (Map.Entry<String, Object> entry : propertyEntries) {
+            query.setVariable(entry.getKey(), entry.getValue());
+        }
+    }
+}

Added: activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/sql/Person.java
URL: http://svn.apache.org/viewvc/activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/sql/Person.java?view=auto&rev=529167
==============================================================================
--- activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/sql/Person.java
(added)
+++ activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/sql/Person.java
Mon Apr 16 01:37:25 2007
@@ -0,0 +1,54 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.camel.builder.sql;
+
+/**
+ * @version $Revision: $
+ */
+public class Person {
+    private String name;
+    private String city;
+
+
+    public Person() {
+    }
+
+    public Person(String name, String city) {
+        this.name = name;
+        this.city = city;
+    }
+
+    public String toString() {
+        return "Person[" + name + "]";
+    }
+
+    public String getCity() {
+        return city;
+    }
+
+    public void setCity(String city) {
+        this.city = city;
+    }
+
+    public String getName() {
+        return name;
+    }
+
+    public void setName(String name) {
+        this.name = name;
+    }
+}

Added: activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/sql/SqlTest.java
URL: http://svn.apache.org/viewvc/activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/sql/SqlTest.java?view=auto&rev=529167
==============================================================================
--- activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/sql/SqlTest.java
(added)
+++ activemq/camel/trunk/camel-josql/src/test/java/org/apache/camel/builder/sql/SqlTest.java
Mon Apr 16 01:37:25 2007
@@ -0,0 +1,92 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.camel.builder.sql;
+
+import static org.apache.camel.builder.sql.SqlBuilder.sql;
+import org.apache.camel.CamelContext;
+import org.apache.camel.Exchange;
+import org.apache.camel.Expression;
+import org.apache.camel.Message;
+import org.apache.camel.TestSupport;
+import org.apache.camel.impl.DefaultCamelContext;
+import org.apache.camel.impl.DefaultExchange;
+
+import java.util.List;
+
+/**
+ * @version $Revision: $
+ */
+public class SqlTest extends TestSupport {
+
+    protected CamelContext context = new DefaultCamelContext();
+    protected Exchange exchange;
+
+    public void testExpression() throws Exception {
+        Expression expression = sql("SELECT * FROM org.apache.camel.builder.sql.Person where
city = 'London'");
+        Object value = expression.evaluate(exchange);
+        assertIsInstanceOf(List.class, value);
+
+        List list = (List) value;
+        assertEquals("List size", 2, list.size());
+
+        for (Object person : list) {
+            log.info("Found: " + person);
+        }
+    }
+
+    public void testExpressionWithHeaderVariable() throws Exception {
+        Expression expression = sql("SELECT * FROM org.apache.camel.builder.sql.Person where
name = :fooHeader");
+        Object value = expression.evaluate(exchange);
+        assertIsInstanceOf(List.class, value);
+
+        List<Person> list = (List<Person>) value;
+        assertEquals("List size", 1, list.size());
+
+        for (Person person : list) {
+            log.info("Found: " + person);
+
+            assertEquals("name", "James", person.getName());
+        }
+    }
+
+    public void testPredicates() throws Exception {
+        assertPredicate(sql("SELECT * FROM org.apache.camel.builder.sql.Person where city
= 'London'"), exchange, true);
+        assertPredicate(sql("SELECT * FROM org.apache.camel.builder.sql.Person where city
= 'Manchester'"), exchange, false);
+    }
+
+    public void testPredicateWithHeaderVariable() throws Exception {
+        assertPredicate(sql("SELECT * FROM org.apache.camel.builder.sql.Person where name
= :fooHeader"), exchange, true);
+    }
+
+    protected void setUp() throws Exception {
+        exchange = createExchange();
+    }
+
+    protected Exchange createExchange() {
+        Exchange exchange = new DefaultExchange(context);
+        Message message = exchange.getIn();
+        message.setHeader("fooHeader", "James");
+
+        Person[] people = {new Person("James", "London"),
+                new Person("Guillaume", "Normandy"),
+                new Person("Rob", "London"),
+                new Person("Hiram", "Tampa")};
+
+        message.setBody(people);
+        return exchange;
+    }
+}



Mime
View raw message