/*  xbsql.h

XBase64 Software Library

Copyright (c) 1997,2003,2014,2022 Gary A Kunkel

The xb64 software library is covered under the terms of the GPL Version 3, 2007 license.

Email Contact:

    XDB-devel@lists.sourceforge.net
    XDB-users@lists.sourceforge.net

This class manages a list of open tables, open indices are connected to the open tables

*/


#ifndef __XB_XBSQL_H__
#define __XB_XBSQL_H__

#ifdef  CMAKE_COMPILER_IS_GNUCC
#pragma interface
#endif


#ifdef XB_SQL_SUPPORT

namespace xb{


struct XBDLLEXPORT xbSqlFld{
  char     cType;      // F - Database field
                       // L - Literal
                       // E - Expression
  xbInt16  iFldNo;     // Field number if db field
  xbExp *  pExp;       // If cType=E, pointer to parsed expression
  xbString sFldAlias;  // Alias name for query display
  xbSqlFld * Next;     // Next field in list
};




class XBDLLEXPORT xbSql : public xbSsv {
 public:
   // xbSql();
   xbSql( xbXBase *x );
   ~xbSql();

   xbInt16 ExecuteNonQuery( const xbString &sCmdLine );
   xbXBase *GetXbasePtr() const;

 protected:

 private:

   xbInt16  SqlAlterTable( const xbString &sCmdLine );
   xbInt16  SqlCreateTable( const xbString &sCmdLine );
   xbInt16  SqlDelete( const xbString &sCmdLine );
   xbInt16  SqlDropTable( const xbString &sCmdLine );

   #ifdef XB_INDEX_SUPPORT
   xbInt16  SqlCreateIndex( const xbString &sCmdLine );
   xbInt16  SqlDropIndex( const xbString &sCmdLine );
   #endif  // XB_INDEX_SUPPORT

// xbInt16  SqlCreateView( const xbString &sCmdLine );
// xbInt16  SqlDropView( const xbString &sCmdLine );
// xbInt16  SqlUpdate( const xbString &sCmdLine );
   xbInt16  SqlSelect( const xbString &sCmdLine );

   void     SqlHelp() const;
   xbInt16  SqlInsert( const xbString &sCmLine );
   xbInt16  SqlSet( const xbString &sCmdLine );
   xbInt16  SqlUse( const xbString &sCmdLine );

   xbXBase *xbase;
   xbUda   uda;

};

}        /* namespace xb    */
#endif   /* XB_SQL_SUPPORT  */
#endif   /* __XB_XBSQL_H__  */