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 insertCondValue(char *fldName
); //For Predecate t1.f1=t2.f1
163 void insertUpdateValue(char *fldName
, char *value
);
165 void insertField(char *fName
, AggType aggType
= AGG_UNKNOWN
);
166 void insertGroupField(char *fName
);
167 void clearFieldNameList();
168 void insertTableName(char *value
);
171 Predicate
* insertPredicate(char *fldName
, ComparisionOp op
, void** value
);
172 Predicate
* insertPredicate(char *fldName
, ComparisionOp op
, char *fldName
);
173 Predicate
* insertBetPredicate(char *fldName
, ComparisionOp op1
, void **value1
, ComparisionOp op2
, void **value2
);
174 Predicate
* insertPredicate(Predicate
*p1
, LogicalOp op
, Predicate
*p2
= NULL
);
175 void setCondition(Predicate
*pred
)
177 //No body is deleting memory allocated during condition::setTerm for PredicateImpl
178 //have list in this pared data and delete it during reset
179 predicate
.setPredicate(pred
);
181 Condition
* getCondition() { return &predicate
; }
183 void insertFieldValue(FieldValue
*newVal
) { fieldValueList
.append(newVal
); }
185 List
getFieldNameList() { return fieldNameList
; }
186 List
getGroupFieldNameList() { return groupFieldNameList
; }
187 List
getConditionValueList() { return conditionValueList
; }
188 List
getFieldValueList() { return fieldValueList
; }
189 List
getInValueList() { return inValueList
; }
190 List
getUpdateFieldValueList() { return updFldValList
; }
191 List
getTableNameList() { return tableNameList
; }
193 void setFldName(char *name
);
194 void setFldType(DataType type
);
195 DbRetVal
setFldLength(size_t length
);
196 void setDefaultValue(char * value
);
197 //void setFldDefaultValue -- will need two parametersers, check how u want to pass default value.
198 void setFldNotNull(bool notNull
);
200 void setUnique(bool unique
){ isUnique
= unique
; }
201 void setPrimary(bool primary
) { isPrimary
= primary
; }
202 void setIndexType (IndexType type
) { indexType
= type
; }
203 IndexType
getIndexType(){ return indexType
; }
204 bool getUnique() { return isUnique
; }
205 bool getPrimary() { return isPrimary
; }
206 Expression
* insertExpression(char *fldName
);
207 Expression
* insertExpression(char *value
, bool flag
);
208 Expression
* insertExpression(Expression
* exp1
, ArithOperator op
,Expression
* exp1
);
209 void insertUpdateExpression(char *fName
, Expression
*exp
);
211 void insertFldDef(); //check if fldDef needs to be a part of ParsedData
213 FieldList
getCreFldList() { return creFldList
; }
215 StatementType
getStmtType() { return stmtType
; }
224 //variable and function names suck, change if u want to
226 //finding out if fldDef needs to be part of parsedData, or can allocate memory and pass around