1 /***************************************************************************
2 * Copyright (C) 2007 by Prabakaran Thirumalai *
3 * praba_tuty@yahoo.com *
5 * This program is free software; you can redistribute it and/or modify *
6 * it under the terms of the GNU General Public License as published by *
7 * the Free Software Foundation; either version 2 of the License, or *
8 * (at your option) any later version. *
10 * This program is distributed in the hope that it will be useful, *
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
13 * GNU General Public License for more details. *
15 * You should have received a copy of the GNU General Public License *
16 * along with this program; if not, write to the *
17 * Free Software Foundation, Inc., *
18 * 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. *
19 ***************************************************************************/
23 #include <AggTableImpl.h>
24 #include <JoinTableImpl.h>
42 char fldName
[IDENTIFIER_LENGTH
];
45 int paramNo
; // 0 ->not a param. It stores the param position
57 int paramNo
; // 0 ->not a param. It stores the param position
62 char fName
[IDENTIFIER_LENGTH
];
67 char fldName
[IDENTIFIER_LENGTH
];
68 AggType aType
; //used only in case of select projection
77 char tblName
[IDENTIFIER_LENGTH
];
84 struct UpdateFieldValue
86 char fldName
[IDENTIFIER_LENGTH
];
100 char tblName
[IDENTIFIER_LENGTH
];
101 char idxName
[IDENTIFIER_LENGTH
];
103 StatementType stmtType
;
108 //holds pointer to field names. used in insert to store field name list
109 //and for projection list of select
110 //also used to store primary or unique key fields in create statement
113 List groupFieldNameList
;
115 //holds pointer to condition values.
116 List conditionValueList
;
118 //holds pointer to field values. used in insert to store field values
119 //used in update to store the current value returned by fetch().This gets replaced
120 //by value in updFldValList and then update() is called.
123 //used to store IN values of SELECT statement
124 //This should be a list of list. so that multiple IN shall be present
125 //in the select statement
128 //update field value list. used to store the values to be updated
129 //value in the SET clause of UPDATE statement is stored here.
132 //stores the where clause condition for SELECT, UPDATE and DELETE
135 //stores field information in CREATE TABLE
138 //stores list of fields for CREATE TABLE
139 FieldList creFldList
;
141 //stores index information
147 ParsedData() { paramCounter
= 0; stmtType
= UnknownStatement
;
148 isUnique
= false; isPrimary
= false; indexType
= hashIndex
;}
149 void setStmtType(StatementType type
) { stmtType
= type
; }
150 void setTableName(char *name
) { strcpy(tblName
, name
); }
151 void setIndexName(char *name
) { strcpy(idxName
, name
); }
153 char* getTableName() { return tblName
; }
154 char* getIndexName() { return idxName
; }
156 void insertValue(char *value
);
157 void insertInValue(char *value
);
158 // third parameter is to avoid conflict between '?' between like operand and parameterized value in sql statement.
159 // eg: select * from t1 where f1 = ? and f2 like '_ti%';
160 // _ is converted to ? before it is processed
161 void** insertCondValueAndGetPtr(char *fName
, char *value
, bool opLike
=false);
162 void insertUpdateValue(char *fldName
, char *value
);
164 void insertField(char *fName
, AggType aggType
= AGG_UNKNOWN
);
165 void insertGroupField(char *fName
);
166 void clearFieldNameList();
167 void insertTableName(char *value
);
170 Predicate
* insertPredicate(char *fldName
, ComparisionOp op
, void** value
);
171 Predicate
* insertPredicate(char *fldName
, ComparisionOp op
, char *fldName
);
172 Predicate
* insertBetPredicate(char *fldName
, ComparisionOp op1
, void **value1
, ComparisionOp op2
, void **value2
);
173 Predicate
* insertPredicate(Predicate
*p1
, LogicalOp op
, Predicate
*p2
= NULL
);
174 void setCondition(Predicate
*pred
)
176 //No body is deleting memory allocated during condition::setTerm for PredicateImpl
177 //have list in this pared data and delete it during reset
178 predicate
.setPredicate(pred
);
180 Condition
* getCondition() { return &predicate
; }
182 void insertFieldValue(FieldValue
*newVal
) { fieldValueList
.append(newVal
); }
184 List
getFieldNameList() { return fieldNameList
; }
185 List
getGroupFieldNameList() { return groupFieldNameList
; }
186 List
getConditionValueList() { return conditionValueList
; }
187 List
getFieldValueList() { return fieldValueList
; }
188 List
getInValueList() { return inValueList
; }
189 List
getUpdateFieldValueList() { return updFldValList
; }
190 List
getTableNameList() { return tableNameList
; }
192 void setFldName(char *name
);
193 void setFldType(DataType type
);
194 DbRetVal
setFldLength(size_t length
);
195 void setDefaultValue(char * value
);
196 //void setFldDefaultValue -- will need two parametersers, check how u want to pass default value.
197 void setFldNotNull(bool notNull
);
199 void setUnique(bool unique
){ isUnique
= unique
; }
200 void setPrimary(bool primary
) { isPrimary
= primary
; }
201 void setIndexType (IndexType type
) { indexType
= type
; }
202 IndexType
getIndexType(){ return indexType
; }
203 bool getUnique() { return isUnique
; }
204 bool getPrimary() { return isPrimary
; }
205 Expression
* insertExpression(char *fldName
);
206 Expression
* insertExpression(char *value
, bool flag
);
207 Expression
* insertExpression(Expression
* exp1
, ArithOperator op
,Expression
* exp1
);
208 void insertUpdateExpression(char *fName
, Expression
*exp
);
210 void insertFldDef(); //check if fldDef needs to be a part of ParsedData
212 FieldList
getCreFldList() { return creFldList
; }
214 StatementType
getStmtType() { return stmtType
; }
223 //variable and function names suck, change if u want to
225 //finding out if fldDef needs to be part of parsedData, or can allocate memory and pass around