Wt

#include <Wt/Dbo/Dbo>
#include <Wt/Dbo/WtSqlTraits>
#include <Wt/Dbo/backend/MySQL>
#include <Wt/Dbo/FixedSqlConnectionPool>
#include <Wt/Dbo/Session>
#include <Wt/Utils>
#include <iostream>

using namespace Wt;
class TestTable : public Dbo::Dbo<TestTable>
{
public:
  TestTable() : somestring( "" ) {}
  TestTable( const std::string &str ) : somestring( str ) {}
  virtual ~TestTable(){}
  std::string somestring;
  template<class Action>
  void persist( Action& a )
  {
    Wt::Dbo::field    ( a, somestring, "somestring" );
  }
};

Dbo::FixedSqlConnectionPool glob_pool( new Dbo::backend::MySQL( "db", "user", "pass" ), 3 );

void setConnection( Dbo::Session &ses )
{
  ses.setConnectionPool( glob_pool );
  ses.mapClass<TestTable>  ( "test" );
}

int main()
{
  const std::string try_write = "Hello World!" + Utils::sha1( "Hello World!" );

  std::cout << try_write << std::endl;

  // create db
  try
  {
    Dbo::Session session;
    setConnection( session );
    Dbo::Transaction transaction( session );
    session.createTables();
    transaction.commit();
  }
  catch( std::exception &e )
  {
    std::cout << e.what() << std::endl;
  }

  // write
  try
  {
    Dbo::Session session;
    setConnection( session );
    Dbo::Transaction transaction( session );

    Dbo::ptr<TestTable> text( new TestTable( try_write ) );
    session.add( text );

    transaction.commit();
  }
  catch( std::exception &e )
  {
    std::cout << e.what() << std::endl;
  }

  // read
  try
  {
    Dbo::Session session;
    setConnection( session );
    Dbo::Transaction transaction( session );

    Dbo::collection<Dbo::ptr<TestTable> > collection = session.find<TestTable>();
    for( Dbo::collection<Dbo::ptr<TestTable> >::iterator it = collection.begin(); it != collection.end(); it++ )
    {
      std::cout << (*it)->somestring << std::endl;
    }
    transaction.commit();
  }
  catch( std::exception &e )
  {
    std::cout << e.what() << std::endl;
  }

//  Hello World!.����T�}_/���#(q
//  Hello World!.
//  sql injection vulnerability ^^^
//

//  NOT TESTED!
//
//  virtual void bind(int column, const std::string& value)
//  {
//    if (in_pars_ == 0)
//      throw MySQLException(std::string("Try to bind too much?"));

//    DEBUG(std::cerr << this << " bind " << column << " "
//          << value << std::endl);

//    unsigned long * len = (unsigned long *)malloc(sizeof(unsigned long));

//    char * data;
//    //memset(&in_pars_[column], 0, sizeofin_pars_[column]);// Check
//    in_pars_[column].buffer_type = MYSQL_TYPE_STRING;

//->  unsigned long bufLen = value.length() * 2 + 1;
//    data = (char *)malloc(bufLen);
//->  *len = mysql_real_escape_string(stmt_,data,value.c_str(),value.length());
//    freeColumn(column);
//    in_pars_[column].buffer = data;
//    in_pars_[column].buffer_length = bufLen;
//    in_pars_[column].length = len;
//    in_pars_[column].is_null = 0;
//  }
//
//  virtual void bind(int column, const std::vector<unsigned char>& value)


  return 0;
}