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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
|
/*
* database.h
*
* (c) 2002-2004,2008-2011 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 database.h
* Header file for Database
*/
#ifndef DATABASE_H
#define DATABASE_H
#include <mk4.h>
#include <QByteArray>
#include <QPixmap>
#include <QStringList>
#include "datatypes.h"
#define FILE_VERSION 11
class CalcNode;
class Condition;
class Crypto;
class Filter;
class ImageUtils;
class QDate;
class View;
/**
* The central point of virtually all operations on a %PortaBase data file.
* As much as possible, detailed knowledge of the internal structure of a
* %PortaBase file is restricted to this class.
*/
class Database
{
public:
/** Enumeration of possible results from attempting to create or open a file */
enum OpenResult {
NewerVersion = 0,
Success = 1,
Encrypted = 2,
Failure = 3
};
Database(const QString &path, OpenResult *result, bool encrypt=false);
~Database();
QString load();
Crypto *encryption();
void updatePreferences();
QString currentView();
View *getView(const QString &name, bool applyDefaults=false,
bool setAsCurrent=true);
QString getDefaultSort(const QString &viewName);
QString getDefaultFilter(const QString &viewName);
QStringList listViews();
void addView(const QString &name, const QStringList &names,
const QString &defaultSort, const QString &defaultFilter,
int rpp=-1, int deskrpp=-1);
void deleteView(const QString &name);
void setViewColWidths(int *widths);
void setViewRowsPerPage(int rpp);
void setViewDefaults(const QString &sorting, const QString &filter);
QStringList listColumns();
int getIndex(const QString &column);
void setIndex(const QString &column, int index);
int getType(const QString &column);
IntList listTypes();
QString getDefault(const QString &column);
void setDefault(const QString &column, const QString &value);
QString getColId(const QString &column, int type=-1);
QString isValidValue(int type, const QString &value);
void addColumn(int index, const QString &name, int type,
const QString &defaultVal, int id=-1);
void renameColumn(const QString &oldName, const QString &newName);
void deleteColumn(const QString &name);
void renameView(const QString &oldName, const QString &newName);
QStringList listViewColumns(const QString &viewName);
void addViewColumn(const QString &viewName, const QString &columnName,
int index=-1, int width=60, int deskwidth=120);
void deleteViewColumn(const QString &viewName, const QString &columnName);
void setViewColumnSequence(const QString &viewName,
const QStringList &colNames);
void updateDataFormat();
QStringList getRow(int rowId, ImageUtils *utils=0);
QString currentSorting();
QStringList listSortings();
bool getSortingInfo(const QString &sortingName, QStringList *allCols,
QStringList *descCols);
void addSorting(const QString &name, const QStringList &allCols,
const QStringList &descCols);
void deleteSorting(const QString &name);
void deleteSortingColumn(const QString &sortName, const QString &columnName);
c4_View getData();
c4_View sortData(c4_View filteredData, const QString &column, Qt::SortOrder order);
c4_View sortData(c4_View filteredData, const QString &sortingName);
QString currentFilter();
QStringList listFilters();
Filter *getFilter(const QString &name);
void addFilter(Filter *filter, bool setAsCurrent=true);
void deleteFilter(const QString &name);
void deleteFilterColumn(const QString &filterName, const QString &columnName);
int getConditionCount(const QString &filterName);
Condition *getCondition(const QString &filterName, int index);
QStringList listEnums();
QStringList listEnumOptions(int id);
void addEnum(const QString &name, const QStringList &options,
int index=-1, int id=-1);
void renameEnum(const QString &oldName, const QString &newName);
void deleteEnum(const QString &name);
int getEnumId(const QString &name);
QString getEnumName(int id);
QStringList columnsUsingEnum(const QString &enumName);
void setEnumSequence(const QStringList &names);
void addEnumOption(const QString &enumName, const QString &option,
int index=-1);
void renameEnumOption(const QString &enumName, const QString &oldName,
const QString &newName);
void deleteEnumOption(const QString &enumName, const QString &option,
const QString &replace);
void setEnumOptionSequence(const QString &enumName,
const QStringList &options);
CalcNode *loadCalc(const QString &colName, int *decimals=0);
void updateCalc(const QString &colName, CalcNode *root, int decimals);
void calculateAll();
QString addRow(const QStringList &values, int *rowId=0,
bool acceptSequenceVals=false, bool fromcsv=false);
void updateRow(int rowId, const QStringList &values);
void deleteRow(int id, bool compressRowIds=true);
void compressRowIds();
void toggleBoolean(int rowId, const QString &colName);
QByteArray getBinaryField(int rowId, const QString &colName);
void setBinaryField(int rowId, const QString &colName, QByteArray bytes);
void commit();
void setImportBasePath(const QString &path);
QStringList importFromCSV(const QString &filename,
const QString &encoding);
void exportToXML(const QString &filename, c4_View &fullView,
c4_View &filteredView, const QStringList &cols);
void setGlobalInfo(const QString &view, const QString &sorting,
const QString &filter);
int addCalcNode(int calcId, CalcNode *root, int nodeId, int parentId);
private:
c4_View createEmptyView(const QStringList &colNames);
void replaceEnumOption(int enumId, const QString &oldOption,
const QString &newOption);
QString makeColId(int id, int type);
QString formatString(bool old = false);
void updateDataColumnFormat();
void updateEncoding();
void updateEncoding(c4_View &view);
void fixConditionIndices();
void addDesktopStats();
void addEnumDataIndices();
void updateEnumDataIndices(const QString &enumName);
void addViewDefaults();
CalcNode *loadCalc(int colId, int *decimals);
void deleteCalc(int colId);
void deleteCalcColumn(const QString &columnName);
void calculateAll(int colId, CalcNode *root, int decimals);
private:
bool smallScreen; /**< True if currently using column widths and rows per page for small-screen devices */
c4_Storage *file; /**< The data file */
c4_Storage *storage; /**< The data file if unencrypted, wrapped data otherwise */
Crypto *crypto; /**< Information about the file's encryption, 0 if not encrypted */
int version; /**< Version number of the file format this database uses */
bool newFile; /**< True if this is a newly created file */
QString importBasePath; /**< The base path to use when importing images with relative paths */
c4_View columns; /**< Table of data table column definitions */
c4_View views; /**< Table of data view definitions */
c4_View viewColumns; /**< Table of data view member column definitions */
c4_View sorts; /**< Table of sorting definitions */
c4_View sortColumns; /**< Table of sorting member column definitions */
c4_View filters; /**< Table of filter definitions */
c4_View filterConditions; /**< Table of filter member condition definitions */
c4_View enums; /**< Table of enum definitions */
c4_View enumOptions; /**< Table of enum member option definitions */
c4_View calcs; /**< Table of calculated column definitions */
c4_View calcNodes; /**< Table of calculated column equation node definitions */
c4_View global; /**< One-row table of information about the database */
c4_View data; /**< Table of user data */
View *curView; /**< The currently selected view */
Filter *curFilter; /**< The currently selected filter */
int maxId; /**< The largest ID of any row currently in the database */
c4_IntProp Id; /**< The "_id" property of the "_data" view */
c4_IntProp cIndex; /**< The "_cindex" property of the "_columns" view */
c4_StringProp cName; /**< The "_cname" property of the "_columns" view */
c4_IntProp cType; /**< The "_ctype" property of the "_columns" view */
c4_StringProp cDefault; /**< The "_cdefault" property of the "_columns" view */
c4_IntProp cId; /**< The "_cid" property of the "_columns" view */
c4_StringProp vName; /**< The "_vname" property of the "_views" view */
c4_IntProp vRpp; /**< The "_vrpp" property of the "_views" view */
c4_IntProp vDeskRpp; /**< The "_vdeskrpp" property of the "_views" view */
c4_StringProp vSort; /**< The "_vsort" property of the "_views" view */
c4_StringProp vFilter; /**< The "_vfilter" property of the "_views" view */
c4_StringProp vcView; /**< The "_vcview" property of the "_viewcolumns" view */
c4_IntProp vcIndex; /**< The "_vcindex" property of the "_viewcolumns" view */
c4_StringProp vcName; /**< The "_vcname" property of the "_viewcolumns" view */
c4_IntProp vcWidth; /**< The "_vcwidth" property of the "_viewcolumns" view */
c4_IntProp vcDeskWidth; /**< The "_vcdeskwidth" property of the "_viewcolumns" view */
c4_StringProp sName; /**< The "_sname" property of the "_sorts" view */
c4_StringProp scSort; /**< The "_scsort" property of the "_sortcolumns" view */
c4_IntProp scIndex; /**< The "_scindex" property of the "_sortcolumns" view */
c4_StringProp scName; /**< The "_scname" property of the "_sortcolumns" view */
c4_IntProp scDesc; /**< The "_scdesc" property of the "_sortcolumns" view */
c4_StringProp fName; /**< The "_fname" property of the "_filters" view */
c4_StringProp fcFilter; /**< The "_fcfilter" property of the "_filterconditions" view */
c4_IntProp fcPosition; /**< The "_fcposition" property of the "_filterconditions" view */
c4_StringProp fcColumn; /**< The "_fccolumn" property of the "_filterconditions" view */
c4_IntProp fcOperator; /**< The "_fcoperator" property of the "_filterconditions" view */
c4_StringProp fcConstant; /**< The "_fcconstant" property of the "_filterconditions" view */
c4_IntProp fcCase; /**< The "_fccase" property of the "_filterconditions" view */
c4_StringProp eName; /**< The "_ename" property of the "_enums" view */
c4_IntProp eId; /**< The "_eid" property of the "_enums" view */
c4_IntProp eIndex; /**< The "_eindex" property of the "_enums" view */
c4_IntProp eoEnum; /**< The "_eoenum" property of the "_enumoptions" view */
c4_IntProp eoIndex; /**< The "_eoindex" property of the "_enumoptions" view */
c4_StringProp eoText; /**< The "_eotext" property of the "_enumoptions" view */
c4_IntProp calcId; /**< The "_calcid" property of the "_calcs" view */
c4_IntProp calcDecimals; /**< The "_calcdecimals" property of the "_calcs" view */
c4_IntProp cnId; /**< The "_cnid" property of the "_calcnodes" view */
c4_IntProp cnNodeId; /**< The "_cnnodeid" property of the "_calcnodes" view */
c4_IntProp cnParentId; /**< The "_cnparentid" property of the "_calcnodes" view */
c4_IntProp cnType; /**< The "_cntype" property of the "_calcnodes" view */
c4_StringProp cnValue; /**< The "_cnvalue" property of the "_calcnodes" view */
c4_IntProp gVersion; /**< The "_gversion" property of the "_global" view */
c4_StringProp gView; /**< The "_gview" property of the "_global" view */
c4_StringProp gSort; /**< The "_gsort" property of the "_global" view */
c4_StringProp gFilter; /**< The "_gfilter" property of the "_global" view */
c4_IntProp gCrypt; /**< The "_gcrypt" property of the "_global" view */
};
#endif
|
