Wt

Dear Koen,

Thank you for your answer.

I've got persist() function, but not in Search.h. My persist() function is in Hit.h.

I use Hit class in template.

I'd like to call the search function from a context like:

    Search<Hit> *search = new Search<Hit>("pdbtm");
    Hits hits = search->search( params );
    cerr << "search results count: " <<  hits.size();
    for (unsigned int i=0; i<hits.size(); i++) 
        cerr << hits[i]->code << " " << hits[i]->chainid << endl;

And my Hit.h, which contains the persist function and define the data structure is the following:

Type 'Hits' is defined end of this file also.

#ifndef __Hit_H__
#define __Hit_H__

#include <Wt/Dbo/Dbo>
#include <Wt/Dbo/Session>
#include <Wt/Dbo/Transaction>
#include <Wt/Dbo/backend/Sqlite3>
#include <Wt/Dbo/Types>
#include <Wt/Dbo/WtSqlTraits>

#include <time.h>

using namespace Wt;
using namespace std;
namespace dbo = Wt::Dbo;


class Hit : public dbo::Dbo<Hit> {
    public:
        Hit() {
        };

        ~Hit() {
        }

        template<class Action>
        void persist(Action& a) {
            Wt::Dbo::field(a, code, "code");
            Wt::Dbo::field(a, chainid, "chainid");
        }


        string code;
        string chainid;

};

typedef Wt::Dbo::collection< Wt::Dbo::ptr<Hit> > HitCollection;
typedef vector<Wt::Dbo::ptr<Hit> >  Hits;

#endif

Thank you for your help in advance!

Best regards,

Daniel

Hey,

Your code seems fine. I can only imagine that there is something wrong with the data, e.g. the 'id' column does not have unique values ? [that shouldn't be possible for a column that is primary key but Sqlite3 has some quirks in that area] Does the data look correctly when doing the query in sqlite3 directly ?

Regards,

koen

Dear Koen,

I've checked with SQLite Database Browser, search works well for the same query:

select * from pdbtm where code = '2bl2'

The data and the database seem correct.

Regards,

Daniel

Dear Koen,

I've found the solution.

I did not have the two auxilary column in my databese: ID, VERSION.

So, you had right, the issue is caused by the wrong structure of my database.

Thank you very much!

Best regards,

Daniel