C:/GCC/docs/DocSqlite/wxSqlite/wx_SQLite.cpp

#ifndef WX_SQLITE_CCP_INCLUDED
#define WX_SQLITE_CCP_INCLUDED

#include <string.h>
#include <cstring>
#include <cstdlib>
#include <ctime>
#include <vector>
#include <algorithm>
#include <iostream>

#include <wx/wxSqlite/wx_SQLite.h>
#include <wx/wxSqlite/wxsqlite3.cpp>
//------------------------
// procedure acces DDS
//------------------------

wx_SQL::wx_SQL() {}; //initalisation
wx_SQL::~wx_SQL(){};


// Initialisation Field
void wx_SQL::F_Field(int nField, wxString nameField,wxString valeurField,
int typeField, int lenField,   int entierField, int precisionField ,
bool keyField , int ordrefield){

// si nombre    donné la longeur entierField voir la precision aussi
// si keyField  donné N° ordrefield
DDS_FILE.ds.push_back(DDS(nField, nameField,valeurField,typeField,lenField,entierField,precisionField,keyField,ordrefield));
};

// Initialisation Index
void wx_SQL::F_Index(int nField, wxString nameField,wxString valeurField,
bool keyField , int ordrefield){
// si keyField  donné N° ordrefield
DDS_FILE.ki.push_back(KID(nField,nameField,valeurField,keyField,ordrefield));
};


// Initialisation Index pour lecture Logique
void wx_SQL::L_Index(int nField, wxString nameField,wxString valeurField,
bool keyField , int ordrefield){
DDS_FILE.lg.push_back(KLF(nField,nameField,valeurField,keyField,ordrefield));
};

// initialisation des Logiques

void  wx_SQL::L_ValLGF( int i ,const wxString V_field ) {
       DDS_FILE.lg[i].wxVal = V_field;
};

// lecture des fields pour wxString
const wxString  wx_SQL::F_GetDDS( int i ) {
return DDS_FILE.ds[i].wxVal;
};


// initialisation des fields pour wxString
void wx_SQL::F_SetDDS( int i ,const wxString V_field ) {
        DDS_FILE.ds[i].wxVal = V_field ;

  if (DDS_FILE.ds[i].Key == true) DDS_FILE.ki[DDS_FILE.ds[i].Ord].wxVal = V_field;
};

void wx_SQL::F_OpnDDS(wxString Fpath)
{

 if  (DDS_FILE.OpnBD == false ) {
    DDS_FILE.BD = Fpath ;
//    remove(DDS_FILE.BD);
    DDS_FILE.db.Open(DDS_FILE.BD);
    DDS_FILE.OpnBD = true;
 }
};


// fonction de creation Sqlite File  Formatage
wxString wx_SQL::F_CrtDDS(wxString Fname)
{

   wxString Csql ;

   Csql.Clear();
   Xsql.Clear();

   Xsql =  _T("CREATE TABLE  ") + Fname  +  _T("(");

   Csql += Xsql;


    for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ds.size() ; i++, f++)
  {
  Xsql.Clear();
  Xsql += DDS_FILE.ds[f].Name ;

      switch (DDS_FILE.ds[f].Type)
     {
      case xText : Xsql +=_T(" CHAR(") ;
                   Xsql += wxString::Format("%d", DDS_FILE.ds[f].Lng ) ;
                   break;

      case xInt  : Xsql +=  _T(" INTG(");
                   Xsql += wxString::Format("%d", DDS_FILE.ds[f].Lng );
                   break;
      case xDbl  : Xsql +=  _T(" REAL(") ;
      Xsql += wxString::Format("%d.%d", DDS_FILE.ds[f].Ent,DDS_FILE.ds[f].Prs ) ;
                   break;
     case xDate : Xsql +=  _T("  DATE(") ;
                  Xsql += wxString::Format("%d", DDS_FILE.ds[f].Lng ) ;
                  break;
      case xBlod : Xsql +=  _T(" BLOD ") ; break;
     }

      if ( i < DDS_FILE.ds.size()) {
      if (DDS_FILE.ds[f].Type != xBlod)  Xsql += ")  ,";
     else Xsql +=  "  ,";
                                   }

      if ( i == DDS_FILE.ds.size()) {
      if (DDS_FILE.ds[f].Type != xBlod)  Xsql += ")  ";

                                  }


 Csql += Xsql;
  }
  Xsql.Clear();
      if (DDS_FILE.ds[DDS_FILE.ds.size()].Type != xBlod) Xsql = "  );";
     else Xsql =  "  ;";

 Csql += Xsql;

 Xsql =Csql.Trim();
  return  Xsql ;
};


// fonction de creation Sqlite File  Index

const wxString  wx_SQL::F_IdxDDS(wxString Fname)
{
  Xsql.Clear();
// create unique index Key ON bd(Nom ASC , Prenom ASC)
 Xsql = "CREATE UNIQUE INDEX Key ON  " + Fname + " (";
    for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ki.size() ; i++, f++)
  {
      Xsql += DDS_FILE.ki[f].Name  ;

      if ( i < DDS_FILE.ki.size())   Xsql += " ASC , ";
      else Xsql += " ASC  );";

  }
  return Xsql;
};


// initialisation  de la base de données
bool  wx_SQL::F_CrtTable(wxString Fname, bool index )
{
   Xsql.Clear();
  try
  {
    if(false == DDS_FILE.db.TableExists(Fname)){
    Xsql = F_CrtDDS (Fname);
    DDS_FILE.db.ExecuteQuery(Xsql.c_str());

     if ( index == true ) {
                         Xsql = F_IdxDDS (Fname);
                         DDS_FILE.db.ExecuteQuery(Xsql);
                         }
     }
    Xsql.Clear();
    return Berr = false ;

    }
  catch (wxSQLite3Exception& e)
  {
  Merr =   _T(e.GetMessage());
  return Berr = true ;
  }

};


//  INSERT BD
bool wx_SQL::F_WrtDDS(wxString Fname) {
 Xsql.Clear();
   Xsql = "insert into " + Fname + " values (";
    for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ds.size() ; i++, f++)
  {
      if ( i < DDS_FILE.ds.size())  Xsql += "?,";
     else Xsql +=  "?);";

  }

  try
  {

    DDS_FILE.stm = DDS_FILE.db.PrepareStatement(Xsql);
    DDS_FILE.db.Begin();
    for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ds.size() ; i++, f++)
    {
      DDS_FILE.stm.Bind(i,DDS_FILE.ds[f].wxVal);

    }
     DDS_FILE.stm.ExecuteUpdate();
     DDS_FILE.db.Commit();
     DDS_FILE.stm.Finalize();
     return Berr = false ;

    }
  catch (wxSQLite3Exception& e)
  {  DDS_FILE.db.Commit();
     DDS_FILE.stm.Finalize();
  Merr =   _T(e.GetMessage());Merr +=   _T("AJout Enregistrement Berr");
  return Berr = true ;
  }

};
//  UPDATE BD
bool wx_SQL::F_UpdDDS(wxString Fname) {
int nerr ;
 Xsql.Clear();
     Xsql = "UPDATE " + Fname + "  SET ";

    for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ds.size() ; i++, f++)
  {
      if ( i < DDS_FILE.ds.size())  Xsql += DDS_FILE.ds[f].Name + "=?,";
     else Xsql += DDS_FILE.ds[f].Name+ "=?  ";

  }


     Xsql += " WHERE " ;
    for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ki.size() ; i++, f++)
  {
      if ( i < DDS_FILE.ki.size()) Xsql += DDS_FILE.ki[f].Name  +  " ='" +DDS_FILE.ki[f].wxVal.Trim()+ "'  and " ;
     else Xsql += DDS_FILE.ki[f].Name  +  " ='" +DDS_FILE.ki[f].wxVal.Trim() + "'  ";

 }

       Xsql +=  " ;" ;


// debug
//   Merr = Xsql;  return Berr = true ;
  try
  {

   DDS_FILE.stm = DDS_FILE.db.PrepareStatement(Xsql);
   DDS_FILE.db.Begin();
    for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ds.size() ; i++, f++)
    {
      DDS_FILE.stm.Bind(i,DDS_FILE.ds[f].wxVal);

    }
  nerr = DDS_FILE.stm.ExecuteUpdate();
   DDS_FILE.db.Commit();
   DDS_FILE.stm.Finalize();
 if (nerr > 0 )  return Berr = false ;
 else { Merr =   _T("Aucune Mise a jour");  return Berr = true ;}
    }
  catch (wxSQLite3Exception& e)
  {  DDS_FILE.db.Commit();
     DDS_FILE.stm.Finalize();
  Merr =   _T(e.GetMessage());Merr += _T("Aucune Mise a jour");
  return Berr = true ;
  }

};


//  UPDATE BD ( 1 Field)
bool wx_SQL::F_UpdDDSx(wxString Fname,unsigned int x) {
 int nerr;

 Xsql.Clear();
    Xsql = "UPDATE " + Fname + "  SET ";
    Xsql += DDS_FILE.ds[x].Name  +  " =? ";
     Xsql += " WHERE " ;
    for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ki.size() ; i++, f++)
  {
      if ( i < DDS_FILE.ki.size()) Xsql += DDS_FILE.ki[f].Name  +  " ='" +DDS_FILE.ki[f].wxVal.Trim()+ "'  and " ;
     else Xsql += DDS_FILE.ki[f].Name  +  " ='" +DDS_FILE.ki[f].wxVal.Trim() + "'  ";

 }
      Xsql +=  " ;" ;
//if( DDS_FILE.db.CheckSyntax(Xsql)== false) {Merr = _T(Xsql); return Berr = true ;  }


  try
  {
     DDS_FILE.stm = DDS_FILE.db.PrepareStatement(Xsql);
    DDS_FILE.db.Begin();
          DDS_FILE.stm.Bind(1,DDS_FILE.ds[x].wxVal);
  nerr = DDS_FILE.stm.ExecuteUpdate();
   DDS_FILE.db.Commit();
   DDS_FILE.stm.Finalize();

 if (nerr > 0 )  return Berr = false ;
 else { Merr =   _T("Aucune Mise a jour"); Merr = Xsql; return Berr = true ;}

    }
  catch (wxSQLite3Exception& e)
  {  DDS_FILE.db.Commit();
       DDS_FILE.stm.Finalize();
  Merr =   _T(e.GetMessage()); Merr += _T("Aucune Mise a jour");
  return Berr = true ;
  }

};

//DELETE DB
bool wx_SQL::F_DltDDS(wxString Fname) {
int nerr;
 Xsql.Clear();
   Xsql = "DELETE FROM  " + Fname + " WHERE " ;

    for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ki.size() ; i++, f++)
  {
      if ( i < DDS_FILE.ki.size()) Xsql += DDS_FILE.ki[f].Name  +  " ='" +DDS_FILE.ki[f].wxVal + "'  and " ;
     else Xsql += DDS_FILE.ki[f].Name  +  " ='" +DDS_FILE.ki[f].wxVal + "' ";

  }
      Xsql +=  " ;" ;
// Merr = Xsql;  return valide = true ;
  try
  {
     DDS_FILE.stm = DDS_FILE.db.PrepareStatement(Xsql);
    DDS_FILE.db.Begin();
  nerr = DDS_FILE.stm.ExecuteUpdate();
   DDS_FILE.db.Commit();
   DDS_FILE.stm.Finalize();

 if (nerr > 0 )  return Berr = false ;
 else { Merr =   _T("Aucune Suppression");  return Berr = true ;}

    }
  catch (wxSQLite3Exception& e)
  {  DDS_FILE.db.Commit();
  Merr =   _T(e.GetMessage());  Merr = Xsql;
  return Berr = true ;
  }

};


// Stell Index Unique
bool wx_SQL::F_ChainDDS(wxString Fname) {
 Xsql.Clear();
   Xsql = "SELECT * from  " + Fname + " WHERE " ;

    for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ki.size() ; i++, f++)
  {
      if ( i < DDS_FILE.ki.size()) Xsql += DDS_FILE.ki[f].Name  +  " ='" +DDS_FILE.ki[f].wxVal + "'  and " ;
     else Xsql += DDS_FILE.ki[f].Name  +  " ='" +DDS_FILE.ki[f].wxVal + "'  ORDER BY  ";

  }
     for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ki.size() ; i++, f++)
  {
      if ( i < DDS_FILE.ki.size()) Xsql += DDS_FILE.ki[f].Name   + "  , " ;
     else Xsql += DDS_FILE.ki[f].Name   + " ";

  }
       Xsql +=  " ;" ;
//debug
// Merr = Xsql;
  try
  {

     DDS_FILE.tbl= DDS_FILE.db.GetTable(Xsql);

    for ( unsigned int i = 1,f =0 ; i <= DDS_FILE.ds.size() ; i++, f++)
    {
     F_SetDDS( f ,DDS_FILE.tbl.GetAsString(f) )  ;
    }


    return Berr = false ;
    }
  catch (wxSQLite3Exception& e)
  {
  Merr =   _T(e.GetMessage());  Merr = Xsql;
  return Berr= true ;
  }

};






//*********************************************************
//*********************************************************
// Gestion Lecture sur logique
//*********************************************************
//*********************************************************



// Setll read *all
bool wx_SQL::L_RallDDS(wxString Fname) {
 Xsql.Clear();
unsigned int knbr;
unsigned int kx;
   Xsql = "SELECT * from  " + Fname + " ORDER BY " ;

for( kx=0 , knbr = 0; DDS_FILE.klg[kx]  <99; kx++) knbr ++;

    for ( unsigned int i = 1,f =0 ; i <= knbr ; i++, f++)
  {
      if ( i < knbr) {
if (DDS_FILE.lg[DDS_FILE.klg[f]].Desc == 1 )  Xsql +=  DDS_FILE.lg[DDS_FILE.klg[f]].Name   + " DESC, ";
else Xsql += DDS_FILE.lg[DDS_FILE.klg[f]].Name   + " , " ;
                     }
     else { Xsql += DDS_FILE.lg[DDS_FILE.klg[f]].Name   + "  ";
            if (DDS_FILE.lg[DDS_FILE.klg[f]].Desc == 1 )  Xsql += " DESC ";
          }
  }
      Xsql +=  " ;" ;
// Merr = Xsql;  return valide = true ;
  try
  {

     DDS_FILE.qry= DDS_FILE.db.ExecuteQuery(Xsql);
    return Berr = false ;
    }
  catch (wxSQLite3Exception& e)
  {
  Merr =   _T(e.GetMessage());  Merr = Xsql;
  return Berr = true ;
  }

};


// Setll  read *GE
bool wx_SQL::L_ReadGeDDS(wxString Fname ) {
 Xsql.Clear();
unsigned int knbr;
unsigned int kx;

for( kx=0 , knbr = 0; DDS_FILE.slg[kx]  <99; kx++) knbr ++;

   Xsql = "SELECT * from  " + Fname ;
//==========================================================================================
// debut WHERE
//==========================================================================================

       if (  knbr >= 1) Xsql += " WHERE " ;
      if (  knbr == 1) {
           Xsql += DDS_FILE.lg[DDS_FILE.slg[0]].Name ;
           if ( DDS_FILE.lg[DDS_FILE.slg[0]].Sel == 1) Xsql += " ='" ; else Xsql += " >='";
           Xsql += DDS_FILE.lg[DDS_FILE.slg[0]].wxVal + "'    " ;
      }



      if (  knbr > 1){
    for ( unsigned int i = 1,f =0 ; i <=  knbr    ; i++, f++)
  {  if ( i < knbr) {
            Xsql += DDS_FILE.lg[DDS_FILE.slg[f]].Name ;
            if ( DDS_FILE.lg[DDS_FILE.slg[f]].Sel == 1) Xsql += " ='" ; else Xsql += " >='";
            Xsql += DDS_FILE.lg[DDS_FILE.slg[f]].wxVal + "'  and " ;
     }
     else { Xsql += DDS_FILE.lg[DDS_FILE.slg[f]].Name ;
            if ( DDS_FILE.lg[DDS_FILE.slg[f]].Sel == 1) Xsql += " ='" ; else Xsql += " >='";
            Xsql += DDS_FILE.lg[DDS_FILE.slg[f]].wxVal + "'     ";
     }
  }
                     }
//==========================================================================================
// debut ORDER BY
//==========================================================================================

for( kx=0 , knbr = 0; DDS_FILE.klg[kx]  <99; kx++) knbr ++;

      Xsql +=  "  ORDER BY  ";


    for ( unsigned int i = 1,f =0 ; i <= knbr ; i++, f++)
  {
      if ( i < knbr) {
if (DDS_FILE.lg[DDS_FILE.klg[f]].Desc == 1 )  Xsql +=  DDS_FILE.lg[DDS_FILE.klg[f]].Name   + " DESC , ";
else Xsql += DDS_FILE.lg[DDS_FILE.klg[f]].Name   + " , " ;
                     }
     else { Xsql += DDS_FILE.lg[DDS_FILE.klg[f]].Name   + "  ";
            if (DDS_FILE.lg[DDS_FILE.klg[f]].Desc == 1 )  Xsql += " DESC ";
          }
  }

    Xsql +=  " ;" ;
// Merr = Xsql;   // return valide = true ;
  try
  {

     DDS_FILE.qry= DDS_FILE.db.ExecuteQuery(Xsql);

    return Berr = false ;
    }
  catch (wxSQLite3Exception& e)
  {
  Merr =   _T(e.GetMessage());  Merr = Xsql;
  return Berr = true ;
  }

};





// Setll  readp *LE
bool wx_SQL::L_ReadpLeDDS(wxString Fname) {
 Xsql.Clear();
   Xsql = "SELECT * from  " + Fname ;
unsigned int knbr;
unsigned int kx;

for( kx=0 , knbr = 0; DDS_FILE.slg[kx]  <99; kx++) knbr ++;

//==========================================================================================
// debut WHERE
//==========================================================================================

       if (  knbr >= 1) Xsql += " WHERE " ;
      if (  knbr == 1) {
           Xsql += DDS_FILE.lg[DDS_FILE.slg[0]].Name ;
           if ( DDS_FILE.lg[DDS_FILE.slg[0]].Sel == 1) Xsql += " ='" ; else Xsql += " <='";
           Xsql += DDS_FILE.lg[DDS_FILE.slg[0]].wxVal + "'    " ;
      }



      if (  knbr > 1){
    for ( unsigned int i = 1,f =0 ; i <=  knbr    ; i++, f++)
  {  if ( i < knbr) {
            Xsql += DDS_FILE.lg[DDS_FILE.slg[f]].Name ;
            if ( DDS_FILE.lg[DDS_FILE.slg[f]].Sel == 1) Xsql += " ='" ; else Xsql += " <='";
            Xsql += DDS_FILE.lg[DDS_FILE.slg[f]].wxVal + "'  and " ;
     }
     else { Xsql += DDS_FILE.lg[DDS_FILE.slg[f]].Name ;
            if ( DDS_FILE.lg[DDS_FILE.slg[f]].Sel == 1) Xsql += " ='" ; else Xsql += " <='";
            Xsql += DDS_FILE.lg[DDS_FILE.slg[f]].wxVal + "'     ";
     }
  }
                     }
//==========================================================================================
// debut ORDER BY
//==========================================================================================

for( kx=0 , knbr = 0; DDS_FILE.klg[kx]  <99; kx++) knbr ++;

    Xsql += "  ORDER BY  ";


    for ( unsigned int i = 1,f =0 ; i <= knbr ; i++, f++)
  {
      if ( i < knbr ) Xsql += DDS_FILE.lg[DDS_FILE.klg[f]].Name   + "  DESC, " ;
     else Xsql += DDS_FILE.lg[DDS_FILE.klg[f]].Name   + "  DESC";

  }
      Xsql +=  " ;" ;
Merr = _T(Xsql);  //return Berr = true ;
  try
  {

     DDS_FILE.qry= DDS_FILE.db.ExecuteQuery(Xsql);

    return Berr = false ;
    }
  catch (wxSQLite3Exception& e)
  {
  Merr =   _T(e.GetMessage());  Merr = Xsql;
  return Berr = true ;
  }

};

#endif

---