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 MySQL databases.
23 */
24 public class MySqlFactory 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 MySqlFactory()
40 {
41 setLineIntro("-- ${location}${newline}");
42 setEscaper(new ValueEscaper()
43 {
44 @Override
45 public String escape(final String value)
46 {
47 return StringEscapeUtils.escapeSql(value);
48 }
49 });
50
51 final String template =
52 "INSERT INTO ${table} VALUES ('${configKey}','${name}','${value}')"
53 + " ON DUPLICATE KEY UPDATE ${valueColumn} = '${value}';${newline}";
54 setTemplate(template);
55 }
56
57 // ****************************** Inner Classes *****************************
58
59 // ********************************* Methods ********************************
60
61 // --- init -----------------------------------------------------------------
62
63 // --- get&set --------------------------------------------------------------
64
65 // --- business -------------------------------------------------------------
66
67 // --- object basics --------------------------------------------------------
68
69 }