Query.withParams upgrade

[vertex-github]

We also had this mod to Query.withParams to allow Lists and arrays to be passed in:

	/**
	 * Construct a Query with the provided variable number of parameters.  Accepts all object types, List, and arrays as parameters.
	 * @param paramValues
	 * @return
	 */
    public Query withParams(Object... paramValues){
        int i=0;
        for (Object paramValue : paramValues) {
	        if( paramValue == null ) { // null values are valid for inserting in to a DB . We need to check for these first.
		        addParameter( "p" + (++i), paramValue );
	        }
	        else if( paramValue instanceof Collection ) {
				if( paramValue instanceof List ) {
					List list = (List) paramValue;
					for( Object val : list ) {
						addParameter( "p" + (++i), val );
					}
				}
				else {
					throw new Sql2oException( "I can only handle ordered Collections - i.e. a List" );
				}
	        }
	        else if( paramValue.getClass().isArray() ) {
		        int len = java.lang.reflect.Array.getLength( paramValue );
		        for( int j = 0; j < len; j++ )
		        {
			        Object arrVal = java.lang.reflect.Array.get( paramValue, j );
			        addParameter( "p" + (++i), arrVal );
		        }
	        }
            else {
		        addParameter( "p" + (++i), paramValue );
	        }
        }
        return this;
    }

[vertex-github]

With the new SequencedCollections this could be improved a little

[aaberg]

Nice. Thanks. I'll take a look 👍🏼