Diffstat (limited to 'noncore/apps/tableviewer/db/csvsource.cpp') (more/less context) (ignore whitespace changes)
| -rw-r--r-- | noncore/apps/tableviewer/db/csvsource.cpp | 207 |
1 files changed, 207 insertions, 0 deletions
diff --git a/noncore/apps/tableviewer/db/csvsource.cpp b/noncore/apps/tableviewer/db/csvsource.cpp new file mode 100644 index 0000000..2561b4b --- a/dev/null +++ b/noncore/apps/tableviewer/db/csvsource.cpp @@ -0,0 +1,207 @@ +/********************************************************************** +** Copyright (C) 2000 Trolltech AS. All rights reserved. +** +** This file is part of Qtopia Environment. +** +** This file may be distributed and/or modified under the terms of the +** GNU General Public License version 2 as published by the Free Software +** Foundation and appearing in the file LICENSE.GPL included in the +** packaging of this file. +** +** This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE +** WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. +** +** See http://www.trolltech.com/gpl/ for GPL licensing information. +** +** Contact info@trolltech.com if any conditions of this licensing are +** not clear to you. +** +**********************************************************************/ +#include "csvsource.h" +#include "common.h" +#include "datacache.h" +#include <qtextstream.h> +#include <qstringlist.h> +#include <qmap.h> +#include <qregexp.h> + +DBCsv::DBCsv(DBStore *d) +{ + dstore = d; +} + +DBCsv::~DBCsv() +{ +} + +QString DBCsv::type() +{ + return "csv"; +} + +QStringList readElem(QString in) +{ + QStringList out; + + if (in.isEmpty()) + return out; + + bool firstChar = TRUE; + bool quotedElem = FALSE; + uint index = 0; + while(index < in.length()) { + if(firstChar) { + /* skip whitespace */ + while(index < in.length() && in[index] == ' ') + index++; + if(in[index] == '"') { + quotedElem = TRUE; + index++; + } + } + /* real first char */ + QString elem; + if(quotedElem) { + while(index < in.length() && in[index] != '"') { + /* check for escape character */ + if (in[index] == '\\') { + if (index++ < in.length()) { + elem.append(in[index]); + index++; + } + } else { + elem.append(in[index]); + index++; + } + } + } else { + while(index < in.length() && in[index] != ',') { + if (in[index] == '\\') { + if (index++ < in.length()) { + elem.append(in[index]); + index++; + } + } else { + elem.append(in[index]); + index++; + } + } + } + /* we have our current elem */ + out << elem.stripWhiteSpace(); + firstChar = TRUE; + quotedElem = FALSE; + /* skip till a , or end of line */ + while (index < in.length() && in[index] != ',') index++; + if(index == in.length()) + return out; + else + index++; + } +} + +bool DBCsv::openSource(QIODevice *inDev) +{ + QTextStream tsIn(inDev); + QString in = tsIn.readLine().stripWhiteSpace(); + QStringList keys; + + keys = readElem(in); + + QMap<int,int> keyIndexes; + + KeyList *keyR = new KeyList(); + QStringList::Iterator i = keys.begin(); + + uint fileIndex = 0; + while(i != keys.end()) { + if ((*i).isEmpty()) + keyIndexes.insert(fileIndex, keyR->addKey("Unamed", TVVariant::String)); + else + keyIndexes.insert(fileIndex, keyR->addKey(*i, TVVariant::String)); + i++; + fileIndex++; + } + dstore->setKeys(keyR); + + in = tsIn.readLine().stripWhiteSpace(); + while(!in.isNull()) { + QStringList elems = readElem(in); + + i = elems.begin(); + fileIndex = 0; + DataElem *current_data = new DataElem(dstore); + while(i != elems.end()) { + if(!(*i).isEmpty()) { + current_data->setField(keyIndexes[fileIndex], *i); + } + fileIndex++; + i++; + } + dstore->addItem(current_data); + in = tsIn.readLine().stripWhiteSpace(); + } + + return TRUE; +} + +bool DBCsv::saveSource(QIODevice *outDev) +{ + /* try not to use the escape character when possible. */ + int i; + DataElem *elem; + KeyList *k; + QTextStream outstream(outDev); + + k = dstore->getKeys(); + KeyListIterator it(*k); + while(it.current()) { + if(!it.current()->delFlag()) { + QString name = it.current()->name(); + + name.replace(QRegExp("\\"), "\\\\"); + name.replace(QRegExp("\""), "\\\""); + if(name.find(',') != -1) { + name.prepend('\"'); + name.append('\"'); + } + + outstream << name; + } + ++it; + if(it.current()) + outstream << ", "; + } + outstream << "\n"; + + dstore->first(); + + do { + elem = dstore->getCurrentData(); + if(!elem) + break; + it.toFirst(); + while(it.current()) { + i = it.currentKey(); + if (elem->hasValidValue(i)) { + QString name = elem->toQString(i); + + name.replace(QRegExp("\\"), "\\\\"); + name.replace(QRegExp("\""), "\\\""); + if(name.find(',') != -1) { + name.prepend('\"'); + name.append('\"'); + } + + outstream << name; + } + ++it; + if(it.current()) + outstream << ", "; + } + outstream << "\n"; + } while (dstore->next()); + + return TRUE; +} + |