MockStatement.java

  1. /***************************************************************************
  2.    Copyright 2012 Emily Estes

  4.    Licensed under the Apache License, Version 2.0 (the "License");
  5.    you may not use this file except in compliance with the License.
  6.    You may obtain a copy of the License at

  8.        http://www.apache.org/licenses/LICENSE-2.0

  10.    Unless required by applicable law or agreed to in writing, software
  11.    distributed under the License is distributed on an "AS IS" BASIS,
  12.    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  13.    See the License for the specific language governing permissions and
  14.    limitations under the License.
  15. ***************************************************************************/
  16. package net.metanotion.sql;


  19. import java.io.InputStream;
  20. import java.io.Reader;
  21. import java.math.BigDecimal;
  22. import java.net.URL;
  23. import java.util.Calendar;
  24. import java.util.Map;
  25. import java.sql.Array;
  26. import java.sql.Blob;
  27. import java.sql.CallableStatement;
  28. import java.sql.Clob;
  29. import java.sql.Connection;
  30. import java.sql.Date;
  31. import java.sql.NClob;
  32. import java.sql.ParameterMetaData;
  33. import java.sql.Ref;
  34. import java.sql.ResultSet;
  35. import java.sql.ResultSetMetaData;
  36. import java.sql.RowId;
  37. import java.sql.SQLException;
  38. import java.sql.SQLWarning;
  39. import java.sql.SQLXML;
  40. import java.sql.Time;
  41. import java.sql.Timestamp;

  43. /** This is a "null" implementation of a JDBC Statement. It's not really meant to be useful
  44. other than as a way to test code with non-null instances of Statement. It would be acceptable
  45. to expand this to a more interesting "mock" implementation of a statement, but it mostly consists
  46. of the bare minimum code to "technically" implement the {@link java.sql.CallableStatement} interface.
  47. */
  48. @SuppressWarnings("deprecation")
  49. public final class MockStatement implements CallableStatement {
  50.     private static final int FETCH_SIZE = 1000;
  51.     private static final int MAX_FIELD_SIZE = 1000;
  52.     private static final int MAX_ROWS = 1000;
  53.     private static final int TIMEOUT = 30;

  55.     private Connection conn = null;
  56.     /** Create a new fake statement with no connection. */
  57.     public MockStatement() { }

  59.     /** Create a new fake statement for the given connection.
  60.         @param conn The connection this statement is attached to.
  61.     */
  62.     public MockStatement(final Connection conn) { this.conn = conn; }

  64.     @Override public void addBatch(final String sql) { }
  65.     @Override public void cancel() { }
  66.     @Override public void clearBatch() { }
  67.     @Override public void clearWarnings() { }
  68.     @Override public void close() { }
  69.     @Override public void closeOnCompletion() throws SQLException { }
  70.     @Override public boolean execute(final String sql) { return true; }
  71.     @Override public boolean execute(final String sql, final int autoGeneratedKeys) { return true; }
  72.     @Override public boolean execute(final String sql, final int[] columnIndexes) { return true; }
  73.     @Override public boolean execute(final String sql, final String[] columnNames) { return true; }
  74.     @Override public int[] executeBatch() { return null; }
  75.     @Override public ResultSet executeQuery(final String sql) { return new MockResultSet(this); }
  76.     @Override public int executeUpdate(final String sql) { return 1; }
  77.     @Override public int executeUpdate(final String sql, final int autoGeneratedKeys) { return 1; }
  78.     @Override public int executeUpdate(final String sql, final int[] columnIndexes) { return 1; }
  79.     @Override public int executeUpdate(final String sql, final String[] columnNames) { return 1; }
  80.     @Override public Connection getConnection() { return conn; }
  81.     @Override public int getFetchDirection() { return 0; }
  82.     @Override public int getFetchSize() { return FETCH_SIZE; }
  83.     @Override public ResultSet getGeneratedKeys() { return null; }
  84.     @Override public int getMaxFieldSize() { return MAX_FIELD_SIZE; }
  85.     @Override public int getMaxRows() { return MAX_ROWS; }
  86.     @Override public boolean getMoreResults() { return false; }
  87.     @Override public boolean getMoreResults(final int current) { return false; }
  88.     @Override public int getQueryTimeout() { return TIMEOUT; }
  89.     @Override public ResultSet getResultSet() { return null; }
  90.     @Override public int getResultSetConcurrency() { return ResultSet.CONCUR_READ_ONLY; }
  91.     @Override public int getResultSetHoldability() { return ResultSet.CLOSE_CURSORS_AT_COMMIT; }
  92.     @Override public int getResultSetType() { return ResultSet.TYPE_SCROLL_SENSITIVE; }
  93.     @Override public int getUpdateCount() { return 1; }
  94.     @Override public SQLWarning getWarnings() { return null; }
  95.     @Override public boolean isClosed() { return false; }
  96.     @Override public boolean isCloseOnCompletion() throws SQLException { return false; }
  97.     @Override public boolean isPoolable() { return true; }
  98.     @Override public void setCursorName(String name) { }
  99.     @Override public void setEscapeProcessing(final boolean enable) { }
  100.     @Override public void setFetchDirection(final int direction) { }
  101.     @Override public void setFetchSize(final int rows) { }
  102.     @Override public void setMaxFieldSize(final int max) { }
  103.     @Override public void setMaxRows(final int max) { }
  104.     @Override public void setPoolable(final boolean poolable) { }
  105.     @Override public void setQueryTimeout(final int seconds) { }

  107.     @Override public void addBatch() { }
  108.     @Override public void clearParameters() { }
  109.     @Override public boolean execute() { return true; }
  110.     @Override public ResultSet executeQuery() { return new MockResultSet(this); }
  111.     @Override public int executeUpdate() { return 1; }
  112.     @Override public ResultSetMetaData getMetaData() { return null; }
  113.     @Override public ParameterMetaData getParameterMetaData() { return null; }
  114.     @Override public void setArray(final int parameterIndex, final Array x) { }
  115.     @Override public void setAsciiStream(final int parameterIndex, final InputStream x) { }
  116.     @Override public void setAsciiStream(final int parameterIndex, final InputStream x, final int length) { }
  117.     @Override public void setAsciiStream(final int parameterIndex, final InputStream x, final long length) { }
  118.     @Override public void setBigDecimal(final int parameterIndex, final BigDecimal x) { }
  119.     @Override public void setBinaryStream(final int parameterIndex, final InputStream x) { }
  120.     @Override public void setBinaryStream(final int parameterIndex, final InputStream x, final int length) { }
  121.     @Override public void setBinaryStream(final int parameterIndex, final InputStream x, final long length) { }
  122.     @Override public void setBlob(final int parameterIndex, final Blob x) { }
  123.     @Override public void setBlob(final int parameterIndex, final InputStream inputStream) { }
  124.     @Override public void setBlob(final int parameterIndex, final InputStream inputStream, final long length) { }
  125.     @Override public void setBoolean(final int parameterIndex, final boolean x) { }
  126.     @Override public void setByte(final int parameterIndex, final byte x) { }
  127.     @Override public void setBytes(final int parameterIndex, final byte[] x) { }
  128.     @Override public void setCharacterStream(final int parameterIndex, final Reader reader) { }
  129.     @Override public void setCharacterStream(final int parameterIndex, final Reader reader, final int length) { }
  130.     @Override public void setCharacterStream(final int parameterIndex, final Reader reader, final long length) { }
  131.     @Override public void setClob(final int parameterIndex, final Clob x) { }
  132.     @Override public void setClob(final int parameterIndex, final Reader reader) { }
  133.     @Override public void setClob(final int parameterIndex, final Reader reader, final long length) { }
  134.     @Override public void setDate(final int parameterIndex, final Date x) { }
  135.     @Override public void setDate(final int parameterIndex, final Date x, final Calendar cal) { }
  136.     @Override public void setDouble(final int parameterIndex, final double x) { }
  137.     @Override public void setFloat(final int parameterIndex, final float x) { }
  138.     @Override public void setInt(final int parameterIndex, final int x) { }
  139.     @Override public void setLong(final int parameterIndex, final long x) { }
  140.     @Override public void setNCharacterStream(final int parameterIndex, final Reader value) { }
  141.     @Override public void setNCharacterStream(final int parameterIndex, final Reader value, final long length) { }
  142.     @Override public void setNClob(final int parameterIndex, final NClob value) { }
  143.     @Override public void setNClob(final int parameterIndex, final Reader reader) { }
  144.     @Override public void setNClob(final int parameterIndex, final Reader reader, final long length) { }
  145.     @Override public void setNString(int parameterIndex, String value) { }
  146.     @Override public void setNull(int parameterIndex, int sqlType) { }
  147.     @Override public void setNull(int parameterIndex, int sqlType, String typeName) { }
  148.     @Override public void setObject(int parameterIndex, Object x) { }
  149.     @Override public void setObject(int parameterIndex, Object x, int targetSqlType) { }
  150.     @Override public void setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) { }
  151.     @Override public void setRef(int parameterIndex, Ref x) { }
  152.     @Override public void setRowId(int parameterIndex, RowId x) { }
  153.     @Override public void setShort(int parameterIndex, short x) { }
  154.     @Override public void setSQLXML(int parameterIndex, SQLXML xmlObject) { }
  155.     @Override public void setString(int parameterIndex, String x) { }
  156.     @Override public void setTime(int parameterIndex, Time x) { }
  157.     @Override public void setTime(int parameterIndex, Time x, Calendar cal) { }
  158.     @Override public void setTimestamp(int parameterIndex, Timestamp x) { }
  159.     @Override public void setTimestamp(int parameterIndex, Timestamp x, Calendar cal) { }
  160.     @Override public void setUnicodeStream(int parameterIndex, InputStream x, int length) { }
  161.     @Override public void setURL(int parameterIndex, URL x) { }

  163.     @Override public Array getArray(int parameterIndex) { return null; }
  164.     @Override public Array getArray(String parameterName) { return null; }
  165.     @Override public BigDecimal getBigDecimal(int parameterIndex) { return null; }
  166.     @Override public BigDecimal getBigDecimal(int parameterIndex, int scale) { return null; }
  167.     @Override public BigDecimal getBigDecimal(String parameterName) { return null; }
  168.     @Override public Blob getBlob(int parameterIndex) { return null; }
  169.     @Override public Blob getBlob(String parameterName) { return null; }
  170.     @Override public boolean getBoolean(int parameterIndex) { return false; }
  171.     @Override public boolean getBoolean(String parameterName) { return false; }
  172.     @Override public byte getByte(int parameterIndex) { return 0; }
  173.     @Override public byte getByte(String parameterName) { return 0; }
  174.     @Override public byte[] getBytes(int parameterIndex) { return null; }
  175.     @Override public byte[] getBytes(String parameterName) { return null; }
  176.     @Override public Reader getCharacterStream(int parameterIndex) { return null; }
  177.     @Override public Reader getCharacterStream(String parameterName) { return null; }
  178.     @Override public Clob getClob(int parameterIndex) { return null; }
  179.     @Override public Clob getClob(String parameterName) { return null; }
  180.     @Override public Date getDate(int parameterIndex) { return null; }
  181.     @Override public Date getDate(int parameterIndex, Calendar cal) { return null; }
  182.     @Override public Date getDate(String parameterName) { return null; }
  183.     @Override public Date getDate(String parameterName, Calendar cal) { return null; }
  184.     @Override public double getDouble(int parameterIndex) { return 0; }
  185.     @Override public double getDouble(String parameterName) { return 0; }
  186.     @Override public float getFloat(int parameterIndex) { return 0; }
  187.     @Override public float getFloat(String parameterName) { return 0; }
  188.     @Override public int getInt(int parameterIndex) { return 0; }
  189.     @Override public int getInt(String parameterName) { return 0; }
  190.     @Override public long getLong(int parameterIndex) { return 0; }
  191.     @Override public long getLong(String parameterName) { return 0; }
  192.     @Override public Reader getNCharacterStream(int parameterIndex) { return null; }
  193.     @Override public Reader getNCharacterStream(String parameterName) { return null; }
  194.     @Override public NClob getNClob(int parameterIndex) { return null; }
  195.     @Override public NClob getNClob(String parameterName) { return null; }
  196.     @Override public String getNString(int parameterIndex) { return null; }
  197.     @Override public String getNString(String parameterName) { return null; }
  198.     @Override public Object getObject(int parameterIndex) { return null; }
  199.     @Override public <T> T getObject(int parameterIndex, Class<T> type) { return null; }
  200.     @Override public Object getObject(int parameterIndex, Map<String,Class<?>> map) { return null; }
  201.     @Override public Object getObject(String parameterName) { return null; }
  202.     @Override public <T> T getObject(String parameterName, Class<T> type) { return null; }
  203.     @Override public Object getObject(String parameterName, Map<String,Class<?>> map) { return null; }
  204.     @Override public Ref getRef(int parameterIndex) { return null; }
  205.     @Override public Ref getRef(String parameterName) { return null; }
  206.     @Override public RowId getRowId(int parameterIndex) { return null; }
  207.     @Override public RowId getRowId(String parameterName) { return null; }
  208.     @Override public short getShort(int parameterIndex) { return 0; }
  209.     @Override public short getShort(String parameterName) { return 0; }
  210.     @Override public SQLXML getSQLXML(int parameterIndex) { return null; }
  211.     @Override public SQLXML getSQLXML(String parameterName) { return null; }
  212.     @Override public String getString(int parameterIndex) { return null; }
  213.     @Override public String getString(String parameterName) { return null; }
  214.     @Override public Time getTime(int parameterIndex) { return null; }
  215.     @Override public Time getTime(int parameterIndex, Calendar cal) { return null; }
  216.     @Override public Time getTime(String parameterName) { return null; }
  217.     @Override public Time getTime(String parameterName, Calendar cal) { return null; }
  218.     @Override public Timestamp getTimestamp(int parameterIndex) { return null; }
  219.     @Override public Timestamp getTimestamp(int parameterIndex, Calendar cal) { return null; }
  220.     @Override public Timestamp getTimestamp(String parameterName) { return null; }
  221.     @Override public Timestamp getTimestamp(String parameterName, Calendar cal) { return null; }
  222.     @Override public URL getURL(int parameterIndex) { return null; }
  223.     @Override public URL getURL(String parameterName) { return null; }
  224.     @Override public void registerOutParameter(int parameterIndex, int sqlType) { }
  225.     @Override public void registerOutParameter(int parameterIndex, int sqlType, int scale) { }
  226.     @Override public void registerOutParameter(int parameterIndex, int sqlType, String typeName) { }
  227.     @Override public void registerOutParameter(String parameterName, int sqlType) { }
  228.     @Override public void registerOutParameter(String parameterName, int sqlType, int scale) { }
  229.     @Override public void registerOutParameter(String parameterName, int sqlType, String typeName) { }
  230.     @Override public void setAsciiStream(String parameterName, InputStream x) { }
  231.     @Override public void setAsciiStream(String parameterName, InputStream x, int length) { }
  232.     @Override public void setAsciiStream(String parameterName, InputStream x, long length) { }
  233.     @Override public void setBigDecimal(String parameterName, BigDecimal x) { }
  234.     @Override public void setBinaryStream(String parameterName, InputStream x) { }
  235.     @Override public void setBinaryStream(String parameterName, InputStream x, int length) { }
  236.     @Override public void setBinaryStream(String parameterName, InputStream x, long length) { }
  237.     @Override public void setBlob(String parameterName, Blob x) { }
  238.     @Override public void setBlob(String parameterName, InputStream inputStream) { }
  239.     @Override public void setBlob(String parameterName, InputStream inputStream, long length) { }
  240.     @Override public void setBoolean(String parameterName, boolean x) { }
  241.     @Override public void setByte(String parameterName, byte x) { }
  242.     @Override public void setBytes(String parameterName, byte[] x) { }
  243.     @Override public void setCharacterStream(String parameterName, Reader reader) { }
  244.     @Override public void setCharacterStream(String parameterName, Reader reader, int length) { }
  245.     @Override public void setCharacterStream(String parameterName, Reader reader, long length) { }
  246.     @Override public void setClob(String parameterName, Clob x) { }
  247.     @Override public void setClob(String parameterName, Reader reader) { }
  248.     @Override public void setClob(String parameterName, Reader reader, long length) { }
  249.     @Override public void setDate(String parameterName, Date x) { }
  250.     @Override public void setDate(String parameterName, Date x, Calendar cal) { }
  251.     @Override public void setDouble(String parameterName, double x) { }
  252.     @Override public void setFloat(String parameterName, float x) { }
  253.     @Override public void setInt(String parameterName, int x) { }
  254.     @Override public void setLong(String parameterName, long x) { }
  255.     @Override public void setNCharacterStream(String parameterName, Reader value) { }
  256.     @Override public void setNCharacterStream(String parameterName, Reader value, long length) { }
  257.     @Override public void setNClob(String parameterName, NClob value) { }
  258.     @Override public void setNClob(String parameterName, Reader reader) { }
  259.     @Override public void setNClob(String parameterName, Reader reader, long length) { }
  260.     @Override public void setNString(String parameterName, String value) { }
  261.     @Override public void setNull(String parameterName, int sqlType) { }
  262.     @Override public void setNull(String parameterName, int sqlType, String typeName) { }
  263.     @Override public void setObject(String parameterName, Object x) { }
  264.     @Override public void setObject(String parameterName, Object x, int targetSqlType) { }
  265.     @Override public void setObject(String parameterName, Object x, int targetSqlType, int scale) { }
  266.     @Override public void setRowId(String parameterName, RowId x) { }
  267.     @Override public void setShort(String parameterName, short x) { }
  268.     @Override public void setSQLXML(String parameterName, SQLXML xmlObject) { }
  269.     @Override public void setString(String parameterName, String x) { }
  270.     @Override public void setTime(String parameterName, Time x) { }
  271.     @Override public void setTime(String parameterName, Time x, Calendar cal) { }
  272.     @Override public void setTimestamp(String parameterName, Timestamp x) { }
  273.     @Override public void setTimestamp(String parameterName, Timestamp x, Calendar cal) { }
  274.     @Override public void setURL(String parameterName, URL val) { }
  275.     @Override public boolean wasNull() { return false; }

  277.     @Override public boolean isWrapperFor(final Class<?> iface) { return false; }
  278.     @Override public <T> T unwrap(final Class<T> iface) throws SQLException { throw new SQLException(); }
  279. }
Created with JaCoCo 0.7.5.201505241946