/*
 * OpenSchemaApplet.cpp 
 * Copyright (c) 2009 Antillia.com TOSHIYUKI ARAI. ALL RIGHTS RESERVED. 
 */


// SOL9
// 2009/05/20

// Assumes that environment of SQL Server 2008 and SQLClient1.0 
// Please create a database 'Sample' for this example.
// 

#include <sol/sql/ADOApplet.h>

namespace SOL {

class OpenSchemaApplet: public ADOApplet {

public:
    /**
     * Constructor
     */
    OpenSchemaApplet(int argc, const TCHAR** argv)
        :ADOApplet(argc, argv)
    {
    }

public:
    ~OpenSchemaApplet()
    {
    }

public:
    /**
     * OpenSchemaApplet main procedure
     */
    virtual void run()
    {
        printf("1 Start\n");
        ADOConnection connection = getConnection();

        ADORecordset schemaset;    
        printf("2 Try to connection.openSchema(adSchemaTables)\n");

        connection.openSchema(ADODB::adSchemaTables, schemaset);
        printf("3 OK, connection.openSchema()\n");
        
        while(!schemaset.getadoEOF()){
            ADOFields fields;
            schemaset.getFields(fields);
            printf("\n4 Found a Schema: ");
            ADOField field;
            char* it[] = {"TABLE_NAME", "TABLE_TYPE"};
            for (int i = 0; i<sizeof(it)/sizeof(it[0]); i++) {
                fields.getItem(it[i], field);
                _bstr_t value = field.getValue();
                printf("%s=\"%S\" ", it[i], (const wchar_t*)value);
            }
            schemaset.moveNext();                
        }
    }
};

}


// Console application starts here.
void _tmain(int argc, const TCHAR** argv)
{
    try {

        OpenSchemaApplet openSchemaApplet(argc, argv);

        openSchemaApplet.start();

    } catch(Exception& ex){
        ex.dump();
    } catch(...){
        printf("Exception:Unknown\n");
    }
}