/****************************************************************************** * $Id: ogrodbcselectlayer.cpp 10646 2007-01-18 02:38:10Z warmerdam $ * * Project:  OpenGIS Simple Features Reference Implementation * Purpose:  Implements OGRODBCSelectLayer class, layer access to the results *           of a SELECT statement executed via ExecuteSQL(). * Author:   Frank Warmerdam, warmerdam@pobox.com * ****************************************************************************** * Copyright (c) 2004, Frank Warmerdam * * Permission is hereby granted, free of charge, to any person obtaining a * copy of this software and associated documentation files (the "Software"), * to deal in the Software without restriction, including without limitation * the rights to use, copy, modify, merge, publish, distribute, sublicense, * and/or sell copies of the Software, and to permit persons to whom the * Software is furnished to do so, subject to the following conditions: * * The above copyright notice and this permission notice shall be included * in all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS * OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL * THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER * DEALINGS IN THE SOFTWARE. ****************************************************************************/#include "cpl_conv.h"#include "ogr_odbc.h"CPL_CVSID("$Id: ogrodbcselectlayer.cpp 10646 2007-01-18 02:38:10Z warmerdam $");/************************************************************************//*                          OGRODBCSelectLayer()                         *//************************************************************************/OGRODBCSelectLayer::OGRODBCSelectLayer( OGRODBCDataSource *poDSIn,                                        CPLODBCStatement * poStmtIn ){    poDS = poDSIn;    iNextShapeId = 0;    nSRSId = -1;    poFeatureDefn = NULL;    poStmt = poStmtIn;    pszBaseStatement = CPLStrdup( poStmtIn->GetCommand() );    BuildFeatureDefn( "SELECT", poStmt );}/************************************************************************//*                          ~OGRODBCSelectLayer()                          *//************************************************************************/OGRODBCSelectLayer::~OGRODBCSelectLayer(){    ClearStatement();}/************************************************************************//*                           ClearStatement()                           *//************************************************************************/void OGRODBCSelectLayer::ClearStatement(){    if( poStmt != NULL )    {        delete poStmt;        poStmt = NULL;    }}/************************************************************************//*                            GetStatement()                            *//************************************************************************/CPLODBCStatement *OGRODBCSelectLayer::GetStatement(){    if( poStmt == NULL )        ResetStatement();    return poStmt;}/************************************************************************//*                           ResetStatement()                           *//************************************************************************/OGRErr OGRODBCSelectLayer::ResetStatement(){    ClearStatement();    iNextShapeId = 0;    CPLDebug( "OGR_ODBC", "Recreating statement." );    poStmt = new CPLODBCStatement( poDS->GetSession() );    poStmt->Append( pszBaseStatement );    if( poStmt->ExecuteSQL() )        return OGRERR_NONE;    else    {        delete poStmt;        poStmt = NULL;        return OGRERR_FAILURE;    }}/************************************************************************//*                            ResetReading()                            *//************************************************************************/void OGRODBCSelectLayer::ResetReading(){    if( iNextShapeId != 0 )        ClearStatement();    OGRODBCLayer::ResetReading();}/************************************************************************//*                             GetFeature()                             *//************************************************************************/OGRFeature *OGRODBCSelectLayer::GetFeature( long nFeatureId ){    return OGRODBCLayer::GetFeature( nFeatureId );}/************************************************************************//*                           TestCapability()                           *//************************************************************************/int OGRODBCSelectLayer::TestCapability( const char * pszCap ){    return OGRODBCLayer::TestCapability( pszCap );}/************************************************************************//*                             GetExtent()                              *//*                                                                      *//*      Since SELECT layers currently cannot ever have geometry, we     *//*      can optimize the GetExtent() method!                            *//************************************************************************/OGRErr OGRODBCSelectLayer::GetExtent(OGREnvelope *, int ){    return OGRERR_FAILURE;}/************************************************************************//*                          GetFeatureCount()                           *//*                                                                      *//*      If a spatial filter is in effect, we turn control over to       *//*      the generic counter.  Otherwise we return the total count.      *//*      Eventually we should consider implementing a more efficient     *//*      way of counting features matching a spatial query.              *//************************************************************************/int OGRODBCSelectLayer::GetFeatureCount( int bForce ){    return OGRODBCLayer::GetFeatureCount( bForce );}