src/sql/Parser.h

   1 /***************************************************************************
   2  *   Copyright (C) 2007 by Prabakaran Thirumalai   *
   3  *   praba_tuty@yahoo.com   *
   4  *                                                                         *
   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.                                   *
   9  *                                                                         *
  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.                          *
  14  *                                                                         *
  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  ***************************************************************************/
  20 #ifndef PARSER_H
  21 #define PARSER_H
  22 #include <CSql.h>
  23 #include <os.h>
  24 #include <Util.h>
  25 enum StatementType
  26 {
  27     UnknownStatement,
  28     SelectStatement,
  29     InsertStatement,
  30     UpdateStatement,
  31     DeleteStatement,
  32     CreateTableStatement,
  33     DropTableStatement,
  34     CreateIndexStatement,
  35     DropIndexStatement
  36 };
  37
  38 struct FieldValue
  39 {
  40     char *parsedString;
  41     void *value;
  42     int paramNo; // 0 ->not a param. It stores the param position
  43     DataType type;
  44     int length;
  45 };
  46
  47
  48 struct ConditionValue
  49 {
  50     char *parsedString;
  51     void *value;
  52     int paramNo; // 0 ->not a param. It stores the param position
  53     DataType type;
  54     int length;
  55     char fName[IDENTIFIER_LENGTH];
  56 };
  57
  58 struct FieldName
  59 {
  60     char fldName[IDENTIFIER_LENGTH];
  61 };
  62
  63 struct UpdateFieldValue
  64 {
  65     char fldName[IDENTIFIER_LENGTH];
  66     char *parsedString;
  67     void *value;
  68     DataType type;
  69     int length;
  70     int paramNo;
  71 };
  72
  73
  74 class ParsedData
  75 {
  76     private:
  77     char tblName[IDENTIFIER_LENGTH];
  78     char idxName[IDENTIFIER_LENGTH];
  79
  80     StatementType stmtType;
  81
  82     int paramCounter;
  83
  84     //holds pointer to field names. used in insert to store field name list
  85     //and for projection list of select
  86     //also used to store primary or unique key fields in create statement
  87     List fieldNameList;
  88
  89     //holds pointer to condition values.
  90     List conditionValueList;
  91
  92     //holds pointer to field values. used in insert to store field values
  93     //used in update to store the current value returned by fetch().This gets replaced
  94     //by value in updFldValList and then update() is called.
  95     List fieldValueList;
  96
  97     //used to store IN values of SELECT statement
  98     //This should be a list of list. so that multiple IN shall be present
  99     //in the select statement
 100     //List inValueList;
 101
 102     //update field value list. used to store the values to be updated
 103     //value in the SET clause of UPDATE statement is stored here.
 104     List updFldValList;
 105
 106     //stores the where clause condition for SELECT, UPDATE and DELETE
 107     Condition predicate;
 108
 109     //stores field information in CREATE TABLE
 110     FieldDef fldDef;
 111
 112     //stores list of fields for CREATE TABLE
 113     FieldList creFldList;
 114
 115     //stores index information
 116     bool isUnique;
 117     bool isPrimary;
 118     IndexType indexType;
 119
 120     public:
 121     ParsedData() { paramCounter = 0; stmtType = UnknownStatement;
 122                  isUnique = false; isPrimary = false; indexType = hashIndex;}
 123     void setStmtType(StatementType type) { stmtType = type; }
 124     void setTableName(char *name) { strcpy(tblName, name); }
 125     void setIndexName(char *name) { strcpy(idxName, name); }
 126
 127     char* getTableName() { return tblName; }
 128     char* getIndexName() { return idxName; }
 129
 130     void insertValue(char *value);
 131     //void insertInValue(char *value);
 132     void** insertCondValueAndGetPtr(char *fName, char *value);
 133     void insertUpdateValue(char *fldName, char *value);
 134
 135     void insertField(char *fName);
 136     void clearFieldNameList();
 137
 138
 139     Predicate* insertPredicate(char *fldName, ComparisionOp op, void** value);
 140     Predicate* insertPredicate(char *fldName, ComparisionOp op, char *fldName);
 141     Predicate* insertPredicate(Predicate *p1, LogicalOp op, Predicate *p2 = NULL);
 142     void setCondition(Predicate *pred)
 143     {
 144         //No body is deleting memory allocated during condition::setTerm for PredicateImpl
 145         //have list in this pared data and delete it during reset
 146         predicate.setPredicate(pred);
 147     }
 148     Condition* getCondition() { return &predicate; }
 149
 150     void insertFieldValue(FieldValue *newVal) { fieldValueList.append(newVal); }
 151
 152     List getFieldNameList() { return fieldNameList; }
 153     List getConditionValueList() { return conditionValueList; }
 154     List getFieldValueList() { return fieldValueList; }
 155     //List getInValueList() { return inValueList; }
 156     List getUpdateFieldValueList() { return updFldValList; }
 157
 158     void setFldName(char *name);
 159     void setFldType(DataType type);
 160     void setFldLength(size_t length);
 161     void setDefaultValue(char * value);
 162     //void setFldDefaultValue -- will need two parametersers, check how u want to pass default value.
 163     void setFldNotNull(bool notNull);
 164
 165     void setUnique(bool unique){ isUnique = unique; }
 166     void setPrimary(bool primary) { isPrimary = primary; }
 167     void setIndexType (IndexType type) { indexType = type; }
 168     IndexType getIndexType(){ return indexType; }
 169     bool getUnique() { return isUnique; }
 170     bool getPrimary() { return isPrimary; }
 171
 172     void insertFldDef(); //check if fldDef needs to be a part of ParsedData
 173
 174     FieldList getCreFldList() { return creFldList; }
 175
 176     StatementType getStmtType() { return stmtType; }
 177
 178     void reset();
 179
 180 };
 181
 182 #endif
 183
 184 //TODO: Aruna
 185 //variable and function names suck, change if u want to
 186 //setFldDefaultValue
 187 //finding out if fldDef needs to be part of parsedData, or can allocate memory and pass around
 188 //primary key
 189 //foreign key