be.images.fabric8.quickstart-karaf-camelrest.2.0.41.source-code.sql.properties Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of quickstart-karaf-camelrest Show documentation

Camel Example using Rest DSL with SQL Database

There is a newer version: 2.2.28

Show newest version

## ------------------------------------------------------------------------
## 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.
## ------------------------------------------------------------------------

## notice we use named parameters in the queries, eg :#name. A named query parameter must start with :#
## sql that insert new orders
sql.insertOrder=insert into orders (id, item, amount, description, processed) values (:#${body.id} , :#${body.item}, :#${body.amount}, :#${body.description}, false)

## sql that select all unprocessed orders
sql.selectUnprocessedOrders=select * from orders where processed = false

## sql that update the order as being processed
sql.markOrder=update orders set processed = true where id = :#id

## sql order by id
sql.selectOrder=select * from orders where id = :#id

## sql select all books (simplify by just returning all the distinct descriptions)
sql.selectBooks=select distinct description from orders