CreateTblStatement Class Reference

#include <Statement.h>

Inheritance diagram for CreateTblStatement:

[legend]Collaboration diagram for CreateTblStatement:

[legend]

Public Member Functions
DbRetVal	execute (int &rowsAffected)
DbRetVal	resolve ()
	CreateTblStatement ()
	~CreateTblStatement ()
DbRetVal	execute (int &rowsAffected)
DbRetVal	resolve ()
	CreateTblStatement ()
	~CreateTblStatement ()

---

Detailed Description

Definition at line 240 of file Statement.h.

---

Constructor & Destructor Documentation

CreateTblStatement::CreateTblStatement

(

)

Definition at line 18 of file DdlStatement.cxx.

References Statement::dbMgr, and Statement::parsedData.

{
    parsedData = NULL; 
    dbMgr = NULL; 
}

CreateTblStatement::~CreateTblStatement

(

)

Definition at line 24 of file DdlStatement.cxx.

References TableDef::reset().

{
    tblDef.reset();
}

Here is the call graph for this function:

CreateTblStatement::CreateTblStatement

(

)

CreateTblStatement::~CreateTblStatement

(

)

---

Member Function Documentation

DbRetVal CreateTblStatement::execute

(

int &

rowsAffected

)

[virtual]

Implements DdlStatement.

DbRetVal CreateTblStatement::execute

(

int &

rowsAffected

)

[virtual]

Implements DdlStatement.

Definition at line 28 of file DdlStatement.cxx.

References DatabaseManager::createIndex(), DatabaseManager::createTable(), Statement::dbMgr, FieldName::fldName, ParsedData::getFieldNameList(), List::getIterator(), ListIterator::hasElement(), hashIndex, IDENTIFIER_LENGTH, ListIterator::nextElement(), OK, Statement::parsedData, and List::size().

{
    DbRetVal rv = OK;
    rv = dbMgr->createTable(tblName, tblDef);
    if (rv != OK) return rv;
    if (parsedData->getFieldNameList().size() > 0)
    {
        HashIndexInitInfo *idxInfo = new HashIndexInitInfo();
        strcpy(idxInfo->tableName, tblName);
        ListIterator iter = parsedData->getFieldNameList().getIterator();
        FieldName *name = NULL;
        while (iter.hasElement())
        {
            name = (FieldName*)iter.nextElement();
            idxInfo->list.append(name->fldName);
        }
        idxInfo->indType = hashIndex;
        idxInfo->isPrimary = true;
        idxInfo->isUnique = true;
 
        char indName[IDENTIFIER_LENGTH];
        sprintf(indName, "%s_idx1_Primary", tblName);
        rv = dbMgr->createIndex(indName, idxInfo);
        delete idxInfo;
    }
    return rv;
}

Here is the call graph for this function:

DbRetVal CreateTblStatement::resolve

(

)

[virtual]

Implements DdlStatement.

DbRetVal CreateTblStatement::resolve

(

)

[virtual]

Implements DdlStatement.

Definition at line 56 of file DdlStatement.cxx.

References TableDef::addField(), FieldDef::defaultValueBuf_, ErrUnknown, FieldName::fldName, FieldDef::fldName_, ParsedData::getCreFldList(), ParsedData::getFieldNameList(), List::getIterator(), FieldList::getIterator(), ParsedData::getTableName(), ListIterator::hasElement(), FieldDef::isDefault_, FieldDef::isNull_, FieldDef::length_, ListIterator::nextElement(), OK, Statement::parsedData, printError, ListIterator::reset(), and FieldDef::type_.

{
    DbRetVal rv = OK;
    strcpy(tblName, parsedData->getTableName());
    FieldIterator iter = parsedData->getCreFldList().getIterator();
    FieldDef fDef; 

    int i = 0;
    FieldName *name = NULL;
    ListIterator nIter = parsedData->getFieldNameList().getIterator();
    while (iter.hasElement())
    {
        fDef = iter.nextElement();
        nIter.reset();
        while (nIter.hasElement())
        {
            name = (FieldName*)nIter.nextElement();
            if (strcmp(name->fldName, fDef.fldName_) == 0) fDef.isNull_ = true;
        }


       //TODO : need a new addField function which can take FieldDef as parameter.
       if (!fDef.isDefault_)  {
           i = tblDef.addField(fDef.fldName_, fDef.type_, fDef.length_, 
                        NULL,fDef.isNull_);
       } else {
           i = tblDef.addField(fDef.fldName_, fDef.type_, fDef.length_, 
                        fDef.defaultValueBuf_,fDef.isNull_);
       }
       if( 0 != i )
       {
          printError(ErrUnknown, "Error while adding field");
          rv = ErrUnknown;
          break;
       }
    }
    return rv;
}

Here is the call graph for this function:

---

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

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

---