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 }