ConfigPropertiesCSkin.java
3.29 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
/*
* @(#)ConfigPropertiesCSkin.java 1.7.1,126 custom 2014-06-22T22:00:00Z UTC
* Built automatically by REVERSER
*/
package it.softecspa.fileproxy.db.skins.criterias;
import it.softecspa.database.dbconnect.ConnectionManager;
import it.softecspa.fileproxy.db.ConfigProperties;
import it.softecspa.kahuna.sql.SqlWriter;
import org.apache.log4j.Logger;
/**
* Abstract criteria filter for table T001_CONFIG_PROPERTIES
* Class auto generated by REVERSER, version 1.7.1,126 custom
*
* Warning: this class will be rewrited from REVERSER
*
* @author il Vera
*/
public abstract class ConfigPropertiesCSkin {
protected Logger log = Logger.getLogger(getClass());
protected ConnectionManager cm;
// V_KEY - VARCHAR(50) NOT NULL PK
protected String key;
// V_VALUE - VARCHAR(256) NOT NULL
protected String value;
// V_DESCRIPTION - VARCHAR(100) nullable
protected String description;
protected String custom_order_by;
protected String custom_add_where;
protected String custom_add_options;
protected ConfigPropertiesCSkin(ConnectionManager cm) {
super();
this.cm = cm;
}
public String getKey() {
return this.key;
}
public void setKey(String value) {
this.key = value;
}
public String getValue() {
return this.value;
}
public void setValue(String value) {
this.value = value;
}
public String getDescription() {
return this.description;
}
public void setDescription(String value) {
this.description = value;
}
/**
* ORDER BY condition
*/
public void orderBy(String value) {
this.custom_order_by = value;
}
/**
* Custom WHERE condition to add in query composition
*/
public void addCustomWhere(String value) {
this.custom_add_where = value;
}
/**
* Custom option to add in query composition
*/
public void addCustomOptions(String value) {
this.custom_add_options = value;
}
public ConnectionManager getConnectionManager() {
return this.cm;
}
/**
* Columns used in select with alias
*/
protected String getColumns(String alias) {
return alias+".v_key" +
", "+alias+".v_value" +
", "+alias+".v_description";
}
/**
* Build select * using alias
*/
protected SqlWriter getSelectAll(String alias) {
SqlWriter sql = new SqlWriter();
sql.setColumns(getColumns(alias));
sql.setTables(ConfigProperties.NAME +" "+ alias);
return sql;
}
/**
* Build select * with filter with standard alias 't'
*/
protected SqlWriter getSelect() {
return getSelect("t");
}
/**
* Build select * with filter using custom alias
*/
protected SqlWriter getSelect(String alias) {
SqlWriter sql = getSelectAll(alias);
if (this.key != null) sql.addWhere(alias+".v_key = "+ sql.fStr(this.key));
if (this.value != null) sql.addWhere(alias+".v_value = "+ sql.fStr(this.value));
if (this.description != null) sql.addWhere(alias+".v_description = "+ sql.fStr(this.description));
// Custom WHERE
if (this.custom_add_where!=null) sql.addWhere(this.custom_add_where);
// Custom OPTIONS
if (this.custom_add_options!=null) sql.addOption(this.custom_add_options);
// Custom ORDER_BY
if (this.custom_order_by!=null) sql.addOption("ORDER BY "+this.custom_order_by);
return sql;
}
}