com.mchange.sc.v1.sql.WrappedPreparedStatement.scala Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of mchange-commons-scala_2.11 Show documentation
mchange-commons-scala
The newest version!
/*
 * Distributed as part of mchange-commons-scala v0.4.0
 *
 * Copyright (C) 2015 Machinery For Change, Inc.
 *
 * Author: Steve Waldman 
 *
 * This library is free software; you can redistribute it and/or modify
 * it under the terms of EITHER:
 *
 *     1) The GNU Lesser General Public License (LGPL), version 2.1, as 
 *        published by the Free Software Foundation
 *
 * OR
 *
 *     2) The Eclipse Public License (EPL), version 1.0
 *
 * You may choose which license to accept if you wish to redistribute
 * or modify this work. You may offer derivatives of this work
 * under the license you have chosen, or you may provide the same
 * choice of license which you have been offered here.
 *
 * This software 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.
 *
 * You should have received copies of both LGPL v2.1 and EPL v1.0
 * along with this software; see the files LICENSE-EPL and LICENSE-LGPL.
 * If not, the text of these licenses are currently available at
 *
 * LGPL v2.1: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html
 *  EPL v1.0: http://www.eclipse.org/org/documents/epl-v10.php 
 * 
 */

package com.mchange.sc.v1.sql;

import language.implicitConversions;

import java.sql.{PreparedStatement,ResultSet};

object WrappedPreparedStatement
{
  implicit def unwrap( wps : WrappedPreparedStatement ) : PreparedStatement = wps.toPreparedStatement;
}

class WrappedPreparedStatement( mgr : PsManager, ps : PreparedStatement )
{
  def paramNames = mgr.paramNames;

  def nullParameters() = mgr.nullParameters( ps );

  def accept(params : Map[String,Any]) = mgr.overwriteParameters( ps, params );
  
  def setParameter( i : Int, param : Any ) = mgr.setParameter( ps, i, param );
  
  def setParameter( paramName : String, param : Any ) = mgr.setParameter( ps, paramName, param );

  def toPreparedStatement() = ps;

  def <<(params : Map[String,Any]) : WrappedPreparedStatement = { this.accept(params); this; }

  def <<(param : Pair[String,Any]) : WrappedPreparedStatement = { this.setParameter( param._1, param._2 ); this }

  def <<(params : Pair[String,Any]*) : WrappedPreparedStatement = { this.accept( Map( params : _* ) ); this }

  def !! : Int = ps.executeUpdate();

  def ?? : ResultSet = ps.executeQuery();

  def ~! : Unit = ps.addBatch()

  def ~!! : Array[Int] = ps.executeBatch();
}