nah, i'd rather use QtSql library.
________________________________
From: Nagaev Boris <bnag...@gmail.com>
To: Oto Magaldadze <omagalda...@yahoo.com>
Cc: "witty-interest@lists.sourceforge.net"
<witty-interest@lists.sourceforge.net>
Sent: Friday, April 27, 2012 1:44 PM
Subject: Re: [Wt-interest] link WTableView to sql table
yes, if you want use Dbo, you should create a class per model
On Fri, Apr 27, 2012 at 13:31, Oto Magaldadze <omagalda...@yahoo.com> wrote:
> oh maan so i need to create a separate class to each of the tables i need to
> connect to ?? :((
>
> ________________________________
> From: Nagaev Boris <bnag...@gmail.com>
> To: Oto Magaldadze <omagalda...@yahoo.com>;
> witty-interest@lists.sourceforge.net
> Sent: Friday, April 27, 2012 12:50 PM
> Subject: Re: [Wt-interest] link WTableView to sql table
>
> Hello!
>
> In QueryModel, Result may be dbo::ptr<YourClass> (or boost::tuple of
> such dbo::ptr's if you use SQL JOIN).
>
> To tell QueryModel, which fields to use, call addColumn method for
> each field, or use addAllFieldsAsColumns() to add all fields as
> columns.
>
> Then setQuery(session.find<YourClass>()) to ad all records from
> database table to this model/view.
>
> Here YourClass is a C++ class, representing a record, for example:
>
> class User {
> public:
> std::string name;
> std::string password;
>
> template<class Action>
> void persist(Action& a)
> {
> dbo::field(a, name, "name");
> dbo::field(a, password, "password");
> }
> };
>
> On Fri, Apr 27, 2012 at 10:25, Oto Magaldadze <omagalda...@yahoo.com> wrote:
>> In Qt if i want to display sql table content in view i can do this:
>> QSqlTableModel model;
>> model.setTable("Table1");
>> model.select();
>>
>> QTableView view;
>> view.setModel(&model);
>>
>> And how do I do that in Wt, 'cause I am stuck with Wt::Dbo::QueryModel<
>> Result > and Wt::Dbo::Query< Result, BindStrategy >, really can't get why
>> is
>> there <Result> stuff, what is it needed for, isn't there a way to
>> .setTable(std:str tablename)?
>>
>>
>> Oto
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> witty-interest mailing list
>> witty-interest@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/witty-interest
>>
>
>------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
witty-interest mailing list
witty-interest@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/witty-interest
