InsStatement Class Reference

#include <Statement.h>

Inheritance diagram for InsStatement:

[legend]Collaboration diagram for InsStatement:

[legend]

Public Member Functions
DbRetVal	getParamFldInfo (int paramPos, FieldInfo *&info)
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	resolve ()
	InsStatement ()
	~InsStatement ()
DbRetVal	getParamFldInfo (int paramPos, FieldInfo *&info)
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)
void *	getParamValuePtr (int)
DbRetVal	resolve ()
	InsStatement ()
	~InsStatement ()

---

Detailed Description

Definition at line 90 of file Statement.h.

---

Constructor & Destructor Documentation

InsStatement::InsStatement

(

)

Definition at line 19 of file InsStatement.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;
}

InsStatement::~InsStatement

(

)

Definition at line 29 of file InsStatement.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:

InsStatement::InsStatement

(

)

InsStatement::~InsStatement

(

)

---

Member Function Documentation

DbRetVal InsStatement::execute

(

int &

rowsAffected

)

[virtual]

Implements DmlStatement.

DbRetVal InsStatement::execute

(

int &

rowsAffected

)

[virtual]

Implements DmlStatement.

Definition at line 57 of file InsStatement.cxx.

References AllDataType::copyVal(), Table::insertTuple(), FieldValue::length, OK, DmlStatement::params, DmlStatement::paramValues, DmlStatement::table, DmlStatement::totalParams, FieldValue::type, and FieldValue::value.

{
    DbRetVal rv = OK;
    //copy param values to binded buffer
    FieldValue *value;
    for (int i = 0; i < totalParams; i ++)
    {
        value = (FieldValue*) params[i];
        if (paramValues[i] == NULL) 
        {
            //printError(ErrBadCall, "param values not set");
            continue;
            //return ErrBadCall;
        }
        AllDataType::copyVal(value->value, paramValues[i], value->type, value->length);
    }
    rv = table->insertTuple();
    if (rv ==OK) rowsAffected = 1;
    return rv;
}

Here is the call graph for this function:

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

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 43 of file InsStatement.cxx.

References ErrBadArg, ErrBadCall, ErrSysFatal, FieldValue::length, FieldInfo::length, OK, DmlStatement::params, printError, DmlStatement::totalParams, FieldValue::type, and FieldInfo::type.

{
    if (paramPos >totalParams ) return ErrBadCall;
    FieldValue *value = (FieldValue*)params[paramPos-1];
    if (value == NULL)
    {
        printError(ErrSysFatal, "param ptr is null: should never happen\n");
        return ErrBadArg;
    }
    info->type = value->type;
    info->length = value->length;
    return OK;
}

void * InsStatement::getParamValuePtr

(

int

)

[virtual]

Implements DmlStatement.

Definition at line 211 of file InsStatement.cxx.

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

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

DbRetVal InsStatement::resolve

(

)

[virtual]

Implements DmlStatement.

DbRetVal InsStatement::resolve

(

)

[virtual]

Implements DmlStatement.

Definition at line 230 of file InsStatement.cxx.

References AllDataType::alloc(), Table::bindFld(), DatabaseManager::closeTable(), Statement::dbMgr, ErrNoConnection, ErrNotExists, ErrNotFound, ErrSyntaxError, ErrSysFatal, FieldName::fldName, Table::getFieldInfo(), Table::getFieldNameList(), ParsedData::getFieldNameList(), ParsedData::getFieldValueList(), List::getIterator(), ParsedData::getTableName(), ListIterator::hasElement(), FieldInfo::length, FieldValue::length, ListIterator::nextElement(), OK, DatabaseManager::openTable(), FieldValue::paramNo, DmlStatement::params, DmlStatement::paramValues, Statement::parsedData, FieldValue::parsedString, printError, List::reset(), ListIterator::reset(), List::size(), AllDataType::strToValue(), DmlStatement::table, DmlStatement::totalParams, FieldInfo::type, FieldValue::type, and FieldValue::value.

{
    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;
    }

    List fieldNameList;
    //check whether filed list is specified
    if( 0 == parsedData->getFieldNameList().size() )
        fieldNameList = table->getFieldNameList();
    else
        fieldNameList = parsedData->getFieldNameList();

    //check whether the total number of field name in the list is same as the total 
    //number of values provided in the values list.
    if ( fieldNameList.size() != 
                               parsedData->getFieldValueList().size())
    {
        dbMgr->closeTable(table);
        table = NULL;
        printError(ErrSyntaxError, "Field Name list and field values do not match");
        return ErrSyntaxError;
    }

    //get the fieldname list and validate field names
    ListIterator iter = fieldNameList.getIterator();
    ListIterator valIter = parsedData->getFieldValueList().getIterator();
    FieldName *name; FieldValue *value;
    FieldInfo *fInfo = new FieldInfo();
    int paramPos =1;
    DbRetVal rv = OK;
    while (iter.hasElement())
    {
        name = (FieldName*)iter.nextElement();
        value = (FieldValue*) valIter.nextElement();
        if (NULL == name || NULL == value) 
        {
            dbMgr->closeTable(table);
            table = NULL;
            delete fInfo;
            printError(ErrSyntaxError, "Field Name list and field values do not match");
            return ErrSyntaxError;
        }
        rv = table->getFieldInfo(name->fldName, fInfo);
        if (ErrNotFound == rv)
        {
            dbMgr->closeTable(table);
            table = NULL;
            delete fInfo;
            printError(ErrSyntaxError, "Field %s does not exist in table", 
                                        name->fldName);
            return ErrSyntaxError;
        }
        value->type = fInfo->type;
        value->length = fInfo->length;
        value->value = AllDataType::alloc(fInfo->type, fInfo->length);
        if (value->parsedString == NULL) continue;
        table->bindFld(name->fldName, value->value);
        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) {
        if( 0 == parsedData->getFieldNameList().size() ) {
            iter.reset();
            while(iter.hasElement())
                delete (Identifier *) iter.nextElement();
            fieldNameList.reset();
        }
                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*));
    valIter.reset();
    while(valIter.hasElement())
    {
        value = (FieldValue*) valIter.nextElement();
        if (value == NULL) 
        {
            dbMgr->closeTable(table);
            table = NULL;
            free(params); params = NULL;
            free(paramValues); paramValues = NULL;
            printError(ErrSysFatal, "Should never happen. value NULL after iteration");
            return ErrSysFatal;
        }
        if (value->paramNo == 0) continue;
        params[value->paramNo -1 ] = value;
    }
   // memory to be deallocated created by table->getFieldNameList
    if( 0 == parsedData->getFieldNameList().size() ) {
        iter.reset();
        while(iter.hasElement())
            delete (Identifier *) iter.nextElement();
        fieldNameList.reset();
    }
    return OK;
}

Here is the call graph for this function:

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

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 137 of file InsStatement.cxx.

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

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

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

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 187 of file InsStatement.cxx.

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

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

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

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 161 of file InsStatement.cxx.

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

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

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

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 149 of file InsStatement.cxx.

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

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

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

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 99 of file InsStatement.cxx.

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

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

    *(int*)cValue->value = value; 
    return OK;
}

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

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 125 of file InsStatement.cxx.

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

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    FieldValue *cValue = (FieldValue*) 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 InsStatement::setLongParam	(	int	paramNo,
		long	value
	)			[virtual]

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 112 of file InsStatement.cxx.

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

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

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

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 78 of file InsStatement.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 InsStatement::setShortParam	(	int	paramNo,
		short	value
	)			[virtual]

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 86 of file InsStatement.cxx.

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

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

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

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 173 of file InsStatement.cxx.

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

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    FieldValue *cValue = (FieldValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    //TODO::check if the strlen(value) is greater than field length
    //do in all stmts
    strcpy((char*)cValue->value, value);
    return OK;
}

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

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 199 of file InsStatement.cxx.

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

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

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

Implements DmlStatement.

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

Implements DmlStatement.

Definition at line 217 of file InsStatement.cxx.

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

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    FieldValue *cValue = (FieldValue*) 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/InsStatement.cxx

---