1 /*
2 * $Source$
3 * $Revision$
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 */
73 public String createTableTypeQualifierSql(Table<?> table) {
74 String tableType;
75 if (table == null || table.getDbmsTableType() == null)
76 tableType = "TEXT ";
77 else
78 tableType = table.getDbmsTableType() + " ";
79
80 return tableType;
81 }
82 /**
83 * {@inheritDoc}
84 * @see org.melati.poem.dbms.AnsiStandard#tableInitialisationSql(org.melati.poem.Table)
85 */
86 @Override
87 public String tableInitialisationSql(Table<?> table) {
88 String tableInitialisationSql = null;
89 if (table.getDbmsTableType() == null)
90 tableInitialisationSql = "SET TABLE " + getQuotedName(table.getName()) +
91 " SOURCE " + getQuotedName(table.getName() + ".csv;ignore_first=true;all_quoted=true");
92 else
93 if (table.getDbmsTableType().equals("TEXT"))
94 tableInitialisationSql = "SET TABLE " + getQuotedName(table.getName()) +
95 " SOURCE " + getQuotedName(table.getName() + ".csv;ignore_first=true;all_quoted=true");
96 System.err.println("Returning tableInitialisationSql:"+ tableInitialisationSql);
97 return tableInitialisationSql;
98 }
99
100
101 }