DelStatement Class Reference

#include <Statement.h>

Inheritance diagram for DelStatement:

[legend]Collaboration diagram for DelStatement:

[legend]

Public Member Functions
DbRetVal	execute (int &rowsAffected)
DbRetVal	setParam (int paramNo, void *value)
DbRetVal	setShortParam (int paramNo, short value)
DbRetVal	setIntParam (int paramNo, int value)
DbRetVal	setLongParam (int paramNo, long value)
DbRetVal	setLongLongParam (int paramNo, long long value)
DbRetVal	setByteIntParam (int paramNo, ByteInt value)
DbRetVal	setFloatParam (int paramNo, float value)
DbRetVal	setDoubleParam (int paramNo, double value)
DbRetVal	setStringParam (int paramNo, char *value)
DbRetVal	setDateParam (int paramNo, Date value)
DbRetVal	setTimeParam (int paramNo, Time value)
DbRetVal	setTimeStampParam (int paramNo, TimeStamp value)
DbRetVal	getParamFldInfo (int paramPos, FieldInfo *&info)
DbRetVal	resolve ()
	DelStatement ()
	~DelStatement ()
DbRetVal	resolveForCondition ()
DbRetVal	execute (int &rowsAffected)
DbRetVal	setParam (int paramNo, void *value)
DbRetVal	setShortParam (int paramNo, short value)
DbRetVal	setIntParam (int paramNo, int value)
DbRetVal	setLongParam (int paramNo, long value)
DbRetVal	setLongLongParam (int paramNo, long long value)
DbRetVal	setByteIntParam (int paramNo, ByteInt value)
DbRetVal	setFloatParam (int paramNo, float value)
DbRetVal	setDoubleParam (int paramNo, double value)
DbRetVal	setStringParam (int paramNo, char *value)
DbRetVal	setDateParam (int paramNo, Date value)
DbRetVal	setTimeParam (int paramNo, Time value)
DbRetVal	setTimeStampParam (int paramNo, TimeStamp value)
DbRetVal	getParamFldInfo (int paramPos, FieldInfo *&info)
void *	getParamValuePtr (int)
DbRetVal	resolve ()
	DelStatement ()
	~DelStatement ()
DbRetVal	resolveForCondition ()

---

Detailed Description

Definition at line 191 of file Statement.h.

---

Constructor & Destructor Documentation

DelStatement::DelStatement

(

)

Definition at line 18 of file DelStatement.cxx.

References Statement::dbMgr, DmlStatement::params, DmlStatement::paramValues, Statement::parsedData, DmlStatement::table, and DmlStatement::totalParams.

{
    parsedData = NULL; 
    dbMgr = NULL; 
    table = NULL;
    params = NULL;
    paramValues = NULL;
    totalParams = 0;
}

DelStatement::~DelStatement

(

)

Definition at line 28 of file DelStatement.cxx.

References DatabaseManager::closeTable(), Statement::dbMgr, DmlStatement::params, DmlStatement::paramValues, Table::setCondition(), DmlStatement::table, and DmlStatement::totalParams.

                            {
    if (table) {
        table->setCondition(NULL);
        if (dbMgr) dbMgr->closeTable(table);
    }
    if (totalParams) {
        free(params);
        params =  NULL;
        free(paramValues);
        paramValues = NULL;
    }

}

Here is the call graph for this function:

DelStatement::DelStatement

(

)

DelStatement::~DelStatement

(

)

---

Member Function Documentation

DbRetVal DelStatement::execute

(

int &

rowsAffected

)

[virtual]

Implements DmlStatement.

DbRetVal DelStatement::execute

(

int &

rowsAffected

)

[virtual]

Implements DmlStatement.

Definition at line 52 of file DelStatement.cxx.

References Table::close(), AllDataType::copyVal(), Table::deleteTuple(), Table::execute(), Table::fetchNoBind(), ConditionValue::length, OK, DmlStatement::params, DmlStatement::paramValues, DmlStatement::table, DmlStatement::totalParams, ConditionValue::type, and ConditionValue::value.

{
    DbRetVal rv = OK;
    //copy param values to binded buffer
    ConditionValue *value;
    for (int i = 0; i < totalParams; i ++)
    {
        value = (ConditionValue*) params[i];
        if (paramValues[i] == NULL) 
        {
            continue;
            //printError(ErrBadCall, "param values not set");
            //return ErrBadCall;
        }
        AllDataType::copyVal(value->value, paramValues[i], value->type, value->length);
    }
    rv = table->execute();
    if (rv != OK) return rv;
    rowsAffected = 0;
    void *tuple;
    while(true)
    {
        tuple = (char*)table->fetchNoBind(rv);
        if (rv != OK) break;
        if (tuple == NULL) {break;}
        rv = table->deleteTuple();
        if (rv != OK) break;
        rowsAffected++;
    }
    table->close();
    return rv;
}

Here is the call graph for this function:

DbRetVal DelStatement::getParamFldInfo	(	int	paramPos,
		FieldInfo *&	info
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::getParamFldInfo	(	int	paramPos,
		FieldInfo *&	info
	)			[virtual]

Implements DmlStatement.

Definition at line 42 of file DelStatement.cxx.

References ErrBadArg, ConditionValue::length, FieldInfo::length, OK, DmlStatement::params, printError, DmlStatement::totalParams, ConditionValue::type, and FieldInfo::type.

{
    if (paramPos <=0 || paramPos > totalParams) return ErrBadArg;
    ConditionValue *value = (ConditionValue*) params[paramPos-1];
    if (value == NULL) { printError(ErrBadArg, "Should never happen\n");
                         return ErrBadArg; }
    info->type = value->type;
    info->length = value->length;
    return OK;
}

void * DelStatement::getParamValuePtr

(

int

)

[virtual]

Implements DmlStatement.

Definition at line 216 of file DelStatement.cxx.

References DmlStatement::params, and ConditionValue::value.

 {
     ConditionValue *cValue = (ConditionValue*) params [pos-1];
     return ( (void*) cValue->value );
 }

DbRetVal DelStatement::resolve

(

)

[virtual]

Implements DmlStatement.

DbRetVal DelStatement::resolve

(

)

[virtual]

Implements DmlStatement.

Definition at line 235 of file DelStatement.cxx.

References DatabaseManager::closeTable(), Statement::dbMgr, ErrNoConnection, ErrNotExists, ParsedData::getCondition(), ParsedData::getTableName(), OK, DatabaseManager::openTable(), Statement::parsedData, printError, resolveForCondition(), Table::setCondition(), and DmlStatement::table.

{
    if (dbMgr == NULL) return ErrNoConnection;
    //check whether the table exists
    table = dbMgr->openTable(parsedData->getTableName());
    if (table == NULL) 
    {
        printError(ErrNotExists, "Unable to open the table:Table not exists");
        return ErrNotExists;
    }

    table->setCondition(parsedData->getCondition());

    DbRetVal rv = resolveForCondition();
    if (rv != OK) 
    {
        //TODO::free memory allocated for params
        table->setCondition(NULL);
        dbMgr->closeTable(table);
        table = NULL;
    }
    return rv;
}

Here is the call graph for this function:

DbRetVal DelStatement::resolveForCondition

(

)

DbRetVal DelStatement::resolveForCondition

(

)

Definition at line 260 of file DelStatement.cxx.

References AllDataType::alloc(), ErrNotFound, ErrSyntaxError, ErrSysFatal, ConditionValue::fName, ParsedData::getConditionValueList(), Table::getFieldInfo(), List::getIterator(), ListIterator::hasElement(), FieldInfo::length, ConditionValue::length, ListIterator::nextElement(), OK, ConditionValue::paramNo, DmlStatement::params, DmlStatement::paramValues, Statement::parsedData, ConditionValue::parsedString, printError, ListIterator::reset(), AllDataType::strToValue(), DmlStatement::table, DmlStatement::totalParams, FieldInfo::type, ConditionValue::type, and ConditionValue::value.

Referenced by resolve().

{
    //get the fieldname list and validate field names
    ListIterator iter = parsedData->getConditionValueList().getIterator();

    ConditionValue *value;
    FieldInfo *fInfo = new FieldInfo();
    int paramPos =1;
    DbRetVal rv = OK;
    while (iter.hasElement())
    {
        value = (ConditionValue*) iter.nextElement();
        if (NULL == value) 
        {
            delete fInfo;
            printError(ErrSysFatal, "Should never happen.");
            return ErrSysFatal;
        }
        rv = table->getFieldInfo(value->fName, fInfo);
        if (ErrNotFound == rv)
        {
            delete fInfo;
            printError(ErrSyntaxError, "Field %s does not exist in table", 
                                        value->fName);
            return ErrSyntaxError;
        }
        value->type = fInfo->type;
        value->length = fInfo->length;
        value->value = AllDataType::alloc(fInfo->type, fInfo->length);
        if (value->parsedString == NULL)
        {
            delete fInfo;
            printError(ErrSyntaxError, "Condition value should not be NULL");
            return ErrSyntaxError;
        }

        if (value->parsedString[0] == '?')
        {
            value->paramNo = paramPos++;
        }
        if (!value->paramNo) 
            AllDataType::strToValue(value->value, value->parsedString, fInfo->type, fInfo->length);
    }
    delete fInfo;
    totalParams = paramPos -1;
    if (0 == totalParams) return OK;
    params = (void**) malloc ( totalParams * sizeof(FieldValue*));
    paramValues = (char**) malloc( totalParams * sizeof(char*));
    memset(params, 0, totalParams * sizeof(FieldValue*));
    memset(paramValues, 0, totalParams * sizeof(char*));
    iter.reset();
    while(iter.hasElement())
    {
        value = (ConditionValue*) iter.nextElement();
        if (value == NULL) 
        {
            free(params); params = NULL;
            free(paramValues); paramValues = NULL;
            printError(ErrSysFatal, "Should never happen. value NULL after iteration");
            return ErrSysFatal;
        }
        params[value->paramNo -1 ] = value;
    }
    return OK;
}

Here is the call graph for this function:

Here is the caller graph for this function:

DbRetVal DelStatement::setByteIntParam	(	int	paramNo,
		ByteInt	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setByteIntParam	(	int	paramNo,
		ByteInt	value
	)			[virtual]

Implements DmlStatement.

Definition at line 144 of file DelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(ByteInt*)cValue->value = value; 
    return OK;
}

DbRetVal DelStatement::setDateParam	(	int	paramNo,
		Date	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setDateParam	(	int	paramNo,
		Date	value
	)			[virtual]

Implements DmlStatement.

Definition at line 192 of file DelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(Date*)cValue->value = value; 
    return OK;
}

DbRetVal DelStatement::setDoubleParam	(	int	paramNo,
		double	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setDoubleParam	(	int	paramNo,
		double	value
	)			[virtual]

Implements DmlStatement.

Definition at line 168 of file DelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(double*)cValue->value = value; 
    return OK;
}

DbRetVal DelStatement::setFloatParam	(	int	paramNo,
		float	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setFloatParam	(	int	paramNo,
		float	value
	)			[virtual]

Implements DmlStatement.

Definition at line 156 of file DelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(float*)cValue->value = value; 
    return OK;
}

DbRetVal DelStatement::setIntParam	(	int	paramNo,
		int	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setIntParam	(	int	paramNo,
		int	value
	)			[virtual]

Implements DmlStatement.

Definition at line 107 of file DelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(int*)cValue->value = value; 
    return OK;
}

DbRetVal DelStatement::setLongLongParam	(	int	paramNo,
		long long	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setLongLongParam	(	int	paramNo,
		long long	value
	)			[virtual]

Implements DmlStatement.

Definition at line 132 of file DelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(long long*)cValue->value = value; 
    return OK;
}

DbRetVal DelStatement::setLongParam	(	int	paramNo,
		long	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setLongParam	(	int	paramNo,
		long	value
	)			[virtual]

Implements DmlStatement.

Definition at line 119 of file DelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(long*)cValue->value = value; 
    return OK;
}

DbRetVal DelStatement::setParam	(	int	paramNo,
		void *	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setParam	(	int	paramNo,
		void *	value
	)			[virtual]

Implements DmlStatement.

Definition at line 86 of file DelStatement.cxx.

References ErrBadArg, OK, DmlStatement::paramValues, and DmlStatement::totalParams.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    if (NULL == value) return ErrBadArg;
    paramValues[paramNo -1] = (char*) value; 
    return OK;
}

DbRetVal DelStatement::setShortParam	(	int	paramNo,
		short	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setShortParam	(	int	paramNo,
		short	value
	)			[virtual]

Implements DmlStatement.

Definition at line 94 of file DelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(short*)cValue->value = value; 
    return OK;
}

DbRetVal DelStatement::setStringParam	(	int	paramNo,
		char *	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setStringParam	(	int	paramNo,
		char *	value
	)			[virtual]

Implements DmlStatement.

Definition at line 180 of file DelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    strcpy((char*)cValue->value, value);
    return OK;
}

DbRetVal DelStatement::setTimeParam	(	int	paramNo,
		Time	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setTimeParam	(	int	paramNo,
		Time	value
	)			[virtual]

Implements DmlStatement.

Definition at line 204 of file DelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(Time*)cValue->value = value; 
    return OK;
}

DbRetVal DelStatement::setTimeStampParam	(	int	paramNo,
		TimeStamp	value
	)			[virtual]

Implements DmlStatement.

DbRetVal DelStatement::setTimeStampParam	(	int	paramNo,
		TimeStamp	value
	)			[virtual]

Implements DmlStatement.

Definition at line 222 of file DelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(TimeStamp*)cValue->value = value;
    return OK;
}

---

The documentation for this class was generated from the following files:

• include/Statement.h
• src/sql/Statement.h
• src/sql/DelStatement.cxx

---