SessionGnuCashew.cpp

Go to the documentation of this file.

#line 2 "src/Dbo/SessionGnuCashew.cpp"
 
#include <iostream>
 
#include <Wt/Dbo/backend/Sqlite3.h>
 
#include <gcwglobal.h>
 
#include "Accounts/Accounts.h"
#include "Customers/Customers.h"
#include "Commodities/Commodities.h"
#include "Slots/Slots.h"
#include "Splits/Splits.h"
#include "Transactions/Transactions.h"
#include "Vars/Vars.h"
#include "SessionGnuCashew.h"
 
bool
GCW::Dbo::GnuCashew::Session::
open( const std::string & _path )
{
  /*
  ** Call the base class.
  **
  */
  GCW::Dbo::AbstractSession::open( _path );
 
  /*
  ** Setup authentication services
  **
  ** This module needs initialization if it is going to be used.  If it is
  **  not going to be used, then no damage is done here.  Once the database
  **  is opened then we can determine if it supports user authentication.
  **
  */
  GCW::Dbo::Users::configure();
 
  GCW::Dbo::Users::mapClasses( *this );
 
  m_users = std::make_unique< GCW::Dbo::Users::UserDatabase >( *this );
 
  /*
  ** Try to get the sqlite3 file open
  **
  */
  try
  {
    auto connection = std::make_unique< Wt::Dbo::backend::Sqlite3 >( _path );
 
//    connection-> setProperty( "show-queries", "true" );
 
    setConnection( std::move( connection ) );
 
  }
 
  /*
  ** Handle the error
  **
  */
  catch( std::exception & e )
  {
    std::cout << __FILE__ << ":" << __LINE__ << " " << e.what() << std::endl;
  }
 
  m_isOpen = true;
 
//  std::cout << __FILE__ << ":" << __LINE__ << " " << tableCreationSql() << std::endl;
 
  return isOpen();
 
} // endopen( const std::string & _path )
 
bool
GCW::Dbo::GnuCashew::Session::
hasGnuCashewExtensions()
{
  /*
  ** assume no extensions
  */
  bool retVal = false;
 
  using ResultRow = std::tuple< std::string, std::string, std::string, int, std::string >;
 
  /*
  **  query the list of tables
  */
  Wt::Dbo::Transaction t( *this );
  auto results =
    query< ResultRow >
    (
     "select type,name,tbl_name,rootpage,sql from sqlite_master"
    )
    .resultList()
    ;
 
  /*
  ** loop the list, looking for the extension tables
  */
  for( auto result : results )
  {
    std::string _type;
    std::string _name;
    std::string tbl_name;
    int         rootpage;
    std::string _text;
 
    std::tie( _type, _name, tbl_name, rootpage, _text ) = result;
 
    if( _type != "table" )
      continue;
 
    if( _name == GCW::Dbo::Vars::s_tableName )
    {
      retVal = true;
      break;
    }
 
#ifdef NEVER
    std::cout << __FILE__ << ":" << __LINE__
      << " type:" << _type
      << " name:" << _name
//      << " tbln:" << tbl_name
//      << " root:" << rootpage
//      << " text:" << _text
      << std::endl
      ;
#endif
 
  } // endfor( auto result : results )
 
  return retVal;
 
} // endhasGnuCashewExtensions() const
 
bool
GCW::Dbo::GnuCashew::Session::
addGnuCashewExtensions()
{
  if( hasGnuCashewExtensions() )
    return true;
 
  Wt::Dbo::Transaction t( *this );
 
  /*
  ** Add a table to contain the vars
  **
  */
  for( int i=0; i< 5; i++ )
  {
    auto key = Wt::WString( "gcw_sql.create.{1}").arg( i ).toUTF8();
    auto sql = TR( key ).toUTF8();
    execute( sql );
  }
 
  /*
  ** poke some initial values in to the vars table
  **
  */
  auto item = GCW::Dbo::Vars::get( "gnucashew","sys" );
 
  item.modify()-> setVar( "createdOn",  Wt::WDateTime::currentDateTime().toString( ISO_DATE_FORMAT ) );
  item.modify()-> setVar( "gcwVersion", 1 );
 
  return true;
 
} // endaddGnuCashewExtensions()