1 /*
2 * Copyright 2013 smartics, Kronseder & Reiner GmbH
3 *
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
7 *
8 * http://www.apache.org/licenses/LICENSE-2.0
9 *
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
15 */
16 package de.smartics.properties.config.transfer.templatestream;
17
18 import org.apache.commons.lang.StringEscapeUtils;
19
20 /**
21 * Creates instances of {@link StreamPropertySink} by providing a template to
22 * generate SQL statements for HSQL databases.
23 */
24 public class HSqlFactory extends Factory
25 {
26 // ********************************* Fields *********************************
27
28 // --- constants ------------------------------------------------------------
29
30 // --- members --------------------------------------------------------------
31
32 // ****************************** Initializer *******************************
33
34 // ****************************** Constructors ******************************
35
36 /**
37 * Default constructor.
38 */
39 public HSqlFactory()
40 {
41 setLineIntro("-- ${location}${newline}");
42 setEscaper(new EscapeAllTheSameValueEscaper()
43 {
44 @Override
45 public String escapeValue(final String value)
46 {
47 return StringEscapeUtils.escapeSql(value);
48 }
49 });
50
51 final String template =
52 "MERGE INTO ${table} USING (VALUES '${configKey}','${name}','${value}') N (c,n,v)"
53 + " ON ${table}.${configColumn}=N.c AND ${table}.${nameColumn}=N.n"
54 + " WHEN MATCHED THEN UPDATE SET ${valueColumn} = '${value}'"
55 + " WHEN NOT MATCHED THEN INSERT (${configColumn}, ${nameColumn}, ${valueColumn})"
56 + " VALUES ('${configKey}','${name}','${value}');${newline}";
57 setTemplate(template);
58 }
59
60 // ****************************** Inner Classes *****************************
61
62 // ********************************* Methods ********************************
63
64 // --- init -----------------------------------------------------------------
65
66 // --- get&set --------------------------------------------------------------
67
68 // --- business -------------------------------------------------------------
69
70 // --- object basics --------------------------------------------------------
71
72 }