/*
 * ADOXTable.h 
 * Copyright (c) 2009 Antillia.com TOSHIYUKI ARAI. ALL RIGHTS RESERVED. 
 */


// SOL9
// 2009/06/02
// 2009/06/07 Added a appendColumn() method to append a new column to ADOXColumns of an ADOXTabl object
/*
    ADOXTable table;
    table.createInstance();

    table.appendColumn("ID", ADOX::adInteger, 0);
    table.appendColumn("Name", ADOX::adVarChar, 255);
    ...
*/
#pragma once

#include <sol/sql/ADOObject.h>
#include <sol/sql/ADOXColumns.h>
#include <sol/sql/ADOXKeys.h>
#include <sol/sql/ADOXIndexes.h>
#include <sol/sql/ADOXProperties.h>


class ADOXTable :public ADOObject {

public:
    ADOXTable()
    {
    }

public:
    HRESULT createInstance()
    {
        return ADOObject::createInstance(__uuidof(ADOX::Table));
    }

public:
    void set(__in ADOX::_TablePtr pF) 
    {
        setObject((IDispatchPtr)pF);    
    }

public:
    ADOX::_TablePtr getTablePtr() 
    {
        return (ADOX::_TablePtr)getObject();    
    }

public:
    //1 Get an object of ADOXColumns from this table
    //2 Append a set of column data passed by arguments to the object as a new column 

    bool appendColumn(
        __in const _variant_t& item,
        __in ADOX::DataTypeEnum type,
         __in long definedSize)
    {
        bool rc = false;

        ADOXColumns columns;
        if (getColumns(columns)) {

            HRESULT hr = columns.append(
                item,
                type,
                 definedSize);
            if (SUCCEEDED(hr)) {
                rc = true;
            } else {
                throw Exception(hr, "%s", __FUNCTION__);
            }
        }
        return rc;
    } 

public:
    bool getColumns(
             __out ADOXColumns& columns)
    {
        bool rc = false;
        ADOX::ColumnsPtr ptr = getColumns();

        if (ptr) {
            columns.set(ptr);
            rc = true;
        } else {
            throw Exception(E_FAIL, "%s: %s", "E_FAIL", __FUNCTION__);
        }
        return rc;
    }


public:
    ADOX::ColumnsPtr getColumns()
    {
        return getTablePtr()->GetColumns();
    }

public:
    _bstr_t getName()
    {
         return getTablePtr()->GetName();
    }

public:
    void putName(__in _bstr_t pVal)
    {
        getTablePtr()->PutName(pVal);
    }

public:
    _bstr_t getType()
    {
        return getTablePtr()->GetType();
    }

public:
    bool getIndexes(
             __out ADOXIndexes& indexes)
    {
        bool rc = false;

        ADOX::IndexesPtr ptr = getIndexes();

        if (ptr) {
            indexes.set(ptr);
            rc = true;
        } else {
            throw Exception(E_FAIL, "%s: %s", "E_FAIL", __FUNCTION__);
        }
        return rc;
    }

public:
    ADOX::IndexesPtr getIndexes()
    {
        return getTablePtr()->GetIndexes();
    }

public:
    bool getKeys(
             __out ADOXKeys& keys)
    {
        bool rc = false;
        ADOX::KeysPtr ptr = getKeys();

        if (ptr) {
            keys.set(ptr);
            rc = true;
        } else {
            throw Exception(E_FAIL, "%s: %s", "E_FAIL", __FUNCTION__);
        }
        return rc;
    }

public:
    ADOX::KeysPtr getKeys()
    {
        return getTablePtr()->GetKeys();
    }

public:
    bool getProperties(
             __out ADOXProperties& properties)
    {
        bool rc = false;
        ADOX::PropertiesPtr ptr = getProperties();

        if (ptr) {
            properties.set(ptr);
            rc = true;
        } else {
            throw Exception(E_FAIL, "%s: %s", "E_FAIL", __FUNCTION__);
        }
        return rc;
    }

public:
    ADOX::PropertiesPtr getProperties()
    {
        return getTablePtr()->GetProperties();
    }

public:
    _variant_t getDateCreated()
    {
        return getTablePtr()->GetDateCreated();
    }

public:
    _variant_t getDateModified()
    {
        return getTablePtr()->GetDateModified();
    }

public:
    ADOX::_CatalogPtr getParentCatalog()
    {
        return getTablePtr()->GetParentCatalog();
    }

public:
    void putParentCatalog (
        __in ADOX::_Catalog * ppvObject)
    {
        getTablePtr()->PutParentCatalog(
                ppvObject);
    }


public:
    void putRefParentCatalog(
             __in ADOX::_Catalog * ppvObject)
    {
        getTablePtr()->PutRefParentCatalog(ppvObject);
    }

public:
    void dump()
    {
        _bstr_t name = getName();
        _bstr_t type = getType();

        COMTypeConverter converter;
        _variant_t val = getDateCreated();
        _bstr_t created="";
        converter.toString(val, created);

        printf("<Table Name=\"%s\" Type=\"%s\" Created=\"%s\">\n",
            (const char*)name,
            (const char*)type,
            (const char*)created
            );

        /*
        */
        ADOXColumns columns;
        getColumns(columns);
        columns.dump();

        ADOXKeys keys;
        getKeys(keys);
        keys.dump();

        ADOXIndexes indexes;
        getIndexes(indexes);
        indexes.dump();

        ADOXProperties properties;
        getProperties(properties);
        properties.dump();

        printf("</Table>\n");
    }
};