/* * Copyright (c) 1998-2011 Caucho Technology -- all rights reserved * * This file is part of Resin(R) Open Source * * Each copy or derived work must preserve the copyright notice and this * notice unmodified. * * Resin Open Source is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * Resin Open Source is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE, or any warranty * of NON-INFRINGEMENT. See the GNU General Public License for more * details. * * You should have received a copy of the GNU General Public License * along with Resin Open Source; if not, write to the * Free SoftwareFoundation, Inc. * 59 Temple Place, Suite 330 * Boston, MA 02111-1307 USA * * @author Scott Ferguson */ package com.caucho.db.table; import com.caucho.db.index.BTree; import com.caucho.db.sql.Expr; import com.caucho.db.sql.QueryContext; import com.caucho.db.sql.SelectResult; import com.caucho.db.xa.DbTransaction; import java.sql.SQLException; /** * Represents a 64-bit double-precision floating point column. */ class DoubleColumn extends Column { /** * Creates a double column. * * @param row the row the column is being added to * @param name the column's name */ DoubleColumn(Row row, String name) { super(row, name); } /** * Returns the column's type code. */ @Override public ColumnType getTypeCode() { return ColumnType.DOUBLE; } /** * Returns the column's Java type. */ @Override public Class<?> getJavaType() { return double.class; } /** * Returns the column's declaration size. */ @Override public int getDeclarationSize() { return 8; } /** * Returns the column's size. */ @Override public int getLength() { return 8; } /** * Sets a string value in the column. * * @param block the block's buffer * @param rowOffset the offset of the row in the block * @param value the value to store */ @Override void setString(DbTransaction xa, byte []block, int rowOffset, String str) { if (str == null) setNull(block, rowOffset); else setDouble(xa, block, rowOffset, Double.parseDouble(str)); } /** * Gets a string value from the column. * * @param block the block's buffer * @param rowOffset the offset of the row in the block */ @Override public String getString(long blockId, byte []block, int rowOffset) { if (isNull(block, rowOffset)) return null; else return String.valueOf(getDouble(blockId, block, rowOffset)); } /** * Sets an integer value in the column. * * @param block the block's buffer * @param rowOffset the offset of the row in the block * @param value the value to store */ @Override void setInteger(DbTransaction xa, byte []block, int rowOffset, int value) { setDouble(xa, block, rowOffset, value); } /** * Gets an integer value from the column. * * @param block the block's buffer * @param rowOffset the offset of the row in the block */ @Override public int getInteger(long blockId, byte []block, int rowOffset) { return (int) getDouble(blockId, block, rowOffset); } /** * Sets a long value in the column. * * @param block the block's buffer * @param rowOffset the offset of the row in the block * @param value the value to store */ @Override void setLong(DbTransaction xa, byte []block, int rowOffset, long value) { setDouble(xa, block, rowOffset, value); } /** * Gets a long value from the column. * * @param block the block's buffer * @param rowOffset the offset of the row in the block */ @Override public long getLong(long blockId, byte []block, int rowOffset) { return (long) getDouble(blockId, block, rowOffset); } /** * Sets a double value in the column. * * @param block the block's buffer * @param rowOffset the offset of the row in the block * @param value the value to store */ @Override void setDouble(DbTransaction xa, byte []block, int rowOffset, double value) { int offset = rowOffset + _columnOffset; long longValue = Double.doubleToRawLongBits(value); block[offset++] = (byte) (longValue >> 56); block[offset++] = (byte) (longValue >> 48); block[offset++] = (byte) (longValue >> 40); block[offset++] = (byte) (longValue >> 32); block[offset++] = (byte) (longValue >> 24); block[offset++] = (byte) (longValue >> 16); block[offset++] = (byte) (longValue >> 8); block[offset++] = (byte) (longValue); setNonNull(block, rowOffset); } /** * Gets a double value from the column. * * @param block the block's buffer * @param rowOffset the offset of the row in the block */ @Override public double getDouble(long blockId, byte []block, int rowOffset) { if (isNull(block, rowOffset)) return 0; int offset = rowOffset + _columnOffset; long longValue = 0; longValue = (block[offset++] & 0xffL) << 56; longValue |= (block[offset++] & 0xffL) << 48; longValue |= (block[offset++] & 0xffL) << 40; longValue |= (block[offset++] & 0xffL) << 32; longValue |= (block[offset++] & 0xffL) << 24; longValue |= (block[offset++] & 0xffL) << 16; longValue |= (block[offset++] & 0xffL) << 8; longValue |= (block[offset++] & 0xffL); return Double.longBitsToDouble(longValue); } /** * Sets the column based on an expression. * * @param block the block's buffer * @param rowOffset the offset of the row in the block * @param expr the expression to store */ @Override void setExpr(DbTransaction xa, byte []block, int rowOffset, Expr expr, QueryContext context) throws SQLException { if (expr.isNull(context)) setNull(block, rowOffset); else setDouble(xa, block, rowOffset, expr.evalDouble(context)); } /** * Evaluates the column to a stream. */ @Override public void evalToResult(long blockId, byte []block, int rowOffset, SelectResult result) { if (isNull(block, rowOffset)) { result.writeNull(); return; } result.writeDouble(getDouble(blockId, block, rowOffset)); } /** * Evaluate to a buffer. * * @param block the block's buffer * @param rowOffset the offset of the row in the block * @param buffer the result buffer * @param buffer the result buffer offset * * @return the length of the value */ @Override int evalToBuffer(byte []block, int rowOffset, byte []buffer, int bufferOffset) throws SQLException { if (isNull(block, rowOffset)) return 0; int startOffset = rowOffset + _columnOffset; int len = 8; System.arraycopy(block, startOffset, buffer, bufferOffset, len); return len; } /** * Returns true if the items in the given rows match. */ @Override public boolean isEqual(byte []block1, int rowOffset1, byte []block2, int rowOffset2) { if (isNull(block1, rowOffset1) != isNull(block2, rowOffset2)) return false; int startOffset1 = rowOffset1 + _columnOffset; int startOffset2 = rowOffset2 + _columnOffset; return (block1[startOffset1 + 0] == block2[startOffset2 + 0] && block1[startOffset1 + 1] == block2[startOffset2 + 1] && block1[startOffset1 + 2] == block2[startOffset2 + 2] && block1[startOffset1 + 3] == block2[startOffset2 + 3] && block1[startOffset1 + 4] == block2[startOffset2 + 4] && block1[startOffset1 + 5] == block2[startOffset2 + 5] && block1[startOffset1 + 6] == block2[startOffset2 + 6] && block1[startOffset1 + 7] == block2[startOffset2 + 7]); } /** * Sets based on an iterator. */ @Override public void set(DbTransaction xa, TableIterator iter, Expr expr, QueryContext context) throws SQLException { iter.setDirty(); setDouble(iter.getTransaction(), iter.getBuffer(), iter.getRowOffset(), expr.evalDouble(context)); } /** * Deleting the row, based on the column. * * @param block the block's buffer * @param rowOffset the offset of the row in the block * @param expr the expression to store */ @Override void deleteIndex(DbTransaction xa, byte []block, int rowOffset) throws SQLException { BTree index = getIndex(); if (index != null) index.remove(block, rowOffset + _columnOffset, 8); } }