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
|
/***************************************************************************
* Copyright (C) 2004 by *
* Unai Garro (ugarro@users.sourceforge.net) *
* Cyril Bosselut (bosselut@b1project.com) *
* Jason Kivlighn (jkivlighn@gmail.com) *
* *
* Copyright (C) 2006 Jason Kivlighn (jkivlighn@gmail.com) *
* *
* 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. *
***************************************************************************/
#ifndef QSQLRECIPEDB_H
#define QSQLRECIPEDB_H
#include "backends/recipedb.h"
#include <qglobal.h>
#include <qobject.h>
#include <qsqldatabase.h>
#include <qimage.h>
#include <qfileinfo.h>
#include <qregexp.h>
#include <qstring.h>
#include "datablocks/recipe.h"
#include "datablocks/elementlist.h"
#include "datablocks/ingredientpropertylist.h"
#include "datablocks/unitratiolist.h"
/**
@author Unai Garro, Jason Kivlighn
*/
class QSqlRecipeDB : public RecipeDB
{
Q_OBJECT
protected:
virtual QString qsqlDriverPlugin() const { return QString::null; }
virtual QSqlDriver *qsqlDriver() const { return 0; }
virtual void createDB( void ) = 0;
virtual void portOldDatabases( float version );
virtual void storePhoto( int recipeID, const QByteArray &data );
virtual void loadPhoto( int recipeID, QPixmap &photo );
void loadRecipeMetadata( Recipe *recipe );
void search( RecipeList *list, int items, const RecipeSearchParameters & );
/** Return the next id for the given table and column.
* If the database supports getting this afterwards,
* leave the default implementation which returns -1.
*
* Note: Only call when an insert is actually going to take place.
* This function will increment the sequence counter.
*/
virtual int getNextInsertID( const QString & /*table*/, const QString & /*column*/ )
{
return -1;
}
QSqlDatabase *database;
QSqlQuery m_query;
QString DBuser;
QString DBpass;
QString DBhost;
int DBport;
public:
QSqlRecipeDB( const QString &host, const QString &user = QString::null, const QString &pass = QString::null, const QString &DBName = DEFAULT_DB_NAME, int port = 0 );
~QSqlRecipeDB( void );
void connect( bool create_db, bool create_tables );
void addIngredientWeight( const Weight & );
void addProperty( const QString &name, const QString &units );
void addPropertyToIngredient( int ingredientID, int propertyID, double amount, int perUnitsID );
void addUnitToIngredient( int ingredientID, int unitID );
void categorizeRecipe( int recipeID, const ElementList &categoryList );
void changePropertyAmountToIngredient( int ingredientID, int propertyID, double amount, int per_units );
void createNewAuthor( const QString &authorName );
void createNewCategory( const QString &categoryName, int parent_id = -1 );
void createNewIngGroup( const QString &name );
void createNewIngredient( const QString &ingredientName );
void createNewPrepMethod( const QString &prepMethodName );
void createNewRating( const QString &name );
void createNewUnit( const Unit &unit );
void createNewYieldType( const QString &type );
void emptyData( void );
void empty( void );
int findExistingAuthorByName( const QString& name );
int findExistingCategoryByName( const QString& name );
int findExistingIngredientGroupByName( const QString& name );
int findExistingIngredientByName( const QString& name );
int findExistingPrepByName( const QString& name );
int findExistingRecipeByName( const QString& name );
int findExistingRatingByName( const QString& name );
int findExistingUnitByName( const QString& name );
int findExistingPropertyByName( const QString& name );
int findExistingYieldTypeByName( const QString& name );
void findIngredientUnitDependancies( int ingredientID, int unitID, ElementList *recipes, ElementList *ingredientInfo );
void findIngredientDependancies( int ingredientID, ElementList *recipes );
void findPrepMethodDependancies( int prepMethodID, ElementList *recipes );
void findUnitDependancies( int unitID, ElementList *properties, ElementList *recipes, ElementList *weights );
void findUseOfIngGroupInRecipes( ElementList *results, int groupID );
void findUseOfCategoryInRecipes( ElementList *results, int catID );
void findUseOfAuthorInRecipes( ElementList *results, int authorID );
QString getUniqueRecipeTitle( const QString &recipe_title );
bool ingredientContainsProperty( int ingredientID, int propertyID, int perUnitsID );
bool ingredientContainsUnit( int ingredientID, int unitID );
void loadAuthors( ElementList *list, int limit = -1, int offset = 0 );
void loadCategories( CategoryTree *list, int limit = -1, int offset = 0, int parent_id = -1, bool recurse = true );
void loadCategories( ElementList *list, int limit = -1, int offset = 0 );
void loadIngredientGroups( ElementList *list );
void loadIngredients( ElementList *list, int limit = -1, int offset = 0 );
void loadPossibleUnits( int ingredientID, UnitList *list );
void loadPrepMethods( ElementList *list, int limit = -1, int offset = 0 );
void loadProperties( IngredientPropertyList *list, int ingredientID = -2 ); // Loads the list of possible properties by default, all the ingredient properties with -1, and the ingredients of given property if id>=0
void loadRatingCriterion( ElementList *list, int limit = -1, int offset = 0 );
void loadRecipes( RecipeList *, int items = All, QValueList<int> ids = QValueList<int>() );
void loadRecipeList( ElementList *list, int categoryID = -1, bool recursive = false );
void loadUncategorizedRecipes( ElementList *list );
void loadUnits( UnitList *list, Unit::Type = Unit::All, int limit = -1, int offset = 0 );
void loadUnitRatios( UnitRatioList *ratioList, Unit::Type );
void loadYieldTypes( ElementList *list, int limit, int offset );
void mergeAuthors( int id1, int id2 );
void mergeCategories( int id1, int id2 );
void mergeIngredientGroups( int id1, int id2 );
void mergeIngredients( int id1, int id2 );
void mergeUnits( int id1, int id2 );
void mergePrepMethods( int id1, int id2 );
void mergeProperties( int id1, int id2 );
void modIngredientGroup( int ingredientID, const QString &newLabel );
/**
* set newLabel for ingredientID
*/
void modIngredient( int ingredientID, const QString &newLabel );
/**
* set newLabel for unitID
*/
void modUnit( const Unit &unit );
/**
* set newLabel for categoryID
*/
void modCategory( int categoryID, const QString &newLabel );
void modCategory( int categoryID, int new_parent_id );
/**
* set newLabel for authorID
*/
void modAuthor( int authorID, const QString &newLabel );
void modPrepMethod( int prepMethodID, const QString &newLabel );
void modProperty( int propertyID, const QString &newLabel );
QString recipeTitle( int recipeID );
void removeAuthor( int categoryID );
void removeCategory( int categoryID );
void removeIngredientGroup( int groupID );
void removeIngredient( int ingredientID );
void removeIngredientWeight( int id );
void removePrepMethod( int prepMethodID );
void removeProperty( int propertyID );
void removePropertyFromIngredient( int ingredientID, int propertyID, int perUnitID );
void removeRecipe( int id );
void removeRecipeFromCategory( int ingredientID, int categoryID );
void removeUnit( int unitID );
void removeUnitFromIngredient( int ingredientID, int unitID );
void removeUnitRatio( int unitID1, int unitID2 );
void saveRecipe( Recipe *recipe );
void saveUnitRatio( const UnitRatio *ratio );
double unitRatio( int unitID1, int unitID2 );
double ingredientWeight( const Ingredient &ing, bool *wasApproximated = 0 );
WeightList ingredientWeightUnits( int ingID );
QString escapeAndEncode( const QString &s ) const;
QString unescapeAndDecode( const QCString &s ) const;
QString categoryName( int ID );
QString prepMethodName( int ID );
QString ingredientName( int ID );
IngredientProperty propertyName( int ID );
Unit unitName( int ID );
int getCount( const QString &table_name );
int categoryTopLevelCount();
bool checkIntegrity( void );
void splitCommands( QString& s, QStringList& sl );
float databaseVersion( void );
protected:
void execSQL( const QString &command );
private:
void loadElementList( ElementList *elList, QSqlQuery *query );
void loadPropertyElementList( ElementList *elList, QSqlQuery *query );
QString getNextInsertIDStr( const QString &table, const QString &column );
QString DBname;
const QString connectionName;
QString m_command;
static int m_refCount;
};
#endif
|
