|
#include <Wt/Dbo/Dbo>
|
|
#include <Wt/Dbo/backend/Sqlite3>
|
|
#include <string>
|
|
|
|
namespace dbo = Wt::Dbo;
|
|
|
|
|
|
#include "orm.h"
|
|
|
|
int main(int argc, char **argv)
|
|
{
|
|
|
|
/*
|
|
* Setup a session, would typically be done once at application startup.
|
|
*/
|
|
/*
|
|
dbo::backend::MySQL sambhaashane("sambhaashane",
|
|
"sambhaashane",
|
|
"secret",
|
|
"localhost",
|
|
3306,
|
|
"/var/run/mysql/mysql.sock");
|
|
*/
|
|
dbo::backend::Sqlite3 sambhaashane("test.db");
|
|
|
|
sambhaashane.setProperty("show-queries", "true");
|
|
dbo::Session session;
|
|
session.setConnection(sambhaashane);
|
|
session.mapClass<sambhaashane_country_iso_3166_orm>("country_iso_3166_tbl");
|
|
|
|
session.createTables();
|
|
|
|
{
|
|
dbo::Transaction transaction(session);
|
|
sambhaashane_country_iso_3166_orm *d
|
|
= new sambhaashane_country_iso_3166_orm();
|
|
|
|
d->country_iso_3166_numeric_code = 40;
|
|
d->country_iso_3166_a2_code = "AA";
|
|
|
|
session.add(d);
|
|
}
|
|
|
|
dbo::Transaction transaction(session);
|
|
{
|
|
|
|
typedef dbo::collection< dbo::ptr<sambhaashane_country_iso_3166_orm> > Countries;
|
|
Countries countries = session.find<sambhaashane_country_iso_3166_orm>();
|
|
|
|
bool flag = transaction.isActive();
|
|
|
|
// Countries countries = session.find<sambhaashane_country_iso_3166_orm>();
|
|
dbo::collection< dbo::ptr<sambhaashane_country_iso_3166_orm> >::const_iterator country = countries.begin();
|
|
int index = 0;
|
|
while(country != countries.end())
|
|
{
|
|
std::cout << index++
|
|
<< "] Country: "
|
|
<< (*country)->country_iso_3166_numeric_code
|
|
<< '\n';
|
|
country++;
|
|
}
|
|
}
|
|
//return WRun(argc, argv, &createApplication);
|
|
}
|
|
|
|
|