1 /*
2 * $Source: /usr/cvsroot/melati/poem/src/main/java/org/melati/poem/dbms/HsqldbText.java,v $
3 * $Revision: 1.4 $
4 *
5 * Copyright (C) 2008 Tim Pizey
6 *
7 * Part of Melati (http://melati.org), a framework for the rapid
8 * development of clean, maintainable web applications.
9 *
10 * Melati is free software; Permission is granted to copy, distribute
11 * and/or modify this software under the terms either:
12 *
13 * a) the GNU General Public License as published by the Free Software
14 * Foundation; either version 2 of the License, or (at your option)
15 * any later version,
16 *
17 * or
18 *
19 * b) any version of the Melati Software License, as published
20 * at http://melati.org
21 *
22 * You should have received a copy of the GNU General Public License and
23 * the Melati Software License along with this program;
24 * if not, write to the Free Software Foundation, Inc.,
25 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA to obtain the
26 * GNU General Public License and visit http://melati.org to obtain the
27 * Melati Software License.
28 *
29 * Feel free to contact the Developers of Melati (http://melati.org),
30 * if you would like to work out a different arrangement than the options
31 * outlined here. It is our intention to allow Melati to be used by as
32 * wide an audience as possible.
33 *
34 * This program is distributed in the hope that it will be useful,
35 * but WITHOUT ANY WARRANTY; without even the implied warranty of
36 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
37 * GNU General Public License for more details.
38 *
39 * Contact details for copyright holder:
40 *
41 * Tim Pizey <timp At paneris.org>
42 * http://paneris.org/~timp
43 */
44
45 package org.melati.poem.dbms;
46
47 import org.melati.poem.Table;
48
49 /**
50 * Use CSV tables as backing store.
51 *
52 * NOTE 2010/10/24 I could not get this working due to problems with prepaed statements.
53 *
54 * @author timp
55 * @since 23 Sep 2008
56 *
57 */
58 public class HsqldbText extends Hsqldb {
59 /**
60 * {@inheritDoc}
61 * @see org.melati.poem.dbms.Dbms#canDropColumns()
62 */
63 @Override
64 public boolean canDropColumns(){
65 return false;
66 }
67
68 /**
69 * The default is to keep everything in memory,
70 * this allows for the db to be written to the disk.
71 *
72 * {@inheritDoc}
73 * @see org.melati.poem.dbms.Dbms#createTableSql()
74 * @see org.melati.poem.dbms.AnsiStandard#createTableSql()
75 */
76 public String createTableTypeQualifierSql(Table<?> table) {
77 String tableType;
78 if (table == null || table.getDbmsTableType() == null)
79 tableType = "TEXT ";
80 else
81 tableType = table.getDbmsTableType() + " ";
82
83 return tableType;
84 }
85 /**
86 * {@inheritDoc}
87 * @see org.melati.poem.dbms.AnsiStandard#tableInitialisationSql(org.melati.poem.Table)
88 */
89 @Override
90 public String tableInitialisationSql(Table<?> table) {
91 String tableInitialisationSql = null;
92 if (table.getDbmsTableType() == null)
93 tableInitialisationSql = "SET TABLE " + getQuotedName(table.getName()) +
94 " SOURCE " + getQuotedName(table.getName() + ".csv;ignore_first=true;all_quoted=true");
95 else
96 if (table.getDbmsTableType().equals("TEXT"))
97 tableInitialisationSql = "SET TABLE " + getQuotedName(table.getName()) +
98 " SOURCE " + getQuotedName(table.getName() + ".csv;ignore_first=true;all_quoted=true");
99 System.err.println("Returning tableInitialisationSql:"+ tableInitialisationSql);
100 return tableInitialisationSql;
101 }
102
103
104 }