001/* 002 * JKNIV, whinstone one contract to access your database. 003 * 004 * Copyright (C) 2017, the original author or authors. 005 * 006 * This library is free software; you can redistribute it and/or 007 * modify it under the terms of the GNU Lesser General Public 008 * License as published by the Free Software Foundation; either 009 * version 2.1 of the License. 010 * 011 * This library is distributed in the hope that it will be useful, 012 * but WITHOUT ANY WARRANTY; without even the implied warranty of 013 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU 014 * Lesser General Public License for more details. 015 * 016 * You should have received a copy of the GNU Lesser General Public 017 * License along with this library; if not, write to the Free Software Foundation, Inc., 018 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA 019 */ 020package net.sf.jkniv.whinstone.cassandra.dialect; 021 022import net.sf.jkniv.sqlegance.dialect.AnsiDialect; 023import net.sf.jkniv.sqlegance.dialect.SqlFeatureFactory; 024import net.sf.jkniv.sqlegance.dialect.SqlFeatureSupport; 025 026/** 027 * Dialect to Cassandra 028 * 029 * <p> 030 * Limit clause: 031 * <code>select name from author LIMIT 1 </code> 032 * </p> 033 * 034 * <ul> 035 * <li>Supports limits? true</li> 036 * <li>Supports limit off set? false</li> 037 * <li>Supports rownum? false</li> 038 * </ul> 039 * 040 * 041 * @author Alisson Gomes 042 * @since 0.6.0 043 */ 044public class CassandraDialect extends AnsiDialect 045{ 046 public CassandraDialect() 047 { 048 super(); 049 addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.LIMIT, true)); 050 addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.LIMIT_OFF_SET, false)); 051 addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.CONN_HOLDABILITY, false)); 052 addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.BOOKMARK_QUERY, true)); 053 addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.PAGING_ROUNDTRIP, false)); 054 } 055 056 /* 057 * LIMIT clause for Cassandra, where LIMIT is parameter from String.format 058 * 059 * @return Return query pattern: 060 * <p> 061 * <code>select name from author LIMIT 1</code> 062 * 063 * 064 @Override 065 public String getSqlPatternPaging() 066 { 067 return "%1$s LIMIT %2$s"; 068 } 069 */ 070}