| ## ------------------------------------------------------------------------ |
| ## 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. |
| ## ------------------------------------------------------------------------ |
| |
| ## START SNIPPET: e1 |
| ## 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 (:#id, :#item, :#amount, :#description, false) |
| |
| ## sql that select all unprocessed orders |
| sql.selectOrder=select * from orders where processed = false |
| |
| ## sql that update the order as being processed |
| sql.markOrder=update orders set processed = true where id = :#id |
| |
| ## END SNIPPET: e1 |