1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
/*
* csvutils.h
*
* (c) 2002,2008 by Jeremy Bowman <jmbowman@alum.mit.edu>
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
/** @file csvutils.h
* Header file for CSVUtils
*/
#ifndef CSVUTILS_H
#define CSVUTILS_H
#include <QStringList>
#include "calc/calcnode.h"
#include "datatypes.h"
class Database;
/**
* Utility methods for parsing and generating CSV files.
*/
class CSVUtils
{
public:
CSVUtils();
~CSVUtils();
QStringList parseFile(const QString &filename, const QString &encoding,
Database *db);
QString encodeRow(QStringList row);
QString encodeCell(QString content);
private:
void initialize(Database *db, const QString &filename);
bool addRow(Database *db);
private:
QChar m_textquote; /**< The character used to quote fields */
QChar m_delimiter; /**< The character used to separate fields */
QStringList colNames; /**< List of database column names, cached for convenience */
int colCount; /**< Number of columns in the database, cached for convenience */
int endStringCount; /**< Number of string or note fields at the end of each record */
int rowNum; /**< Number of the row currently being parsed; used in error messages */
QString message; /**< Error message, if any, from loading the last parsed record */
QString rowString; /**< The record currently being parsed; used in error messages */
QStringList row; /**< The fields of the record currently being parsed */
IntList addedIds; /**< IDs of all rows added while parsing a file */
IntList types; /**< List of database column types, cached for convenience */
CalcNodeList calcs; /**< List of calculated column definition tree root nodes */
IntList calcDecimals; /**< List of decimal places to show for each calculated column */
int calcCount; /**< Number of calculated columns */
};
#endif
|
