%line | %branch | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
org.apache.torque.adapter.DBPostgres |
|
|
1 | package org.apache.torque.adapter; |
|
2 | ||
3 | /* |
|
4 | * Copyright 2001-2005 The Apache Software Foundation. |
|
5 | * |
|
6 | * Licensed under the Apache License, Version 2.0 (the "License") |
|
7 | * you may not use this file except in compliance with the License. |
|
8 | * You may obtain a copy of the License at |
|
9 | * |
|
10 | * http://www.apache.org/licenses/LICENSE-2.0 |
|
11 | * |
|
12 | * Unless required by applicable law or agreed to in writing, software |
|
13 | * distributed under the License is distributed on an "AS IS" BASIS, |
|
14 | * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
|
15 | * See the License for the specific language governing permissions and |
|
16 | * limitations under the License. |
|
17 | */ |
|
18 | ||
19 | import java.sql.Connection; |
|
20 | import java.sql.SQLException; |
|
21 | import java.text.SimpleDateFormat; |
|
22 | import java.util.Date; |
|
23 | ||
24 | /** |
|
25 | * This is used to connect to PostgresQL databases. |
|
26 | * |
|
27 | * <a href="http://www.postgresql.org/">http://www.postgresql.org/</a> |
|
28 | * |
|
29 | * @author <a href="mailto:hakan42@gmx.de">Hakan Tandogan</a> |
|
30 | * @author <a href="mailto:hps@intermeta.de">Henning P. Schmiedehausen</a> |
|
31 | * @version $Id: DBPostgres.java 239636 2005-08-24 12:38:09Z henning $ |
|
32 | */ |
|
33 | public class DBPostgres extends DB |
|
34 | { |
|
35 | ||
36 | /** A specialized date format for PostgreSQL. */ |
|
37 | private static final String DATE_FORMAT = "yyyy-MM-dd HH:mm:ss"; |
|
38 | ||
39 | 1 | private SimpleDateFormat sdf = null; |
40 | ||
41 | /** |
|
42 | * Empty constructor. |
|
43 | */ |
|
44 | protected DBPostgres() |
|
45 | 1 | { |
46 | 1 | sdf = new SimpleDateFormat(DATE_FORMAT); |
47 | 1 | } |
48 | ||
49 | /** |
|
50 | * This method is used to ignore case. |
|
51 | * |
|
52 | * @param in The string to transform to upper case. |
|
53 | * @return The upper case string. |
|
54 | */ |
|
55 | public String toUpperCase(String in) |
|
56 | { |
|
57 | 0 | String s = new StringBuffer("UPPER(").append(in).append(")").toString(); |
58 | 0 | return s; |
59 | } |
|
60 | ||
61 | /** |
|
62 | * This method is used to ignore case. |
|
63 | * |
|
64 | * @param in The string whose case to ignore. |
|
65 | * @return The string in a case that can be ignored. |
|
66 | */ |
|
67 | public String ignoreCase(String in) |
|
68 | { |
|
69 | 0 | String s = new StringBuffer("UPPER(").append(in).append(")").toString(); |
70 | 0 | return s; |
71 | } |
|
72 | ||
73 | /** |
|
74 | * @see org.apache.torque.adapter.DB#getIDMethodType() |
|
75 | */ |
|
76 | public String getIDMethodType() |
|
77 | { |
|
78 | 0 | return SEQUENCE; |
79 | } |
|
80 | ||
81 | /** |
|
82 | * @param name The name of the field (should be of type |
|
83 | * <code>String</code>). |
|
84 | * @return SQL to retreive the next database key. |
|
85 | * @see org.apache.torque.adapter.DB#getIDMethodSQL(Object) |
|
86 | */ |
|
87 | public String getIDMethodSQL(Object name) |
|
88 | { |
|
89 | 0 | return ("select nextval('" + name + "')"); |
90 | } |
|
91 | ||
92 | /** |
|
93 | * Locks the specified table. |
|
94 | * |
|
95 | * @param con The JDBC connection to use. |
|
96 | * @param table The name of the table to lock. |
|
97 | * @exception SQLException No Statement could be created or executed. |
|
98 | */ |
|
99 | public void lockTable(Connection con, String table) throws SQLException |
|
100 | { |
|
101 | 0 | } |
102 | ||
103 | /** |
|
104 | * Unlocks the specified table. |
|
105 | * |
|
106 | * @param con The JDBC connection to use. |
|
107 | * @param table The name of the table to unlock. |
|
108 | * @exception SQLException No Statement could be created or executed. |
|
109 | */ |
|
110 | public void unlockTable(Connection con, String table) throws SQLException |
|
111 | { |
|
112 | 0 | } |
113 | ||
114 | /** |
|
115 | * This method is used to chek whether the database natively |
|
116 | * supports limiting the size of the resultset. |
|
117 | * |
|
118 | * @return True. |
|
119 | */ |
|
120 | public boolean supportsNativeLimit() |
|
121 | { |
|
122 | 0 | return true; |
123 | } |
|
124 | ||
125 | /** |
|
126 | * This method is used to chek whether the database natively |
|
127 | * supports returning results starting at an offset position other |
|
128 | * than 0. |
|
129 | * |
|
130 | * @return True. |
|
131 | */ |
|
132 | public boolean supportsNativeOffset() |
|
133 | { |
|
134 | 0 | return true; |
135 | } |
|
136 | ||
137 | /** |
|
138 | * This method is used to chek whether the database supports |
|
139 | * limiting the size of the resultset. |
|
140 | * |
|
141 | * @return LIMIT_STYLE_POSTGRES. |
|
142 | */ |
|
143 | public int getLimitStyle() |
|
144 | { |
|
145 | 0 | return DB.LIMIT_STYLE_POSTGRES; |
146 | } |
|
147 | ||
148 | /** |
|
149 | * Override the default behavior to associate b with null? |
|
150 | * |
|
151 | * @see DB#getBooleanString(Boolean) |
|
152 | */ |
|
153 | public String getBooleanString(Boolean b) |
|
154 | { |
|
155 | 1 | return (b == null) ? "FALSE" : (Boolean.TRUE.equals(b) ? "TRUE" : "FALSE"); |
156 | } |
|
157 | ||
158 | /** |
|
159 | * This method overrides the JDBC escapes used to format dates |
|
160 | * using a <code>DateFormat</code>. |
|
161 | * |
|
162 | * This generates the timedate format defined in |
|
163 | * http://www.postgresql.org/docs/7.3/static/datatype-datetime.html |
|
164 | * which defined PostgreSQL dates as YYYY-MM-DD hh:mm:ss |
|
165 | * @param date the date to format |
|
166 | * @return The properly formatted date String. |
|
167 | */ |
|
168 | public String getDateString(Date date) |
|
169 | { |
|
170 | 0 | StringBuffer dateBuf = new StringBuffer(); |
171 | 0 | char delim = getStringDelimiter(); |
172 | 0 | dateBuf.append(delim); |
173 | 0 | dateBuf.append(sdf.format(date)); |
174 | 0 | dateBuf.append(delim); |
175 | 0 | return dateBuf.toString(); |
176 | } |
|
177 | } |
This report is generated by jcoverage, Maven and Maven JCoverage Plugin. |