// SpryCSVDataSet.js - version 0.1 - Spry Pre-Release 1.6
|
//
|
// Copyright (c) 2007. Adobe Systems Incorporated.
|
// All rights reserved.
|
//
|
// Redistribution and use in source and binary forms, with or without
|
// modification, are permitted provided that the following conditions are met:
|
//
|
// * Redistributions of source code must retain the above copyright notice,
|
// this list of conditions and the following disclaimer.
|
// * Redistributions in binary form must reproduce the above copyright notice,
|
// this list of conditions and the following disclaimer in the documentation
|
// and/or other materials provided with the distribution.
|
// * Neither the name of Adobe Systems Incorporated nor the names of its
|
// contributors may be used to endorse or promote products derived from this
|
// software without specific prior written permission.
|
//
|
// THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
|
// AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
|
// IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
|
// ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
|
// LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
|
// CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
|
// SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
|
// INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
|
// CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
|
// ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
|
// POSSIBILITY OF SUCH DAMAGE.
|
|
Spry.Data.CSVDataSet=function(dataSetURL,dataSetOptions)
|
{Spry.Data.HTTPSourceDataSet.call(this,dataSetURL,dataSetOptions);this.firstRowAsHeaders=true;this.columnNames=[];Spry.Utils.setOptions(this,dataSetOptions);};Spry.Data.CSVDataSet.prototype=new Spry.Data.HTTPSourceDataSet();Spry.Data.CSVDataSet.prototype.constructor=Spry.Data.CSVDataSet;Spry.Data.CSVDataSet.prototype.getDataRefStrings=function()
|
{var strArr=[];if(this.url)strArr.push(this.url);return strArr;};Spry.Data.CSVDataSet.prototype.getDocument=function(){return this.doc;};Spry.Data.CSVDataSet.cleanFieldString=function(str)
|
{str=str.replace(/\s*(\r\n)\s*/g,"$1");str=str.replace(/^[ \t]*"?|"?\s*,?\s*$/g,"");return str.replace(/""/g,'"');};Spry.Data.CSVDataSet.prototype.columnNumberToColumnName=function(colNum)
|
{var colName=this.columnNames[colNum];if(!colName)
|
colName="column"+colNum;return colName;};Spry.Data.CSVDataSet.prototype.loadDataIntoDataSet=function(rawDataDoc)
|
{var data=new Array();var dataHash=new Object();var s=rawDataDoc?rawDataDoc:"";var strLen=s.length;var i=0;var done=false;var firstRowAsHeaders=this.firstRowAsHeaders;var searchStartIndex=0;var regexp=/([ \t]*"([^"]|"")*"[ \t]*,?)|([ \t]*[^",\r\n]+[ \t]*,?)|[ \t]*(\r\n|\r|\n)/mg;var results=regexp.exec(s);var rowObj=null;var columnNum=-1;var rowID=0;while(results&&results[0])
|
{var f=Spry.Data.CSVDataSet.cleanFieldString(results[0]);if(f=="\r\n"||f=="\r"||f=="\n")
|
{if(!firstRowAsHeaders)
|
{rowObj.ds_RowID=rowID++;data.push(rowObj);rowObj=null;}
|
firstRowAsHeaders=false;columnNum=-1;}
|
else
|
{if(firstRowAsHeaders)
|
this.columnNames[++columnNum]=f;else
|
{if(++columnNum==0)
|
rowObj=new Object;rowObj[this.columnNumberToColumnName(columnNum)]=f;}}
|
searchStartIndex=regexp.lastIndex;results=regexp.exec(s);}
|
this.doc=rawDataDoc;this.data=data;this.dataHash=dataHash;this.dataWasLoaded=(this.doc!=null);};
|
